修改条码转存规则

chenhaozhe

4 天以前 519315a21c6290455e4ea2b9a04d6bc51568a862

 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs

@@ -6,9 +6,11 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using WebAPI.Models;

@@ -525,6 +527,8 @@
            }
            return ordrlist;
        }

       

        public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType,string HSourceBillType)
        {
@@ -1647,7 +1651,10 @@
                        ",@HFactory = N'" + HFactory + "'" +
                        ",@HCoilNO = N'" + HCoilNO + "'" +
                        ",@HFurnaceNO = N'" + HFurnaceNO + "'" +
                        ",@HInnerBillNo = N'" + ordrlist[0].HInnerBillNo + "'"
                        ",@HInnerBillNo = N'" + ordrlist[0].HInnerBillNo + "'" + 
                        ",@HSourceBillType = N'" + ordrlist[0].HBillType + "'" + 
                        ",@HStockOrg = N'" + HOrgType + "'" + 
                        ",@HInterID = N'" + ordrlist[0].HInterID + "'"
                        , "h_p_SC_BarCode_Transfer");
                    if((bool)ds1.Tables[0].Rows[0]["returntype"] == true)
                    {
@@ -1670,6 +1677,221 @@
                return objJsonResult;
            }
            return objJsonResult;
        }
        #endregion

        #region æ¡ç è½¬å­˜æ¡ç ä¸»æ¡£(批量)
        /// <summary>
        /// æ¡ç è½¬å­˜æ¡ç ä¸»æ¡£(批量)
        /// </summary>
        /// <param name="msg"></param>
        /// <returns></returns>
        [Route("Sc_BarCode/SaveBarCode_NoGenerate_Batch")]
        [HttpPost]
        public object SaveBarCode_NoGenerate_Batch([FromBody] JObject msg)
        {
            try
            {
                var _value = msg["msg"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.None);
                string msg2 = sArray[0].ToString();
                string HOrgType = sArray[1].ToString();
                string HSourceBillTypeName = sArray[2].ToString();
                string HSelectBarCodeType = sArray[3].ToString();
                string CampanyName = sArray[4].ToString() == "xxx" ? "" : sArray[4].ToString();
                string UserName = sArray[5].ToString();
                string barCodeNoStrs = sArray[6].ToString(); // è¿™é‡Œçš„条码是与提交的单据序列对应的条码数组
                string HFactory = sArray[7].ToString();
                string HCoilNO = sArray[8].ToString();
                string HFurnaceNO = sArray[9].ToString();
                ClsPub.CurUserName = UserName;

                //获取内码
                HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
                DAL.ClsGy_ORGANIZATIONS_View oClsGy_ORGANIZATIONS_View = new DAL.ClsGy_ORGANIZATIONS_View();
                HOrgNumber = "";
                if (oClsGy_ORGANIZATIONS_View.GetInfoByName(HOrgType))
                {
                    HOrgID = oClsGy_ORGANIZATIONS_View.omodel.HItemID;
                    HOrgNumber = DBUtility.ClsPub.isStrNull(oClsGy_ORGANIZATIONS_View.omodel.HNumber);
                }
                if (HOrgID == -1)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "[0000-2-055]选择组织有错误!";
                    return objJsonResult;
                }
                if (!Sub_AllowSave(msg2, HSelectBarCodeType))//单据完整性判断
                {
                    return objJsonResult;
                }
                if (HSelectBarCodeType == "仪器成品条码规则")
                {
                    //客户定制
                }
                else
                {
                    string HBarCodeType = ClsPub.isStrNull(HSelectBarCodeType);
                    // æ¡ç è½¬å­˜
                    msg2 = msg2.Replace("\\", "");
                    msg2 = msg2.Replace("\n", "");  //\n
                    List<HSouceOrderList> ordrlist = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HSouceOrderList>>(msg2);
                    List<string> barcodeList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<string>>(barCodeNoStrs);
                    // TODO é€šè¿‡InterID å’Œ EntryID ä»Žæ¡ç æ¡£æ¡ˆä¸­æŸ¥è¯¢æ˜¯å¦æœ‰å·²ç”Ÿæˆçš„单据 é‡æ–°å†™ä¸€ä¸ªå­˜å‚¨è¿‡ç¨‹ï¼Œå½“已存在对应的条码单据时，返回条码主档中的条码档案
                    DataSet dsCache = oCN.RunProcReturn($@"select * from h_v_IF_BarCodeBillList a 
                                                    Inner Join Gy_BarCodeBill b on a.HItemID = b.HItemID
                                                    where b.HSourceINterID = { ordrlist[0].HMainID } and b.HSourceEntryID = {ordrlist[0].HSubID}"
                                                        , "h_v_IF_BarCodeBillList");
                    if(dsCache.Tables[0].Rows.Count > 0)
                    {
                        objJsonResult.code = "2";
                        objJsonResult.count = 1;
                        objJsonResult.data = dsCache.Tables[0];
                        objJsonResult.Message = "条码已存在!";
                        return objJsonResult;
                    }
                    DataSet ds1 = new DataSet();
                    for(int i=0; i<ordrlist.Count; i++)
                    {

                        long HSourceInterID = string.IsNullOrEmpty(ordrlist[i].HMainID) == true ? 0 : ClsPub.isLong(ordrlist[0].HMainID);
                        long HSourceEntryID = string.IsNullOrEmpty(ordrlist[i].HSubID) == true ? 0 : ClsPub.isLong(ordrlist[0].HSubID);

                        ds1 = oCN.RunProcReturn("exec h_p_SC_BarCode_Transfer " +
                        "@HBarCodeNo = N'" + barcodeList[i] + "'" +
                        ",@HSubID = " + ordrlist[i].HSubID +
                        ",@HMaterID = " + ordrlist[i].HMaterID +
                        ",@HGiveAwayFlag = " + ordrlist[i].HGiveAwayFlag +
                        ",@HQty = " + ordrlist[i].HQty +
                        ",@HUnitID = " + ordrlist[i].HUnitID +
                        ",@HMinQty = " + ordrlist[i].HMinQty +
                        ",@HSupID = " + ordrlist[i].HSupID +
                        ",@HBatchNo = N'" + ordrlist[i].HBatchNo + "'" +
                        ",@HMTONO = N'" + ordrlist[i].HMTONo + "'" +
                        ",@HBarCodeDate = N'" + ordrlist[i].HDate + "'" +
                        ",@HEmpID = " + ordrlist[i].HEmpID +
                        ",@HSourceInterID = " + HSourceInterID +
                        ",@HSourceEntryID = " + HSourceEntryID +
                        ",@HBarCodeType = N'" + HBarCodeType + "'" +
                        ",@HSourceBillNo = N'" + ordrlist[i].HSourceBillNo + "'" +
                        ",@HMaker = N'" + ordrlist[i].HMaker + "'" +
                        ",@HFactory = N'" + HFactory + "'" +
                        ",@HCoilNO = N'" + HCoilNO + "'" +
                        ",@HFurnaceNO = N'" + HFurnaceNO + "'" +
                        ",@HInnerBillNo = N'" + ordrlist[i].HInnerBillNo + "'" +
                        ",@HSourceBillType = N'" + ordrlist[i].HBillType + "'" +
                        ",@HStockOrg = N'" + HOrgType + "'" + 
                        ",@HInterID = " + ordrlist[i].HInterID
                        , "h_p_SC_BarCode_Transfer");
                        if ((bool)ds1.Tables[0].Rows[0]["returntype"] == false)
                        {
                            throw new Exception(ds1.Tables[0].Rows[0]["mesg"].ToString());     
                        }
                    }

                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = ds1.Tables[0].Rows[0]["mesg"].ToString();
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "[3899-2-006]条码生成失败!" + e.Message;
                return objJsonResult;
            }
            return objJsonResult;
        }
        #endregion

        #region [获取标签打印指令 CPCL指令]
        [Route("Sc_BarCode/Get_BarCodePrintCode_CPCL")]
        [HttpGet]
        public object Get_BarCodePrintCode_CPCL(string HOrginationName, int HBillInterID, int HBillEntryID, string HViewName, string HBillSubType, int HInterID)
        {
            try
            {
                ds = oCN.RunProcReturn("exec h_p_getHBarCodePrintCode_CPCL N'" + HOrginationName + "'" +
                    "," + HBillInterID + "," + HBillEntryID + ",N'" + HViewName + "',N'" + HBillSubType + "'," + HInterID, "h_p_getHBarCodePrintCode_CPCL");
                if((int)ds.Tables[0].Rows[0]["resultType"] == 1)
                {
                    string resultMesg = ds.Tables[0].Rows[0]["payload"].ToString().Replace("\\r\\n", "\r\n");
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = resultMesg;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "打印指令获取失败!" + ds.Tables[0].Rows[0]["payload"];
                    return objJsonResult;
                }
            }
            catch(Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "打印指令获取失败!" + e.Message;
                return objJsonResult;
            }
        }
        #endregion

        #region [APP èŽ·å–打印模板]
        public class PrintTemplate
        {
            public int Id { get; }
            public string OrgShort { get; }
            public string HBillSubtype { get; }
            public string Format { get; }
            public string Description { get; }
            public string[] Placeholder { get; }
        }

        [Route("Sc_BarCode/Get_BarCodeGenTemplate")]
        [HttpGet]
        public object Get_BarCodeGenTemplate(string HOrginationName, string HBillSubType)
        {
            try
            {

                string filePath = HttpContext.Current.Server.MapPath("~/Template");
                string fileFullPath = Path.Combine(filePath, "barCodeTemplateStorage.json");

                if (!File.Exists(fileFullPath))
                {

                    throw new Exception($"模板文件不存在：{fileFullPath}");
                }

                string jsonContent = File.ReadAllText(fileFullPath);
                var templates = JsonConvert.DeserializeObject<PrintTemplate[]>(jsonContent);

                var targetTemplate = templates.FirstOrDefault<PrintTemplate>(t => HOrginationName.Contains(t.OrgShort) && string.Equals(t.HBillSubtype, HBillSubType));
                if (targetTemplate != null)
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.data = JsonConvert.SerializeObject(targetTemplate);
                    return objJsonResult;
                }
                else
                {
                    throw new Exception($"没有找到对应的模板");
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "打印模板获取失败!" + e.Message;
                return objJsonResult;
            }
        }
        #endregion

