MES研发
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
王 垚
2021-03-19 2a2e3fbbef29bbc568b10f2bd45bd6e658443d6e 
 src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs


@@ -1,7 +1,7 @@


using Demo.Model.Model;


using Demo.Model.Model.PODemandPlan;


using Demo.Utility;


using K3Cloud.Extend.Utils;


using Kingdee.BOS.App.Data;


using Kingdee.BOS.Core;


using Kingdee.BOS.Core.Bill.PlugIn;


using Kingdee.BOS.Core.Const;


@@ -39,7 +39,6 @@


using System.Web;


using System.Windows.Documents;


using ZD.Cloud.Logger;


using ZD.Cloud.WebApi;


using ZD.Share.Common;




namespace Demo.DynamicForm.PRD


@@ -268,7 +267,7 @@


            jObject.Put("desc", "请点击打开附件：");


            jObject.Put("urltitle", "这是文件名");


            this.View.AddAction(JSAction.openUrlWindow, new JSONArray { jObject });


        }


        }   


        /// <summary>


        /// 锁定


        /// </summary>


@@ -279,16 +278,16 @@


            string sql = $"/*dialect*/update t1 set t1.FHLockedSub=1 from Sc_WorkBillSortBillSub t1  join Sc_WorkBillSortBillMain t2 on  t1.FID = t2.FID  where  FHMASTERDATE between  DATEADD(day,-1,getdate()) and DATEADD(day,{day - 1},getdate())";


            sqlList.Add(sql);


            int result = DBServiceHelper.ExecuteBatch(Context, sqlList);


            if (result > 0)


            {


                //锁定后生成日计划用料清单 及 提料计划


                DayPlanPPBomBillBatch();


                Extraction();


                SearchList();


                this.View.ShowMessage("操作成功");


            }


            else


                this.View.ShowMessage("操作失败，联系管理员！");


            //if (result > 0)


            //{


            //锁定后生成日计划用料清单 及 提料计划


            DayPlanPPBomBillBatch();


            Extraction();


            SearchList();


            this.View.ShowMessage("操作成功");


            //}


            //else


            //    this.View.ShowMessage("操作失败，联系管理员！");


        }


        /// <summary>


        /// 解锁


@@ -646,7 +645,7 @@


                    if (item.FOwnerId != null)


                        jsonModel.Add("FOwnerId", new JObject() { ["FNUMBER"] = item.FOwnerId });


                    jsonRoot.Add("Model", jsonModel);


                    CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");


                    CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");


                    var result = cloudClient.Save("paez_CompleteAnalysisTemp", jsonRoot.ToString());


                    JObject saveObj = JObject.Parse(result);


                    string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();


@@ -897,7 +896,7 @@


                            ["IsVerifyBaseDataField"] = "false",


                            ["Model"] = Fentity


                        };


                        CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");


                        CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");


                        var result = cloudClient.BatchSave("paez_CompleteAnalysisTemp", jsonRoot.ToString());


                        JObject saveObj = JObject.Parse(result);


                        string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();


@@ -1490,7 +1489,7 @@


                            ["Model"] = model


                        };




                        CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");


                        CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");


                        var result = cloudClient.Save("Paez_Sc_DayPlanPPBomBill", jsonRoot.ToString());


                        JObject saveObj = JObject.Parse(result);


                        string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();


@@ -1520,7 +1519,7 @@


                string sql = string.Format(@"


/*dialect*/


 select t1.FID,t1.FEntryID,t3.FMATERIALID,T5.FNUMBER,t1.FHMASTERDATE,t1.FHQTY,t4.FMATERIALID FMATERIALID2,T6.FNUMBER FNUMBER2,T7.FNUMBER FUNITNUMBER,FNumerator,FDenominator,convert(decimal(18,2),(FNumerator/FDenominator) *t1.FHQTY) FHQtyMust,T4.FUnitID,t8.FNUMBER FUNITNUMBER2,T3.FID FPPBOM,T4.FENTRYID FPPBOMENTRYID,isnull(T9.FBillNo,'')FBillNo,t10.FNUMBER FORGNUMBER,t11.FNUMBER FHSOURCENUMBER,FSCRAPRATE,FFIXSCRAPQTY,T9.FID AS DayPlanFID,t2.FSCORDERNO,


t3.FMOENTRYID,t3.FBILLNO FPPBOMBILLNO,T4.FSEQ,tc.FOWNERTYPEID,tc.FOWNERID,tc.FEntrustPickOrgId,torg.FNUMBER as FORGNUMBER,t3.FMOID,FIssueType


t3.FMOENTRYID,t3.FBILLNO FPPBOMBILLNO,T4.FSEQ,tc.FOWNERTYPEID,tc.FOWNERID,tc.FEntrustPickOrgId,torg.FNUMBER as FORGNUMBER,t3.FMOID,FIssueType,FMaterialType


FROM Sc_WorkBillSortBillSub t1


JOIN Sc_WorkBillSortBillMAIN t2 on t1.FID = t2.FID


JOIN T_PRD_PPBOM T3 on T2.FPRDMOMAINID=t3.FMOID AND T2.FPRDMOENTYID=T3.FMOENTRYID


@@ -1575,7 +1574,8 @@


                            FOwnerID = dr["FORGNUMBER"].ToString(),


                            FEntrustPickOrgId = dr["FORGNUMBER"].ToString(),


                            FMOID = dr["FMOID"].ToString(),


                            FIssueType = dr["FIssueType"].ToString()


                            FIssueType = dr["FIssueType"].ToString(),


                            FMaterialType = dr["FMaterialType"].ToString()


                        });


                    }


                    LogHelper.Info($"日计划用料清单，数据准备完成，保存到Model实体，总行数：{DayPlanMaterial.Count}，耗时：" + sw.Elapsed);


