1

llj

2025-12-08 41c83fa0c0d53e90540c190fe8eacf3177e780f6

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

@@ -560,12 +560,17 @@

                if(HSourceBillType == "收料通知单")
                {
                    if (oSystemParameter.omodel.WMS_CampanyName != "瑞与祺")
                    if (oSystemParameter.omodel.WMS_CampanyName.Contains("四维尔"))
                    {

                    }
                    else if (oSystemParameter.omodel.WMS_CampanyName != "瑞与祺")
                    {
                        ordrlist.HFurnaceNO = dt.Rows[i]["炉号"].ToString();
                        ordrlist.HCoilNO = dt.Rows[i]["钢卷捆包号"].ToString();
                        ordrlist.HheatNO = dt.Rows[i]["热处理"].ToString();
                    }
                    
                }

                if (HBarCodeType == "仪器外购件条码容器规则")
@@ -776,9 +781,9 @@
                string CampanyName = sArray[4].ToString()=="xxx"?"": sArray[4].ToString();
                string UserName = sArray[5].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))
@@ -2658,7 +2663,7 @@
                    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" +
                  "HPinfan, HAuxPropID, HMTONo, HInnerBillNo, HCoilNO, HFurnaceNO, HFactory, HAuxQty, HheatNO, HProduceDate, HExpiryDate, HEmpID, HCusModel, HCusMaterName, HCheckEmpName, HZZRQ,HSupMaterNumber,HSupBatchNo" +
                  ") values (" +
                  "'" + ds.Tables[0].Rows[0]["HInterID"].ToString() + "', " +
                  "'" + (int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1).ToString() + "', " +
@@ -2711,7 +2716,9 @@
                  "'" + 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() + "'" +
                  "'" + ds.Tables[0].Rows[0]["HZZRQ"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSupBatchNo"].ToString() + "', " +
                  "'" + ds.Tables[0].Rows[0]["HSupMaterNumber"].ToString() + "'" +
                  ")";
                    //插入拆分条码
                    oCN.RunProc(sql);
@@ -2750,6 +2757,60 @@
        }
        #endregion

        #region [app æ¡ç æ‹†ç èŽ·å–拆码打印数据]
        [Route("Sc_BarCode/GetSplitBarCode_SubList")]
        [HttpGet]
        public object GetSplitBarCode_SubList(string HBarCodeNo)
        {
            try
            {
                if (string.IsNullOrWhiteSpace(HBarCodeNo))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "请输入条码编号";
                    objJsonResult.data = null;
                    return objJsonResult;
                }                

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


                var sql = "select * from h_v_Gy_BarCodeBillList_APP where æ¡ç ç¼–号='"+ HBarCodeNo + "'";

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

                //判断条码是否存在条码档案
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "[0000-1-037]查询成功";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "[0000-1-010]没有返回任何记录！当前条码不存在条码档案";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                return objJsonResult;
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "异常：" + ex.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region [条码生成接口_小卫镭雕码]
        [Route("Sc_BarCode/SaveSNByICMO_XW")]
        [HttpGet]