From 3ee1243be7aa6a7bdbfc23a96da82dc72b4de3b4 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期四, 31 十二月 2020 11:25:06 +0800
Subject: [PATCH] 代码上传
---
src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs | 33 +++++-
src/BLL/Demo.BillView/Demo.BillView.csproj | 1
src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs | 26 ++---
src/BLL/Demo.BillView/PRD/ProTardinessDetails.cs | 136 +++++++++++++++++++++++++++
src/Model/Demo.Model/Model/CompleteAnalysisTempModel.cs | 4
src/BLL/Demo.BillView/PRD/PODemandPlanListLoad.cs | 4
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 82 +++++++++-------
7 files changed, 223 insertions(+), 63 deletions(-)
diff --git a/src/BLL/Demo.BillView/Demo.BillView.csproj b/src/BLL/Demo.BillView/Demo.BillView.csproj
index e32c608..93b4deb 100644
--- a/src/BLL/Demo.BillView/Demo.BillView.csproj
+++ b/src/BLL/Demo.BillView/Demo.BillView.csproj
@@ -196,6 +196,7 @@
<ItemGroup>
<Compile Include="PRD\LogService.cs" />
<Compile Include="PRD\PODemandPlanListLoad.cs" />
+ <Compile Include="PRD\ProTardinessDetails.cs" />
<Compile Include="PRD\ProCompleteAnalysisMateriel.cs" />
<Compile Include="PRD\ProCompleteAnalysisDetails.cs" />
<Compile Include="PRD\Pro_ScDayImport.cs" />
diff --git a/src/BLL/Demo.BillView/PRD/PODemandPlanListLoad.cs b/src/BLL/Demo.BillView/PRD/PODemandPlanListLoad.cs
index 1bdae6d..5a61a52 100644
--- a/src/BLL/Demo.BillView/PRD/PODemandPlanListLoad.cs
+++ b/src/BLL/Demo.BillView/PRD/PODemandPlanListLoad.cs
@@ -16,8 +16,6 @@
public override void OnFormatRowConditions(Kingdee.BOS.Core.List.PlugIn.Args.ListFormatConditionArgs args)
{
base.OnFormatRowConditions(args);
-
-
//1.浜哄憳浜ц兘涓嶈冻 绾㈣壊
//2.妯″叿璁惧褰卞搷
//3.鍘熸枡澶囪揣寤舵湡 姗欒壊
@@ -25,8 +23,6 @@
//5.璁捐鍙樻洿鍥犵礌褰卞搷 榛勮壊
//6.蹇�掔墿娴佸師鍥�
//7.涓嶅彲鎶楀姏鍥犵礌 钃濊壊
-
-
FormatCondition fc = new FormatCondition();
fc.ApplayRow = true;
diff --git a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
index 2286bd4..06bd552 100644
--- a/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
+++ b/src/BLL/Demo.BillView/PRD/ProCompleteAnalysisDetails.cs
@@ -1,18 +1,14 @@
-锘縰sing Kingdee.BOS.App.Data;
-using Kingdee.BOS.Core.DynamicForm;
+锘縰sing Kingdee.BOS.Core.DynamicForm;
using Kingdee.BOS.Core.DynamicForm.PlugIn;
-using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
-using Kingdee.BOS.Core.Metadata.EntityElement;
using Kingdee.BOS.Orm.DataEntity;
using Kingdee.BOS.Util;
using System;
-using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
-using System.Linq;
-using System.Text;
using Kingdee.BOS.ServiceHelper;
-using System.Threading.Tasks;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+using Kingdee.BOS.Core.Metadata.EntityElement;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel;
namespace Demo.BillView
{
@@ -49,6 +45,7 @@
this.Model.SetValue("FLackCount", dt.Rows[i]["FLackCount"], i);//缂烘枡鏁伴噺
this.Model.SetValue("FPassableCount", dt.Rows[i]["FHLeftQty"].ToString(), i);//鍙敤鏁伴噺
this.Model.SetValue("FMateralCount", dt.Rows[i]["FHStockQty"].ToString(), i);//鐗╂枡鏁伴噺
+ this.Model.SetValue("FOccupyCount", dt.Rows[i]["FOccupyCount"].ToString(), i);//鍗犵敤鏁伴噺
this.Model.SetValue("FCompleteDetailStatus", dt.Rows[i]["FComPlete"].ToString(), i);//鏄惁榻愬
this.Model.SetValue("FHMainICMOInterIDr", dt.Rows[i]["FHMainICMOInterIDr"].ToString(), i);//鐢熶骇璁㈠崟鍐呯爜
this.Model.SetValue("FPRDBillNo", dt.Rows[i]["FPRDBillNo"].ToString(), i);//鐢熶骇璁㈠崟鍐呯爜
@@ -61,6 +58,26 @@
did = true;
}
}
+ public override void AfterBindData(EventArgs e)
+ {
+ base.AfterBindData(e);
+ //鑾峰彇鍗曟嵁浣撲俊鎭�
+ //Entity entity = this.View.BillBusinessInfo.GetEntity("FEntity");
+ ////鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
+ //DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
+ //EntryGrid grid = this.View.GetControl<EntryGrid>("FEntity");
+ //int i = 0;
+ //foreach (DynamicObject current in entityDataObjoct)
+ //{
+ // if (Convert.ToString(current["FCompleteDetailStatus"]) == "鏈綈濂�")
+ // {
+ // grid.SetBackcolor("FEntity", "#FF0000", i);
+ // }
+ // i++;
+ //}
+ //this.View.UpdateView();
+ }
+
public override void BarItemClick(BarItemClickEventArgs e)
{
base.BarItemClick(e);
diff --git a/src/BLL/Demo.BillView/PRD/ProTardinessDetails.cs b/src/BLL/Demo.BillView/PRD/ProTardinessDetails.cs
new file mode 100644
index 0000000..da8cb12
--- /dev/null
+++ b/src/BLL/Demo.BillView/PRD/ProTardinessDetails.cs
@@ -0,0 +1,136 @@
+锘縰sing Kingdee.BOS.Core.DynamicForm;
+using Kingdee.BOS.Core.DynamicForm.PlugIn;
+using Kingdee.BOS.Orm.DataEntity;
+using Kingdee.BOS.Util;
+using System;
+using System.ComponentModel;
+using System.Data;
+using Kingdee.BOS.ServiceHelper;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
+
+namespace Demo.BillView
+{
+ [Description("鐢熶骇璁″垝骞冲彴鎷栨湡鏄庣粏")]
+ [HotUpdate]
+ public class ProTardinessDetails : AbstractDynamicFormPlugIn
+ {
+ bool did = false;
+ string FID = "";
+ public override void OnLoad(EventArgs e)
+ {
+ base.OnLoad(e);
+ if (this.View.OpenParameter.GetCustomParameter("FID") == null)
+ {
+ SearchList();
+ }
+ else
+ {
+ if (did)
+ return;
+ FID = this.View.OpenParameter.GetCustomParameter("FID").ToString();
+ string sql = string.Format(@"
+/*dialect*/
+ select a.*,b.FHMASTERDATE,b.FHQTY,b.FNOTPRODUCTNUM,FHCloseManSub from SC_WORKBILLSORTBILLMain a
+ join SC_WORKBILLSORTBILLSub b on a.FID=b.FID
+ where DATEDIFF(D,FHMASTERDATE,GETDATE())>0 and isnull(FHCloseManSub,'')=''
+ and FNOTPRODUCTNUM>0
+ and a.FID='{0}'
+", FID);
+ DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
+ if (dt.Rows.Count > 0)
+ {
+ for (int i = 0; i < dt.Rows.Count; i++)
+ {
+ this.Model.CreateNewEntryRow("FEntity");
+ this.Model.SetValue("FSEQ", i + 1, i);//搴忓彿
+ //this.Model.SetValue("FCompleteSetCount", "", i);//鎬婚綈濂楁暟閲�
+ this.Model.SetValue("FProOrderCount", dt.Rows[i]["FHOrderNeedQty"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FSalOrderCount", dt.Rows[i]["FHSeOrderBillNo"].ToString(), i);//閿�鍞鍗曟暟閲�
+ this.Model.SetValue("FBatch", dt.Rows[i]["FBatch"].ToString(), i);//鎵规鍙�
+ this.Model.SetValue("FUnit", dt.Rows[i]["FHUnitID"].ToString(), i);//璁￠噺鍗曚綅
+ this.Model.SetValue("FORGID", dt.Rows[i]["FHPRDORGID"].ToString(), i);//鐢熶骇缁勭粐
+ this.Model.SetValue("FMatrailId", dt.Rows[i]["FHMaterID"].ToString(), i);//浜у搧浠ｇ爜
+ this.Model.SetValue("FDeliverydate", dt.Rows[i]["FHOrderCommitDate"].ToString(), i);//浜よ揣鏃ユ湡
+ this.Model.SetValue("FOrderLevel", dt.Rows[i]["FHOrderLev"].ToString(), i);//璁㈠崟绛夌骇
+ this.Model.SetValue("FSCOrderNo", dt.Rows[i]["FSCOrderNo"].ToString(), i);//鐢熶骇璁㈠崟鍙�
+ this.Model.SetValue("FSalOrderNo", dt.Rows[i]["FHSEORDERBILLNO"].ToString(), i);//閿�鍞鍗曞彿
+ this.Model.SetValue("FBzDate", dt.Rows[i]["FPreparatDate"].ToString(), i);//缂栧埗鏃ユ湡
+ this.Model.SetValue("FProOrderCount", dt.Rows[i]["FHOrderNeedQty"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FHMainSourceInterID", dt.Rows[i]["FPRDMOMAINID"].ToString(), i);//婧愬崟涓诲唴鐮丗HMainSourceInterID
+ this.Model.SetValue("FHMainSourceEntryID", dt.Rows[i]["FPRDMOENTYID"].ToString(), i);//婧愬崟瀛愬唴鐮丗HMainSourceEntryID
+ this.Model.SetValue("FDayPlanWorkID", dt.Rows[i]["FID"].ToString(), i);//鏃ヨ鍒掑伐鍗旻ID
+ this.Model.SetValue("FResourcesId", dt.Rows[i]["FHSourceID"].ToString(), i);//鐢熶骇璧勬簮
+ this.Model.SetValue("FProductWorkShopId", dt.Rows[i]["FHWorkShopID"].ToString(), i);//鐢熶骇杞﹂棿
+ this.Model.SetValue("FOrderQuantity", dt.Rows[i]["FOrderQuantity"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FDayPlanQuantity", dt.Rows[i]["FHQTY"].ToString(), i);//鏃ヨ鍒掓暟閲�
+ this.Model.SetValue("FDelaylnUM", dt.Rows[i]["FNotProductNum"].ToString(), i);//鎷栨湡鏁伴噺
+ this.Model.SetValue("FPlanDate", dt.Rows[i]["FHMASTERDATE"].ToString(), i);//鎷栨湡鏁伴噺
+
+ }
+ }
+ did = true;
+ }
+ }
+ public override void BarItemClick(BarItemClickEventArgs e)
+ {
+ base.BarItemClick(e);
+ if (e.BarItemKey.ToUpper() == "TBFILTER")
+ {
+ SearchList();
+ }
+ }
+ /// <summary>
+ /// 鏌ヨ浜嬩欢
+ /// </summary>
+ public void SearchList()
+ {
+ string sqlwhere = "AND a.FID ='" + FID + "'";
+ //鏃ヨ鍒掓棩鏈�
+ string FPlanDate = Convert.ToString(this.Model.GetValue("FDate"));
+ if (!string.IsNullOrEmpty(FPlanDate))
+ sqlwhere += $" and FHMASTERDATE='{FPlanDate}'";
+
+ string sql = string.Format(@"
+/*dialect*/
+ select a.*,b.FHMASTERDATE,b.FHQTY,b.FNOTPRODUCTNUM,FHCloseManSub from SC_WORKBILLSORTBILLMain a
+ join SC_WORKBILLSORTBILLSub b on a.FID=b.FID
+ where DATEDIFF(D,FHMASTERDATE,GETDATE())>0 and isnull(FHCloseManSub,'')=''
+ and FNOTPRODUCTNUM>0
+");
+ sql += sqlwhere;
+ DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
+ this.Model.DeleteEntryData("FEntity");
+ if (dt.Rows.Count > 0)
+ {
+ for (int i = 0; i < dt.Rows.Count; i++)
+ {
+ this.Model.CreateNewEntryRow("FEntity");
+ this.Model.SetValue("FSEQ", i + 1, i);//搴忓彿
+ this.Model.SetValue("FProOrderCount", dt.Rows[i]["FHOrderNeedQty"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FSalOrderCount", dt.Rows[i]["FHSeOrderBillNo"].ToString(), i);//閿�鍞鍗曟暟閲�
+ this.Model.SetValue("FBatch", dt.Rows[i]["FBatch"].ToString(), i);//鎵规鍙�
+ this.Model.SetValue("FUnit", dt.Rows[i]["FHUnitID"].ToString(), i);//璁￠噺鍗曚綅
+ this.Model.SetValue("FORGID", dt.Rows[i]["FHPRDORGID"].ToString(), i);//鐢熶骇缁勭粐
+ this.Model.SetValue("FMatrailId", dt.Rows[i]["FHMaterID"].ToString(), i);//浜у搧浠ｇ爜
+ this.Model.SetValue("FDeliverydate", dt.Rows[i]["FHOrderCommitDate"].ToString(), i);//浜よ揣鏃ユ湡
+ this.Model.SetValue("FOrderLevel", dt.Rows[i]["FHOrderLev"].ToString(), i);//璁㈠崟绛夌骇
+ this.Model.SetValue("FSCOrderNo", dt.Rows[i]["FSCOrderNo"].ToString(), i);//鐢熶骇璁㈠崟鍙�
+ this.Model.SetValue("FSalOrderNo", dt.Rows[i]["FHSEORDERBILLNO"].ToString(), i);//閿�鍞鍗曞彿
+ this.Model.SetValue("FBzDate", dt.Rows[i]["FPreparatDate"].ToString(), i);//缂栧埗鏃ユ湡
+ this.Model.SetValue("FProOrderCount", dt.Rows[i]["FHOrderNeedQty"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FHMainSourceInterID", dt.Rows[i]["FPRDMOMAINID"].ToString(), i);//婧愬崟涓诲唴鐮丗HMainSourceInterID
+ this.Model.SetValue("FHMainSourceEntryID", dt.Rows[i]["FPRDMOENTYID"].ToString(), i);//婧愬崟瀛愬唴鐮丗HMainSourceEntryID
+ this.Model.SetValue("FDayPlanWorkID", dt.Rows[i]["FID"].ToString(), i);//鏃ヨ鍒掑伐鍗旻ID
+ this.Model.SetValue("FResourcesId", dt.Rows[i]["FHSourceID"].ToString(), i);//鐢熶骇璧勬簮
+ this.Model.SetValue("FProductWorkShopId", dt.Rows[i]["FHWorkShopID"].ToString(), i);//鐢熶骇杞﹂棿
+ this.Model.SetValue("FOrderQuantity", dt.Rows[i]["FOrderQuantity"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
+ this.Model.SetValue("FDayPlanQuantity", dt.Rows[i]["FHQTY"].ToString(), i);//鏃ヨ鍒掓暟閲�
+ this.Model.SetValue("FDelaylnUM", dt.Rows[i]["FNotProductNum"].ToString(), i);//鎷栨湡鏁伴噺
+ this.Model.SetValue("FPlanDate", dt.Rows[i]["FHQTY"].ToString(), i);//鎷栨湡鏁伴噺
+ }
+ }
+ this.View.UpdateView();
+ did = true;
+ }
+ }
+}
diff --git a/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs b/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs
index eef07d7..ebac424 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_ScDayImport.cs
@@ -358,14 +358,9 @@
jsonFPOOrderEntry.Add("FColumn", "FT" + "" + i + ""); ;//瀵瑰簲鐨勫垪澶�
Entry.Add(jsonFPOOrderEntry);
}
- }
- jsonModel.Add("FEntity", Entry);
- //鏃ヨ鍒掑伐鍗曚笉涓虹┖鏃秛pdate
- if (Convert.ToString(current["FDayPlanID"]) != "0")
- {
+ jsonModel.Add("FEntity", Entry);
jsonModel.Add("FID", Convert.ToString(current["FDayPlanID"])); ;//婧愬崟缂栧彿
jsonRoot.Add("Model", jsonModel);
- CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");
var result = cloudClient.Save("Paez_Sc_WorkBillAutoSortBill", jsonRoot.ToString());
JObject saveObj = JObject.Parse(result);
string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
@@ -374,13 +369,10 @@
{
string FDayPlanBillNo = saveObj["Result"]["Number"].ToString();
string FDayPlanID = saveObj["Result"]["Id"].ToString();
- this.Model.SetValue("FDayPlanBillNo", FDayPlanBillNo, Convert.ToInt32(current["SEQ"]) - 1);//
- this.Model.SetValue("FDayPlanID", FDayPlanID, Convert.ToInt32(current["SEQ"]) - 1);//
this.View.ShowMessage("瀵煎叆鎴愬姛");
}
else
{
- //LogService.WriteAsync(saveIsSuc);
LogService.WriteAsync(jsonRoot);
LogHelper.Error(jsonRoot.ToString());
this.View.ShowErrMessage(jsonRoot.ToString());
@@ -388,8 +380,16 @@
}
else
{
+ for (int i = 0; i <= 60; i++)
+ {
+ JObject jsonFPOOrderEntry = new JObject();
+ jsonFPOOrderEntry.Add("FHMasterDate", date.AddDays(i).ToShortDateString()); ;//涓绘棩鏈�
+ jsonFPOOrderEntry.Add("FHQty ", Convert.ToString(current["FT" + "" + i + ""])); ;//鏃ヨ鍒掓暟閲�
+ jsonFPOOrderEntry.Add("FColumn", "FT" + "" + i + ""); ;//瀵瑰簲鐨勫垪澶�
+ Entry.Add(jsonFPOOrderEntry);
+ }
+ jsonModel.Add("FEntity", Entry);
jsonRoot.Add("Model", jsonModel);
- CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");
var result = cloudClient.Save("Paez_Sc_WorkBillAutoSortBill", jsonRoot.ToString());
JObject saveObj = JObject.Parse(result);
string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
@@ -398,21 +398,15 @@
{
string FDayPlanBillNo = saveObj["Result"]["Number"].ToString();
string FDayPlanID = saveObj["Result"]["Id"].ToString();
-
this.Model.SetValue("FDayPlanBillNo", FDayPlanBillNo, Convert.ToInt32(current["SEQ"]) - 1);//
this.Model.SetValue("FDayPlanID", FDayPlanID, Convert.ToInt32(current["SEQ"]) - 1);//
this.View.ShowMessage("瀵煎叆鎴愬姛");
-
}
else
{
- // LogService.WriteAsync(saveIsSuc);
LogService.WriteAsync(jsonRoot);
LogHelper.Error(jsonRoot.ToString());
-
this.View.ShowErrMessage(jsonRoot.ToString());
-
-
}
}
this.View.UpdateView();
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index 9767d5a..75a9132 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -115,7 +115,6 @@
public override void EntryBarItemClick(BarItemClickEventArgs e)
{
base.EntryBarItemClick(e);
-
if (e.BarItemKey.ToUpper() == "TBEDIT")
{
SearchListEdit();
@@ -127,23 +126,25 @@
/// <param name="e"></param>
public override void EntityRowDoubleClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.EntityRowClickEventArgs e)
{
- var m = e.Row;
- var n = e.Key;
base.EntityRowClick(e);
+
DynamicFormShowParameter formPa = new DynamicFormShowParameter();
- formPa.FormId = "paez_CompleteAnalysisDetail";
- /* jsonModel.Add("FHMainICMOInterID", FMainInterID);//涓荤敓浜ц鍗曚富鍐呯爜
- jsonModel.Add("FHMainICMOEntryID", FMainEntryID);//涓荤敓浜ц鍗曞瓙鍐呯爜
- jsonModel.Add("FHICMOInterID", FDayPlanWorkID);//鏃ヨ鍒掕鍗曚富鍐呯爜
- current["FMatrailId_Id"].ToString(), current["FHMainSourceInterID"].ToString(), current["FHMainSourceEntryID"].ToString(), current["FDayPlanWorkID"].ToString())
-
- */
-
- formPa.CustomParams.Add("FHMainICMOInterID", Convert.ToString(this.View.Model.GetValue("FHMainSourceInterID", e.Row).ToString()));
- formPa.CustomParams.Add("FHMainICMOEntryID", Convert.ToString(this.View.Model.GetValue("FHMainSourceEntryID", e.Row).ToString()));
- formPa.CustomParams.Add("FHICMOInterID", Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString()));
- formPa.CustomParams.Add("FMatrailId_Id", Convert.ToString((this.View.Model.GetValue("FMatrailId", e.Row) as DynamicObject)["Id"].ToString()));
+ if (e.ColKey == "FDELAYLNUM")
+ {
+ //鐢熶骇璁″垝骞冲彴鎷栨湡鏄庣粏璺宠浆
+ formPa.FormId = "paez_TardinessDetails";
+ formPa.CustomParams.Add("FID", Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString()));
+ }
+ else
+ {
+ //榻愬鍒嗘瀽鏄庣粏鍒楄〃璺宠浆
+ formPa.FormId = "paez_CompleteAnalysisDetail";
+ formPa.CustomParams.Add("FHMainICMOInterID", Convert.ToString(this.View.Model.GetValue("FHMainSourceInterID", e.Row).ToString()));
+ formPa.CustomParams.Add("FHMainICMOEntryID", Convert.ToString(this.View.Model.GetValue("FHMainSourceEntryID", e.Row).ToString()));
+ formPa.CustomParams.Add("FHICMOInterID", Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString()));
+ formPa.CustomParams.Add("FMatrailId_Id", Convert.ToString((this.View.Model.GetValue("FMatrailId", e.Row) as DynamicObject)["Id"].ToString()));
+ }
this.View.ShowForm(formPa);
}
/// <summary>
@@ -711,7 +712,6 @@
/// </summary>
public void CompleteSetAnalysis()
{
-
try
{
Stopwatch sw = new Stopwatch();
@@ -760,7 +760,7 @@
string sql = @"
/*dialect*/
select a.FPRDMOMAINID,a.FPRDMOENTYID,a.FID,b.FEntryID,a.FHPRDORGID FStockOrgId,t5.FNUMBER as OrgFnumber,a.FHOrderLev,b.FHQTY,b.FHMASTERDATE,T1.FBillNo,T1.FMOBillNO,T1.FMOEntrySeq,T1.FMoId,T1.FMaterialID,T1.FQty,
-T2.FMATERIALID FMATERIALID2, T4.FNumber,T2.FNeedQty,FNeedQty/FQty dwyl,FHQTY*(FNeedQty/FQty) PlanCount from SC_WORKBILLSORTBILLMAIN a
+T2.FMATERIALID FMATERIALID2, T4.FNumber,T2.FNeedQty,FNeedQty/FQty dwyl,(FHQTY-ISNULL(FProductNum,0))*(FNeedQty/FQty) PlanCount from SC_WORKBILLSORTBILLMAIN a
join SC_WORKBILLSORTBILLSub b on a.FID = b.FID
join T_PRD_PPBOM T1 on a.FPRDMOMAINID = t1.FMoId and a.FPRDMOENTYID = t1.FMOENTRYID
LEFT JOIN(select FID, MAX(FENTRYID) FENTRYID, SUM(FNeedQty) FNeedQty, FMATERIALID from T_PRD_PPBOMENTRY
@@ -768,10 +768,10 @@
--LEFT JOIN T_STK_Inventory T3 on t2.FMATERIALID = t3.FMATERIALID
JOIN T_BD_MATERIAL T4 on T2.FMATERIALID = T4.FMATERIALID
JOIN T_ORG_Organizations t5 on a.FHPRDORGID = t5.FORGID
---where FPRDMOMAINID = 100010
---where t4.FMATERIALID in (105773
---)
-ORDER BY b.FHMASTERDATE,a.FHOrderLev ";
+--鏉′欢涓轰粖澶╁線鍚庣殑鏃ヨ鍒� + 浠婂ぉ涔嬪墠鏈叧闂殑鏃ヨ鍒�
+where (FHEntryCloseDate is null and DATEDIFF(D,GETDATE(),FHMASTERDATE)<0)or DATEDIFF(D,GETDATE(),FHMASTERDATE)>=0
+ORDER BY b.FHMASTERDATE,a.FHOrderLev
+";
ds = DBServiceHelper.ExecuteDataSet(Context, sql);
List<PRD_PPBOM> BomList = ds.ToModelList<PRD_PPBOM>();
//鏃ヨ鍒�+鐢熶骇璁㈠崟瀛愯〃缂栫爜ID
@@ -779,18 +779,17 @@
//CompleteAnalysisTempModel 鐢ㄤ簬瀛樺偍涓存椂闇�瑕佹彃鍏ユ暟鎹�
List<CompleteAnalysisTempModel> completeAnalysisTempModel = new List<CompleteAnalysisTempModel>();
int i = 1;
+ //鍒涘缓瀛楀吀 鐢ㄤ簬鍌ㄥ瓨鐗╂枡 + 鍗犵敤鏁伴噺
+ Dictionary<string, decimal> occupyDic = new Dictionary<string, decimal>();
foreach (var item in DatePlanList)
{
this.View.Session["ProcessRateValue"] = Convert.ToInt32(this.View.Session["ProcessRateValue"]) + Convert.ToInt32((decimal)(1.0 / DatePlanList.Count));
-
//绛涢�夊嚭褰撴棩璁″垝鏁版嵁
var _BomList = BomList.Where(x => x.FHMASTERDATE == item.FHMASTERDATE && x.FPRDMOENTYID == item.FPRDMOENTYID).ToList();
foreach (var _item in _BomList)
{
//璇ユ棩璁″垝鐗╂枡闇�瑕佹暟
decimal need = _item.PlanCount;
- //瀹為檯鎬诲簱瀛�
- decimal sjkc = 0;
var sjkcList = ListInventoryByStockOrgId.Where(x => x.FMATERIALID == _item.FMATERIALID2 && x.FStockOrgId == _item.FStockOrgId).FirstOrDefault();
//鐪熸闇�瑕佸彇璁＄畻鐨勬暟閲忥紙鎷嗗垎璐т富锛�
//璐т富鍖归厤
@@ -800,10 +799,20 @@
decimal _fLackCount = _item.PlanCount > sjkcList.FBASEQTY ? (_item.PlanCount - sjkcList.FBASEQTY) : 0;//缂烘枡鏁伴噺
foreach (var Inventory in _ListInventory)
{
+
if (need == 0)
break;
decimal fCompleteCount = need >= Inventory.FBASEQTY ? Inventory.FBASEQTY : need;//榻愬鏁伴噺
- //鎬昏鍒掓暟閲� 鍜� 鎬诲簱瀛樻暟閲忔瘮瀵�
+ decimal occupyMaterial = 0;
+ if (!occupyDic.ContainsKey(_item.FMATERIALID2))
+ {
+ occupyDic.Add(_item.FMATERIALID2, fCompleteCount);
+ }
+ else
+ {
+ occupyMaterial = occupyDic[_item.FMATERIALID2];
+ occupyDic[_item.FMATERIALID2] = occupyMaterial + fCompleteCount;
+ }
completeAnalysisTempModel.Add(new Demo.Model.Model.CompleteAnalysisTempModel
{
FHMainICMOInterIDr = _item.FPRDMOMAINID,
@@ -822,6 +831,7 @@
FLackCount = _fLackCount,//缂烘枡鏁伴噺
FHStockQty = sjkcList.FBASEQTY,//鍗虫椂搴撳瓨
FHLeftQty = Inventory.FBASEQTY,//鍙敤鏁伴噺
+ FOccupyCount = occupyMaterial,//鍗犵敤鏁伴噺
FComPlete = sjkcList.FBASEQTY >= _item.PlanCount ? "榻愬" : "鏈綈濂�",
FPlanDate = item.FHMASTERDATE // 鏃ヨ鍒掓棩鏈�
});
@@ -835,6 +845,9 @@
}
else
{
+ decimal occupyMaterial = 0;
+ if (occupyDic.ContainsKey(_item.FMATERIALID2))
+ occupyMaterial = occupyDic[_item.FMATERIALID2];
completeAnalysisTempModel.Add(new Demo.Model.Model.CompleteAnalysisTempModel
{
FHMainICMOInterIDr = _item.FPRDMOMAINID,
@@ -852,12 +865,13 @@
FLackCount = _item.PlanCount,//缂烘枡鏁伴噺
FHStockQty = 0,//鍗虫椂搴撳瓨
FHLeftQty = 0,//鍙敤鏁伴噺
+ FOccupyCount = occupyMaterial,//鍗犵敤鏁伴噺
FComPlete = "鏈綈濂�",
FPlanDate = item.FHMASTERDATE // 鏃ヨ鍒掓棩鏈�
});
}
}
- Thread.Sleep(100);
+ //Thread.Sleep(100);
this.View.Session["ProcessRateValue"] = Convert.ToInt32((Convert.ToDecimal(40) / DatePlanList.Count) * i);
i++;
@@ -891,6 +905,7 @@
jsonModel.Add("FOwnerTypeId", item.FOwnerTypeId);
jsonModel.Add("FComPlete", item.FComPlete);
jsonModel.Add("FLackCount", item.FLackCount);
+ jsonModel.Add("FOccupyCount", item.FOccupyCount);
jsonModel.Add("FPlanDate", item.FPlanDate);
if (item.FOwnerId != null)
jsonModel.Add("FOwnerId", new JObject() { ["FNUMBER"] = item.FOwnerId });
@@ -954,8 +969,8 @@
sqlwhere += $" and FPreparatDate='{FPreparatDate}'";
try
{
- string sql = @"/*dialect*/select t1.* from Sc_WorkBillSortBillMain t1
- left join T_BD_MATERIAL t3 on t1.FHMaterID=t3.FMATERIALID
+ string sql = @"/*dialect*/ select t1.*,isnull((select SUM(isnull(FNotProductNum,0)) from SC_WORKBILLSORTBILLSub t2 where t2.FID = t1.FID and DATEDIFF(D,FHMASTERDATE,GETDATE())>0),0)FNotProductNum from Sc_WorkBillSortBillMain t1
+ left join T_BD_MATERIAL t3 on t1.FHMaterID=t3.FMATERIALID
" + sqlwhere;
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
DateTime DateNow = DateTime.Now;//鑾峰彇褰撳墠鏃ユ湡
@@ -987,15 +1002,11 @@
this.Model.SetValue("FOrderQuantity", dt.Rows[i]["FOrderQuantity"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
this.Model.SetValue("FDayPlanQuantity", dt.Rows[i]["FDayPlanQuantity"].ToString(), i);//鏃ヨ鍒掓暟閲�
this.Model.SetValue("FNoScheduled", dt.Rows[i]["FNoScheduled"].ToString(), i);//鏈帓鏁伴噺
+ this.Model.SetValue("FDelaylnUM", dt.Rows[i]["FNotProductNum"].ToString(), i);//鎷栨湡鏁伴噺
sql = @"/*dialect*/SELECT * FROM Sc_WorkBillSortBillSub WHERE DATEDIFF(D,GETDATE(),FHMASTERDATE)>=0 and FID=" + dt.Rows[i]["FID"].ToString();
DataTable _dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
foreach (DataRow dr in _dt.Rows)
{
- /*
- this.Model.SetValue(dr["FColumn"].ToString(), dr["FHQTY"].ToString(), i);//鏃ヨ鍒掑伐鍗旻ID
- if (dr["FHLockedSub"].ToString() == "1")
- this.View.GetFieldEditor(dr["FColumn"].ToString(), i).Enabled = false; //鍗曟嵁浣撹閿佸畾瀛楁
- */
DateTime start = Convert.ToDateTime(DateNow.ToShortDateString());
DateTime end = Convert.ToDateTime(Convert.ToDateTime(dr["FHMASTERDATE"]).ToShortDateString());
TimeSpan getDay = end.Subtract(start);
@@ -1087,8 +1098,8 @@
sqlwhere += $" and FPreparatDate='{FPreparatDate}'";
try
{
- string sql = @"/*dialect*/select t1.* from Sc_WorkBillSortBillMain t1
- left join T_BD_MATERIAL t3 on t1.FHMaterID=t3.FMATERIALID
+ string sql = @"/*dialect*/ select t1.*,isnull((select SUM(isnull(FNotProductNum,0)) from SC_WORKBILLSORTBILLSub t2 where t2.FID = t1.FID and DATEDIFF(D,FHMASTERDATE,GETDATE())>0),0)FNotProductNum from Sc_WorkBillSortBillMain t1
+ left join T_BD_MATERIAL t3 on t1.FHMaterID=t3.FMATERIALID
" + sqlwhere;
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
DateTime DateNow = DateTime.Now;//鑾峰彇褰撳墠鏃ユ湡
@@ -1120,6 +1131,7 @@
this.Model.SetValue("FOrderQuantity", dt.Rows[i]["FOrderQuantity"].ToString(), i);//鐢熶骇璁㈠崟鏁伴噺
this.Model.SetValue("FDayPlanQuantity", dt.Rows[i]["FDayPlanQuantity"].ToString(), i);//鏃ヨ鍒掓暟閲�
this.Model.SetValue("FNoScheduled", dt.Rows[i]["FNoScheduled"].ToString(), i);//鏈帓鏁伴噺
+ this.Model.SetValue("FDelaylnUM", dt.Rows[i]["FNotProductNum"].ToString(), i);//鎷栨湡鏁伴噺
sql = @"/*dialect*/SELECT * FROM Sc_WorkBillSortBillSub WHERE DATEDIFF(D,GETDATE(),FHMASTERDATE)>=0 and FID=" + dt.Rows[i]["FID"].ToString();
DataTable _dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
foreach (DataRow dr in _dt.Rows)
diff --git a/src/Model/Demo.Model/Model/CompleteAnalysisTempModel.cs b/src/Model/Demo.Model/Model/CompleteAnalysisTempModel.cs
index c0a359f..e9a8c92 100644
--- a/src/Model/Demo.Model/Model/CompleteAnalysisTempModel.cs
+++ b/src/Model/Demo.Model/Model/CompleteAnalysisTempModel.cs
@@ -106,6 +106,10 @@
/// 缂烘枡鏁伴噺
/// </summary>
public decimal FLackCount { get; set; }
+ /// <summary>
+ /// 鍗犵敤鏁伴噺
+ /// </summary>
+ public decimal FOccupyCount { get; set; }
/// <summary>
/// 鍗曚綅鐢ㄩ噺锛欶UnitDosage
--
Gitblit v1.9.1