From 0ce538e3c3dc01153ce1bfc2d75276881206c222 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 12 十一月 2021 13:34:35 +0800
Subject: [PATCH] 产品代码上传
---
src/BLL/Demo.BillView/PRD/Pro_DayPlanList.cs | 83 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 80 insertions(+), 3 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlanList.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlanList.cs
index cdabb6b..fbacfe4 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlanList.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlanList.cs
@@ -12,10 +12,11 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
+using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
-using ZD.Cloud.Logger;
+
namespace Demo.BillView.PRD
{
@@ -51,13 +52,89 @@
FID = FID + ID[i].ToString() + ",";
}
FID = FID.Substring(0, FID.Length - 1);
- string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'E' where FID in ({FID})";
- //LogHelper.Info(sql);
+ string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'E',FHCloseMan = '{Context.UserId}',FHCloseDate = GETDATE() where FID in ({FID})";
+ ////LogHelper.Info(sql);
DBServiceHelper.Execute(Context, sql);
this.View.ShowMessage("鎿嶄綔鎴愬姛");
}
}
+ //鍙嶅叧闂�
+ else if (e.BarItemKey.Equals("BTNCANCELCLOSE"))
+ {
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽//鑾峰彇閫夋嫨璁板綍
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽ListSelectedRowCollection selectRows = this.ListView.SelectedRowsInfo;
+ //璇诲彇ID,鏀惧埌鏁扮粍
+ string[] ID = selectRows.GetPrimaryKeyValues();
+ string FID = "";
+
+ //娌℃湁閫夋嫨琛屾彁绀�
+ if (ID.Length == 0)
+ {
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽//濡傛灉閫夋嫨鐨勬槸0,鍗虫病鏈夐�夋嫨琛岃褰�,寮圭獥鎶ラ敊,杩斿洖
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽this.View.ShowMessage("璇烽�夋嫨鍗曟嵁!", MessageBoxType.Notice);
+ return;
+ }
+ else
+ {
+ //濡傛灉鐐瑰嚮鎴愬姛,寰幆ID
+ for (int i = 0; i < ID.Length; i++)
+ {
+ FID = FID + ID[i].ToString() + ",";
+ }
+ FID = FID.Substring(0, FID.Length - 1);
+ //楠岃瘉 鍏抽棴璁㈠崟
+ //楠岃瘉鎵�閫夎鍗曟槸鍚﹀瓨鍦ㄧ浉鍚屾暟鎹� 鐢熶骇璁㈠崟鍙�+鐢熶骇璁㈠崟鏄庣粏琛屽彿
+ string errmsg = "";
+ string fbillno = "";
+ string yzSql = string.Format(@"/*dialect*/
+SELECT FBILLNO FROM SC_WORKBILLSORTBILLMAIN WHERE FSCORDERNO+CONVERT(VARCHAR,FSRCBILLENTRYSEQ) IN (
+SELECT FSCORDERNO+CONVERT(VARCHAR,FSRCBILLENTRYSEQ) FROM SC_WORKBILLSORTBILLMAIN
+WHERE FID IN ({0})
+GROUP BY
+FSCORDERNO,FSRCBILLENTRYSEQ
+HAVING COUNT(*)>1
+)", FID);
+ DataTable dataTable = DBServiceHelper.ExecuteDataSet(Context, yzSql).Tables[0];
+ if (dataTable.Rows.Count > 0)
+ {
+ errmsg += "鎵�閫夎鍗曚腑瀛樺湪鐩稿悓鐢熶骇璁㈠崟鍜屾槑缁嗚鍙锋暟鎹�,璁㈠崟鍙凤細";
+ foreach (DataRow dr in dataTable.Rows)
+ {
+ errmsg += dr["FBILLNO"].ToString();
+ fbillno += $"'{dr["FBILLNO"].ToString()}',";
+ }
+ }
+ yzSql = string.Format(@"/*dialect*/
+SELECT A.FBILLNO FROM SC_WORKBILLSORTBILLMAIN A
+JOIN (SELECT * FROM SC_WORKBILLSORTBILLMAIN WHERE FDOCUMENTSTATUS <>'E') B ON A.FSCORDERNO=B.FSCORDERNO AND A.FSRCBILLENTRYSEQ=B.FSRCBILLENTRYSEQ
+WHERE A.FID IN ({0})
+", FID);
+ dataTable = DBServiceHelper.ExecuteDataSet(Context, yzSql).Tables[0];
+ if (dataTable.Rows.Count > 0)
+ {
+ errmsg += "\n" + "鎵�閫夎鍗曚腑瀛樺湪鐢熶骇璁㈠崟鍜屾槑缁嗚鍙峰叧闂悗鏁版嵁閲嶅,璁㈠崟鍙凤細";
+ foreach (DataRow dr in dataTable.Rows)
+ {
+ errmsg += dr["FBILLNO"].ToString();
+ fbillno += $"'{dr["FBILLNO"].ToString()}',";
+ }
+ }
+ string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'C',FHCloseMan = '',FHCloseDate = NULL where FID in ({FID})";
+ if (fbillno.Length > 0) {
+ fbillno = fbillno.Substring(0, fbillno.Length - 1);
+ sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'C',FHCloseMan = '',FHCloseDate = NULL where FID in ({FID}) AND FBILLNO NOT IN ({fbillno})";
+ }
+ ////LogHelper.Info(sql);
+ DBServiceHelper.Execute(Context, sql);
+ if (errmsg != "")
+ {
+ this.View.ShowMessage("閮ㄥ垎鍗曟嵁鎿嶄綔鎴愬姛\n" + errmsg);
+ return;
+ }
+ this.View.ShowMessage("鎿嶄綔鎴愬姛");
+ }
+ }
}
}
}
--
Gitblit v1.9.1