生产计划排程齐套分析单据体列表数据加载 功能实现

王 垚

2021-04-15 a6eea3dcc73f60831b7b238809ad600f62525999

生产计划排程齐套分析单据体列表数据加载 功能实现

 src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs

@@ -60,7 +60,6 @@
                var FQTYLS = Convert.ToDouble(model.GetValue("FQTYLS", e.Row));//历史
                this.View.Model.SetValue("FNoScheduled", scOrderCount - sum - FQTYLS, e.Row);
                this.View.Model.SetValue("FDayPlanQuantity", sum, e.Row);
                this.View.UpdateView();
            }
        }
        public override void BarItemClick(BarItemClickEventArgs e)
@@ -1233,7 +1232,7 @@
                    this.Model.SetValue("FProductWorkShopId", dt.Rows[i]["FHWorkShopID"].ToString(), i);//生产车间
                    this.Model.SetValue("FCompleteSetCount", dt.Rows[i]["FCompleteCount"].ToString(), i);//齐套数量
                    this.Model.SetValue("FOrderQuantity", dt.Rows[i]["FOrderQuantity"].ToString(), i);//生产订单数量
                    this.Model.SetValue("FDayPlanQuantity", Convert.ToDecimal(dt.Rows[i]["FOrderQuantity"]) - Convert.ToDecimal(dt.Rows[i]["FQTYLS"]), i);//日计划数量
                    this.Model.SetValue("FDayPlanQuantity", Convert.ToDecimal(dt.Rows[i]["FDAYPLANQUANTITY"]) - Convert.ToDecimal(dt.Rows[i]["FQTYLS"]), i);//日计划数量
                    this.Model.SetValue("FQTYLS", dt.Rows[i]["FQTYLS"].ToString(), i);//历史遗留
                    this.Model.SetValue("FNoScheduled", dt.Rows[i]["FNoScheduled"].ToString(), i);//未排数量
                    this.Model.SetValue("FDelaylnUM", dt.Rows[i]["FNotProductNum"].ToString(), i);//拖期数量

 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,103 @@
        /// </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);//日计划总数
            }
        }
        /// <summary>
        /// 页面初始化 渲染界面 将T0-T60更改为日期显示
        /// </summary>
        /// <param name="e"></param>
        public override void OnInitialize(InitializeEventArgs e)
@@ -68,14 +166,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 +208,9 @@
                //刷新
                if (e.BarItemKey.ToUpper().Equals("TBREFASH"))
                {
                    isSearched = false;
                    SearchList();
                    isSearched = true;
                }
            }
            catch (Exception ex)
@@ -120,8 +224,10 @@
        /// </summary>
        public void SearchList()
        {
            isSearched = false;
            DprwSearcrList("", "");
            ScddSearchList("", "");
            isSearched = true;
        }
        /// <summary>
        /// 界面上方“待排任务”的页签
@@ -138,7 +244,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 +292,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);//日计划工单ID  
@@ -350,7 +458,7 @@
                    {
                        if (FSCOrderCount == 0)
                            break;
                        dayFCapacity = FCapacity * item.FALLHOURS; 
                        dayFCapacity = FCapacity * item.FALLHOURS;
                        decimal fqty = dayFCapacity > FSCOrderCount ? FSCOrderCount : dayFCapacity;
                        finalyResult.Add(new Demo.Model.Model.ENG_WORKCALFULLDATA
                        {
@@ -363,7 +471,7 @@
                            //改变list中某个元素值
                            var model = ENG_WORKCALFULLDATA.Where(c => c.FENTRYID == item.FENTRYID).FirstOrDefault();
                            //model.FALLHOURS -= Math.Ceiling(fqty / FCapacity);
                            model.FALLHOURS -= fqty / FCapacity ; // 生产数 / 小时产能 = 消耗的小时 （数值类型为decimal）
                            model.FALLHOURS -= fqty / FCapacity; // 生产数 / 小时产能 = 消耗的小时 （数值类型为decimal）
                        }
                        else
                        {
@@ -507,11 +615,11 @@
            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);
@@ -558,7 +666,7 @@
                if (saveIsSuc != "TRUE")
                {
                    LogHelper.Error("生产计划平台保存失败:" + jsonRoot.ToString());
                    this.View.ShowMessage("数据储存失败！请联系管理员！");
                    this.View.ShowMessage(saveObj["Result"]["ResponseStatus"]["Errors"][0]["Message"].ToString());
                }
            }