智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
2024-04-09 a2239df699a9decdcc49a8fe0f4e2da225ec838c 
 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs


@@ -431,7 +431,7 @@


                }


                //主表




                //LogService.Write($"5.系统控制查询判断，用时" + sw.Elapsed);


                LogService.Write($"5.系统控制查询判断，用时" + sw.Elapsed);


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


                if (ds == null)


                {


@@ -442,7 +442,7 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //LogService.Write($"5.1，用时" + sw.Elapsed);


                LogService.Write($"5.1，用时" + sw.Elapsed);


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


                {


                    oCN.RollBack();


@@ -452,7 +452,7 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //LogService.Write($"5.2，用时" + sw.Elapsed);


                LogService.Write($"5.2，用时" + sw.Elapsed);


                if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2")


                {


                    oCN.RollBack();


@@ -462,17 +462,18 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //LogService.Write($"6.判断结束，用时" + sw.Elapsed);


                LogService.Write($"6.判断结束，用时" + sw.Elapsed);


                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ","+ num + "");


                //LogService.Write($"6.1，用时" + sw.Elapsed);


                LogService.Write($"6.1，用时" + sw.Elapsed);


                oCN.RunProc("exec h_p_Mes_ProcessExchangeChangeStatus  " + HInterID + " ");


                //LogService.Write($"6.2，用时" + sw.Elapsed);


                LogService.Write($"6.2，用时" + sw.Elapsed);


                oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode  " + HInterID + " ");


                //LogService.Write($"7.存储过程结束，用时" + sw.Elapsed);


                LogService.Write($"7.存储过程结束，用时" + sw.Elapsed);


                //判断是否是 末道工序 


                ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a  " +


                                    " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID  " +


                                    " Where a.HInterID=" + HProcExchInterID + " and b.HEntryID=" + HProcExchEntryID + " ", "Sc_ProcessExchangeBillMain");


                LogService.Write($"7.1.查询，用时" + sw.Elapsed);


                //判断是否是新增


                if ("Add".Equals(eventType))


                {


@@ -523,6 +524,7 @@


                        }


                    }


                }


                LogService.Write($"7.2.查询，用时" + sw.Elapsed);




                //=========================保存后控制  


                DataSet ds2 = oCN.RunProcReturn("Exec h_p_Sc_StationOutBill_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "',1 ", "h_p_Sc_StationOutBill_AfterSaveCtrl");


@@ -548,7 +550,7 @@


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






                //LogService.Write($"10.事务结束，用时" + sw.Elapsed);


                LogService.Write($"10.事务结束，用时" + sw.Elapsed);


                oCN.Commit();


                string sReturn = "";


                if (oSystemParameter.ShowBill(ref sReturn) == true)


@@ -2185,7 +2187,30 @@


                        }


                    }




                    if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HProcExchInterID, oBill.omodel.HProcExchEntryID, ref DBUtility.ClsPub.sExeReturnInfo))


                    //删除前控制=========================================      


                    string HBillNo = oBill.omodel.HBillNo;


                    string sql1 = "exec h_p_Sc_StationOutBill_BeforeDelCtrl " + HInterID + ",'" + HBillNo + "','" + HDeleteMan + "'";


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


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




                    if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HProcExchInterID, oBill.omodel.HProcExchEntryID, HBillNo, "h_p_Sc_StationOutBill_AfterDelCtrl", HDeleteMan, ref DBUtility.ClsPub.sExeReturnInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


