From 75770bb618e25f62b18f3e98eb64c3c2293c5696 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期六, 27 二月 2021 15:42:41 +0800
Subject: [PATCH] 日计划工单下推，建立生产汇报单与生产订单的关联关系 代码上传 测试通过
---
src/BLL/Demo.BillView/Demo.BillView.csproj | 3
src/BLL/Demo.BillView/PRD/Pro_SCHBSH.cs | 65 +++++++++
src/BLL/Demo.BillView/PRD/Pro_DayPlanPushSCHB.cs | 280 ++++++++++++++++++++++++++++++++++++++++
src/BLL/Demo.BillView/PRD/Pro_SCHBFSH.cs | 66 +++++++++
4 files changed, 414 insertions(+), 0 deletions(-)
diff --git a/src/BLL/Demo.BillView/Demo.BillView.csproj b/src/BLL/Demo.BillView/Demo.BillView.csproj
index 6b484c2..c3ce92a 100644
--- a/src/BLL/Demo.BillView/Demo.BillView.csproj
+++ b/src/BLL/Demo.BillView/Demo.BillView.csproj
@@ -220,7 +220,10 @@
<Compile Include="PRD\ProCompleteAnalysisMateriel.cs" />
<Compile Include="PRD\ProCompleteAnalysisDetails.cs" />
<Compile Include="PRD\Pro_DayPlanCheckSelectMenu.cs" />
+ <Compile Include="PRD\Pro_DayPlanPushSCHB.cs" />
+ <Compile Include="PRD\Pro_SCHBFSH.cs" />
<Compile Include="PRD\Pro_SCLLFSH.cs" />
+ <Compile Include="PRD\Pro_SCHBSH.cs" />
<Compile Include="PRD\Pro_SCLLSH.cs" />
<Compile Include="PRD\Pro_ZJDBSH.cs" />
<Compile Include="PRD\Pro_ZJDBFSH.cs" />
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushSCHB.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushSCHB.cs
new file mode 100644
index 0000000..c4b36a9
--- /dev/null
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlanPushSCHB.cs
@@ -0,0 +1,280 @@
+锘縰sing System;
+using System.Collections.Generic;
+using Kingdee.BOS.Util;
+using Kingdee.BOS.Core.Metadata;
+using Kingdee.BOS.Core.Metadata.EntityElement;
+using Kingdee.BOS.Core.DynamicForm.PlugIn;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+using Kingdee.BOS.Orm.DataEntity;
+using Kingdee.BOS.Contracts;
+using Kingdee.BOS.App;
+using Kingdee.BOS.Core.Metadata.FieldElement;
+using System.ComponentModel;
+using Kingdee.BOS.ServiceHelper;
+using Kingdee.K3.SCM.App;
+
+namespace Demo.DynamicForm.PRD
+{
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曚笅鎺ㄥ悗锛屽缓绔嬬敓浜ф眹鎶ュ崟涓庣敓浜ц鍗曠殑鍏宠仈鍏崇郴
+ /// </summary>
+ /// <remarks>
+ /// 瑕佹眰锛�
+ /// 1. 闇�瑕佸紩鍏ュ崟鎹綋鐨勬簮鍗曠被鍨嬨�佹簮鍗曠紪鍙峰瓧娈�
+ /// 2. 鏈彃浠舵寕鍦ㄧ洿鎺ヨ皟鎷ㄥ崟鐨勪繚瀛樻搷浣滀笂
+ /// 鐢熶骇姹囨姤鍗曞叧鑱旂敓浜ц鍗�
+ /// </remarks>
+ [Description("鏃ヨ鍒掑伐鍗曚笅鎺ㄥ悗锛屽缓绔嬬敓浜ф眹鎶ュ崟涓庣敓浜ц鍗曠殑鍏宠仈鍏崇郴")]
+ [HotUpdate]
+ public class Pro_DayPlanPushSCHB : AbstractOperationServicePlugIn
+ {
+ public override void OnPreparePropertys(PreparePropertysEventArgs e)
+ {
+ base.OnPreparePropertys(e);
+ e.FieldKeys.Add("FSrcBillType");
+ e.FieldKeys.Add("FSrcBillNo");
+ e.FieldKeys.Add("FID");
+ e.FieldKeys.Add("FTreeEntity_FEntryID");
+ e.FieldKeys.Add("FBillNo");
+ e.FieldKeys.Add("FBFLowId");
+ e.FieldKeys.Add("FMaterialId");
+ e.FieldKeys.Add("FBaseUnitQty");
+ e.FieldKeys.Add("FBaseJoinQty");
+ }
+ private const string POFormId = "PRD_MO";
+ public List<string> FentryIdList = new List<string>();
+ public override void BeforeExecuteOperationTransaction(BeforeExecuteOperationTransaction e)
+ {
+ base.BeforeExecuteOperationTransaction(e);
+ HashSet<string> poBillNos = new HashSet<string>();
+ Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
+ Entity linkEntry = this.BusinessInfo.GetEntity("FEntity_Link");
+ Field fldSrcFormId = this.BusinessInfo.GetField("FSrcBillType");
+ Field fldSrcBillNo = this.BusinessInfo.GetField("FSrcBillNo");
+ // 瀵瑰崟鎹綋杩涜寰幆锛屽彇鍏宠仈鐨勬簮鍗曠紪鍙�
+ foreach (var billObj in e.SelectedRows)
+ {
+ DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
+ as DynamicObjectCollection;
+ foreach (var entryRow in entryRows)
+ {
+ //鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃�
+ if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
+ continue;
+ string srcFormId = "";
+ string srcSrcBillNo = "";
+ string FPPBOMFENTRYID = "";
+ try
+ {
+ srcFormId = fldSrcFormId.DynamicProperty.GetValue<string>(entryRow);
+ srcSrcBillNo = fldSrcBillNo.DynamicProperty.GetValue<string>(entryRow);
+ //srcFormId = "PRD_MO";
+ //srcSrcBillNo = entryRow["FPPBOMBILLNO"]?.ToString();
+ //string FPPBOMFID = entryRow["FPPOMFID"]?.ToString();
+ //FPPBOMFENTRYID = entryRow["FPPBOMFENTRYID"]?.ToString();
+ }
+ catch (Exception)
+ {
+ }
+ if (string.IsNullOrWhiteSpace(srcFormId)
+ || string.IsNullOrWhiteSpace(srcSrcBillNo)
+ )
+ {// 婧愬崟涓嶆槸閲囪喘璁㈠崟锛岀暐杩�
+ continue;
+ }
+ // 婧愬崟缂栧彿宸茬粡鐧昏锛屼笉鍐嶉噸澶嶈褰曪紝鐣ヨ繃
+ if (poBillNos.Contains(srcSrcBillNo)) continue;
+ // Link宸茬粡璁板綍浜嗘簮鍗曚俊鎭紝鐣ヨ繃
+ //DynamicObjectCollection linkRows = linkEntry.DynamicProperty.GetValue(entryRow)
+ // as DynamicObjectCollection;
+ //if (linkRows.Count > 0) continue;
+ bool Ret = SourceVerification(Convert.ToString(entryRow["Id"]));
+ if (!Ret) continue;
+
+ poBillNos.Add(srcSrcBillNo);
+ }
+ }
+ if (poBillNos.Count == 0) return;
+ DynamicObject[] poObjs = this.LoadPurchaseOrder(poBillNos);
+ if (poObjs == null || poObjs.Length == 0) return;
+ Dictionary<string, Dictionary<string, DynamicObject>> dctAllBills = this.BuildDictionary(poObjs);
+ string srcTableNumber = this.GetPOEntryTableNumber();
+ List<DynamicObject> allNewLinkRows = new List<DynamicObject>();
+ // 寰幆鍗曟嵁浣擄紝涓哄崟鎹綋锛屽缓绔嬭捣婧愬崟鍏宠仈淇℃伅锛�
+ foreach (var billObj in e.SelectedRows)
+ {
+ DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
+ as DynamicObjectCollection;
+ foreach (var entryRow in entryRows)
+ {
+ string srcFormId = fldSrcFormId.DynamicProperty.GetValue<string>(entryRow);
+ string srcSrcBillNo = fldSrcBillNo.DynamicProperty.GetValue<string>(entryRow);
+ // srcFormId = "PRD_PPBOM";
+ // srcSrcBillNo = entryRow["FPPBOMBILLNO"]?.ToString();
+ //string FPPBOMFID = entryRow["FPPOMFID"]?.ToString();
+ //string FPPBOMFENTRYID = entryRow["FPPBOMFENTRYID"]?.ToString();
+
+ if (string.IsNullOrWhiteSpace(srcFormId)
+ || string.IsNullOrWhiteSpace(srcSrcBillNo)
+ )
+ {// 婧愬崟涓嶆槸閿�鍞鍗曪紝鐣ヨ繃
+ continue;
+ }
+ Dictionary<string, DynamicObject> dctOneBill = null;
+ if (dctAllBills.TryGetValue(srcSrcBillNo, out dctOneBill) == false) continue;
+ DynamicObject materialObj = entryRow["MaterialId"] as DynamicObject;
+ if (materialObj == null) continue;
+ string materialNumber = Convert.ToString(materialObj["number"]);
+ DynamicObject srcRow = null;
+ if (dctOneBill.TryGetValue(materialNumber, out srcRow) == false) continue;
+ // Link宸茬粡璁板綍浜嗘簮鍗曚俊鎭紝鐣ヨ繃
+ bool Ret = SourceVerification(Convert.ToString(entryRow["Id"]));
+ if (!Ret) continue;
+
+ //璁板綍婧愬崟ID 鐢ㄤ簬鏇存柊
+ if (!FentryIdList.Contains(entryRow["Id"]?.ToString()))
+ FentryIdList.Add(entryRow["Id"]?.ToString());
+
+ DynamicObjectCollection linkRows = linkEntry.DynamicProperty.GetValue(entryRow)
+ as DynamicObjectCollection;
+ DynamicObject linkRow = new DynamicObject(linkEntry.DynamicObjectType);
+ linkRow["STableName"] = srcTableNumber;
+ this.FillLinkRow(srcRow, entryRow, linkRow);
+ linkRows.Add(linkRow);
+ allNewLinkRows.Add(linkRow);
+ }
+ }
+ // 涓烘柊寤虹殑婧愬崟鍏宠仈淇℃伅锛岃缃唴鐮�
+ IDBService dbService = ServiceHelper.GetService<IDBService>();
+ dbService.AutoSetPrimaryKey(this.Context, allNewLinkRows.ToArray(), linkEntry.DynamicObjectType);
+ }
+
+ // /// <summary>
+ // /// 淇濆瓨鎿嶄綔鍏宠仈鍏崇郴鍐欏叆瀹屾垚鍚� 鏇存敼婧愬崟淇℃伅
+ // /// </summary>
+ // /// <param name="e"></param>
+ // public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
+ // {
+ // base.AfterExecuteOperationTransaction(e);
+ // //鏇存敼LK琛ㄤ俊鎭� 浠ュ強 婧愬崟鍏宠仈淇℃伅
+ // List<string> sqlList = new List<string>();
+ // string sql = "";
+ // if (FentryIdList.Count > 0)
+ // {
+ // string FentryId = string.Join(",", FentryIdList.ToArray());
+ // // sql = string.Format(@"/*dialect*/
+ // //update a set FBASEQTY = FQTY
+ // //from T_STK_STKTRANSFERINENTRY_LK a
+ // //join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID
+ // //where
+ // //--a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and
+ // //a.FENTRYID in ({0})", FentryId);
+ // // sqlList.Add(sql);
+ // sql = string.Format(@"/*dialect*/update T_STK_STKTRANSFERINENTRY_R
+ //set FSrcBillTypeId = 'PRD_PPBOM',FSRCBILLNO=b.FPPBOMBILLNO
+ //,FTRANSRESERVELINK=1
+ //from T_STK_STKTRANSFERINENTRY_R a
+ //join T_STK_STKTRANSFERINENTRY b on a.FENTRYID=b.FENTRYID
+ //where a.FENTRYID in({0})", FentryId);
+ // sqlList.Add(sql);
+ // DBServiceHelper.ExecuteBatch(Context, sqlList);
+ // }
+
+ // }
+ /// <summary>
+ /// 鍔犺浇鐩稿叧鐨勭敓浜ц鍗曚俊鎭�
+ /// </summary>
+ /// <param name="poBillNos"></param>
+ /// <returns></returns>
+ private DynamicObject[] LoadPurchaseOrder(HashSet<string> poBillNos)
+ {
+ IViewService viewService = ServiceHelper.GetService<IViewService>();
+ string formId = "PRD_MO";
+
+ // 鎸囧畾闇�瑕佸姞杞界殑鐢ㄦ枡娓呭崟瀛楁
+ List<SelectorItemInfo> fields = new List<SelectorItemInfo>();
+ fields.Add(new SelectorItemInfo("FID"));// 鍗曟嵁涓婚敭
+ fields.Add(new SelectorItemInfo("FTreeEntity_FEntryID"));// 鍗曟嵁浣撲富閿�
+ fields.Add(new SelectorItemInfo("FBillNo"));// 鍗曟嵁缂栧彿
+ fields.Add(new SelectorItemInfo("FBFLowId"));// 涓氬姟娴佺▼
+ fields.Add(new SelectorItemInfo("FMaterialId"));// 鐗╂枡
+ fields.Add(new SelectorItemInfo("FBaseUnitQty"));//鍩烘湰鍗曚綅鏁伴噺
+ fields.Add(new SelectorItemInfo("FBFLOWID"));//涓氬姟娴佺▼
+
+ // 鎸囧畾杩囨护鏉′欢
+ string filter = string.Format(" FBillNo IN ('{0}') ", string.Join("','", poBillNos));
+ OQLFilter ofilter = OQLFilter.CreateHeadEntityFilter(filter);
+ var objs = viewService.Load(this.Context, formId, fields, ofilter);
+ return objs;
+ }
+ /// <summary>
+ /// 鎶婄敓浜ц鍗曞崟鎹綋琛屾瀯寤轰负瀛楀吀锛欴ictionary(鍗曟嵁缂栧彿, Dictionary(鐗╂枡缂栫爜, 婧愬崟琛�));
+ /// </summary>
+ /// <param name="poObjs"></param>
+ /// <returns></returns>
+ private Dictionary<string, Dictionary<string, DynamicObject>> BuildDictionary(DynamicObject[] poObjs)
+ {
+ Dictionary<string, Dictionary<string, DynamicObject>> dctAllBills =
+ new Dictionary<string, Dictionary<string, DynamicObject>>();
+ foreach (var poObj in poObjs)
+ {
+ string billNo = Convert.ToString(poObj["BillNo"]);
+ Dictionary<string, DynamicObject> dctOneBill = new Dictionary<string, DynamicObject>();
+ DynamicObjectCollection entryRows = poObj["TreeEntity"] as DynamicObjectCollection;
+ foreach (var entryRow in entryRows)
+ {
+ DynamicObject materialObj = entryRow["MaterialId"] as DynamicObject;
+ if (materialObj == null) continue;
+ string materialNumber = Convert.ToString(materialObj["number"]);
+ dctOneBill[materialNumber] = entryRow;
+ }
+ dctAllBills.Add(billNo, dctOneBill);
+ }
+ return dctAllBills;
+ }
+ /// <summary>
+ /// 鑾峰彇鐢ㄦ枡娓呭崟鍏宠仈涓诲疄浣撹〃鏍肩紪鐮�
+ /// </summary>
+ /// <returns></returns>
+ private string GetPOEntryTableNumber()
+ {
+ IBusinessFlowService bfMetaService = ServiceHelper.GetService<IBusinessFlowService>();
+ var tableDefine = bfMetaService.LoadTableDefine(this.Context, POFormId, "FTreeEntity");
+ return tableDefine.TableNumber;
+ }
+ /// <summary>
+ /// 濉啓婧愬崟淇℃伅
+ /// </summary>
+ /// <param name="srcRow">婧愬崟琛�</param>
+ /// <param name="toRow">鐩爣鍗曡</param>
+ /// <param name="linkRow">鍏宠仈琛�</param>
+ private void FillLinkRow(DynamicObject srcRow, DynamicObject toRow, DynamicObject linkRow)
+ {
+ //鍓╀綑璋冩嫧鏁伴噺 锛堝熀鏈崟浣嶆暟閲� - 鍩烘湰鍗曚綅姹囨姤閫夊崟鏁伴噺锛�
+ decimal remainQty = DBServiceHelper.ExecuteScalar<decimal>(Context, $"select FBASEUNITQTY -isnull(FRepQuaSelQty,0) from T_PRD_MOENTRY t1 left join T_PRD_MOENTRY_A t2 on t1.FENTRYID = t2.FENTRYID where t1.FENTRYID={srcRow["Id"]?.ToString()}", 0);
+ linkRow["FlowId"] = srcRow["BFLowId_Id"];
+ linkRow["FlowLineId"] = 13;
+ linkRow["RuleId"] = "PRD_PPBOM-STK_TransferDirect";
+ linkRow["SBillId"] = ((DynamicObject)srcRow.Parent)[0];
+ linkRow["SId"] = srcRow[0];
+ // 鍘熷鎼哄甫閲�
+ linkRow["BASEQUAQTY"] = remainQty;//鍓╀綑姹囨姤鏁伴噺
+ linkRow["BASEQUAQTYOLD"] = toRow["FinishQty"]; //鏈姹囨姤鏁伴噺锛堝熀鏈崟浣嶅畬鎴愭暟閲忥級
+ }
+
+ /// <summary>
+ /// 楠岃瘉鏄惁鐢熸垚杩囩敓浜ц鍗曞搴旂殑婧愬崟
+ /// </summary>
+ /// <returns></returns>
+ public bool SourceVerification(string FTID)
+ {
+ string sql = $" select count(*) from T_BF_INSTANCEENTRY where FSTABLENAME= 'T_PRD_MOENTRY' and FTTABLENAME = 'T_PRD_MORPTENTRY' and FTID = '{FTID}'";
+ int count = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
+ if (count == 0)
+ return true;
+ else
+ return false;
+ }
+
+ }
+}
diff --git a/src/BLL/Demo.BillView/PRD/Pro_SCHBFSH.cs b/src/BLL/Demo.BillView/PRD/Pro_SCHBFSH.cs
new file mode 100644
index 0000000..9b7cf43
--- /dev/null
+++ b/src/BLL/Demo.BillView/PRD/Pro_SCHBFSH.cs
@@ -0,0 +1,66 @@
+锘縰sing System;
+using System.Collections.Generic;
+using Kingdee.BOS.Util;
+using Kingdee.BOS.Core.Metadata;
+using Kingdee.BOS.Core.Metadata.EntityElement;
+using Kingdee.BOS.Core.DynamicForm.PlugIn;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+using Kingdee.BOS.Orm.DataEntity;
+using Kingdee.BOS.Contracts;
+using Kingdee.BOS.App;
+using Kingdee.BOS.Core.Metadata.FieldElement;
+using System.ComponentModel;
+using Kingdee.BOS.ServiceHelper;
+using Kingdee.K3.SCM.App;
+
+namespace Demo.DynamicForm.PRD
+{
+ [Description("[鐢熶骇姹囨姤鍗�-鍙嶅鏍竇鎸夐挳鍔熻兘]")]
+ [HotUpdate]
+ public class Pro_SCHBFSH : AbstractOperationServicePlugIn
+ {
+ public override void OnPreparePropertys(PreparePropertysEventArgs e)
+ {
+ base.OnPreparePropertys(e);
+ e.FieldKeys.Add("FSrcBillType");
+ e.FieldKeys.Add("FSrcBillNo");
+ e.FieldKeys.Add("FID");
+ e.FieldKeys.Add("FTreeEntity_FEntryID");
+ e.FieldKeys.Add("FBillNo");
+ e.FieldKeys.Add("FBFLowId");
+ e.FieldKeys.Add("FMaterialId");
+ e.FieldKeys.Add("FBaseUnitQty");
+ e.FieldKeys.Add("FBaseJoinQty");
+ e.FieldKeys.Add("FDayPlanBillNo");
+ e.FieldKeys.Add("FDayPlanFentryId");
+ }
+ /// <summary>
+ ///鍙嶅鏍� 鍙嶆洿鏂版棩璁″垝鐢ㄦ枡娓呭崟璋冩嫧鏁伴噺
+ /// </summary>
+ /// <param name="e"></param>
+ public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
+ {
+ base.AfterExecuteOperationTransaction(e);
+ List<string> sqlList = new List<string>();
+ string sql = "";
+ //淇濆瓨鏃舵洿鏂扮敓浜х敤鏂欐竻鍗曡〃鏄庣粏璋冩嫧鏁伴噺
+ Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
+ foreach (var billObj in e.SelectedRows)
+ {
+ DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
+ as DynamicObjectCollection;
+ foreach (var entryRow in entryRows)
+ {
+ //鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃�
+ if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
+ continue;
+ string fentryId = entryRow["FDayPlanFentryId"].ToString();
+ decimal FBaseQty = Convert.ToDecimal(entryRow["BaseQuaQty"]);//鍩烘湰鍗曚綅鍚堟牸鏁伴噺
+ sql = string.Format($"/*dialect*/update Sc_WorkBillSortBillSub set FRptFinishQty -= {FBaseQty} where FEntryID = { fentryId} ");
+ sqlList.Add(sql);
+ }
+ }
+ DBServiceHelper.ExecuteBatch(Context, sqlList);
+ }
+ }
+}
diff --git a/src/BLL/Demo.BillView/PRD/Pro_SCHBSH.cs b/src/BLL/Demo.BillView/PRD/Pro_SCHBSH.cs
new file mode 100644
index 0000000..0a4aa84
--- /dev/null
+++ b/src/BLL/Demo.BillView/PRD/Pro_SCHBSH.cs
@@ -0,0 +1,65 @@
+锘縰sing System;
+using System.Collections.Generic;
+using Kingdee.BOS.Util;
+using Kingdee.BOS.Core.Metadata;
+using Kingdee.BOS.Core.Metadata.EntityElement;
+using Kingdee.BOS.Core.DynamicForm.PlugIn;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+using Kingdee.BOS.Orm.DataEntity;
+using Kingdee.BOS.Contracts;
+using Kingdee.BOS.App;
+using Kingdee.BOS.Core.Metadata.FieldElement;
+using System.ComponentModel;
+using Kingdee.BOS.ServiceHelper;
+using Kingdee.K3.SCM.App;
+
+namespace Demo.DynamicForm.PRD
+{
+ [Description("[鐢熶骇姹囨姤鍗�-瀹℃牳]鎸夐挳鍔熻兘]")]
+ [HotUpdate]
+ public class Pro_SCHBSH : AbstractOperationServicePlugIn
+ {
+ public override void OnPreparePropertys(PreparePropertysEventArgs e)
+ {
+ base.OnPreparePropertys(e);
+ e.FieldKeys.Add("FSrcBillType");
+ e.FieldKeys.Add("FSrcBillNo");
+ e.FieldKeys.Add("FID");
+ e.FieldKeys.Add("FTreeEntity_FEntryID");
+ e.FieldKeys.Add("FBillNo");
+ e.FieldKeys.Add("FBFLowId");
+ e.FieldKeys.Add("FMaterialId");
+ e.FieldKeys.Add("FBaseUnitQty");
+ e.FieldKeys.Add("FBaseJoinQty");
+ e.FieldKeys.Add("FDayPlanBillNo");
+ e.FieldKeys.Add("FDayPlanFentryId");
+ }
+ /// <summary>
+ ///鍙嶅鏍� 鍙嶆洿鏂版棩璁″垝鐢ㄦ枡娓呭崟璋冩嫧鏁伴噺
+ /// </summary>
+ /// <param name="e"></param>
+ public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
+ {
+ base.AfterExecuteOperationTransaction(e);
+ List<string> sqlList = new List<string>();
+ string sql = "";
+ //瀹℃牳鏃舵洿鏂扮敓浜х敤鏂欐竻鍗曡〃鏄庣粏璋冩嫧鏁伴噺
+ Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
+ foreach (var billObj in e.SelectedRows)
+ {
+ DynamicObjectCollection entryRows = entity.DynamicProperty.GetValue(billObj.DataEntity)
+ as DynamicObjectCollection;
+ foreach (var entryRow in entryRows)
+ {
+ //鐢熶骇鐢ㄦ枡娓呭崟涓虹┖鏃�
+ if (Convert.ToString(entryRow["FDayPlanBillNo"]) == "")
+ continue;
+ string fentryId = entryRow["FDayPlanFentryId"].ToString();
+ sql = string.Format($"/*dialect*/update Sc_WorkBillSortBillSub set FRptFinishQty = (select sum(FBaseQuaQty) from T_PRD_MORPTENTRY where FDayPlanFentryId = { fentryId})where FEntryID = { fentryId} ");
+ sqlList.Add(sql);
+ }
+ }
+ DBServiceHelper.ExecuteBatch(Context, sqlList);
+ }
+ }
+}
--
Gitblit v1.9.1