智云SRM-WEBAPI（目前客户通用API）
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-08-22 5cdcde592ae19de697c4bf16dce08838065987e3 
 WebAPI/Controllers/BarCodeController.cs


@@ -13,6 +13,8 @@


using System.Web.Script.Serialization;


using WebAPI.Code;


using WebAPI.Models;


using WebAPI.Utility;




namespace WebAPI.Controllers


{




@@ -711,7 +713,7 @@


                        }


                    }


                }


                




                string HBarCode = "";


                string HBarCodeType = "";


                Int64 HMaterID = 0;


@@ -1456,15 +1458,12 @@


        /// <summary>


        /// 条码生成表体（采购订单）


        /// </summary>


        /// <param name="sMsg"></param>


        /// <param name="sMsg">采购订单HinterID</param>


        /// <returns></returns>


        public object GetHBarCodeShowBillSubBycg(string sMsg)


        {


            try


            {


                DataSet ds;


                string s = "";


                string ShowItem = " * ";//显示的字段


                if (DBUtility.ClsPub.isLong(sMsg) == 0)


                {


                    objjson.code = "0";


@@ -1473,9 +1472,18 @@


                    objjson.data = null;


                    return objjson;


                }


                //预处理 修改采购订单的退料数量


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


                string sql = $@"update t1 set 


 t1.HMrbQty = t2.FMRBQTY


 from Cg_POOrderBillSub t1 


 join {kdTbaleName}..T_PUR_POORDERENTRY_R t2 


 on t1.HEntryID = t2.FENTRYID


 where t1.HInterID = {sMsg} ";//sMsg 采购订单hinterid


                oCn.RunProc(sql);


                DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill();


                string sql = string.Format(@"select * from h_v_Cg_POOrderBillSub_ForWeb2 where HInterID = " + sMsg);


                ds = oCn.RunProcReturn(sql, "h_v_Cg_POOrderBillSub_ForWeb2");


                sql = string.Format(@"select * from h_v_Cg_POOrderBillSub_ForWeb2 where HInterID = " + sMsg);


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


                //ds = oClsWeb_BarCodeBill.ShowBillSub(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);


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


                {


@@ -1518,8 +1526,8 @@


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


            string msg1 = _value.ToString();


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


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


            string msg3 = sArray[1].ToString();


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


            string msg3 = sArray[1].ToString();// 


            string UserName = "";


            ListModels oListModels = new ListModels();


            try


@@ -1539,6 +1547,7 @@


                List<Model.ClsGy_MaterialList_WMS_Model> ls = new List<Model.ClsGy_MaterialList_WMS_Model>();


                List<Model.ClsGy_BarCodeBill_WMS_Model> ls2 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();//外箱model


                List<Model.ClsGy_BarCodeBill_WMS_Model> ls3 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();//内箱model




                ls = oListModels.getObjectByJson_MaterialList(msg3);//列表数据model




                long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);


@@ -1559,6 +1568,7 @@


                string WeiShu = ""; //尾数


                DataSet Ds;


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


                oCn.BeginTran();


                Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");


                LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);


                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


@@ -1567,15 +1577,35 @@


                    if (oItemSub.HQty == 0 || oItemSub.HMinQty == 0 || oItemSub.HWXQty == 0)


                        continue;


                    //检验打印数量（HQTY）和未打印数量


                    string sql = $"select HQty -HBarcodeCount as HNotBarcodeCount ,* from Cg_POOrderBillSub where HEntryID = {oItemSub.HSourceEntryID}";


                    string sql = $"select HQty + isnull(HMrbQty,0) - HBarcodeCount as HNotBarcodeCount ,* from Cg_POOrderBillSub where HEntryID = {oItemSub.HSourceEntryID}";


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


                    if (ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0][0]) < oItemSub.HQty)




                    if (ds.Tables[0].Rows.Count > 0 && Convert.ToDouble(ds.Tables[0].Rows[0][0]) < oItemSub.HQty)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = $"物料编码{oItemSub.HMaterNumber}，本次生成条码数量不能超出未生成条码数量";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //校验批号 和 生产日期


                    sql = $"select top 1 HKFDate from Gy_BarCodeBill where HSupID = '{oItemSub.HSupID}' and HBatchNo = '{oItemSub.HBatchNo.TrimStart().TrimEnd()}' and HMaterID ={oItemSub.HMaterID} and isnull(HKFDate, '') <> ''";


                    LogService.Write($"sql:{sql}");


                    DataTable dt = oCn.RunProcReturn(sql, "tables").Tables[0];


                    if (dt.Rows.Count > 0)


                    {


                        LogService.Write($"HKFDate:{dt.Rows[0][0]}");


                        sql = $"select DATEDIFF(D,{dt.Rows[0][0]},{oItemSub.HKFDate})";


                        ds = oCn.RunProcReturn(sql, "tables2");


                        LogService.Write($"DATEDIFF:{Convert.ToInt32(ds.Tables[0].Rows[0][0])}");


                        if (ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0][0]) != 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = $"物料编码{oItemSub.HMaterNumber}，批号{oItemSub.HBatchNo.TrimStart().TrimEnd()},生产日期为{dt.Rows[0][0]},请核对";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    if (ClsPub.isLong(oItemSub.HMaterID) != 0)


                    {


@@ -1611,8 +1641,34 @@


                            }




                            //安瑞条码规则：物料编码（系统代入）@物料名称（系统代入）@规格型号（系统代入）@生产日期（手工输入）@数量（手工输入）@失效日期（手工输入）@批次号（手工代入）@供应商名称（系统代入）@采购订单号（系统代入）


                            TM = $"{oItemSub.HMaterNumber}@{oItemSub.HMaterName}@{oItemSub.HMaterModel}@{oItemSub.HKFDate}@{HMinQty}@{oItemSub.HKFDQDate}@{oItemSub.HBatchNo}@{oItemSub.HSupName}@{oItemSub.HSourceBillNo}";


                            TM = $"{oItemSub.HMaterNumber}@{oItemSub.HMaterName}@{oItemSub.HMaterModel}@{oItemSub.HKFDate}@{HMinQty}@{oItemSub.HKFDQDate}@{oItemSub.HBatchNo.TrimStart().TrimEnd()}@{oItemSub.HSupName}@{oItemSub.HSourceBillNo}";


                            Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();




                            var HBarCode_verify = TM.Split('@'); //校验条码信息


                            var HMaterNumber_verify = HBarCode_verify[0]; //校验物料编码


                            var HMaterName_verify = HBarCode_verify[1]; //校验物料名称


                            var HMaterModel_verify = HBarCode_verify[2]; //校验规格型号


                            var HSupName_verify = HBarCode_verify[7]; //校验供应商


                            var HSourceBillNo_verify = HBarCode_verify[8]; //校验采购订单号




                            sql = $"select * from Gy_Material where HNumber = '{HMaterNumber_verify}' and HName = '{HMaterName_verify}'";


                            DataSet verifyMatInfo = oCn.RunProcReturn(sql, "tables");




                            sql = $"select * from Cg_POOrderBillMain where HBillNo = '{HSourceBillNo_verify}'";


                            DataSet verifyBillInfo = oCn.RunProcReturn(sql, "tables");




                            sql = $"select * from Gy_Supplier where HName = '{HSupName_verify}'";


                            DataSet verifySupInfo = oCn.RunProcReturn(sql, "tables");




                            if (verifyMatInfo.Tables[0].Rows.Count <= 0 || verifyBillInfo.Tables[0].Rows.Count <= 0 || verifySupInfo.Tables[0].Rows.Count <= 0)


                            {


                                oCn.RollBack();


                                objJsonResult.code = "0";


                                objJsonResult.count = 0;


                                objJsonResult.Message = $"条码信息校验出错，请重新生成条码";


                                objJsonResult.data = null;


                                return objJsonResult;


                            }




                            bar.HBarCode = TM;


                            bar.HMaterID = oItemSub.HMaterID;


