From 4b0a1f01a9d67ca51765a39ac24cfbafaed4c4c9 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 12 三月 2021 13:34:55 +0800
Subject: [PATCH] 用于上查打开界面的通用插件（表单插件）
---
src/BLL/Demo.BillView/Demo.BillView.csproj | 1
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs | 4 +-
src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs | 87 +++++++++++++++++++++++++++++++++++++++++++
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 9 +++-
4 files changed, 97 insertions(+), 4 deletions(-)
diff --git a/src/BLL/Demo.BillView/Demo.BillView.csproj b/src/BLL/Demo.BillView/Demo.BillView.csproj
index cb5ae23..b1ebd36 100644
--- a/src/BLL/Demo.BillView/Demo.BillView.csproj
+++ b/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" />
diff --git a/src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs b/src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs
new file mode 100644
index 0000000..deb2b0c
--- /dev/null
+++ b/src/BLL/Demo.BillView/PRD/Pro_ShowParameter.cs
@@ -0,0 +1,87 @@
+锘縰sing 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);
+ }
+ }
+ }
+}
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index e3c684b..cfc5ebd 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/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);
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs
index b6fd439..469a225 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatformXNQT.cs
+++ b/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")
--
Gitblit v1.9.1