@@ -2175,6 +2397,9 @@
                //增加 æ¡ç è¶…过未生成功能控制

                //
                //自动装箱
                string sql_autoForBoxBill = "exec h_v_Gy_BarCode_AutoProductBarCodeBox " + HInterID.ToString();
                oCN.RunProc(sql_autoForBoxBill);

                oCN.Commit();
                List<Object> listobj = ListRows.ConvertAll(s => (object)s);//List实体类转换为object
@@ -2211,6 +2436,204 @@
            }
        }
        #endregion

        #region [app æ¡ç æ‹†ç èŽ·å–子条码]
        [Route("Sc_BarCode/SplitBarCode_Sub")]
        [HttpGet]
        public object SplitBarCode_Sub(string HBarCodeNo)
        {
            try
            {
                SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                //查询条码信息
                if (HBarCodeNo != null)
                {
                    string prefix = HBarCodeNo.Trim() + "-";

                    ds = oCn.RunProcReturn("SELECT * FROM h_v_Gy_SplitBarCode WITH(NOLOCK) WHERE HBarCode LIKE '" + prefix + "' + '%' AND HBarCode NOT LIKE  '" + prefix + "'  + '%-%' AND ISNUMERIC(RIGHT(HBarCode, LEN(HBarCode) - LEN( '" + prefix + "' ))) = 1  AND TRY_CAST(RIGHT(HBarCode, LEN(HBarCode) - LEN( '" + prefix + "' )) AS INT) IS NOT NULL ", "Gy_BarCodeBill");
                    if (ds != null || ds.Tables[0].Rows.Count >= 0) 
                    {
                        // æ‰¾å‡ºæœ€å¤§åŽç¼€æ•°å­—，用于生成下一个编号
                        int maxSuffix = 0;
                        foreach (DataRow row in ds.Tables[0].Rows)
                        {
                            string barCode = row["HBarCode"].ToString();
                            string suffixPart = barCode.Substring(prefix.Length); // å– - åŽçš„部分
                            if (int.TryParse(suffixPart, out int num))
                            {
                                if (num > maxSuffix) maxSuffix = num;
                            }
                        }

                        // ç”Ÿæˆä¸‹ä¸€ä¸ªå­ç ç¼–号
                        string nextBarCode = $"{HBarCodeNo}-{maxSuffix + 1}";

                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "Sucess！";
                        objJsonResult.data = new
                        {
                            SubBarCodes = ds.Tables[0],        // æ¡ç åŸºç¡€ä¿¡æ¯
                            NextBarCode = nextBarCode          // ä¸‹ä¸€ä¸ªç”Ÿæˆçš„条码
                        };
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "条码编号不存在, æç¤º";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }                                       
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "请输入条码编号或拆分条码数";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
               
            }
            catch (Exception e) //抛出异常
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region [app条码拆码生成]
        [Route("Sc_BarCode/SplitBarCode_Save")]
        [HttpPost]
        public object SplitBarCode_Save([FromBody] JObject msg)
        {
            try
            {
                ListModels oListModels = new ListModels();
                DAL.ClsGy_BarCodeBill_ChaiMa BillNew = new DAL.ClsGy_BarCodeBill_ChaiMa();
                var _value = msg["msg"].ToString();
                string msg1 = _value.ToString();

                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string barcode = sArray[0].ToString(); //条码编号
                Double splitnum = Convert.ToDouble(sArray[1]); //拆码数量
                string data = sArray[2].ToString(); //表体数据
                string user = sArray[3].ToString(); //用户名

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

                List<Model.ClsGy_BarCodeEdit_Model> lsmain = new List<Model.ClsGy_BarCodeEdit_Model>();
                lsmain = oListModels.getObjectByJson_Gy_SplitBarCode(data);

                oCN.BeginTran();

                ds = oCN.RunProcReturn("select top 1 * from Gy_BarCodeBill where HBarCode='" + barcode + "'", "Gy_BarCodeBill");
              
                if (ds != null || ds.Tables[0].Rows.Count > 0)
                {

                    string sql = "insert into Gy_BarCodeBill (HInterID, HEntryID, HBarCode, HBarCodeType, HBarCodeSubType, HMaterID, HUnitID, HQty, HBatchNo, HSupID, HGroupID, HMaker, HMakeDate, " +
                  "HPrintQty, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HinitQty, HEndQty, HBarcodeQtys, HBarcodeNo, HDeptID, HWhID, HSPID, HRemark, " +
                  "HCusID, HCusType, HEndDate, HWorkLineName, HBarCodeDate, HSTOCKORGID, HOWNERID, HSeOrderBillNo, HGiveAwayFlag, HMaterName, HMaterModel, " +
                  "HPinfan, HAuxPropID, HMTONo, HInnerBillNo, HCoilNO, HFurnaceNO, HFactory, HAuxQty, HheatNO, HProduceDate, HExpiryDate, HEmpID, HCusModel, HCusMaterName, HCheckEmpName, HZZRQ" +
                  ") values (" +
                  "'" + ds.Tables[0].Rows[0]["HInterID"].ToString() + "', " +
                  "'" + (int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1).ToString() + "', " +
                  "'" + lsmain[0].HBarCode.ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBarCodeType"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBarCodeSubType"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HMaterID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HUnitID"].ToString() + "', " +
                  "'" + splitnum + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBatchNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSupID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HGroupID"].ToString() + "', " +
                  "'" + user + "', getdate(), " +
                  "'" + ds.Tables[0].Rows[0]["HPrintQty"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSourceInterID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSourceEntryID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSourceBillNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSourceBillType"].ToString() + "', " +
                  "'" + splitnum + "', " +
                  "'" + ds.Tables[0].Rows[0]["HEndQty"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBarcodeQtys"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBarcodeNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HDeptID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HWhID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSPID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HRemark"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCusID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCusType"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HEndDate"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HWorkLineName"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HBarCodeDate"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSTOCKORGID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HOWNERID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSeOrderBillNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HGiveAwayFlag"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HMaterName"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HMaterModel"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HPinfan"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HAuxPropID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HMTONo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HInnerBillNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCoilNO"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HFurnaceNO"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HFactory"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HAuxQty"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HheatNO"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HProduceDate"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HExpiryDate"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HEmpID"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCusModel"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCusMaterName"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HCheckEmpName"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HZZRQ"].ToString() + "'" +
                  ")";
                    //插入拆分条码
                    oCN.RunProc(sql);
                    //更新老条码的HQty数量
                    oCN.RunProc("update  Gy_BarCodeBill set HQty= HQty-'"+splitnum+"' where HItemID="+ ds.Tables[0].Rows[0]["HItemID"].ToString());



                    oCN.Commit();
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功！";
                    objJsonResult.data = 1;
                    return objJsonResult;

                }
                else
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！未查询到条码信息";
                    objJsonResult.data = 1;
                    return objJsonResult;
                }               
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #endregion
    }
}