新增盘点方案基础资料获取调用方法；新增模治具盘点单模块，扫描模治具条码调用方法

yxj

2021-12-24 5c25ab3f079245bd936e27b2628629dadd7efe29

新增盘点方案基础资料获取调用方法；新增模治具盘点单模块，扫描模治具条码调用方法

 CLOUDWEB/WebService1.asmx.cs

@@ -135,6 +135,24 @@
            return dal.GetList(sWhere);
        }

        //返回盘点方案列表  同步资料
        [WebMethod]
        public DataSet GetStockCheckItemList(string sWhere, ref string sErr)
        {
            DataSet ds;
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            ds = oCN.RunProcReturn("select HItemID,HNumber,HName from Gy_StockCheckItem"+ sWhere, "Gy_StockCheckItem");
            if (ds == null && ds.Tables[0].Rows.Count == 0)
            {
                sErr = "没有返回任何数据！";
                return null;
            }
            else
            {
                return ds;
            }
        }

        //根据代码返回生产资源信息
        [WebMethod]
        public Model.ClsGy_Source_Model GetSourceInfoByNumber(string sWhere, ref string sErr)
@@ -33682,6 +33700,34 @@

        #endregion

        #region 盘点单模块    扫描模治具条码
        [WebMethod]
        //扫描模治具条码存入模治具条码临时表，盘点单专用
        public bool Get_CheckTypeByMouldBarCode_ProdCheckStock(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, Int64 HWhID, Int64 HSPID, Int64 HStockCheckItemID, string HStockCheckNumber, Int64 HCorrespondentTypeID, Int64 HCorrespondentID, string HMaker, Int64 HOWNERID, ref string sErrMsg)
        {
            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
            DataSet ds = oCN.RunProcReturn("exec h_p_WMS_AddMouldBarCode_ProdCheckStock '" + sBarCode + "'," + HBillID.ToString() + ",'" + HBillNo + "','" + HBillType + "'," + HWhID.ToString() + "," + HSPID.ToString() + "," + HStockCheckItemID.ToString() + ",'" + HStockCheckNumber + "'," + HCorrespondentTypeID.ToString() + "," + HCorrespondentID.ToString() + ",'" + HMaker + "'," + HOWNERID.ToString(), "h_p_WMS_AddMouldBarCode_ProdCheckStock");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
            {
                sErrMsg = "将模治具信息写入模治具出入库临时表失败！";
                return false;
            }
            else
            {
                if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 0)
                {
                    return true;
                }
                else
                {
                    sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
                    return false;
                }
            }
        }

        #endregion

        //显示模治具列表信息
        [WebMethod]
        public DataSet GetMouldBillEntry_TmpList(long HInterID, string HBillNo, string HBillType, ref string sErrMsg)