智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yxj
7 天以前 ae36a4639fff74935c27c8e7bb0ce6b39ad039a5 
 WebAPI/Controllers/POStockInBillController.cs


@@ -936,7 +936,7 @@


                    {


                '@'


                    });


                    string str = array[0];


                    string str = array[0]; //物料代码


                    long num = (long)ClsPub.isInt(array[4]);


                    string text2 = array[6];


                    DateTime dateTime = ClsPub.isDate(array[3]);


@@ -995,12 +995,12 @@


                        bool flag3 = dataSet5.Tables[0].Rows.Count > 0;


                        if (!flag3)


                        {


                            POStockInBillController postockInBillController = new POStockInBillController();


                            //扫源单方法


                            postockInBillController.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);


                            //POStockInBillController postockInBillController = new POStockInBillController();


                            ////扫源单方法


                            //postockInBillController.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);




                            //WEBSController webscontroller4 = new WEBSController();


                            //object obj4 = webscontroller4.Get_SourceBarCode_PoStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID,1, oSystemParameterMain, ref DBUtility.ClsPub.sErrInfo);


                            WEBSController webscontroller4 = new WEBSController();


                            object obj4 = webscontroller4.get_SourceBarCode_POStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID);








@@ -1066,8 +1066,11 @@


                        bool flag4 = dataSet6.Tables[0].Rows.Count > 0;


                        if (!flag4)


                        {


                            POStockInBillController postockInBillController2 = new POStockInBillController();


                            postockInBillController2.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);


                            //POStockInBillController postockInBillController2 = new POStockInBillController();


                            //postockInBillController2.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);




                            WEBSController webscontroller4 = new WEBSController();


                            object obj4 = webscontroller4.get_SourceBarCode_POStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID);


                        }


                    }


                }


@@ -1079,12 +1082,12 @@


                    bool flag6 = text7.Contains("W") || text7.Contains("N");


                    if (flag6)


                    {


                        string text8 = sBarCodeNew.Substring(0, 10);//商品码


                        string text8 = sBarCodeNew.Substring(0, 10);//商品码    商品码+物料代码+生产日期+批次+失效日期+一位字母+三位数字


                        string str4 = sBarCodeNew.Substring(10, 10);//物料代码


                        string text9 = "20" + sBarCodeNew.Substring(20, 6);


                        long num8 = (long)ClsPub.isInt(text9.Substring(0, 4));


                        long num9 = (long)ClsPub.isInt(text9.Substring(4, 2));


                        long num10 = (long)ClsPub.isInt(text9.Substring(6, 2));


                        long num8 = (long)ClsPub.isInt(text9.Substring(0, 4));  //年


                        long num9 = (long)ClsPub.isInt(text9.Substring(4, 2));  //月


                        long num10 = (long)ClsPub.isInt(text9.Substring(6, 2)); //日


                        long num11 = (long)ClsPub.isInt(sBarCodeNew.Remove(0, sBarCodeNew.Length - 3));//后三位永远都是数字


                        string text10 = sBarCodeNew.Remove(0, sBarCodeNew.Length - 10);//失效日期+一位字母+三位数字


                        string text11 = "20" + text10.Substring(0, 6);


@@ -1241,7 +1244,7 @@


                    }


                    else


                    {


                        /*前十位物料代码，后六位生效日期，倒数前三位是数字前六位是失效日期  批号改为动态获取*/


                        /*前十位物料代码，后六位生效日期，倒数前三位是数字前六位是失效日期 */


                        string str6 = sBarCodeNew.Substring(0, 10);//物料代码


                        string text17 = "20" + sBarCodeNew.Substring(10, 6);


                        long num21 = (long)ClsPub.isInt(text17.Substring(0, 4));


@@ -1261,7 +1264,7 @@


                    "-",


                    num27.ToString()


                        }));


                        string text20 = sBarCodeNew.Remove(0, 16); //SAE1300100230309 2303704250308010


                        string text20 = sBarCodeNew.Remove(0, 16); //SAE1300100 230309 2303704 250308 010


                        string text21 = text20.Remove(text20.Length - 9 , 9); //SAE1300100230309 2303704 250308010


                         ClsCN clsCN3 = new ClsCN();


                        DataSet dataSet13 = clsCN3.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + str6 + "' and  huseorgid = " + HOrgID.ToString(), "Gy_Material");


