智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
yangle
昨天 6d0bfe2160e06a4502dc3052c43fab9813341db3 
 WebAPI/Controllers/OtherOutBillController.cs


@@ -47,6 +47,8 @@


        // private DataBaseServices objDataBaseServices = new DataBaseServices();


        private JsonResult objJsonResult = new JsonResult();


        public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();


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


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


        // private string msgModel = "{{\"count\":{0},\"code\":{0},\"message\":\"{1}\",\"result\":{2}}}";


        public static string GetSession(string sMsg)


        {


@@ -67,27 +69,98 @@


        /// <returns></returns>


        [Route("OtherOutBill/get_CheckTypeByBarCode_Out_Json")]


        [HttpGet]


        public Object get_CheckTypeByBarCode_Out_Json(string sCode, Int64 sInterID, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID)


        //public Object get_CheckTypeByBarCode_Out_Json(string sCode, Int64 sInterID,string HBillType, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID, string HScanStyle)


        //{


        //    //oBar = webserver.get_CheckTypeByBarCode_Out(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);


        //    //if (oBar == 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 = "扫码成功！";


        //    //    //objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


        //    //    objJsonResult.data = oBar;


        //    //    return objJsonResult;


        //    //}






        //    string sErrMsg = "";


        //    string sJXCode = "";


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


        //    {


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


        //        SourceFlag = true;


        //    }


        //    else


        //    {


        //        sJXCode = sCode;


        //    }








        //    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);


        //    SourceFlag = true;


        //    //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_All(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


        //    WebSoBar = oWebs.get_CheckTypeByBarCode_New(sJXCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, HScanStyle, 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_CheckTypeByBarCode_Out_Json(string sCode, long sInterID, string sBillNo, string sMaker, long WhID, long SPID, double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, long HOWNERID)


        {


            oBar = webserver.get_CheckTypeByBarCode_Out(sCode, sInterID, HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, ref DBUtility.ClsPub.sErrInfo);


            if (oBar == null)


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


            WebAPI.WebS.ClsKf_ICStockBill_WMS clsKf_ICStockBill_WMS = new WebAPI.WebS.ClsKf_ICStockBill_WMS();


            string hexpressNumber = "";


            clsKf_ICStockBill_WMS = oWebs.get_CheckTypeByBarCode_All(sCode, sInterID, this.HBillType, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, hexpressNumber, ref ClsPub.sErrInfo);


            bool flag = clsKf_ICStockBill_WMS == 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 = "扫码成功！";


                //objJsonResult.Message = DBUtility.ClsPub.sErrInfo;


                objJsonResult.data = oBar;


                return objJsonResult;


                this.objJsonResult.code = "0";


                this.objJsonResult.count = 1;


                this.objJsonResult.Message = ClsPub.sErrInfo;


                this.objJsonResult.data = clsKf_ICStockBill_WMS;


                result = this.objJsonResult;


            }


            return result;


        }




        /// <summary>


        /// 一键扫码(红字)


        /// </summary>


@@ -96,7 +169,7 @@


        [HttpGet]


        public Object get_CheckTypeByBarCode_All_Json(string sCode, Int64 sInterID, string sBillNo, string sMaker, Int64 WhID, Int64 SPID, Double sQty, bool sRedBlue, bool SourceFlag, string sSourceBillNo, string sSourceType, Int64 HOWNERID, string sExpressNumber)


        {


            oBar = webserver.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType1, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID,sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


            oBar = webserver.get_CheckTypeByBarCode_All(sCode, sInterID, HBillType1, sBillNo, sMaker, WhID, SPID, sQty, sRedBlue, SourceFlag, sSourceBillNo, sSourceType, HOWNERID, sExpressNumber, ref DBUtility.ClsPub.sErrInfo);


            if (oBar == null)


            {


                objJsonResult.code = "0";


@@ -155,7 +228,7 @@


            }


        }




         /// <summary>


        /// <summary>


        /// 扫描条码


        /// </summary>


        /// <param name="msg"></param>


