生产计划平台（虚拟齐套）插件

王 垚

2021-03-11 0d16effeead91ab14bef60cfd556bcc3056f793c

 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>