智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenhaozhe
昨天 862257fe2991fa96e0f20e31bcf00e4f9b1f86a2 
 WebAPI/Controllers/LMESController.cs


@@ -3039,13 +3039,12 @@


                ds = null;


            }


            return CustomCorrect(ds);


            //return ds.Tables[0].Rows;


        }




        //墨西哥白标生成


        [Route("LEMS/SaveCirculationCard_Json_MXG")]


        [HttpGet]


        public object SaveCirculationCard_Json_MXG(string HBillNo, string HInterID, string HBillNo2, string HBarCode,string HNumber, string HName, string HModel)


        public object SaveCirculationCard_Json_MXG(string HBillNo, string HInterID, string HBillNo2, string HBarCode,string HNumber, string HName, string HModel,string NBXMH, string HOrgID)


        {


            DataSet ds;


            try


@@ -3055,7 +3054,7 @@


                {


                    HBarCode = " ";


                }


                ds = oCN.RunProcReturn("exec Save_Sc_ProcessExchangeBillMainToTmp_MXG '" + HBillNo + "','" + HInterID + "','" + HBillNo2 + "','" + HBarCode + "','" + HNumber + "','" + HName + "','" + HModel + "'", "Save_Sc_ProcessExchangeBillMainToTmp_MXG");


                ds = oCN.RunProcReturn("exec Save_Sc_ProcessExchangeBillMainToTmp_MXG '" + HBillNo + "','" + HInterID + "','" + HBillNo2 + "','" + HBarCode + "','" + HNumber + "','" + HName + "','" + HModel + "','" + NBXMH + "','" + HOrgID + "'", "Save_Sc_ProcessExchangeBillMainToTmp_MXG");




            }


            catch (Exception e)


@@ -3193,7 +3192,6 @@


                ds = null;


            }


            return CustomCorrect(ds);


            //return ds.Tables[0].Rows;


        }




        #endregion


@@ -3252,9 +3250,7 @@


                ds = null;


            }


            return CustomCorrect(ds);


            //return ds.Tables[0].Rows;


        }






        #endregion




@@ -3305,7 +3301,7 @@




        [Route("LEMS/SaveToSc_PackUnionBillMain_MXG")]


        [HttpGet]


        public object SaveToSc_PackUnionBillMain(string HBillNo, string HRemark, string HProjectNum, string zxQty, string BBM, string LDM, string HMaterNumber, string HBarCode_White,string HOrgID)


        public object SaveToSc_PackUnionBillMain_MXG(string HBillNo, string HRemark, string HProjectNum, string zxQty, string BBM, string LDM, string HMaterNumber, string HBarCode_White,string HOrgID,string NBXMH)


        {


            DataSet ds;


            DataSet dsHSNum;


@@ -3316,7 +3312,7 @@


                {


                    if (LDM != "其他" && BBM != "其他")


                    {


                        ds = oCN.RunProcReturn($"exec h_p_MES_HBarCode_White_SMR_MXG {zxQty},'{BBM}','{HMaterNumber}','{HBillNo}'", "h_p_MES_HBarCode_White_SMR_MXG");


                        ds = oCN.RunProcReturn($"exec h_p_MES_HBarCode_White_SMR_MXG {zxQty},'{BBM}','{HMaterNumber}','{HBillNo}','{NBXMH}','{HOrgID}'", "h_p_MES_HBarCode_White_SMR_MXG");


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


                    }


                }                             


@@ -3547,7 +3543,6 @@


                ds = null;


            }


            return CustomCorrect(ds);


            //return ds.Tables[0].Rows;


        }




        #endregion


@@ -3645,7 +3640,6 @@


        }




        #endregion






        #region 产线包装单列表查询




