nothing

王 垚

2021-03-12 4c6efec8ce7a716d730c476bd055ff76a2435593

 src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs

@@ -158,6 +158,44 @@
            }
        }
        /// <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);
                    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);
                    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);

                    DBServiceHelper.ExecuteBatch(Context, sqlList);
                }
                catch (Exception ex)
                {
                    this.View.ShowErrMessage(ex.Message);
                    return;
                }
                this.View.ShowMessage("操作成功");
            }
        }
        /// <summary>
        /// 行双击 跳出齐套分析明细列表
        /// </summary>
        /// <param name="e"></param>    
@@ -1408,7 +1446,7 @@
            }
            catch (Exception ex)
            {
                this.View.ShowErrMessage("异常："+ ex.Message.ToString());
                this.View.ShowErrMessage("异常：" + ex.Message.ToString());
                LogHelper.Error("虚拟齐套分析跳出：" + ex.Message.ToString());
            }
            finally
@@ -1462,7 +1500,7 @@
                {
                    this.Model.CreateNewEntryRow("FEntity");
                    this.Model.SetValue("FSEQ", i + 1, i);//序号
                    this.Model.SetValue("FMOFBILLTYPE",Convert.ToString(dt.Rows[i]["FMOFBILLTYPE"]), i);//生产订单单据类型
                    this.Model.SetValue("FMOFBILLTYPE", Convert.ToString(dt.Rows[i]["FMOFBILLTYPE"]), i);//生产订单单据类型
                    this.Model.SetValue("FCompleteSetCount", "", i);//总齐套数量
                    this.Model.SetValue("FProOrderCount", dt.Rows[i]["FHOrderNeedQty"].ToString(), i);//生产订单数量 
                    this.Model.SetValue("FSRCBILLENTRYSEQ", dt.Rows[i]["FSRCBILLENTRYSEQ"].ToString(), i);//  
@@ -1926,7 +1964,8 @@
                            string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
                            if (saveIsSuc != "TRUE")
                            {
                                LogHelper.Error(saveObj.ToString());
                                LogHelper.Error("日计划用料清单列表生成失败:" + jsonRoot.ToString());
                                this.View.ShowMessage(saveObj["Result"]["ResponseStatus"]["Errors"][0]["Message"].ToString());
                            }
                            Fentity = new JArray();
                        }