优化凯贝桌面端批量下推有的字段没有存入值，优化app条码拆码，增加app条码拆码获取打印数据

zrg

2025-12-01 f1c107b1ae5f48f2c18c23568bf902c410b564f5

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

@@ -2658,7 +2658,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 +2711,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 +2752,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]