From 0d16effeead91ab14bef60cfd556bcc3056f793c Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 11 三月 2021 09:01:46 +0800
Subject: [PATCH] 生产计划平台（虚拟齐套）插件
---
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index d01441c..e3c684b 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -158,6 +158,39 @@
}
}
/// <summary>
+ /// button鎸夐挳鐐瑰嚮浜嬩欢
+ /// </summary>
+ /// <param name="e"></param>
+ public override void ButtonClick(ButtonClickEventArgs e)
+ {
+ base.ButtonClick(e);
+ if (e.Key.ToUpper() == "FTBXNQT")
+ {
+ try
+ {
+ List<string> sqlList = new List<string>();
+ string sql = $"truncate table Sc_WorkBillMainXnqt";
+ sqlList.Add(sql);
+ sql = $"truncate table Sc_WorkBillSubXnqt";
+ sqlList.Add(sql);
+ sql = $"insert into Sc_WorkBillMainXnqt select * from Sc_WorkBillSortBillMain";
+ sqlList.Add(sql);
+ sql = $"insert into Sc_WorkBillSubXnqt select * from Sc_WorkBillSortBillSub";
+ sqlList.Add(sql);
+ sql = $"update Sc_WorkBillSubXnqt set FComplete=''";
+ sqlList.Add(sql);
+
+ DBServiceHelper.ExecuteBatch(Context, sqlList);
+ }
+ catch (Exception ex)
+ {
+ this.View.ShowErrMessage(ex.Message);
+ return;
+ }
+ this.View.ShowMessage("鎿嶄綔鎴愬姛");
+ }
+ }
+ /// <summary>
/// 琛屽弻鍑� 璺冲嚭榻愬鍒嗘瀽鏄庣粏鍒楄〃
/// </summary>
/// <param name="e"></param>
--
Gitblit v1.9.1