@@ -1622,7 +1622,8 @@


                            ModelEnty.Add("FEntrustPickOrgId", new JObject() { ["Fnumber"] = _item.FEntrustPickOrgId });// 


                            ModelEnty.Add("FMOID", _item.FMOID);//  


                            ModelEnty.Add("FISSUETYPE", _item.FIssueType);//  


                           // ModelEnty.Add("FSEQ", FSEQ);//  


                            ModelEnty.Add("FMaterialType", _item.FMaterialType);//  


                                                                                // ModelEnty.Add("FSEQ", FSEQ);//  


                            Entry.Add(ModelEnty);


                            FSEQ++;




@@ -1638,18 +1639,18 @@


                                ["Creator"] = "",


                                ["NeedUpDateFields"] = new JArray(),


                                ["NeedReturnFields"] = new JArray(),


                                ["IsDeleteEntry"] = "false",


                                ["IsDeleteEntry"] = "true",


                                ["SubSystemId"] = "",


                                ["IsVerifyBaseDataField"] = "false",


                                ["Model"] = Fentity


                            };


                            CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");


                            CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");


                            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")


                            {


                                LogHelper.Error(jsonRoot.ToString());


                                LogHelper.Error(saveObj.ToString());


                            }


                            Fentity = new JArray();


                        }


@@ -1679,7 +1680,7 @@


                DataTable fidDt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];


                string FDayPlanWorkID = "";


                foreach (DataRow dr in fidDt.Rows)


                {   


                {


                    FDayPlanWorkID += Convert.ToString(dr["FID"]) + ",";


                }


                FDayPlanWorkID = FDayPlanWorkID.Substring(0, FDayPlanWorkID.Length - 1);


@@ -1693,13 +1694,14 @@


                //采购订单数据


                sql = @"


 /*dialect*/


select t1.FID,t1.FBillNo,t2.FENTRYID,t1.FSUPPLIERID,t3.fnumber,t2.FMATERIALID,(t2.FQTY-t2.FPODemandPlanCount)FQTY,FPurchaseOrgId FStockOrgId,t5.FNUMBER FORGNumber,FSTOCKINQTY,FReceiveQty,FCloseStatus,FMRPCLOSESTATUS from t_PUR_POOrder t1


 select t1.FID,t1.FBillNo,t2.FENTRYID,t1.FSUPPLIERID,t3.fnumber,t2.FMATERIALID,(t2.FQTY-t2.FPODemandPlanCount)FQTY,FPurchaseOrgId FStockOrgId,t5.FNUMBER FORGNumber,FSTOCKINQTY,FReceiveQty,FCloseStatus,FMRPCLOSESTATUS from t_PUR_POOrder t1


join t_PUR_POOrderEntry t2 on t1.FID = t2.FID


join t_BD_Supplier t3 on t1.FSUPPLIERID = t3.FSUPPLIERID


join  T_PUR_POORDERENTRY_R t4 on t2.FENTRYID = t4.FENTRYID


join T_ORG_Organizations t5 on t1.FPurchaseOrgId = t5.FORGID


where t2.FQTY-t2.FPODemandPlanCount>0


 and FCloseStatus in('A') and FMRPCLOSESTATUS in('A')


 and t1.FBillTypeID in('83d822ca3e374b4ab01e5dd46a0062bd','6d01d059713d42a28bb976c90a121142')


";


                List<PurchaseInventory> PurchaseInventory = DBServiceHelper.ExecuteDataSet(Context, sql).ToModelList<PurchaseInventory>();


                LogHelper.Info("[提料计划准备阶段]可用采购订单数据sql：" + sql);


@@ -1752,7 +1754,7 @@


                foreach (var item in MaterialIDList)


                {


                    //当前物料没有采购订单时 直接跳出


                    List<PurchaseInventory> _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x=>x.FENTRYID).ToList();


                    List<PurchaseInventory> _PurchaseInventory = PurchaseInventory.Where(x => x.FMATERIALID == item.FMATERIALID && x.FStockOrgId == item.FStockOrgId && x.FQTY > 0).OrderBy(x => x.FENTRYID).ToList();


                    if (_PurchaseInventory.Count == 0)


                    {


                        LogHelper.Info("[提料计划开始]当前物料无采购信息：" + item.FMATERIALID + " 库存组织：" + item.FStockOrgId);


@@ -1831,7 +1833,7 @@


                                        FORGNumber = Purchase.FORGNumber


                                    });


                                    //扣除日计划明细已被分配的数量


                                    DayPlanPpbomls.NeedQty = 0; 


                                    DayPlanPpbomls.NeedQty = 0;


                                }


                                FEntryIdList.Clear();


                                //更新采购订单


@@ -2071,7 +2073,7 @@


                            ["IsVerifyBaseDataField"] = "false",


                            ["Model"] = FinalyResult


                        };


                        CloudClient cloudClient = new CloudClient("http://localhost/K3Cloud/");


                        CloudClient cloudClient = new CloudClient("http://localhost//k3cloud/");


                        var result = cloudClient.BatchSave("paez_PODemandPlan", jsonRoot.ToString());


                        JObject saveObj = JObject.Parse(result);


                        string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();