@@ -2496,12 +2521,13 @@


                }


              


            


                var HBillNo = HInterID.Split(',');


                var HInterIDs = HInterID.Split(',');


                string[] HBillNo = new string[HInterIDs.Length];


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




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


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


                {


                    if (HBillNo[i] == "0")


                    if (HInterIDs[i] == "0")


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


@@ -2510,7 +2536,7 @@


                        return objJsonResult;


                    }


                    //查看是否已审核,关闭,作废


                    if (oBill.ShowBill(long.Parse(HBillNo[i]), ref DBUtility.ClsPub.sExeReturnInfo))


                    if (oBill.ShowBill(long.Parse(HInterIDs[i]), ref DBUtility.ClsPub.sExeReturnInfo))


                    {


                        if (oBill.omodel.HChecker.Trim() != "")


                        {


@@ -2520,6 +2546,7 @@


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        HBillNo[i] = oBill.omodel.HBillNo;


                    }


                    else


                    {


@@ -2532,10 +2559,32 @@


                }




                int j = 0;


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


                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)


                    {


                        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 (Cj_StationOutBillCheckBill(long.Parse(HBillNo[i]), CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))


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


                    {


                        j += 1;


                    }


@@ -2566,7 +2615,7 @@


        }




        //审核


        public bool Cj_StationOutBillCheckBill(Int64 lngBillKey, string CurUserName,bool HLastSubProc, ref string sReturn)


        public bool Cj_StationOutBillCheckBill(Int64 lngBillKey, string HBillNo, string CurUserName,bool HLastSubProc, ref string sReturn)


        {


            try


            {


@@ -2594,6 +2643,23 @@


                else if (Pub_Class.ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "是")


                {


                }




                //审核后控制


                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)


                {


                    sReturn = "审核过程中出错，请与网络管理人员联系";


                    oCN.RollBack();


                    return false;


                }


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


                {


                    sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();


                    oCN.RollBack();


                    return false;


                }




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


                oCN.Commit();


                return true;


@@ -2640,16 +2706,17 @@


                }


              




                var HBillNo = HInterID.Split(',');


                var HInterIDs = HInterID.Split(',');


                string[] HBillNo = new string[HInterIDs.Length];


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




                //获取系统参数


                string Ret = "";


                oSystemParameter.ShowBill(ref Ret);




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


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


                {


                    if (long.Parse(HBillNo[i]) == 0)


                    if (long.Parse(HInterIDs[i]) == 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


@@ -2659,7 +2726,7 @@


                    }




                    //查看是否已审核,关闭,作废


                    if (oBill.ShowBill(long.Parse(HBillNo[i]), ref DBUtility.ClsPub.sExeReturnInfo))


                    if (oBill.ShowBill(long.Parse(HInterIDs[i]), ref DBUtility.ClsPub.sExeReturnInfo))


                    {


                        if (oBill.omodel.HChecker.Trim() == "")


                        {


@@ -2682,6 +2749,8 @@


                                return objJsonResult;


                            }


                        }




                        HBillNo[i] = oBill.omodel.HBillNo;


                    }


                    else


                    {


@@ -2694,10 +2763,31 @@


                }




                int j = 0;


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


                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)


                    {


                        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 (Cj_StationOutBillAbandonCheckBill(long.Parse(HBillNo[i]), CurUserName, oBill.omodel.HLastSubProc, ref DBUtility.ClsPub.sExeReturnInfo))


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


                    {


                        j += 1;


                    }


@@ -2728,7 +2818,7 @@


        }




        //反审核


        public bool Cj_StationOutBillAbandonCheckBill(Int64 lngBillKey, string CurUserName, bool HLastSubProc, ref string sReturn)


        public bool Cj_StationOutBillAbandonCheckBill(Int64 lngBillKey,string HBillNo, string CurUserName, bool HLastSubProc, ref string sReturn)


        {


            if (Cj_StationInBillisUse(lngBillKey, ref sReturn))


            {


@@ -2761,6 +2851,23 @@


                else if (Pub_Class.ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "是")


                {


                }




                //反审核后控制


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


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


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


                {


                    sReturn = "反审核过程中出错，请与网络管理人员联系";


                    oCN.RollBack();


                    return false;


                }


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


                {


                    sReturn = ds.Tables[0].Rows[0]["HRemark"].ToString();


                    oCN.RollBack();


                    return false;


                }




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


                oCN.Commit();


                return true;