智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-04-24 105bb5f0f4edd01d8f915ffda28ccd37afbfddc8 
 WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs


@@ -50,7 +50,7 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                DBUtility.ClsPub.CurUserName = msg4;


                DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill();


                List<Model.ClsSc_ProcessExchangeBillMain> lsmain = new List<Model.ClsSc_ProcessExchangeBillMain>();


                msg2 = msg2.Replace("\\", "");


@@ -61,8 +61,8 @@


                    UserName = oItem.HMaker;  //制单人


                    oItem.HBillType = "3772";


                    oItem.HBillSubType = "3772";


                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


                    {


                        objJsonResult.code = "0";


@@ -445,6 +445,9 @@


                {


                    Main.HBillNo = ListHbillNo[i].HBillNo;


                    Main.HQty = ListHbillNo[i].HQty;


                    Main.HSplitNo = ListHbillNo[i].HSplitNo;


                    Main.HAuxQty = 0;


                    Main.HAuxUnit = 0;


                    oBill.omodel = Main;




                    int j = 0;


@@ -666,12 +669,12 @@


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                string sql = string.Format(@"select 流水号 HProcNo,HProcID,工序代码 HProcNumber,工序名称 HProcName,加工说明 HWorkRemark,HCenterID,工作中心代码 HCenterNumber,


                                                工作中心 HCenterName,HSupID,供应商代码 HSupNumber,供应商 HSupName,isEntrust,计划数量 HQty,加工单价 HOutPrice, 表体备注 HRemark,


                                                工作中心 HCenterName,HSupID,供应商代码 HSupNumber,供应商 HSupName,isEntrust HSupFlag,计划数量 HQty,加工单价 HOutPrice, 表体备注 HRemark,


                                            进站关联数量 HRelationQty_In,出站关联数量 HRelationQty_Out,委外工单数量 HRelationQty_WWOrder,不合格数量 HRelationQty_Bad,超额比例 HOverRate,


                                            良率 HPassRate,累计良率 HSumPassRate,图纸编号 HPicNum,本工序确认记录 HProcCheckNote,工艺参数 HTechnologyParameter,HDeptID,


                                            加工车间代码 HDeptNumber,加工车间 HDeptName


                                            from h_v_Sc_ProcessExchangeBillQuerySub");


                ds = oCN.RunProcReturn(sql+ " where hmainid="+ HInterID, "h_v_Sc_ProcessExchangeBillQuerySub");


                ds = oCN.RunProcReturn(sql+ " where hmainid="+ HInterID + "  order by cast(流水号 as int) ", "h_v_Sc_ProcessExchangeBillQuerySub");


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


@@ -900,12 +903,26 @@


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();




                var ds1= oCN.RunProcReturn("select isnull(max(流水号),0) from h_v_Sc_ProcessExchangeBillQuerySub where hmainid=" + HInterID + " and 出站关联数量>0 ", "h_v_Sc_ProcessExchangeBillQuerySub");




                string sql = string.Format(@"select * from h_v_Sc_ProcessExchangeBillQuerySub");


                ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID, "h_v_Sc_ProcessExchangeBillQuerySub");


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "获取信息成功！";


                objJsonResult.data = ds.Tables[0];




                ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 出站关联数量=0  and  cast(流水号 as int)>" + ds1 .Tables[0].Rows[0][0].ToString(), "h_v_Sc_ProcessExchangeBillQuerySub");




                if (float.Parse(ds.Tables[0].Rows[0]["进站关联数量"].ToString()) > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "当前单据:"+ ds.Tables[0].Rows[0]["工序名称"].ToString() + "未出站不能拆分!";


                    objJsonResult.data = ds.Tables[0];


                }


                else {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                }


            }


            catch (Exception e)


            {


@@ -933,6 +950,7 @@


            string msg3 = sArray[1].ToString();


            string msg4 = sArray[2].ToString();


            string msg5 = sArray[3].ToString();


            string linterid = sArray[4].ToString();




            string UserName = "";


            ListModels oListModels = new ListModels();


@@ -953,16 +971,11 @@


                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Sc_ProcessExchangeBillMain(msg2);


                string sReturn = "";


                DBUtility.ClsPub.HOrgID = lsmain[0].HPRDORGID;


                oBill.ShowBill(long.Parse(linterid), ref sReturn);


                foreach (Model.ClsSc_ProcessExchangeBillMain oItem in lsmain)


                {


                    oItem.HMaker = msg5;  //制单人


                    oItem.HBillType = "3772";


                    oBill.HBillSubType = "Split";


                    oItem.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]);


                    oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期


                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);


                    oItem.HMaterID2 = oItem.HMaterID;


                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")


                    {


                        objJsonResult.code = "0";


@@ -971,7 +984,16 @@


                        objJsonResult.data = 1;


                        return objJsonResult;


                    }


                    oBill.omodel = oItem;




                    oBill.omodel.HMaker = msg5;  //制单人


                    oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]);


                    oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                    oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);


                    oBill.omodel.HDate = oItem.HDate;// 日期


                    oBill.omodel.HPlanBeginDate = oItem.HPlanBeginDate;// 计划开工日期


                    oBill.omodel.HPlanEndDate = oItem.HPlanEndDate;// 计划完工日期


                    oBill.omodel.HQty = oItem.HQty;// 数量


                    oBill.omodel.HBillNo = oItem.HBillNo;// 单据号


                }




                //表体数据