@@ -3808,6 +3802,48 @@




        #endregion




        #region 获取白标项目号




        [Route("LEMS/GetHProject_MXG")]  


        [HttpGet]


        public object GetHProject_MXG(string HOrgID)


        {


            DataSet ds;


            DataSet dsHSNum;


            try


            {


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




                ds = oCN.RunProcReturn("select HInterID,HSupBarCodeNumber HName from Sc_PackUnionBillBarCode_temp where HUSEORGID='" + HOrgID + "'", "Sc_PackUnionBillBarCode_temp");




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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "获取失败" + DBUtility.ClsPub.sErrInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取成功!";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }           


        }


        #endregion






        #region 根据ID删除缓存表中扫码记录-产线包装单




@@ -3911,7 +3947,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "[0000-1-051]" + ds.Tables[0].Rows[0]["HBackRemark"].ToString() + "！";


                    objJsonResult.Message = ds.Tables[0].Rows[0]["HBackRemark"].ToString() + "！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -4370,7 +4406,7 @@


            {


                if (HBillSubType == "SUB")


                {


                    //判断是否有删除权限


                    //判断是否有审核权限


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


                    {


                        objJsonResult.code = "0";


@@ -4552,28 +4588,55 @@


                            return objJsonResult;


                        }


                    }


                    //反审核单据


                    if (BillOld.AbandonCheck(Int64.Parse(HInterID), ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_RoutingBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    {


                        //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();


                        //DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl");


                        ////if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0)


                        ////{


                        ////    objJsonResult.code = "0";


                        ////    objJsonResult.count = 1;


                        ////    objJsonResult.Message = "该任务单已下推流转卡，不允许反审核" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]);


                        ////    objJsonResult.data = null;


                        ////    return objJsonResult;


                        ////}


                    }


                    else




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




                    oCN.RunProc(" Update Gy_RoutingBillMain set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + HInterID.ToString());






                    string sql2 = "exec h_p_Gy_RoutingBill_AfterCheckCtrl " + HInterID + ",'" + HBillNo + "','" + user + "'";


                    ds = oCN.RunProcReturn(sql2, "h_p_Gy_RoutingBill_AfterUnCheckCtrl");


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


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


                        objJsonResult.data = null;


                        oCN.RollBack();


                        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;


                        oCN.RollBack();


                        return objJsonResult;


                    }


                    //反审核单据


                    // if (BillOld.AbandonCheck(HInterID, ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_Gy_RoutingBill_AfterUnCheckCtrl", user, ref ClsPub.sExeReturnInfo))


                    //{


                    //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();


                    //DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl");


                    ////if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0)


                    ////{


                    ////    objJsonResult.code = "0";


                    ////    objJsonResult.count = 1;


                    ////    objJsonResult.Message = "该任务单已下推流转卡，不允许反审核" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]);


                    ////    objJsonResult.data = null;


                    ////    return objJsonResult;


                    ////}


                    //}


                    // else


                    // {


                    //     objJsonResult.code = "0";


                    //     objJsonResult.count = 1;


                    //     objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;


                    //     objJsonResult.data = null;


                    //     return objJsonResult;


                    // }


                }




                oCN.Commit();//提交事务


@@ -4996,5 +5059,53 @@


            }


        }


        #endregion




        #region 多级审核审核列表


        [Route("LEMS/CheckFlowList")]


        [HttpGet]


        public json CheckFlowList(string sWhere, string billType, int type, string userid)


        {


            DataSet ds;


            json res = new json();


            try


            {


                List<object> columnNameList = new List<object>();


                


                


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn($"exec h_p_Xt_CheckFlowList '','{billType}',{type},'{userid}'", "h_p_Xt_CheckFlowList");


                }


                else


                {


                    sWhere = sWhere.Replace("'", "''");


                    ds = oCN.RunProcReturn($"exec h_p_Xt_CheckFlowList '{sWhere}','{billType}',{type},'{userid}'", "h_p_Xt_CheckFlowList");


                }




                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


                    Type dataType = col.DataType;


                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";


                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名


                }




                res.code = CodeConstant.SUCCEED;


                res.count = 1;


                res.Message = "Sucess！";


                res.list = columnNameList;


                res.data = ds.Tables[0];


                return res;


            }


            catch (Exception e)


            {


                res.code = CodeConstant.FAIL;


                res.count = CountConstant.FAIL;


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


                res.data = null;


                return res;


            }


        }


        #endregion


    }


}