| src/BLL/Demo.BillView/Demo.BillView.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/BLL/Demo.BillView/Demo.BillView.csproj
@@ -226,6 +226,7 @@ <Compile Include="PRD\Pro_SCHBSH.cs" /> <Compile Include="PRD\Pro_SCLLSH.cs" /> <Compile Include="PRD\Pro_WorkBillPlatformXNQT.cs" /> <Compile Include="PRD\Pro_ShowParameter.cs" /> <Compile Include="PRD\Pro_ZJDBSH.cs" /> <Compile Include="PRD\Pro_ZJDBFSH.cs" /> <Compile Include="PRD\Pro_DayPlanPushZJDB2.cs" /> src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs
New file @@ -0,0 +1,87 @@ using Kingdee.BOS.Core.Bill; using Kingdee.BOS.Core.Bill.PlugIn; using Kingdee.BOS.Core.DynamicForm; using Kingdee.BOS.Core.DynamicForm.PlugIn; using Kingdee.BOS.Core.Metadata; using Kingdee.BOS.Orm.DataEntity; using Kingdee.BOS.Util; using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using System.Threading.Tasks; using ZD.Cloud.Logger; namespace Demo.BillView.PRD { [Description("[下推]上查按钮弹出界面通用插件")] [HotUpdate] public class Pro_ShowParameter : AbstractBillPlugIn { public override void BarItemClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.BarItemClickEventArgs e) { base.BarItemClick(e); var _key = this.View.Model.GetEntryCurrentRowIndex("FEntity"); if (_key < 0) return; if (e.BarItemKey.ToUpper() == "TB_LLDLB") { int FDayPlanFid = Convert.ToInt32(this.View.Model.GetValue("FDayPlanFid", _key)); if (FDayPlanFid == 0) { this.View.ShowMessage("选择明细行不是日计划用料清单下推生成"); return; } //领料单 string pageId = Guid.NewGuid().ToString(); BillShowParameter showParameter = new BillShowParameter(); showParameter.FormId = "Paez_Sc_DayPlanPPBomBill"; showParameter.OpenStyle.ShowType = ShowType.MainNewTabPage; showParameter.PageId = pageId; showParameter.Status = OperationStatus.EDIT; // 传入需要修改的销售订单内码，演示代码直接固定写死为100001 showParameter.PKey = FDayPlanFid.ToString(); this.View.ShowForm(showParameter); } else if (e.BarItemKey.ToUpper() == "TB_DBDLB") { int FDayPlanFid = Convert.ToInt32(this.View.Model.GetValue("FDayPlanFid", _key)); if (FDayPlanFid == 0) { this.View.ShowMessage("选择明细行不是日计划用料清单下推生成"); return; } //直接调拨单 string pageId = Guid.NewGuid().ToString(); BillShowParameter showParameter = new BillShowParameter(); showParameter.FormId = "Paez_Sc_DayPlanPPBomBill"; showParameter.OpenStyle.ShowType = ShowType.MainNewTabPage; showParameter.PageId = pageId; showParameter.Status = OperationStatus.EDIT; // 传入需要修改的销售订单内码，演示代码直接固定写死为100001 showParameter.PKey = FDayPlanFid.ToString(); this.View.ShowForm(showParameter); } else if (e.BarItemKey.ToUpper() == "TB_SCHBDLB") { int FDayPlanFid = Convert.ToInt32(this.View.Model.GetValue("FDayPlanFid", _key)); if (FDayPlanFid == 0) { this.View.ShowMessage("选择明细行不是日计划工单下推生成"); return; } //日计划工单 string pageId = Guid.NewGuid().ToString(); BillShowParameter showParameter = new BillShowParameter(); showParameter.FormId = "Paez_Sc_WorkBillAutoSortBill"; showParameter.OpenStyle.ShowType = ShowType.MainNewTabPage; showParameter.PageId = pageId; showParameter.Status = OperationStatus.EDIT; // 传入需要修改的销售订单内码，演示代码直接固定写死为100001 showParameter.PKey = FDayPlanFid.ToString(); this.View.ShowForm(showParameter); } } } } src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -173,9 +173,14 @@ sqlList.Add(sql); sql = $"truncate table Sc_WorkBillSubXnqt"; sqlList.Add(sql); sql = $"insert into Sc_WorkBillMainXnqt select * from Sc_WorkBillSortBillMain"; string columnName = DBServiceHelper.ExecuteScalar<string>(Context, "/*dialect*/ select stuff((select ',' + name from syscolumns Where id = object_Id('Sc_WorkBillMainXnqt') for xml path('')),1,1,'') as name ", ""); sql = $"insert into Sc_WorkBillMainXnqt({columnName}) select {columnName} from Sc_WorkBillSortBillMain"; LogHelper.Info("测试1："+sql); sqlList.Add(sql); sql = $"insert into Sc_WorkBillSubXnqt select * from Sc_WorkBillSortBillSub"; columnName = DBServiceHelper.ExecuteScalar<string>(Context, "/*dialect*/ select stuff((select ',' + name from syscolumns Where id = object_Id('Sc_WorkBillSubXnqt') for xml path('')),1,1,'') as name ", ""); sql = $"insert into Sc_WorkBillSubXnqt({columnName}) select {columnName} from Sc_WorkBillSortBillSub"; LogHelper.Info("测试1：" + sql); sqlList.Add(sql); sql = $"update Sc_WorkBillSubXnqt set FComplete=''"; sqlList.Add(sql); src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs
@@ -419,7 +419,7 @@ jsonModel.Add("FOrderQuantity", Convert.ToString(current["FOrderQuantity"])); jsonModel.Add("FDayPlanQuantity", Convert.ToDecimal(current["FDayPlanQuantity"]) + Convert.ToDecimal(current["FQTYLS"])); jsonModel.Add("FNoScheduled", Convert.ToString(current["FNoScheduled"])); sql = $" /*dialect*/ select FEntryID, FHMASTERDATE from SC_WORKBILLSORTBILLSub where FID={Convert.ToString(current["FDayPlanWorkID"])} "; sql = $" /*dialect*/ select FEntryID, FHMASTERDATE from Sc_WorkBillSubXnqt where FID={Convert.ToString(current["FDayPlanWorkID"])} "; List<DayPlanModel> dayPlanModel = new List<DayPlanModel>(); dayPlanModel = DBServiceHelper.ExecuteDataSet(Context, sql).ToModelList<DayPlanModel>(); JArray Entry = new JArray(); @@ -440,7 +440,7 @@ jsonModel.Add("FEntity", Entry); jsonRoot.Add("Model", jsonModel); CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/"); var result = cloudClient.Save("Paez_Sc_WorkBillAutoSortBill", jsonRoot.ToString()); var result = cloudClient.Save("paez_WorkBillSortBillSubXnqt", jsonRoot.ToString()); JObject saveObj = JObject.Parse(result); string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper(); if (saveIsSuc != "TRUE")
