智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
王 垚
2021-05-26 523faafceb1b5c1009812c739ff609fcf42ce18c 
 WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs


@@ -69,7 +69,7 @@


        }




        /// <summary>


        /// 委外工序发出单流水号回车获取流转卡信息


        /// 委外工序发出单流水号回车获取流转卡信息（委外工序接收、工序进站接收通用）


        ///参数：string sql。


        ///返回值：object。


        /// </summary>


@@ -138,48 +138,48 @@


            {


                //委外工序发出反序列化


                msg1 = "[" + msg1.ToString() + "]";


                List<StationEntrustInBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationEntrustInBill>>(msg1);


                List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(msg1);




                var HInterID = list[0].HInterID;//递入type得到的单据ID


                var HYear = 2021;


                var HPeriod = list[0].HPeriod;//单价


                var HBillNo = list[0].HBillNo;//递入type得到的单据号


                var HBillStatus = 0;


                var HInnerBillNo = list[0].HInnerBillNo;//送货单号


                var HICMOBillNo = list[0].HICMOBillNo;//生产订单号


                long HICMOInterID = DBUtility.ClsPub.isLong(list[0].HICMOInterID);//生产订单号ID


                var HProcExchInterID = 0;


                var HProcExchEntryID = 0;


                var HProcExchBillNo = list[0].HProcExchBillNo;//流转卡


                var HProcID = list[0].HProcID;//当前工序


                var HMaterID = list[0].HMaterID;//产品ID


                var HStationInTime = list[0].HStationInTime;//


                var HEmpID = list[0].HEmpID;//操作员ID


                var HSourceID = list[0].HSourceID;//生产资源ID


                var HGroupID = list[0].HGroupID;//班组ID


                var HICMOQty = list[0].HICMOQty;//任务单数量


                var HPlanQty = list[0].HPlanQty;//流转卡数量


                var HQty = list[0].HQty;//发出数量


                var HSupID = list[0].HSupID;//供应商ID


                var HPieceQty = list[0].HPieceQty;//发出件数


                var HSourceName = list[0].HSourceName;//


                var HPrice = list[0].HPrice;//单价


                var HMoney = list[0].HMoney;//金额


                var HRemark = list[0].HRemark;//备注


                var HTaxRate = list[0].HTaxRate;//税率


                var HProcNo = list[0].HProcNo;//流水号


                var HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号


                var HWWWorkOrderInterID = 0;//委外工单号子内码


                var HWWWorkOrderEntryID = 0;//委外工单号主内吗


                var HWWWorkOrderBillNo = list[0].HWWWorkOrderBillNo;//委外工单号


                var HMaker = list[0].HMaker;//制单人


                var HProcPlanInterID = 0;


                var HProcPlanEntryID = 0;


                var HProcPlanBillNo = "";


                var HDeptID = list[0].HDeptID;//部门ID


                var HBarCode = list[0].HBarCode;//条形码


                var HAddr = "";


                var HBarCodeMaker = "";


                long HInterID = list[0].HInterID;//递入type得到的单据ID


                int HYear = 2021;


                double HPeriod = list[0].HPeriod;//单价


                string HBillNo = list[0].HBillNo;//递入type得到的单据号


                int HBillStatus = 0;


                string HInnerBillNo = list[0].HInnerBillNo;//送货单号


                string HICMOBillNo = list[0].HICMOBillNo;//生产订单号


                long HICMOInterID = list[0].HICMOInterID;//生产订单号ID


                int HProcExchInterID = 0;


                int HProcExchEntryID = 0;


                string HProcExchBillNo = list[0].HProcExchBillNo;//流转卡


                long HProcID = list[0].HProcID;//当前工序


                long HMaterID = list[0].HMaterID;//产品ID


                DateTime HStationInTime = list[0].HStationInTime;//


                long HEmpID = list[0].HEmpID;//操作员ID


                long HSourceID = list[0].HSourceID;//生产资源ID


                long HGroupID = list[0].HGroupID;//班组ID


                double HICMOQty = list[0].HICMOQty;//任务单数量


                double HPlanQty = list[0].HPlanQty;//流转卡数量


                double HQty = list[0].HQty;//发出数量


                long HSupID = list[0].HSupID;//供应商ID


                double HPieceQty = list[0].HPieceQty;//发出件数


                string HSourceName = list[0].HSourceName;//


                double HPrice = list[0].HPrice;//单价


                double HMoney = list[0].HMoney;//金额


                string HRemark = list[0].HRemark;//备注


                double HTaxRate = list[0].HTaxRate;//税率


                string HProcNo = list[0].HProcNo;//流水号


                string HOrderProcNO = list[0].HOrderProcNO;//订单跟踪号


                int HWWWorkOrderInterID = 0;//委外工单号子内码


                int HWWWorkOrderEntryID = 0;//委外工单号主内吗


                string HWWWorkOrderBillNo = list[0].HWWWorkOrderBillNo;//委外工单号


                string HMaker = list[0].HMaker;//制单人


                int HProcPlanInterID = 0;


                int HProcPlanEntryID = 0;


                string HProcPlanBillNo = "";


                long HDeptID = list[0].HDeptID;//部门ID


                string HBarCode = list[0].HBarCode;//条形码


                string HAddr = "";


                string HBarCodeMaker = "";




                //若MAINDI重复则重新获取


                oCN.BeginTran();


@@ -193,15 +193,15 @@


                ",HSupID,HTaxRate,HQty,HPrice,HMoney,HPieceQty" +


                ",HProcNo,HOrderProcNO,HWWWorkOrderBillNo,HWWWorkOrderInterID,HWWWorkOrderEntryID" +


                ") " +


                " values('3792','3792'," + HInterID.ToString() + ",'" + HBillNo + "'," + HBillStatus.ToString() + ",getdate(),'" + HMaker + "',getdate()" +


                "," + HYear.ToString() + "," + HPeriod.ToString() + ",'" + HRemark + "','" + HInnerBillNo + "'" +


                "," + HICMOInterID.ToString() + ",'" + HICMOBillNo + "'," + HProcPlanInterID.ToString() + "," + HProcPlanEntryID.ToString() + ",'" + HProcPlanBillNo + "'," + HProcExchInterID.ToString() + "," + HProcExchEntryID.ToString() +


                ",'" + HProcExchBillNo + "'," + HMaterID.ToString() + "," + HProcID.ToString() + "," + HICMOQty.ToString() + "," + HPlanQty.ToString() + ",getdate()," + HSourceID.ToString() +


                "," + HGroupID.ToString() + "," + HDeptID.ToString() + "," + HEmpID.ToString() + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +


                "," + HSupID.ToString() + "," + HTaxRate.ToString() + "," + HQty.ToString() + "," + HPrice.ToString() + "," + HMoney.ToString() + "," + HPieceQty.ToString() +


                "," + HProcNo.ToString() + ",'" + HOrderProcNO.ToString() + "'" + ",'" + HWWWorkOrderBillNo.ToString() + "'" + "," + HWWWorkOrderInterID.ToString() + "" + "," + HWWWorkOrderEntryID.ToString() + "" +


                " values('3792','3792'," + HInterID.ToString() + ",'" + HBillNo + "','" + HBillStatus.ToString() + "',getdate(),'" + HMaker + "',getdate()" +


                ",'" + HYear.ToString() + "','" + HPeriod.ToString() + "','" + HRemark + "','" + HInnerBillNo + "'" +


                "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID +


                ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID +


                "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" +


                "," + HSupID + "," + HTaxRate + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty +


                ",'" + HProcNo + "','" + HOrderProcNO + "'" + ",'" + HWWWorkOrderBillNo + "'" + "," + HWWWorkOrderInterID + "" + "," + HWWWorkOrderEntryID + "" +


              ") ");


                ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID.ToString() + "", "h_p_MES_StationInBill_QtyCtrl");


                ds = oCN.RunProcReturn("exec h_p_MES_StationInBill_QtyCtrl " + HInterID + "", "h_p_MES_StationInBill_QtyCtrl");


                if (ds == null)


                {


                    oCN.RollBack();


@@ -243,7 +243,7 @@


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();


                objJsonResult.Message = "Exception！" + e.Message;


                objJsonResult.data = null;


                return objJsonResult;


            }