From f26b3129adde088d5ff4a633cecfeabb72834e96 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 10 九月 2021 17:24:35 +0800
Subject: [PATCH] 选单功能
---
src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs | 43 +++++++++++++++++++++++++------------------
1 files changed, 25 insertions(+), 18 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
index 9688acf..c0bc9db 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_MaterialRequisitionAuditDayPlan.cs
@@ -16,13 +16,13 @@
namespace Demo.DynamicForm.PRD
{
/// <summary>
- /// 鎻掍欢绀轰緥锛氬紩鍏ラ攢鍞嚭搴撳崟锛屽缓绔嬩笌閿�鍞鍗曠殑鍏宠仈
+ /// 鎻掍欢绀轰緥锛氭棩璁″垝鐢ㄦ枡娓呭崟涓嬫帹鍚庯紝寤虹珛鐢熶骇棰嗘枡鍗曚笌鐢熶骇鐢ㄦ枡娓呭崟鍏宠仈鍏崇郴
/// </summary>
/// <remarks>
/// 瑕佹眰锛�
/// 1. 闇�瑕佸紩鍏ュ崟鎹綋鐨勬簮鍗曠被鍨嬨�佹簮鍗曠紪鍙峰瓧娈�
- /// 2. 鏈彃浠舵寕鍦ㄩ攢鍞嚭搴撳崟鐨勪繚瀛樻搷浣滀笂
- /// 鍑哄簱鍏宠仈閿�鍞鍗�
+ /// 2. 鏈彃浠舵寕鍦ㄧ敓浜ч鏂欏崟鐨勪繚瀛樻搷浣滀笂
+ /// 鐢熶骇棰嗘枡鍗曚笌鐢熶骇鐢ㄦ枡娓呭崟鍏宠仈
/// </remarks>
[Description("鏃ヨ鍒掔敤鏂欐竻鍗曚笅鎺ㄥ悗锛屽缓绔嬬敓浜ч鏂欏崟涓庣敓浜х敤鏂欐竻鍗曞叧鑱斿叧绯�")]
[HotUpdate]
@@ -59,6 +59,9 @@
as DynamicObjectCollection;
foreach (var entryRow in entryRows)
{
+ //鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃�
+ if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
+ continue;
string srcFormId = "";
string srcSrcBillNo = "";
string FPPBOMFENTRYID = "";
@@ -142,7 +145,7 @@
}
}
// 涓烘柊寤虹殑婧愬崟鍏宠仈淇℃伅锛岃缃唴鐮�
- IDBService dbService = ServiceHelper.GetService<IDBService>();
+ IDBService dbService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IDBService>();
dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType);
}
/// <summary>
@@ -152,24 +155,28 @@
public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
{
base.AfterExecuteOperationTransaction(e);
+ if (FentryIdList.Count == 0)
+ return;
string FentryId = string.Join(",", FentryIdList.ToArray());
List<string> sqlList = new List<string>();
string sql = string.Format(@"/*dialect*/
- update a set FBASEACTUALQTY = b.FBASEACTUALQTY
- from T_PRD_PICKMTRLDATA_LK a
- join T_PRD_PICKMTRLDATA b on a.FENTRYID = b.FENTRYID
- where a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and a.FENTRYID in ({0})", FentryId);
+ update a set FSTOCKAPPQTY = FAPPQTY,FSTOCKACTUALQTY=FACTUALQTY
+ from T_PRD_PICKMTRLDATA a
+ where a.FENTRYID in ({0})", FentryId);
sqlList.Add(sql);
sql = string.Format(@"/*dialect*/
- update T_PRD_PICKMTRLDATA set
- FSrcBillType = 'PRD_PPBOM',
- FSRCENTRYID=FPPBomEntryId,
- FSrcBillNo=FPPBOMBILLNO
- where FENTRYID in ({0})
+update a set
+FSrcBillType='PRD_PPBOM',
+FSrcBillNo = b.FPPBOMBILLNO,
+FSRCINTERID =FHPPBomInterID,
+FSRCENTRYID = FHPPBomEntryID,
+FSRCENTRYSEQ =FPPBOMFSEQINT
+from T_PRD_PICKMTRLDATA a
+join Sc_DayPlanPPBomBillSub b on a.FDAYPLANFENTRYID = b.FEntryID
+where a.FEntryID in ({0})
", FentryId);
sqlList.Add(sql);
DBServiceHelper.ExecuteBatch(Context, sqlList);
- //DBServiceHelper.Execute(Context, sql);
}
/// <summary>
/// 鍔犺浇鐩稿叧鐨勯攢鍞鍗曟暟鎹�
@@ -178,7 +185,7 @@
/// <returns></returns>
private DynamicObject[] LoadPurchaseOrder(HashSet<string> poBillNos)
{
- IViewService viewService = ServiceHelper.GetService<IViewService>();
+ IViewService viewService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IViewService>();
string formId = "PRD_PPBOM";
// 鎸囧畾闇�瑕佸姞杞界殑閿�鍞鍗曞瓧娈�
@@ -230,7 +237,7 @@
/// <returns></returns>
private string GetPOEntryTableNumber()
{
- IBusinessFlowService bfMetaService = ServiceHelper.GetService<IBusinessFlowService>();
+ IBusinessFlowService bfMetaService = Kingdee.K3.SCM.App.ServiceHelper.GetService<IBusinessFlowService>();
var tableDefine = bfMetaService.LoadTableDefine(this.Context, POFormId, "FEntity");
return tableDefine.TableNumber;
}
@@ -245,11 +252,11 @@
//鍓╀綑棰嗘枡鏁伴噺
decimal remainQty = DBServiceHelper.ExecuteScalar<decimal>(Context, $"select FMustQty -isnull(FSelPickedQty,0) from T_PRD_PPBOMENTRY t1 left join T_PRD_PPBOMENTRY_Q t2 on t1.FENTRYID = t2.FENTRYID where t1.FENTRYID={toRow["PPBomEntryId"]?.ToString()}", 0);
linkRow["FlowId"] = srcRow["BFLowId_Id"];
- linkRow["FlowLineId"] = 0;
+ linkRow["FlowLineId"] = 5;
linkRow["RuleId"] = "PRD_PPBOM2PICKMTRL_NORMAL";
linkRow["SBillId"] = ((DynamicObject)srcRow.Parent)[0];
linkRow["STableId"] = ((DynamicObject)srcRow.Parent)[0];
- linkRow["SId"] = srcRow[0];
+ linkRow["SId"] = toRow["PPBomEntryId"];
linkRow["BaseActualQtyOld"] = remainQty;
linkRow["BaseActualQty"] = toRow["ACTUALQTY"]; //鍩烘湰鍗曚綅瀹炲彂鏁伴噺
--
Gitblit v1.9.1