智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
wtt
2025-08-04 50256099f5f248bef29df5c7605eb318af42647e 
 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs


@@ -153,6 +153,7 @@


                double HBackWorkByMaterQty = list[0].HBackWorkByMaterQty;//遗失数量


                int HMouldID = list[0].HMouldID;//模具id


                double HMachineWorkTimes = list[0].HMachineWorkTimes;//设备工时


                int HIsTimeFlag = list[0].HIsTimeFlag;


                LogService.Write($"1.字段赋值，用时" + sw.Elapsed );




                //单据完整性判断


@@ -413,7 +414,7 @@


                    ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" +


                    ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" +


                    ",HmaterOutqty,HProcPriceRate,HTemporaryAreaID,HWasterQty_Work,HWasterQty_Mater,HBackWorkQty,HShiftsID" +


                    ",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID,HMachineWorkTimes " +


                    ",HToCheckQty,HLossQty,HBackWorkByMaterQty,HMouldID,HMachineWorkTimes,HIsTimeFlag " +


                    ") " +


                    " values('" + BillType + "','" + (OperationType == "5" ? "SUB" : HBillSubType)  + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",'"+ HDate + "','" + HMaker + "',getdate(),'" + HMouldNum + "'" +


                    "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL +


@@ -424,7 +425,7 @@


                    "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) +


                    "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID +


                    "," + HmaterOutqty + "," + HProcPriceRate + "," + HTemporaryAreaID + "," + HWasterQty_Work + "," + HWasterQty_Mater + "," + HBackWorkQty +


                    "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ",'" + HMachineWorkTimes + "') ");


                    "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + "," + HMouldID + ",'" + HMachineWorkTimes + "',"+ HIsTimeFlag + ") ");




                    LogService.Write($"4.新增结束，用时" + sw.Elapsed);


                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工序出站单据:" + HBillNo);


@@ -471,7 +472,8 @@


                    ",HBackWorkQty=" + HBackWorkQty +


                    ",HBackWorkByMaterQty=" + HBackWorkByMaterQty +


                    ",HMouldID=" + HMouldID +


                    ",HMachineWorkTimes=" + HMachineWorkTimes +  


                    ",HMachineWorkTimes=" + HMachineWorkTimes +


                    ",HIsTimeFlag=" + HIsTimeFlag +


                    " where HInterID=" + HInterID);




                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改工序出站单据:" + HBillNo);


@@ -2754,7 +2756,7 @@


                int j = 0;


                for (int i = 0; i < HInterIDs.Length; i++)


                {


                    //审核前控制


                    //审核前控制================================================================================


                    string sql = "exec h_p_Sc_StationOutBill_BeforeCheckCtrl " + HInterIDs[i] + ",'" + HBillNo[i] + "','" + CurUserName + "'";


                    ds = oCN.RunProcReturn(sql, "h_p_Sc_StationOutBill_BeforeCheckCtrl");


                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


@@ -2774,7 +2776,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    //================================================================================




                    //审核


                    if (Cj_StationOutBillCheckBill(long.Parse(HInterIDs[i]), HBillNo[i], CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))


@@ -2850,7 +2852,7 @@


                    LogService.Write("出站单据审核更改流转卡数量,流转卡:" + HProcExchBillNo + ",出站单号：" + HBillNo + ",原流转卡数量:" + HProcExchQty + ",新流转卡数量:" + HQty);


                }




                //审核后控制


                //审核后控制================================================================================


                string sql = "exec h_p_Sc_StationOutBill_AfterCheckCtrl " + lngBillKey + ",'" + HBillNo + "','" + CurUserName + "'";


                ds = oCN.RunProcReturn(sql, "h_p_Sc_StationOutBill_AfterCheckCtrl");


                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


@@ -2865,7 +2867,7 @@


                    oCN.RollBack();


                    return false;


                }


               


                //================================================================================




                sReturn = sReturn + " 审核功能！";


                oCN.Commit();


@@ -2972,7 +2974,7 @@


                int j = 0;


                for (int i = 0; i < HInterIDs.Length; i++)


                {


                    //反审核前控制


                    //反审核前控制=============================================================


                    string sql = "exec h_p_Sc_StationOutBill_BeforeUnCheckCtrl " + HInterIDs[i] + ",'" + HBillNo[i] + "','" + CurUserName + "'";


                    ds = oCN.RunProcReturn(sql, "h_p_Sc_StationOutBill_BeforeUnCheckCtrl");


                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


@@ -2992,7 +2994,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    //================================================================================


                    //反审核


                    if (Cj_StationOutBillAbandonCheckBill(long.Parse(HInterIDs[i]),HBillNo[i], CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))


                    {


@@ -3086,7 +3088,7 @@


                return false; ;


            }


        }




        #endregion




        #region 工序出站关闭/反关闭功能


        [Route("Cj_StationOutBill/CloseCj_StationOutBill")]


@@ -3151,8 +3153,32 @@


                            return objJsonResult;


                        }


                    }


                    var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();




                    //关闭前控制=========================================      


                    string sql1 = "exec h_p_Sc_StationOutBill_BeforeCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                    ds = oCN.RunProcReturn(sql1, "h_p_Sc_StationOutBill_BeforeCloseCtrl");


                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "关闭失败!原因:关闭前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //==================================================================================    




                    //关闭单据


                    if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    if (!BillOld.CloseBill(Int64.Parse(HInterID), HBillNo, "h_p_Sc_StationOutBill_AfterCloseCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


@@ -3178,8 +3204,32 @@


                            return objJsonResult;


                        }


                    }


                    var HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();


                    //反关闭前控制=========================================      


                    string sql1 = "exec h_p_Sc_StationOutBill_BeforeUnCloseCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                    ds = oCN.RunProcReturn(sql1, "h_p_Sc_StationOutBill_BeforeUnCloseCtrl");


                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反关闭失败!原因:反关闭前判断失败，请与网络管理人员联系";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "反关闭失败!原因:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //==================================================================================      






                    //反关闭单据


                    if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))


                    if (!BillOld.CancelClose(Int64.Parse(HInterID), HBillNo, "h_p_Sc_StationOutBill_AfterUnCloseCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


@@ -3211,7 +3261,7 @@








        //是否被关联


        #region //是否被关联


        public bool Cj_StationInBillisUse(Int64 lngBillKey, ref string sReturn)


        {


            try