From 4c6efec8ce7a716d730c476bd055ff76a2435593 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 12 三月 2021 17:36:48 +0800
Subject: [PATCH] nothing
---
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 45 ++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 42 insertions(+), 3 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index 615552b..cfc5ebd 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/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();
}
--
Gitblit v1.9.1