智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
2024-07-03 18bf65577b174d574b36c5fb5ab4364a14c7724a 
 WebAPI/Controllers/ProductInController.cs


@@ -42,6 +42,7 @@


        public ClsGy_BarCodeBill_WMS_Model_View oView =new ClsGy_BarCodeBill_WMS_Model_View();


        public ClsKF_PonderationBillMain_Temp model = new ClsKF_PonderationBillMain_Temp();


        public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();


        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();


        //public ClsKf_ICStockBill_WMS oBar = new ClsKf_ICStockBill_WMS();


        public double sRelQty = 0;


       // private DataBaseServices objDataBaseServices = new DataBaseServices();


@@ -155,6 +156,47 @@


                        list = ds.Tables[0],


                        list2 = ds.Tables[4]


                    };


                    return objJsonResult;


                }


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "没有返回任何记录！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        //缓存列表查询功能


        [Route("ProductInBillList/list1")]


        [HttpGet]


        public object list1(string BillType, string HBillNo, string HSourceBillNo)


        {


            try


            {


                if (HSourceBillNo == null)


                {


                    HSourceBillNo = "";


                }


                WebS.WebService1 oWebs = new WebS.WebService1();


                ds = oWebs.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo);


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


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录！";


                    objJsonResult.data = null;


                    return objJsonResult;


                    //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning);


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "获取信息成功！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                }


            }


@@ -286,29 +328,59 @@


        /// <returns></returns>


        [Route("OtherOutBill_Check_New/get_InfoByBarCode_Source_Json")]


        [HttpGet]


        public Object get_InfoByBarCode_Source_Json(string sCode, Int64 sInterID, string HBillType,string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Int64 sQty, Int64 HOWNERID)


        //public Object get_InfoByBarCode_Source_Json(string sCode, Int64 sInterID, string HBillType,string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Int64 sQty, Int64 HOWNERID)


        //{


        //    WebS.WebService1 oWebs = new WebS.WebService1();


        //    WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();


        //    string sExpressNumber = "";




        //    var sJXCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HOWNERID, sBillNo, sMaker);


        //    //WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


        //    WebSoBar = oWebs.get_CheckTypeByBarCode_BillCheck(sJXCode, sInterID, HBillType, sBillNo, sMaker,  WhID,  SPID,  sQty,  HOWNERID, ref DBUtility.ClsPub.sErrInfo);


        //    if (WebSoBar == null)


        //    {


        //        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 = DBUtility.ClsPub.sErrInfo;


        //        objJsonResult.data = WebSoBar;


        //        return objJsonResult;


        //    }


        //}




        public object get_InfoByBarCode_Source_Json(string sCode, long sInterID, string HBillType, string sBillNo, string sMaker, long WhID, long SPID, long sQty, long HOWNERID)


        {


            WebS.WebService1 oWebs = new WebS.WebService1();


            WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();


            string sBarCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HOWNERID, sBillNo, sMaker);


            string sExpressNumber = "";


            //WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


            WebSoBar = oWebs.get_CheckTypeByBarCode_BillCheck(sCode, sInterID, HBillType, sBillNo, sMaker,  WhID,  SPID,  sQty,  HOWNERID, ref DBUtility.ClsPub.sErrInfo);


            if (WebSoBar == null)


            WebSoBar = oWebs.get_CheckTypeByBarCode_BillCheck(sBarCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, (double)sQty, HOWNERID, ref ClsPub.sErrInfo);


            bool flag = WebSoBar == null;


            object result;


            if (flag)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


                objJsonResult.data = null;


                return objJsonResult;


                this.objJsonResult.code = "0";


                this.objJsonResult.count = 0;


                this.objJsonResult.Message = ClsPub.sErrInfo;


                this.objJsonResult.data = null;


                result = this.objJsonResult;


            }


            else


            {


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


                objJsonResult.data = WebSoBar;


                return objJsonResult;


                this.objJsonResult.code = "0";


                this.objJsonResult.count = 1;


                this.objJsonResult.Message = ClsPub.sErrInfo;


                this.objJsonResult.data = WebSoBar;


                result = this.objJsonResult;


            }


            return result;


        }






