From 0fcc730fb3fa804c6e38f6f980eb15ee0a84eb33 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期三, 08 九月 2021 13:24:15 +0800
Subject: [PATCH] 送货计划保存删除 反写提料计划 服务插件
---
src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs | 49 ++++++++++++++-----------------------------------
1 files changed, 14 insertions(+), 35 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
index fcde28b..68bccb4 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
@@ -24,36 +24,15 @@
base.BarItemClick(e);
try
{
- if (e.BarItemKey.ToUpper() == "TBDAYPLANMENU")
+
+ //涓昏〃鍏抽棴
+ if (e.BarItemKey.ToUpper() == "BTNCLOSE")
{
- string pageId = Guid.NewGuid().ToString();
- ListShowParameter showParameter = new ListShowParameter();
- showParameter.FormId = "Paez_Sc_WorkBillAutoSortBill";
- showParameter.PageId = pageId;
- showParameter.UseOrgId = this.Context.CurrentOrganizationInfo.ID;
- showParameter.IsLookUp = true;
- this.View.ShowForm(showParameter);
-
- this.View.ShowForm(showParameter, delegate (FormResult result)
- {
- object returnData = result.ReturnData;
- if (returnData is ListSelectedRowCollection)
- {
- ListSelectedRowCollection listSelectedRowCollection = returnData as ListSelectedRowCollection;
- if (listSelectedRowCollection != null)
- {
- DynamicObjectDataRow datarow = (DynamicObjectDataRow)listSelectedRowCollection[0].DataRow;
-
- this.View.Model.SetValue("FMATERIALID", datarow.DynamicObject["FHMaterID_Id"].ToString());
- this.View.Model.SetValue("FPROORDERNO", datarow.DynamicObject["FSCOrderNo"].ToString());
- this.View.Model.SetValue("FQty", datarow.DynamicObject["FHOrderNeedQty"].ToString());
- this.View.Model.SetValue("FDayPlanFID", datarow.DynamicObject["FID"].ToString());
- this.View.Model.SetValue("FDayPlanFentryID", datarow.DynamicObject["t1_FENTRYID"].ToString());
- this.View.Model.SetValue("FSourceBillNo", datarow.DynamicObject["FBillNo"].ToString());
- this.View.Model.SetValue("FSourceBillType", datarow.DynamicObject["FBillTypeID"].ToString());
- }
- }
- });
+ var FID = this.View.Model.GetPKValue();
+ string sql = $"/*dialect*/ update Sc_WorkBillSortBillMain set FDocumentStatus = 'E' where FID = {FID}";
+ DBServiceHelper.Execute(Context, sql);
+ this.View.Refresh();
+ this.View.ShowMessage("鎿嶄綔鎴愬姛");
}
}
catch (Exception ex)
@@ -83,11 +62,11 @@
left join T_PRD_INSTOCKENTRY c on b.FENTRYID = c.FSrcEntryId
where a.FEntryID in ({0})", selectedRow["Id"]);
decimal FRealQty = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
- if (FRealQty == 0)
- {
- result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屾棩璁″垝鏄庣粏鏈笅鎺ㄧ敓鎴愮敓浜у叆搴撳崟\r\n");
- continue;
- }
+ //if (FRealQty == 0)
+ //{
+ // result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屾棩璁″垝鏄庣粏鏈笅鎺ㄧ敓鎴愮敓浜у叆搴撳崟\r\n");
+ // continue;
+ //}
sql = string.Format(@"
/*dialect*/
select count(*)res from Sc_WorkBillSortBillSub a
@@ -99,7 +78,7 @@
decimal Count = DBServiceHelper.ExecuteScalar<decimal>(Context, sql, 0);
if (Count > 0)
{
- result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屼笅娓搁鏂欏崟鐨勫凡棰嗘枡鏁板皬浜庡叆搴撶殑鏍囧噯鐢ㄩ噺\r\n");
+ result.Append($"鍒嗗綍琛岋細{selectedRow["Seq"]}锛屼笅娓搁鏂欏崟鐨勫凡棰嗘枡鏁板ぇ浜庡叆搴撶殑鏍囧噯鐢ㄩ噺\r\n");
continue;
}
sql = string.Format(@"
--
Gitblit v1.9.1