日计划用料清单增加条件

王 垚

2021-02-27 ebac4c0aaf96258fc67cd3ad6b3d1ac1991df632

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

@@ -68,6 +68,7 @@
            base.BarItemClick(e);
            try
            {
                LogHelper.Info("生产计划平台按钮");
                if (e.BarItemKey.ToUpper() == "BTEXPORT")
                {
                    ExportExcel();
@@ -208,7 +209,7 @@
            base.EntityRowClick(e);
            DynamicFormShowParameter formPa = new DynamicFormShowParameter();
            if (e.ColKey == "FDELAYLNUM")
            {   
            {
                //生产计划平台拖期明细跳转
                formPa.FormId = "paez_TardinessDetails";
                formPa.CustomParams.Add("FID", Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString()));
@@ -224,7 +225,7 @@
                showParameter.PageId = pageId;
                showParameter.Status = OperationStatus.EDIT;
                // 传入需要修改的日计划工单内码， 
                showParameter.PKey =Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString());
                showParameter.PKey = Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString());
                this.View.ShowForm(showParameter);

            }
@@ -235,7 +236,7 @@
                formPa.CustomParams.Add("FHICMOInterID", Convert.ToString(this.View.Model.GetValue("FDayPlanWorkID", e.Row).ToString()));
                this.View.ShowForm(formPa);
            }
           

        }
        /// <summary>
        /// 查看虚拟齐套
@@ -1862,6 +1863,9 @@
 LEFT join T_ORG_Organizations t10 on t2.FHPRDORGID = t10.FORGID
 LEFT join T_ENG_WORKCENTER t11 on t2.FHSOURCEID = t11.FID
 WHERE t1.FHQTY>0
 and t9.FID not in(
 select distinct FID from  Sc_DayPlanPPBomBillSub WHERE FTranslateQty >0 or FPickedQty >0
 )
"
);
                LogHelper.Info("生成日计划用料清单准备数据sql:" + sql);
@@ -1980,6 +1984,27 @@
                            var result = cloudClient.BatchSave("Paez_Sc_DayPlanPPBomBill", jsonRoot.ToString());
                            JObject saveObj = JObject.Parse(result);
                            string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
                            if (saveIsSuc == "TRUE")
                            {
                                var Success = saveObj["Result"]["ResponseStatus"]["SuccessEntitys"].ToString().TrimStart('{').TrimEnd('}');
                                var allList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Dictionary<string, string>>>(Success);
                                List<string> ls = new List<string>();
                                foreach (var it in allList)
                                {
                                    it.TryGetValue("Id", out string value);
                                    ls.Add(value);
                                }
                                var resultAA = String.Join(",", ls.ToArray());
                                string resSql = string.Format(@"/*dialect*/ update Sc_WorkBillSortBillSub set Sc_WorkBillSortBillSub.FDAYPLANPPBOMBILLNO = Sc_DayPlanPPBomBillMain.FBILLNO from Sc_WorkBillSortBillSub   join Sc_DayPlanPPBomBillMain   on Sc_WorkBillSortBillSub.FEntryID = Sc_DayPlanPPBomBillMain.FDayPlanFID where Sc_DayPlanPPBomBillMain.FID in ({0})", resultAA);
                                DBServiceHelper.Execute(Context, resSql);
                                //JArray array = JArray.Parse(m);
                                //for (int mm = 0; mm < array.Count; mm++)
                                //{
                                //    JObject b = JObject.Parse(array[mm].ToString());
                                //    var id = b["ID"].ToString();
                                //}

                            }
                            if (saveIsSuc != "TRUE")
                            {
                                LogHelper.Error("日计划用料清单列表生成失败:" + jsonRoot.ToString());