@@ -982,24 +1004,52 @@


                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsSc_ProcessExchangeBillSub> ls = new List<Model.ClsSc_ProcessExchangeBillSub>();


                ls = oListModels.getObjectByJson_Sc_ProcessExchangeBillSub(msg3);


                int i = 0;


                foreach (Model.ClsSc_ProcessExchangeBillSub oItemSub in ls)


                {


              


                string HEntryID = "";




                    i++;


                    if (oItemSub.HSplitQty > oItemSub.HLeftQty)


                for (int i = 0; i < oBill.DetailColl.Count; i++)


                {


                    if (oBill.DetailColl[i].HRelationQty_Out > 0 || oBill.DetailColl[i].HRelationQty_In > 0)


                    {


                        HEntryID += i + ",";


                    }


                }


                if (HEntryID != "")


                {


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


                    var num = HEntryID.Split(',');




                    for (int k = 0; k < num.Length; k++)


                    {


                        oBill.DetailColl.RemoveAt(int.Parse(num[k]) - k);


                    }


                }




                int j = 0 ;


                foreach (Model.ClsSc_ProcessExchangeBillSub oItemSub in oBill.DetailColl)


                {


                    if (ls[j].HSplitQty > ls[j].HLeftQty)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "第"+i+ "行，拆分数量不能大于可拆分数量！";


                        objJsonResult.Message = "第" + (j + 1) + "行，拆分数量不能大于可拆分数量！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    oItemSub.HEntryID = i;


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oBill.DetailColl.Add(oItemSub);




                    if (oBill.DetailColl[j].HProcNo == ls[j].HProcNo)


                    {


                        oBill.DetailColl[j].HEntryID = j+1;


                        oBill.DetailColl[j].HQty = ls[j].HQty;


                        oBill.DetailColl[j].HBackProc = ls[j].HBackProc;


                        oBill.DetailColl[j].HPrevSourceInterID = ls[j].HPrevSourceInterID;


                        oBill.DetailColl[j].HPrevSourceEntryID = ls[j].HPrevSourceEntryID;


                        oBill.DetailColl[j].HRemark = ls[j].HRemark;


                        oBill.DetailColl[j].HTechnologyParameter = ls[j].HTechnologyParameter;


                        j++;


                    }


                }






                //保存


                //保存完毕后处理


@@ -1012,6 +1062,13 @@


                //{


                //    bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo);


                //}


               


                oCN.BeginTran();




                oCN.RunProc("update Sc_ProcessExchangeBillSub set HQty=(select HQty from Sc_ProcessExchangeBillMain where HInterID="+ oBill.DetailColl[0].HPrevSourceInterID + ") where HInterID=" + oBill.DetailColl[0].HPrevSourceInterID );




                oCN.Commit();




                if (bResult)


                {


                    objJsonResult.code = "0";