智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2025-03-24 1b7bc6d187a47b42e10b36c1d4d0215e58ed28ca 
 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs


@@ -1871,7 +1871,10 @@


                    case "Emp":


                        sql = "select * from h_v_Sc_StationOutBillSubQuery_Emp where 1 = 1 and HInterID=" + sWhere;


                        break;


                  


                    case "Sup":


                        sql = "select * from h_v_Sc_StationOutBillSubQuery_Sup where 1 = 1 and HInterID=" + sWhere;


                        break;




                }




                ds = oCN.RunProcReturn(sql, TableName);


@@ -2751,7 +2754,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)


@@ -2771,7 +2774,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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




                    //审核


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


@@ -2847,7 +2850,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)


@@ -2862,7 +2865,7 @@


                    oCN.RollBack();


                    return false;


                }


               


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




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


                oCN.Commit();


@@ -2969,7 +2972,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)


@@ -2989,7 +2992,7 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




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


                    //反审核


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


                    {


@@ -3083,7 +3086,7 @@


                return false; ;


            }


        }




        #endregion




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


        [Route("Cj_StationOutBill/CloseCj_StationOutBill")]


@@ -3148,8 +3151,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;


@@ -3175,8 +3202,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;


@@ -3208,7 +3259,7 @@








        //是否被关联


        #region //是否被关联


        public bool Cj_StationInBillisUse(Int64 lngBillKey, ref string sReturn)


        {


            try


@@ -4066,5 +4117,123 @@


            }


        }


        #endregion




        #region 出站单列表-下推PPM数据录入保存,删除




        [Route("Cj_StationOutBill/PPMSupAddBill")]


        [HttpPost]


        public object PPMSupAddBill([FromBody] JObject sSubStr)


        {


            var _value = sSubStr["sSubStr"].ToString();


            string msg1 = _value.ToString();


            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


            try


            {


                //反序列化


                string msg2 = sArray[0].ToString(); //表体


                string refSav = sArray[1].ToString();//操作类型


                string user = sArray[2].ToString(); //用户


                msg2 = msg2.Substring(1, msg2.Length - 2);


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


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


                msg2 = "[" + msg2 + "]";


                //判断是否有编辑权限


                if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无编辑权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }






                List<Sc_StationOutBillSub_Sup> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_StationOutBillSub_Sup>>(msg2);




                oCN.BeginTran();


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


                {              


                    int HInterID = list[i].HInterID;


                    int HEntryID = i+1;


                    int HSupID = list[i].HSupID;


                    double HWasterQty_Mater = list[i].HWasterQty_Mater;


                    double HBackWorkQty = list[i].HBackWorkQty;




                    oCN.RunProc("Insert Into Sc_StationOutBillSub_Sup " +


                     "(HInterID, HEntryID, HSupID, HWasterQty_Mater, HBackWorkQty) " +


                     "values ('" + HInterID + "', '" + HEntryID + "', '" + HSupID + "', '" + HWasterQty_Mater + "', '" + HBackWorkQty + "')");




                }




                oCN.Commit();            


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "新增单据成功！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        [Route("Cj_StationOutBill/PPMSupDelete")]


        [HttpGet]


        public object PPMSupDelete(int HInterID,string user)


        {


            try


            {


                //判断是否有查询权限


                if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Drop", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "无删除权限!";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_Sup WITH(NOLOCK) where HInterID = " + HInterID, "Sc_StationOutBillSub_Sup");




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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "查无数据！";


                    objJsonResult.data = null;


                }




                oCN.BeginTran();




                string sql = "";


               


                sql = "delete from Sc_StationOutBillSub_Sup where HInterID = " + HInterID;


                oCN.RunProc(sql);




                oCN.Commit();




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


    }


}