智云SRM-WEBAPI（目前客户通用API）
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
1
王 垚
2023-01-04 0c5df3ecaf922d07a02960791c0ab1dd3bb16f5e 
 WebAPI/Controllers/BarCodeController.cs


@@ -21,7 +21,8 @@


        private JsonResult objJsonResult = new JsonResult();


        private json objjson = new json();


        public new ClsCNSRM oCn = new ClsCNSRM();




        //获取系统参数


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


        public T ScriptDeserialize<T>(string strJson)


        {


            JavaScriptSerializer js = new JavaScriptSerializer();


@@ -494,6 +495,7 @@


        /// <returns></returns>


        public object GetBarcodeSaveBill_Box([FromBody] JObject msg)


        {


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


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


            string msg1 = _value.ToString();


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


@@ -525,33 +527,9 @@




                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    //if (oBill.CheckBarCode(oItemSub.HSourceInterID, oItemSub.HSourceEntryID) == false)


                    //{


                    //    objJsonResult.code = "0";


                    //    objJsonResult.count = 0;


                    //    objJsonResult.Message = "已存在条码，不允许重复生成！";


                    //    objJsonResult.data = null;


                    //    return objJsonResult;


                    //}


                    if (msg2 != string.Empty)


                    {


                        if (oItemSub.HBQty == 0 || oItemSub.HMinQty == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "内箱包装数不能为0！";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                        if (oItemSub.HWBQty == 0 || oItemSub.HWXQty == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "外箱包装数不能为0！";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }


                    }


                    //数量为0 跳过


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


                        continue;


                }


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


                int LSHlen = 6;             //流水号长度


@@ -733,6 +711,7 @@


                        }


                    }


                }


                


                string HBarCode = "";


                string HBarCodeType = "";


                Int64 HMaterID = 0;


@@ -752,6 +731,11 @@


                string HWei = "";


                string HMTONO = "";


                oCn.BeginTran();


                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    //更新条码档案 该源单其它条码默认已经打印过一次


                    oCn.RunProc($"update Gy_BarCodeBill set  HPrintQty += 1   where HPrintQty = 0 and  HSourceInterID={oItemSub.HSourceInterID} and HSourceEntryID = {oItemSub.HSourceEntryID}");


                }


                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)


                {


                    //LogService.Write("循环第二次:" + oItemSub.HSupID);


@@ -774,6 +758,11 @@


                        HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);


                        HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);


                        HWei = ClsPub.isStrNull(oItemSub.HEndQty);


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


                        {


                            HBarCode = $"{oItemSub.HMaterID}";


                            HBarCodeType = "品种码_外箱";


                        }


                        string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +


                                    ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +


                                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +


@@ -809,6 +798,11 @@


                        HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);


                        HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);


                        HWei = ClsPub.isStrNull(oItemSub.HEndQty);


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


                        {


                            HBarCode = $"{oItemSub.HMaterID}";


                            HBarCodeType = "品种码";


                        }


                        string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +


                                    ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +


                                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +


@@ -873,6 +867,7 @@


        /// <returns></returns>


        public object GetBarcodeSaveBillOnlyInnerBox([FromBody] JObject msg)


        {


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


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


            string msg1 = _value.ToString();


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


@@ -900,30 +895,6 @@


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


                ls = oListModels.getObjectByJson_MaterialList(msg3);




                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    if (CheckBarCode(oItemSub.HSourceInterID, oItemSub.HSourceEntryID) == false)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "已存在条码，不允许重复生成！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    if (msg2 != string.Empty)


                    {


                        if (oItemSub.HBQty == 0 || oItemSub.HMinQty == 0)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


                            objJsonResult.Message = "内箱包装数不能为0！";


                            objJsonResult.data = null;


                            return objJsonResult;


                        }




                    }


                }


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


                int LSHlen = 6;             //流水号长度


                int SumLen = 10;            //总长度


@@ -940,6 +911,20 @@


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


                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    //数量为0 跳过


                    if (oItemSub.HQty == 0)


                        continue;


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


                    string sql = $"select HQty -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)


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


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


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //内箱


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


                    {


@@ -999,6 +984,11 @@


                oCn.BeginTran();


                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)


                {


                    //更新条码档案 该源单其它条码默认已经打印过一次


                    oCn.RunProc($"update Gy_BarCodeBill set  HPrintQty += 1   where HPrintQty = 0 and  HSourceInterID={oItemSub.HSourceInterID} and HSourceEntryID = {oItemSub.HSourceEntryID}");


                }


                foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)


                {


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


                    {


                        HBarCode = oItemSub.HBarCode.ToString();


@@ -1031,8 +1021,27 @@


                    }


                }


                //暂时只回填关联数量


                string _sql = "exec H_p_SRM_BarCodeBill_Update_UpdateBillRelateData " + linterid.ToString();


                oCn.RunProc(_sql);


                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    if (oItemSub.HQty == 0)


                        continue;


                    //更新条码档案 该源单其它条码默认已经打印过一次


                    //更新 已打印数量


                    if (oItemSub.HSourceBillType == "1102")


                    {


                        string _HBarCodeType = "箱号条码";


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


                            _HBarCodeType = "品种码";


                        string sql = string.Empty;


                        sql = string.Format(@"


update t1 set  


t1.HBarcodeCount = 


isnull((select sum(HQty)from Gy_BarCodeBill where HSourceInterID = t1.HInterID and HSourceEntryID = t1.HEntryID and HBarCodeType ='{2}'),0)


from Cg_POOrderBillSub t1 


where t1.HInterID = {0} and t1.HEntryID ={1}", oItemSub.HSourceInterID, oItemSub.HSourceEntryID, _HBarCodeType);


                        oCn.RunProc(sql);


                    }


                }


                oCn.Commit();


            }


            catch (Exception e)