@@ -1640,6 +1696,7 @@


                        }


                    }


                }


                oCn.Commit();


                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2)


                {


                    if (ClsPub.isLong(oItemSub2.HMaterID) != 0)


@@ -1782,7 +1839,6 @@


                                        + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate


                                        + "','" + HBatchNo + "','" + SubModel.Count + "','" + count + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"


                                        + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";


                            LogService.Write(sql);


                            oCn.RunProc(sql);


                            oCn.RunProc("exec setLSH '" + DateTime.Today + "'");


                            count++;


@@ -1827,7 +1883,6 @@


                                      + linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate


                                      + "','" + HBatchNo + "','" + SubModel.Count + "','" + _count + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"


                                      + "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";


                            LogService.Write(sql);


                            oCn.RunProc(sql);


                            _count++;


                        }


@@ -1983,12 +2038,19 @@


        }




        [Route("DeltetBarCodeBill")]


        [HttpGet]


        public object DeltetBarCodeBill(string HInterID, string HUserName)


        [HttpPost]


        public object DeltetBarCodeBill([FromBody] JObject oData)


        {


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


            try


            {


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


                string msg1 = _value.ToString();


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


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


                string HInterID = HInter.Replace("\"", "");


                string HUserName = sArray[1].ToString();




                string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);


                string sql = "select HItemID,HBarCode,HSourceInterID,HSourceEntryID,HQty,HBarCodeType,HSourceBillType from Gy_BarCodeBill where  HItemID in(" + HInterID + ") ";


                //LogService.Write("删除sql:" + sql);