@@ -322,23 +394,54 @@


        {


            WebS.WebService1 oWebs = new WebS.WebService1();


            WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS();


            string sExpressNumber = "";


            //WebSoBar = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


            WebSoBar = oWebs.get_BarCode_MoveStockBillCheck(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, SCWhID, SCSPID, sQty, HOWNERID, ref DBUtility.ClsPub.sErrInfo);


            if (WebSoBar == null)


            //获取系统参数


            string sErrMsg = "";


            string sJXCode = "";


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


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


                objJsonResult.data = null;


                return objJsonResult;


                if (oSystemParameter.omodel.WMS_CampanyName == "安瑞") //系统参数  客户定制化名称     空白为通用


                {


                    sJXCode = POStockInBillController.JX_Json(sCode, sInterID, HBillType, HOWNERID, sBillNo, sMaker);


                }


                else


                {


                    sJXCode = sCode;


                }


                try


                {


                    WebSoBar = oWebs.get_BarCode_MoveStockBillCheck(sJXCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, SCWhID, SCSPID, sQty, HOWNERID, ref DBUtility.ClsPub.sErrInfo);


                    if (WebSoBar == null)


                    {


                        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 = DBUtility.ClsPub.sErrInfo;


                        objJsonResult.data = WebSoBar;


                        return objJsonResult;


                    }


                }


                catch (Exception e)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "扫描条码失败！" + e.ToString();


                    objJsonResult.data = null;


                    return objJsonResult;


                }


            }


            else


            {


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


                objJsonResult.data = WebSoBar;


                objJsonResult.count = 0;


                objJsonResult.Message = "获取系统参数失败！ " + sErrMsg;


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


@@ -1093,67 +1196,143 @@


        [HttpPost]


        public object set_SaveProductInBill_Json([FromBody]JObject oMain)


        {


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


            string msg1 = _value.ToString();


            //List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();


            //ListModels oListModels = new ListModels();


            //lsmain = oListModels.getProductInBillMainByJson(msg1);


            //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


            //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


            //string sSourceBillType = lsmain[0].HBillType;


            //BLL.ClsKf_ProductInBill bll = new BLL.ClsKf_ProductInBill();


            //return bll.set_SaveProductInBill_New(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo);


            


            //var _value = oMain["oMain"].ToString();


            //string msg1 = _value.ToString();


            ////List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();


            ////ListModels oListModels = new ListModels();


            ////lsmain = oListModels.getProductInBillMainByJson(msg1);


            ////lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


            ////lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


            ////string sSourceBillType = lsmain[0].HBillType;


            ////BLL.ClsKf_ProductInBill bll = new BLL.ClsKf_ProductInBill();


            ////return bll.set_SaveProductInBill_New(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo);




            //try


            //{


            //    List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();


            //    ListModels oListModels = new ListModels();


            //    lsmain = oListModels.getProductInBillMainByJson(msg1);


            //    //lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


            //    //lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


            //    string sSourceBillType = lsmain[0].HBillType;




            //    WebAPI.WebS.ClsKf_ProductInBillMain websLsmain = new WebS.ClsKf_ProductInBillMain();




            //    websLsmain.HInterID = lsmain[0].HInterID;


            //    websLsmain.HDate = lsmain[0].HDate;


            //    websLsmain.HBillNo = lsmain[0].HBillNo;


            //    websLsmain.HDeptID = lsmain[0].HDeptID;


            //    websLsmain.HEmpID = lsmain[0].HEmpID;


            //    websLsmain.HKeeperID= lsmain[0].HKeeperID;


            //    websLsmain.HRemark = lsmain[0].HRemark;


            //    websLsmain.HMaker = lsmain[0].HMaker;


            //    websLsmain.HWHID = lsmain[0].HWHID;


            //    websLsmain.HSupID = lsmain[0].HSupID;


            //    websLsmain.HExplanation = lsmain[0].HExplanation;


            //    websLsmain.HBillType = "1202";//固定值






            //    if (webserver.set_SaveProductInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))


            //    {


            //        objJsonResult.code = "0";


            //        objJsonResult.count = 1;


            //        objJsonResult.Message = "生成产品入库单成功！单据号为：";


            //        objJsonResult.data = null;


            //        return objJsonResult;


            //    }


            //    else


            //    {


            //        objJsonResult.code = "0";


            //        objJsonResult.count = 0;


            //        objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;


            //        objJsonResult.data = null;


            //        return objJsonResult;


            //    }


            //}


            //catch (Exception e)


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


            //    objJsonResult.Message = "上传失败！" + e.ToString();


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}












            string text = oMain["oMain"].ToString();


            string jsonString = text.ToString();


            object result;


            try


            {


                List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();


                ListModels oListModels = new ListModels();


                lsmain = oListModels.getProductInBillMainByJson(msg1);


                lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);


                lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


                string sSourceBillType = lsmain[0].HBillType;




                WebAPI.WebS.ClsKf_ProductInBillMain websLsmain = new WebS.ClsKf_ProductInBillMain();




                websLsmain.HInterID = lsmain[0].HInterID;


                websLsmain.HDate = lsmain[0].HDate;


                websLsmain.HBillNo = lsmain[0].HBillNo;


                websLsmain.HDeptID = lsmain[0].HDeptID;


                websLsmain.HEmpID = lsmain[0].HEmpID;


                websLsmain.HKeeperID= lsmain[0].HKeeperID;


                websLsmain.HRemark = lsmain[0].HRemark;


                websLsmain.HMaker = lsmain[0].HMaker;


                websLsmain.HWHID = lsmain[0].HWHID;


                websLsmain.HSupID = lsmain[0].HSupID;


                websLsmain.HExplanation = lsmain[0].HExplanation;


                websLsmain.HBillType = "1202";//固定值






                if (webserver.set_SaveProductInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))


                List<ClsKf_ProductInBillMain> list = new List<ClsKf_ProductInBillMain>();


                ListModels listModels = new ListModels();


                list = listModels.getProductInBillMainByJson(jsonString);


                //list[0].HYear = ClsPub.isLong(DateTime.Now.Year);


                //list[0].HDate = ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));


                string hbillType = list[0].HBillType;


                WebAPI.WebS.ClsKf_ProductInBillMain clsKf_ProductInBillMain = new WebAPI.WebS.ClsKf_ProductInBillMain();


                clsKf_ProductInBillMain.HInterID = list[0].HInterID;


                clsKf_ProductInBillMain.HDate = list[0].HDate;


                clsKf_ProductInBillMain.HBillNo = list[0].HBillNo;


                clsKf_ProductInBillMain.HDeptID = list[0].HDeptID;


                clsKf_ProductInBillMain.HEmpID = list[0].HEmpID;


                clsKf_ProductInBillMain.HKeeperID = list[0].HKeeperID;


                clsKf_ProductInBillMain.HSecManagerID = list[0].HSecManagerID;


                clsKf_ProductInBillMain.HRemark = list[0].HRemark;


                clsKf_ProductInBillMain.HMaker = list[0].HMaker;


                clsKf_ProductInBillMain.HBillerID = list[0].HBillerID;


                clsKf_ProductInBillMain.HWHID = list[0].HWHID;


                clsKf_ProductInBillMain.HSupID = list[0].HSupID;


                clsKf_ProductInBillMain.HExplanation = list[0].HExplanation;


                clsKf_ProductInBillMain.HBillType = "1202";


                if (list[0].HBillType == "3714")


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "生成产品入库单成功！单据号为：";


                    objJsonResult.data = null;


                    return objJsonResult;


                    clsKf_ProductInBillMain.HMainSourceBillType = "工序汇报单";


                }


                else if (list[0].HBillType == "3711")


                {


                    clsKf_ProductInBillMain.HMainSourceBillType = "生产汇报单";


                }


                else if (list[0].HBillType == "3710")


                {


                    clsKf_ProductInBillMain.HMainSourceBillType = "生产订单";


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;


                    objJsonResult.data = null;


                    return objJsonResult;


                    clsKf_ProductInBillMain.HMainSourceBillType = "手工录入";


                }


                bool flag = this.webserver.set_SaveProductInBill_New(clsKf_ProductInBillMain, hbillType, ref ClsPub.sErrInfo);


                if (flag)


                {


                    this.objJsonResult.code = "0";


                    this.objJsonResult.count = 1;


                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //成功！


                    //this.objJsonResult.Message = "生成产品入库单成功！单据号为：";


                    this.objJsonResult.data = null;


                    result = this.objJsonResult;


                }


                else


                {


                    this.objJsonResult.code = "0";


                    this.objJsonResult.count = 0;


                    objJsonResult.Message = DBUtility.ClsPub.sErrInfo;  //失败！


                    //this.objJsonResult.Message = "上传失败！" + ClsPub.sErrInfo;


                    this.objJsonResult.data = null;


                    result = this.objJsonResult;


                }


            }


            catch (Exception e)


            catch (Exception ex)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "上传失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


                this.objJsonResult.code = "0";


                this.objJsonResult.count = 0;


                this.objJsonResult.Message = "上传失败！" + ex.ToString();


                this.objJsonResult.data = null;


                result = this.objJsonResult;


            }


            return result;


        }




        /// <summary>