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_DayPlan.cs | 24 ++++++++++++++++++++++--
1 files changed, 22 insertions(+), 2 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
index 68bccb4..081497e 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
@@ -11,6 +11,7 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
+using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
@@ -24,12 +25,31 @@
base.BarItemClick(e);
try
{
-
//涓昏〃鍏抽棴
if (e.BarItemKey.ToUpper() == "BTNCLOSE")
{
var FID = this.View.Model.GetPKValue();
- string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'E' where FID = {FID}";
+ string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'E',FHCloseMan = '{Context.UserId}',FHCloseDate = GETDATE() where FID = {FID}";
+ DBServiceHelper.Execute(Context, sql);
+ this.View.Refresh();
+ this.View.ShowMessage("鎿嶄綔鎴愬姛");
+ }
+ //鍙嶅叧闂�
+ if (e.BarItemKey.ToUpper() == "BTNCANCELCLOSE")
+ {
+ var FID = this.View.Model.GetPKValue();
+ string 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 dataTable = DBServiceHelper.ExecuteDataSet(Context, yzSql).Tables[0];
+ if (dataTable.Rows.Count > 0)
+ {
+ this.View.ShowErrMessage("鍙嶅叧闂悗浼氬瓨鍦ㄧ敓浜ц鍗曞拰鏄庣粏琛屽彿鏁版嵁閲嶅");
+ return;
+ }
+ string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'C',FHCloseMan = '',FHCloseDate = NULL where FID = {FID}";
DBServiceHelper.Execute(Context, sql);
this.View.Refresh();
this.View.ShowMessage("鎿嶄綔鎴愬姛");
--
Gitblit v1.9.1