@@ -227,7 +300,7 @@


        /// <returns></returns>


        [Route("OtherOutBill/set_SaveOtherOutBackBill_Json")]


        [HttpPost]


        public object set_SaveOtherOutBackBill_Json([FromBody]JObject oMain )


        public object set_SaveOtherOutBackBill_Json([FromBody] JObject oMain)


        {


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


            string msg1 = _value.ToString();


@@ -269,68 +342,120 @@




        [Route("OtherInStockBill/set_SavePonderationBillMain_Temp_Source_Fast_Json")]


        [HttpGet]


        public object set_SavePonderationBillMain_Temp_Source_Fast_Json(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo)


        public object set_SavePonderationBillMain_Temp_Source_Fast_Json(Int64 sInterID, string SBillNo, string HBillType, string sSourceBillNo, string sSourceType, string sMaker, Int64 sHOWNERID)


        {


            try


            {


                // DataSet ds = new DataSet();


                // WebServer webserver = new WebServer();


                string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'";


                if (HSourceBillType == "3720")


                {


                    ds = webserver.GetSc_ICMOBackBillList(sWhere + "  ");


                }


                else


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有返回任何记录,源单类型有错误！";


                    objJsonResult.data = null;


                    return objJsonResult; ;


                }


            //try


            //{


            //    // DataSet ds = new DataSet();


            //    // WebServer webserver = new WebServer();


            //    string sWhere = " Where 单据号 like '%" + HSourceBillNo.Trim() + "%'";


            //    if (HSourceBillType == "3720")


            //    {


            //        ds = webserver.GetSc_ICMOBackBillList(sWhere + "  ");


            //    }


            //    else


            //    {


            //        objJsonResult.code = "0";


            //        objJsonResult.count = 0;


            //        objJsonResult.Message = "没有返回任何记录,源单类型有错误！";


            //        objJsonResult.data = null;


            //        return objJsonResult; ;


            //    }




                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


                {


                    HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]);


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


                    HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);


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


                    if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, HBillType, HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "返回记录成功！";


                        objJsonResult.data = ds.Tables[0];


                        return objJsonResult;


                    }


                    else


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


            }


            catch (Exception ex)


            //    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


            //    {


            //        HSupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSupID"]);


            //        HSupName = Convert.ToString(ds.Tables[0].Rows[0]["HSupName"]);


            //        HDeptID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HDeptID"]);


            //        HDeptName = Convert.ToString(ds.Tables[0].Rows[0]["HDeptName"]);


            //        if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, HBillType, HSourceBillNo, HSourceBillType, "蓝字", ref DBUtility.ClsPub.sErrInfo))


            //        {


            //            objJsonResult.code = "0";


            //            objJsonResult.count = 1;


            //            objJsonResult.Message = "返回记录成功！";


            //            objJsonResult.data = ds.Tables[0];


            //            return objJsonResult;


            //        }


            //        else


            //        {


            //            objJsonResult.code = "0";


            //            objJsonResult.count = 0;


            //            objJsonResult.Message = "写入临时表失败！" + DBUtility.ClsPub.sErrInfo;


            //            objJsonResult.data = null;


            //            return objJsonResult;


            //        }


            //    }


            //}


            //catch (Exception ex)


            //{


            //    objJsonResult.code = "0";


            //    objJsonResult.count = 0;


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


            //    objJsonResult.data = null;


            //    return objJsonResult;


            //}




            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_SourceBarCode_OtherIn(sInterID, SBillNo, HBillType, sSourceBillNo, sSourceType, sMaker, sHOWNERID, ref DBUtility.ClsPub.sErrInfo);


            if (WebSoBar == null)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                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;


            }


        }




        [Route("OtherOutBill/set_SavePonderationBillMain_Temp_Source_Fast_Json1")]


        [HttpGet]


        public object set_SavePonderationBillMain_Temp_Source_Fast_Json1(Int64 sInterID, string SBillNo, string HBillType, string sSourceBillNo, string sSourceType,bool sRedBlue, string sMaker, Int64 sHOWNERID)


        {


           


            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_CheckTypeBySource_New(sInterID, SBillNo, HBillType, sSourceBillNo, sSourceType,sRedBlue, sMaker, sHOWNERID, 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;


            }


        }








        /// <summary>


        /// 生成其他入库单


@@ -338,7 +463,7 @@


        /// <returns></returns>


        [Route("OtherOutBill/set_set_SaveOtherOutBill_Json")]


        [HttpPost]


        public object set_set_SaveOtherOutBill_Json([FromBody]JObject oMain)


        public object set_set_SaveOtherOutBill_Json([FromBody] JObject oMain)


        {


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


            string msg1 = _value.ToString();


@@ -347,27 +472,33 @@


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


                ListModels oListModels = new ListModels();


                lsmain = oListModels.getOtherOutBillMainByJson(msg1);


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


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


                //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_OtherOutBillMain websLsmain = new WebS.ClsKf_OtherOutBillMain();


                websLsmain.HInterID = lsmain[0].HInterID;


                websLsmain.HDate = lsmain[0].HDate;


                websLsmain.HBillNo = lsmain[0].HBillNo;


                websLsmain.HSupID = lsmain[0].HSupID;


                websLsmain.HDeptID = lsmain[0].HDeptID;


                websLsmain.HEmpID = lsmain[0].HEmpID;


                websLsmain.HKeeperID = lsmain[0].HKeeperID;


                websLsmain.HSecManagerID = lsmain[0].HSecManagerID;


                websLsmain.HRemark = lsmain[0].HRemark;


                websLsmain.HMaker = lsmain[0].HMaker;


                websLsmain.HBillerID = lsmain[0].HBillerID;


                websLsmain.HSTOCKORGID = lsmain[0].HSTOCKORGID;


                websLsmain.HOWNERID = lsmain[0].HSTOCKORGID;




                websLsmain.HOWNERID = lsmain[0].HOWNERID;


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


                websLsmain.HBillSubType = lsmain[0].HBillSubType;


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


                WebS.ClsXt_SystemParameterMain oSystemParameterMain = new WebS.ClsXt_SystemParameterMain();


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


                if (oWebs.set_SaveOtherOutBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "生成其他出库单成功！单据号为：";


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -375,7 +506,7 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -571,6 +702,38 @@


                return objJsonResult;


            }


        }


    }




        #region PDA其他出库


        //PDA其他出库整托删除


        [Route("OtherOutBillList/OtherOutBillSDeleCode")]


        [HttpGet]


        public object OtherOutBillSDeleCode(string HBarCode, string HInterID)


        {


            try


            {


                //根据条码在条码档案中找到对应的托条码，再在临时表中删除该托条码的全部记录


                string sql = string.Format(@"delete from KF_PonderationBillMain_Temp where HBillType=1206 and HInterID=" + HInterID + " and HBarCode" +


                    " in (select HBarCode from Gy_BarCodeBill where HBarCode_Pack = (select HBarCode_Pack from Gy_BarCodeBill where HBarCode = '" + HBarCode + "'))");


                oCn.RunProc(sql);




                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "整托删除成功！";


                objJsonResult.data = 1;


                return objJsonResult;


            }


            catch (Exception e)


            {


                objJsonResult.code = "0";


                objJsonResult.count = 0;


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


                objJsonResult.data = null;


                return objJsonResult;


            }




        }


        #endregion






    }


}