墙咔装箱2.0

zzr99

2022-03-25 f3e1b2eac8a806b3ae8d5a8854d694204e2468ad

 WebAPI/WebServer.cs

@@ -3841,6 +3841,28 @@
            }
        }

        //根据托条码  获取条码档案列表唯一码信息
        public DataSet GetBarCode(string HBarCode)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            //
            try
            {
                DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
                //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return null;
                else
                {
                    return DS;
                }
            }
            catch (Exception e)
            {
                throw (e);
            }
        }

        public DataSet GetHBW(long HBadType)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();