@@ -1505,6 +1514,7 @@


        /// <returns></returns>


        public object GetBarcodeSaveBillBoxBycg([FromBody] JObject msg)


        {


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


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


            string msg1 = _value.ToString();


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


@@ -1527,9 +1537,9 @@


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


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


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


                List<Model.ClsGy_BarCodeBill_WMS_Model> ls3 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();


                ls = oListModels.getObjectByJson_MaterialList(msg3);


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


                int LSHlen = 6;             //流水号长度


@@ -1554,12 +1564,12 @@


                foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)


                {


                    //数量为0 跳过


                    if (oItemSub.HQty == 0)


                    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}";


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


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


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


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


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


@@ -1569,6 +1579,7 @@


                    }


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


                    {




                        HNumber = oItemSub.HMaterID.ToString();


                        //HNumber = HNumber.Replace(".", "");


                        //HQty = Math.Ceiling(HBQty + ClsPub.isDoule(oItemSub.HWBQty));


@@ -1599,7 +1610,7 @@


                                HMinQty = HSumQty;


                            }




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


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


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


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




@@ -1741,7 +1752,6 @@


                    int count = 1;


                    foreach (var oItemSub in SubModel)


                    {




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


                        {


                            HBarCode = oItemSub.HBarCode.ToString();


@@ -1760,7 +1770,11 @@


                            HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);


                            HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);


                            HWei = ClsPub.isStrNull(oItemSub.HEndQty);




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


                            {


                                HBarCode = $"{oItemSub.HMaterID}";


                                HBarCodeType = "品种码_外箱";


                            }


                            string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +


                                        ",HBatchNo,HBarcodeQtys,HBarcodeNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +


                                        ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +


@@ -1801,6 +1815,11 @@


                            HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);


                            HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);


                            HWei = ClsPub.isStrNull(oItemSub.HEndQty);


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


                            {


                                HBarCode = $"{oItemSub.HMaterID}";


                                HBarCodeType = "品种码";


                            }


                            string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +


                                      ",HBatchNo,HBarcodeQtys,HBarcodeNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +


                                      ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +


@@ -1823,18 +1842,21 @@


                    //更新 已打印数量


                    if (oItemSub.HSourceBillType == "1102")


                    {


                        string _HBarCodeType = "箱号条码";


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


                            _HBarCodeType = "品种码";


                        string sql = string.Empty;


                        sql = string.Format(@"


update t1 set  


t1.HBarcodeCount = 


isnull((select sum(HQty)from Gy_BarCodeBill where HSourceInterID = t1.HInterID and HSourceEntryID = t1.HEntryID and HBarCodeType ='箱号条码'),0)


isnull((select sum(HQty)from Gy_BarCodeBill where HSourceInterID = t1.HInterID and HSourceEntryID = t1.HEntryID and HBarCodeType ='{2}'),0)


from Cg_POOrderBillSub t1 


where t1.HInterID = {0} and t1.HEntryID ={1}", oItemSub.HSourceInterID, oItemSub.HSourceEntryID);


where t1.HInterID = {0} and t1.HEntryID ={1}", oItemSub.HSourceInterID, oItemSub.HSourceEntryID, _HBarCodeType);


                        oCn.RunProc(sql);


                    }


                }


                oCn.Commit();


               




            }


            catch (Exception e)


            {


@@ -1967,6 +1989,7 @@


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


            try


            {


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


                oCN.BeginTran();


@@ -1975,9 +1998,12 @@


                {


                    foreach (DataRow dr in dt.Rows)


                    {


                        string _HBarCodeType = "箱号条码";


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


                            _HBarCodeType = "品种码";


                        WebAPIController.Add_Log("条码档案删除", HUserName, "单号" + dr["HBarCode"].ToString());


                        //反写打印数量到采购订单子表


                        if (dr["HBarCodeType"].ToString() == "箱号内条码" && dr["HSourceBillType"].ToString() == "1102")


                        if (dr["HBarCodeType"].ToString() == _HBarCodeType && dr["HSourceBillType"].ToString() == "1102")


                            oCN.RunProc($"update Cg_POOrderBillSub set HBarcodeCount -= {dr["HQty"]} where  HInterID ={dr["HSourceInterID"]} and  HEntryID ={dr["HSourceEntryID"]}");


                        //反写打印数量到委外订单


                        if (dr["HBarCodeType"].ToString() == "箱号内条码" && dr["HSourceBillType"].ToString() == "1601")