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/PODemandPlanListFilter.cs | 54 +++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 51 insertions(+), 3 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs b/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
index 6ea520c..09491d9 100644
--- a/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
+++ b/src/BLL/Demo.BillView/PRD/PODemandPlanListFilter.cs
@@ -21,15 +21,63 @@
using Kingdee.BOS.Core.Metadata;
using Kingdee.K3.MFG.ServiceHelper;
using Kingdee.BOS;
-using ZD.Cloud.Logger;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+using Kingdee.BOS.Core.List;
namespace Demo.BillView.PRD
{
- [Description("鎻愭枡璁″垝鍒楄〃杩囨护")]
+ [Description("鎻愭枡璁″垝鍒楄〃 鍒楄〃鎻掍欢")]
[HotUpdate]
public class PODemandPlanListFilter : AbstractListPlugIn
{
+ public override void BarItemClick(BarItemClickEventArgs e)
+ {
+ base.BarItemClick(e);
+ //鍏抽棴
+ if (e.BarItemKey.ToUpper().Equals("BTNCLOSE"))
+ {
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽//鑾峰彇閫夋嫨璁板綍
+聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽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 sql = string.Format(@"/*dialect*/
+update Cg_PODemandPlanBillMain set
+FHCloseMan = {0},
+FHCloseDate = GETDATE(),
+FHCloseType = 1
+where fid IN ({1})", Context.UserId, FID);
+ DBServiceHelper.Execute(Context, sql);
+ sql = string.Format(@"/*dialect*/
+UPDATE A SET
+A.FPODemandPlanCount -= B.FHQTY
+FROM t_PUR_POOrderEntry A
+JOIN Cg_PODemandPlanBillSub B ON A.FENTRYID = B.FHPOOrderEntryID
+where B.FID IN (select FID FROM Cg_PODemandPlanBillMain WHERE FHCloseType = 0 AND FID IN ({0})) AND B.FCLOSESTATUS = 0
+", FID);
+ this.View.Refresh();
+ this.View.ShowMessage("鎿嶄綔鎴愬姛");
+ }
+ }
+ }
+
public override void PrepareFilterParameter(global::Kingdee.BOS.Core.List.PlugIn.Args.FilterArgs e)
{
base.PrepareFilterParameter(e);
@@ -51,7 +99,7 @@
{
long userId = this.Context.UserId;
string sql = $"/*dialect*/ select FSupplierId from T_SEC_user a join T_SCP_USERDATA b on a.FUSERID = b.FUSERID where FUSERTYPE = 2 and a.FUSERID ={userId}";
- //LogHelper.Info(sql);
+ ////LogHelper.Info(sql);
int FSupplierId = DBServiceHelper.ExecuteScalar<int>(Context, sql, 0);
return FSupplierId;
}
--
Gitblit v1.9.1