From 7af4d9d0181f2442bc60b218ec65bfaf831d0422 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 02 九月 2021 09:27:22 +0800
Subject: [PATCH] nothing
---
src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs | 55 +++++++++++++++++++------------------------------------
1 files changed, 19 insertions(+), 36 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs b/src/BLL/Demo.BillView/PRD/Pro_DayPlan.cs
index 585f532..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(@"
@@ -112,13 +91,15 @@
where FEntryID={1}", FRealQty, selectedRow["Id"]);
sqlList.Add(sql);
}
+ var fid = this.View.Model.GetPKValue();
+ sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
DBServiceHelper.ExecuteBatch(Context, sqlList);
this.View.Refresh();
if (string.IsNullOrEmpty(result.ToString()))
this.View.ShowMessage("鎿嶄綔鎴愬姛");
else
this.View.ShowErrMessage(result.ToString());
-
+
}
else if (e.BarItemKey.ToUpper() == "TBROWCANCELCLOSE")
{
@@ -140,6 +121,8 @@
where FEntryID={0}", selectedRow["Id"]);
sqlList.Add(sql);
}
+ var fid = this.View.Model.GetPKValue();
+ sqlList.Add($"update Sc_WorkBillSortBillMain set FCloseCount = (select sum(FNotInStockCount) from Sc_WorkBillSortBillSub where FID ={fid}) where FID ={fid}");
DBServiceHelper.ExecuteBatch(Context, sqlList);
this.View.Refresh();
this.View.ShowMessage("鎿嶄綔鎴愬姛");
--
Gitblit v1.9.1