@@ -1298,7 +1301,7 @@


                    "-",


                    num23.ToString()


                        }));


                        DataSet dataSet16 = clsCN3.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + text1 + "'", "Gy_BarCodeBill");


                        DataSet dataSet16 = clsCN3.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + text1 + "'", "Gy_BarCodeBill"); 


                        bool flag10 = dataSet16.Tables[0].Rows.Count > 0;


                        if (flag10)


                        {


@@ -1323,6 +1326,7 @@


                        }


                        else


                        {


                            //可能和他们的登录组织有关系


                            string billCode3 = "85";


                            long num32 = ClsPub.CreateBillID_Prod(billCode3, ref ClsPub.sExeReturnInfo);


                            long num33 = 0L;


@@ -3917,8 +3921,8 @@


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


                ListModels oListModels = new ListModels();


                lsmain = oListModels.getPOStockInBillMainByJson(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_POStockInBillMain websLsmain = new WebS.ClsKf_POStockInBillMain();


@@ -3950,7 +3954,8 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "成功！单据号为：";


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


                    //objJsonResult.Message = "成功！单据号为：";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -3958,7 +3963,8 @@


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


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


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


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


                    objJsonResult.data = null;


                    return objJsonResult;


                }


@@ -4307,6 +4313,14 @@


                {


                    DataSet dataSet = this.oCn.RunProcReturn("exec h_p_ReceiveBill_Fast " + hinterID, "h_p_ReceiveBill_Fast");


                    DataRow dataRow = dataSet.Tables[0].Rows[0];


                    if (dataSet.Tables[0].Rows.Count == 1 && dataSet.Tables[0].Rows[0]["FRECEIVENumber"].ToString() == "0")


                    {


                        this.objJsonResult.code = "0";


                        this.objJsonResult.count = 0;


                        this.objJsonResult.Message = "存在多个采购订单单据类型，不允许提交！";


                        this.objJsonResult.data = null;


                        return this.objJsonResult;


                    }


                    bool flag4 = dataSet.Tables[0].Rows.Count <= 0;


                    bool flag5 = flag4;


                    bool flag6 = flag5;


@@ -4425,6 +4439,7 @@


                            jobject16.Add("FSRCENTRYID", dataRow2["FENTRYID"].ToString());


                            jobject16.Add("FORDERBILLNO", dataRow2["FBILLNO"].ToString());


                            jobject16.Add("FPOORDERENTRYID", dataRow2["FENTRYID"].ToString());


                            jobject16.Add("FGiveAway", dataRow2["FGIVEAWAY"].ToString());//是否赠品


                            //jobject16.Add("FPrice", dataRow2["FPRICE"].ToString());


                            //jobject16.Add("FTaxPrice", dataRow2["FTAXPRICE"].ToString());


                            //jobject16.Add("FEntryTaxRate", dataRow2["FTAXRATE"].ToString());


@@ -4998,7 +5013,16 @@


        {


            try


            {


                string _msg = msg["msg"].ToString();


                string HMaker ="";           //制单人


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


                string msg1 = _value.ToString();


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


                string _msg = sArray[0].ToString();


                if(sArray.Length>1)


                {


                    HMaker = sArray[1].ToString();


                }




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


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


                List<Models.ReciveBill_FastModel> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ReciveBill_FastModel>>(_msg);


@@ -5046,6 +5070,7 @@


,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER  AS FSETTLEORGNUMBER,


E.FPRICETIMEPOINT,E.FSETTLECURRID,EC.FNUMBER AS FSETTLECURRNUMBER,C.FMATERIALID,CM.FNUMBER AS FMATERIALNUMBER ,C.FUNITID 


,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER


,C.FGIVEAWAY AS FGIVEAWAY   


FROM CG_POINSTOCKBILLSUB B  


JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID


JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID


@@ -5129,6 +5154,7 @@


                                FentityModel.Add("FPrice", item["FPRICE"].ToString());//单价


                                FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价


                                FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率


                                FentityModel.Add("FGiveAway", item["FGIVEAWAY"].ToString());//是否赠品




                                JArray Fentity2 = new JArray();


                                JObject FentityModel2 = new JObject();


@@ -5157,7 +5183,8 @@


                                ["IsVerifyBaseDataField"] = "false",


                                ["Model"] = model


                            };


                            var loginRet = InvokeHelper.Login();


                            //登录


                            var loginRet = InvokeHelper.LoginUser(HMaker);


                            var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                            if (isSuccess == 0)


                            {


@@ -5203,7 +5230,54 @@


                        LogService.Write("收料通知单审核无数据：" + sql);


                    }


                }


                else //夏宝 ，更新erp信息


                else if(FCusName.Contains("夏宝"))


                {


                    JObject jsonRoot = new JObject();


                    jsonRoot.Add("Creator", "");


                    jsonRoot.Add("NeedUpDateFields", new JArray());


                    jsonRoot.Add("NeedReturnFields", new JArray());


                    jsonRoot.Add("IsDeleteEntry", "false"); //注意IsDeleteEntry参数，如为True，则原分录行的FEntryId未在分录json出现的行，将会被删除 （如无需删除分录行，可改为fasle）


                    jsonRoot.Add("SubSystemId", "");


                    jsonRoot.Add("IsVerifyBaseDataField", "");




                    JObject jsonModel = new JObject();


                    jsonModel.Add("FID", FID);


                    JArray Entry = new JArray();


                    foreach (var item in list)


                    {


                        if (item.HSQty == 0)


                            continue;


                        JObject jsonFPOOrderEntry = new JObject();


                        jsonFPOOrderEntry.Add("FEntryID", item.FEntryID);


                        jsonFPOOrderEntry.Add("FActReceiveQty ", item.HSQty); ;


                        Entry.Add(jsonFPOOrderEntry);


                    }


                    jsonModel.Add("FDetailEntity", Entry);


                    jsonRoot.Add("Model", jsonModel);


                    //登录


                    var loginRet = InvokeHelper.LoginUser(HMaker);


                    var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                    if (isSuccess <= 0)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = loginRet;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    var result = InvokeHelper.Save("PUR_ReceiveBill", jsonRoot.ToString());


                    //LogService.Write(result);


                    if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")


                    {


                        LogService.Write("收料通知单修改失败jsonRoot:" + jsonRoot.ToString());


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "金蝶收料通知单更新失败" + result;


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                }


                else //更新erp信息


                {


                    JObject jsonRoot = new JObject();


                    jsonRoot.Add("Creator", "");


@@ -5227,7 +5301,8 @@


                    }


                    jsonModel.Add("FDetailEntity", Entry);


                    jsonRoot.Add("Model", jsonModel);


                    var loginRet = InvokeHelper.Login();


                    //登录


                    var loginRet = InvokeHelper.LoginUser(HMaker);


                    var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                    if (isSuccess <= 0)


                    {


@@ -5300,6 +5375,82 @@




        }




        [Route("POStockInBillList/AuditPOInStockBillPost_TianKang")]


        [HttpGet]


        public object AuditPOInStockBill_TianKang(long FID,string user)


        {


            try


            {


                //string _msg = msg["msg"].ToString();


                //_msg = _msg.Replace("\\", "");


                //_msg = _msg.Replace("\n", "");


                //List<Models.ReciveBill_FastModel> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ReciveBill_FastModel>>(_msg);


                //DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();


                //var hinterID = list[0].HInterID;


                //var FID = list[0].FID;


                //string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称               


                //var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");


                //string sql = string.Empty;


                                              


                var json = new


                {


                    Ids = FID,


                };


                //LogService.Write(json);


                //登录


                var loginRet = InvokeHelper.LoginUser(user);


                var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();


                if (isSuccess <= 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = loginRet;


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                //提交


                var _result = InvokeHelper.Submit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));


                var _saveObj = JObject.Parse(_result);


                if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")


                {


                    LogService.Write("收料通知单提交失败jsonRoot:" + json.ToString());


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "金蝶收料通知单提交失败" + _result;


                    objJsonResult.data = null;


                    return objJsonResult;




                }


                //审核


                _result = InvokeHelper.Audit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));


                _saveObj = JObject.Parse(_result);


                if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")


                {


                    LogService.Write("收料通知单审核失败jsonRoot:" + json.ToString());


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "金蝶收料通知单审核失败jsonRoot" + _result;


                    objJsonResult.data = null;


                    return objJsonResult;




                }


                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 = "异常！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }




        /// <summary>


        /// 到货确认 扫条码 校验


        /// </summary>


@@ -5318,9 +5469,11 @@


                string sql = string.Empty;


                if (FCusName.Contains("安瑞"))


                    sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from  Gy_BarCodeBill where HSourceInterID =(select distinct HSourceInterID from Cg_POInStockBillSub where HInterID ={HInterID}) and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'";


                else if(FCusName.Contains("添康科技"))


                    sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID,HMaterID,HBatchNo,HProduceDate,HExpiryDate from  Gy_BarCodeBill where HSourceInterID = {HInterID} and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'";


                else


                    sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from  Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}";


                DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList");


                DataSet ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill");


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


                {


                    objJsonResult.code = "0";