From e2b0f85331c972a77ed6e0e179d736c4c6eb1abc Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期日, 21 三月 2021 15:34:26 +0800
Subject: [PATCH] 代码上传
---
src/BLL/Demo.BillView/PRD/ProductScheduleButtonClick.cs | 161 ++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 145 insertions(+), 16 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/ProductScheduleButtonClick.cs b/src/BLL/Demo.BillView/PRD/ProductScheduleButtonClick.cs
index 0bf4e8f..11f9528 100644
--- a/src/BLL/Demo.BillView/PRD/ProductScheduleButtonClick.cs
+++ b/src/BLL/Demo.BillView/PRD/ProductScheduleButtonClick.cs
@@ -14,6 +14,8 @@
using System.Linq;
using Newtonsoft.Json.Linq;
using ZD.Cloud.WebApi;
+using Kingdee.BOS.Core.DynamicForm;
+using Kingdee.BOS.Core.DynamicForm.PlugIn.ControlModel;
namespace Demo.BillView
{
@@ -26,7 +28,123 @@
/// </summary>
public List<ENG_WORKCALFULLDATA> ENG_WORKCALFULLDATA = new List<ENG_WORKCALFULLDATA>();
/// <summary>
- ///
+ /// 寰呮帓浠诲姟鍙屽嚮琛� 灏嗚鍗曢綈濂楄祴鍊�
+ /// </summary>
+ /// <param name="e"></param>
+ public override void EntityRowDoubleClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.EntityRowClickEventArgs e)
+ {
+ base.EntityRowClick(e);
+ isSearched = false;
+ DynamicFormShowParameter formPa = new DynamicFormShowParameter();
+ if (!e.Key.ToString().Contains("FDPRWENTITY"))
+ return;
+ var model = this.View.Model;
+ var fid = model.GetValue("FID", e.Row).ToString();
+ while (this.Model.GetEntryRowCount("FQtfxEntity") > 0)
+ {
+ this.Model.DeleteEntryRow("FQtfxEntity", 0);
+ }
+ string sql = $"/*dialect*/select * from view_JIT_MOMaterReadysBill where FHICMOInterID='{fid}' order by FPlanDate, FHStockQty desc ,FHMaterID ";
+ DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
+ if (dt.Rows.Count > 0)
+ {
+ for (int i = 0; i < dt.Rows.Count; i++)
+ {
+ this.Model.CreateNewEntryRow("FQtfxEntity");
+ this.Model.SetValue("FSEQ", i + 1, i);//搴忓彿
+ this.Model.SetValue("FMateralDetailId", dt.Rows[i]["FHMATERID"], i);
+ this.Model.SetValue("FPlanIssueCount", dt.Rows[i]["FSumPlanCount"], i);//璁″垝鍙戞枡鏁伴噺
+ this.Model.SetValue("FCompleteCount", dt.Rows[i]["FCompleteCount1"], i);//榻愬鏁伴噺
+ 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("FIsHavePur", dt.Rows[i]["FIsHavePur"].ToString(), i);//鏄惁鏈夐噰璐鍗�
+ this.Model.SetValue("FHMainICMOInterIDr", dt.Rows[i]["FHMainICMOInterIDr"].ToString(), i);//鐢熶骇璁㈠崟鍐呯爜
+ this.Model.SetValue("FPRDBillNo", dt.Rows[i]["FPRDBillNo"].ToString(), i);//鐢熶骇璁㈠崟鍐呯爜
+ this.Model.SetValue("FPlanDate", dt.Rows[i]["FPlanDate"].ToString(), i);//鏃ヨ鍒掓棩鏈�
+ this.Model.SetValue("FOrgId", dt.Rows[i]["FHStockOrgID"], i);//搴撳瓨缁勭粐
+ this.Model.SetValue("FOwnerTypeId", dt.Rows[i]["FOwnerTypeId"], i);//璐т富绫诲瀷
+ this.Model.SetValue("FOwnerId", dt.Rows[i]["FOwnerId"], i);//璐т富
+ this.Model.SetValue("FErpClsID", dt.Rows[i]["FErpClsID"], i);//鐗╂枡灞炴��
+ }
+ ChangeColor();
+ }
+ isSearched = true;
+ }
+ /// <summary>
+ /// 涓嶉綈濂椾俊鎭覆鏌撳簳鑹�
+ /// </summary>
+ private void ChangeColor()
+ {
+ Entity entity = this.View.BillBusinessInfo.GetEntity("FQtfxEntity");
+ //鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
+ DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
+ EntryGrid grid = this.View.GetControl<EntryGrid>("FQtfxEntity");
+ int _i = 0;
+ foreach (DynamicObject current in entityDataObjoct)
+ {
+ if (Convert.ToString(current["FCompleteDetailStatus"]) == "鏈綈濂�")
+ {
+ // grid.SetRowBackcolor("#FF0000", _i);
+ grid.SetRowBackcolor("#71FF98CB", _i);
+ }
+ _i++;
+ }
+ }
+ private bool isSearched = true;
+ /// <summary>
+ /// 鍊兼洿鏂颁簨浠�
+ /// </summary>
+ /// <param name="e"></param>
+ public override void DataChanged(DataChangedEventArgs e)
+ {
+ if (!isSearched) return;
+ base.DataChanged(e);
+ var columns = new List<string>() { "", "" };
+ for (int i = 0; i < 100; i++)
+ {
+ columns.Add("FT" + i.ToString());
+ }
+ var model = this.View.Model;
+ if (columns.Contains(e.Field.Key))
+ {
+ //if (Convert.ToDouble(model.GetValue(e.Field.Key, e.Row)) == 0)
+ //{
+ // this.View.ShowErrMessage("鏃ヨ鍒掓暟閲忛渶澶т簬0");
+ // //this.View.Model.SetValue("FT0", 100, e.Row);//杩斿洖鍊�
+ // return;
+ //}
+ var sum = columns.Select(x => Convert.ToDouble(model.GetValue(x, e.Row))).Sum();//鏃ヨ鍒掓�诲拰
+ var scOrderCount = Convert.ToDouble(model.GetValue("FSCOrderCountZD", e.Row));//鐢熶骇璁㈠崟鏁伴噺
+ var FQTYLS = Convert.ToDouble(model.GetValue("FQTYLS", e.Row));//鍘嗗彶
+ this.View.Model.SetValue("FNoScheduledCount", scOrderCount - sum - FQTYLS, e.Row);//寰呮帓鏁�
+ this.View.Model.SetValue("FSumQty", sum, e.Row);//鏃ヨ鍒掓�绘暟
+ }
+ //鍒嗛厤鏁伴噺
+ if (e.Field.Key == "FAllocatedCount")
+ {
+ var scOrderNo = model.GetValue("FProOrderNo", e.Row).ToString();
+ var scOrderFentrySeqNo = model.GetValue("FSRCBILLENTRYSEQ", e.Row).ToString();
+ var scOrderCount = Convert.ToDouble(model.GetValue("FSCOrderCount", e.Row));
+ Entity entity = this.View.BillBusinessInfo.GetEntity("FDprwEntity");
+ //鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
+ DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
+ var groups = entityDataObjoct.Where(x => Convert.ToString(x["FProOrderNo"]) == scOrderNo && Convert.ToString(x["FSRCBILLENTRYSEQ"]) == scOrderFentrySeqNo);//鐢熶骇璧勬簮鍒嗙粍锛堣绠椾紭鍏堢骇锛�
+ double allocatedCount = 0;
+ foreach (var group in groups)
+ {
+ allocatedCount += Convert.ToDouble(group["FAllocatedCount"]);
+ }
+ if (allocatedCount > scOrderCount)
+ {
+ this.View.ShowErrMessage("搴忓彿锛�"+ model.GetValue("FSEQ", e.Row).ToString() + ",璁㈠崟鍙凤細" + scOrderNo + "锛岃鍙�:" + scOrderFentrySeqNo + " 鍒嗛厤鎬绘暟瓒呭嚭鐢熶骇璁㈠崟鏁般��");
+ }
+ }
+ }
+ /// <summary>
+ /// 椤甸潰鍒濆鍖� 娓叉煋鐣岄潰 灏員0-T60鏇存敼涓烘棩鏈熸樉绀�
/// </summary>
/// <param name="e"></param>
public override void OnInitialize(InitializeEventArgs e)
@@ -68,14 +186,18 @@
{
string FDepartId = (this.Model.GetValue("FDpDepartment") as DynamicObject)?["Id"].ToString();
string FDate = Convert.ToString(this.Model.GetValue("FNewPzDate"));
+ isSearched = false;
DprwSearcrList(FDepartId, FDate);
+ isSearched = true;
}
//鐢熶骇璁㈠崟 鏌ヨ
if (e.Key.ToUpper().Equals("FSEARCHBUTTONSC"))
{
string FMaterialId = (this.Model.GetValue("FMATERIALIDCX") as DynamicObject)?["Id"].ToString();
string FProOrderNo = Convert.ToString(this.Model.GetValue("FOrderNoCX"));
+ isSearched = false;
ScddSearchList(FMaterialId, FProOrderNo);
+ isSearched = true;
}
}
catch (Exception ex)
@@ -106,7 +228,9 @@
//鍒锋柊
if (e.BarItemKey.ToUpper().Equals("TBREFASH"))
{
+ isSearched = false;
SearchList();
+ isSearched = true;
}
}
catch (Exception ex)
@@ -120,8 +244,10 @@
/// </summary>
public void SearchList()
{
+ isSearched = false;
DprwSearcrList("", "");
ScddSearchList("", "");
+ isSearched = true;
}
/// <summary>
/// 鐣岄潰涓婃柟鈥滃緟鎺掍换鍔♀�濈殑椤电
@@ -138,7 +264,7 @@
if (!string.IsNullOrEmpty(FDate))
sqlWhere += $" and dadediff(d,FDate,) =0 ";
//寰呮帓浠诲姟 鍒濆鍖栧姞杞� where FNoScheduled > 0 鏈帓浜ф暟閲忓ぇ浜�0
- string sql = @"select * from Sc_WorkBillSortBillMain ";
+ string sql = @"select * ,isnull((select SUM(isnull(FHQTY,0)) from SC_WORKBILLSORTBILLSub t2 where t2.FID = t1.FID and DATEDIFF(D,FHMASTERDATE,GETDATE())>0),0)FQTYLS from Sc_WorkBillSortBillMain t1";
DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
if (dt.Rows.Count > 0)
{
@@ -186,7 +312,9 @@
this.Model.SetValue("FMATERIALIDZD", dt.Rows[i]["FHMaterID"], i);//鐗╂枡浠ｇ爜
this.Model.SetValue("FSCOrderCountZD", dt.Rows[i]["FOrderQuantity"], i);//鐢熶骇璁㈠崟鏁�
//this.Model.SetValue("FFinishConutZD", dt.Rows[i]["FNOTE"], i);//瀹屽伐鏁� 锛堟病鏈夊搴斿瓧娈碉級
- this.Model.SetValue("FNoScheduledCount", dt.Rows[i]["FNoScheduled"], i);//寰呮帓鏁�
+ this.Model.SetValue("FQTYLS", dt.Rows[i]["FQTYLS"].ToString(), i);//鍘嗗彶閬楃暀
+ this.Model.SetValue("FNoScheduledCount", Convert.ToDecimal(dt.Rows[i]["FOrderQuantity"]) - Convert.ToDecimal(dt.Rows[i]["FDayPlanQuantity"]), i);//寰呮帓鏁�
+ this.Model.SetValue("FSumQty", Convert.ToDecimal(dt.Rows[i]["FDAYPLANQUANTITY"]) - Convert.ToDecimal(dt.Rows[i]["FQTYLS"]), i);//
this.Model.SetValue("FPriorityZD", dt.Rows[i]["FHYX"], i);//浼樺厛绾�
this.Model.SetValue("FCapacityZD", dt.Rows[i]["FHWorkQty"], i);//浜ц兘
this.Model.SetValue("FIDZD", dt.Rows[i]["FID"], i);//鏃ヨ鍒掑伐鍗旾D
@@ -320,7 +448,7 @@
{
//鏌ヨ鍑洪噸澶嶇敓浜х嚎瀵瑰簲鐨勫伐浣滄棩鍘嗕俊鎭�
string _sql = @"
-select FCalUserId,FCalUserType,FShiftId,FIsWorkTime,FDay,FDateStyle,c.FALLHOURS,b.FENTRYID from T_ENG_WORKCAL a
+select FCalUserId,FCalUserType,FShiftId,FIsWorkTime,FDay,FDateStyle,c.FALLHOURS ,c.FALLHOURS FALLHOURSCONST,b.FENTRYID from T_ENG_WORKCAL a
left join T_ENG_WORKCALFULLDATA b on a.FID=b.FID
left join T_ENG_SHIFT c on b.FShiftId =c.FID
where FDateStyle = 1 and FIsWorkTime = 1
@@ -329,7 +457,6 @@
--鏉′欢涓� 宸ヤ綔鏃�+鏄惁鐢熶骇 == 1 ";
ENG_WORKCALFULLDATA = DBServiceHelper.ExecuteDataSet(Context, _sql).ToModelList<ENG_WORKCALFULLDATA>();
- var list = new List<object>();
Entity entity = this.View.BillBusinessInfo.GetEntity("FDprwEntity");
//鍗曟嵁浣撲俊鎭浆鎹负鍒楄〃闆嗗悎
DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
@@ -344,7 +471,7 @@
decimal FCapacity = Convert.ToDecimal(order["FCapacity"]);//灏忔椂浜ц兘
decimal FSCOrderCount = Convert.ToDecimal(order["FSCOrderCount"]);//鐢熶骇璁㈠崟鏁�
List<ENG_WORKCALFULLDATA> finalyResult = new List<ENG_WORKCALFULLDATA>();
- decimal dayFCapacity = 0;//鏃ヤ骇閲�
+ decimal dayFCapacity = 0;//褰撴棩鍓╀綑浜ч噺 = 灏忔椂浜ц兘 * 鏃ュ墿浣欏伐浣滄椂闀�
List<ENG_WORKCALFULLDATA> _ENG_WORKCALFULLDATA = ENG_WORKCALFULLDATA.Where(x => x.FALLHOURS > 0 && x.FCalUserId == Convert.ToInt32(order["FSczy_Id"])).ToList();
foreach (var item in _ENG_WORKCALFULLDATA)
{
@@ -357,13 +484,13 @@
FDay = item.FDay,
FQTY = fqty
}); ;
- //褰撴棩浜ч噺澶т簬鍓╀綑鐢熶骇璁㈠崟鏁伴噺鏃� 鎸夊皬鏃朵骇閲忓幓璁＄畻闇�瑕佹椂闂� list<>鍘绘墸闄ょ浉搴旂殑宸ユ椂
+ //褰撴棩鍓╀綑浜ч噺澶т簬鍓╀綑鐢熶骇璁㈠崟鏁伴噺鏃� 鎸夊皬鏃朵骇閲忓幓璁＄畻闇�瑕佹椂闂� list<>鍘绘墸闄ょ浉搴旂殑宸ユ椂
if (dayFCapacity > FSCOrderCount)
{
//鏀瑰彉list涓煇涓厓绱犲��
var model = ENG_WORKCALFULLDATA.Where(c => c.FENTRYID == item.FENTRYID).FirstOrDefault();
- model.FALLHOURS -= Math.Ceiling(fqty / FCapacity);
-
+ //model.FALLHOURS -= Math.Ceiling(fqty / FCapacity);
+ model.FALLHOURS -= fqty / FCapacity; // 鐢熶骇鏁� / 灏忔椂浜ц兘 = 娑堣�楃殑灏忔椂 锛堟暟鍊肩被鍨嬩负decimal锛�
}
else
{
@@ -400,7 +527,7 @@
jsonRoot.Add("Creator", "");
jsonRoot.Add("NeedUpDateFields", new JArray());
jsonRoot.Add("NeedReturnFields", new JArray());
- jsonRoot.Add("IsDeleteEntry", "false");//
+ jsonRoot.Add("IsDeleteEntry", "true");//
jsonRoot.Add("SubSystemId", "");
jsonRoot.Add("IsVerifyBaseDataField", "");
@@ -507,16 +634,18 @@
DynamicObjectCollection entityDataObjoct = this.View.Model.GetEntityDataObject(entity);
DateTime date = Convert.ToDateTime(DateTime.Now.ToString("d"));
string _result = "";
- //foreach (DynamicObject current in entityDataObjoct)
- //{
- // if (Convert.ToInt32(current["FNoScheduled"]) < 0)
- // _result += "搴忓彿锛�" + Convert.ToString(current["SEQ"]) + ",鏃ヨ鍒掓�绘暟閲忚秴鍑虹敓浜ц鍗曟暟閲�";
- //}
+ foreach (DynamicObject current in entityDataObjoct)
+ {
+ if (Convert.ToInt32(current["FNoScheduledCount"]) < 0)
+ _result += "搴忓彿锛�" + Convert.ToString(current["SEQ"]) + ",鏃ヨ鍒掓�绘暟閲忚秴鍑虹敓浜ц鍗曟暟閲�";
+ }
if (_result != "")
{
this.View.ShowErrMessage(_result);
return;
}
+ //var groups = entityDataObjoct.GroupBy(x => new {x});//鐢熶骇璧勬簮鍒嗙粍锛堣绠椾紭鍏堢骇锛�
+ //var groups = entityDataObjoct.GroupBy(x => x["FSczy_Id"]);//鐢熶骇璧勬簮鍒嗙粍锛堣绠椾紭鍏堢骇锛�
foreach (DynamicObject current in entityDataObjoct)
{
JObject jsonRoot = new JObject();
@@ -558,7 +687,7 @@
if (saveIsSuc != "TRUE")
{
LogHelper.Error("鐢熶骇璁″垝骞冲彴淇濆瓨澶辫触:" + jsonRoot.ToString());
- this.View.ShowMessage("鏁版嵁鍌ㄥ瓨澶辫触锛佽鑱旂郴绠＄悊鍛橈紒");
+ this.View.ShowMessage(saveObj["Result"]["ResponseStatus"]["Errors"][0]["Message"].ToString());
}
}
--
Gitblit v1.9.1