根据所输源单号模糊查询源单信息，新增返回源单列表信息方法

yxj

2021-06-22 81445580560cb34bd087e8d948abac16d1555be9

根据所输源单号模糊查询源单信息，新增返回源单列表信息方法

 CLOUDWEB/WebService1.asmx.cs

@@ -4991,6 +4991,21 @@
                    return false;
                }
            }
            else if (sHSourceType == "1243") //调拨申请单
            {
                if (SaveMoveStockBill_MoveStockRequest_CLD(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg))
                {
                    //"保存成功！";
                    sErrMsg = "保存成功！" + oMain.HBillNo;
                    return true;
                }
                else
                {
                    //"保存失败！";
                    sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + sErrMsg;
                    return false;
                }
            }
            //直接调拨
            else if (sHSourceType == "-1")
            {
@@ -9265,6 +9280,20 @@
        [WebMethod]
        public bool set_SaveSellOutBackBill_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
        {
            ////上传前判断是否存在相同条码
            //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            //DataSet ds = oCn.RunProcReturn("exec h_p_WMS_UpLoadControl " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HBillType + "'", "h_p_WMS_UpLoadControl");
            //if (ds == null || ds.Tables[0].Rows.Count == 0)
            //{
            //}
            //else
            //{
            //    if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 1)
            //    {
            //        sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
            //        return false;
            //    }
            //}
            if (sHSourceType == "1403")   //退货通知单
            {
                if (SaveSellOutBackBill_SeOutStockBack_CLD_New(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg))
@@ -30633,6 +30662,44 @@
        #endregion


        #region 返回源单信息

        //根据所输源单号模糊查询源单信息，并返回数据
        [WebMethod]
        public DataSet GetSourceBillList(Int64 HInterID, string HBillNo, string HBillType, string HSourceBillNo, string HSourceBillType, Int64 HOWNERID, ref string sErrMsg)
        {
            try
            {
                DataSet ds;
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ds = oCN.RunProcReturn("exec h_p_WMS_SourceBillList " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + HSourceBillNo + "','" + HSourceBillType + "'," + HOWNERID, "h_p_WMS_SourceBillList");
                if (ds == null && ds.Tables[0].Rows.Count == 0)
                {
                    sErrMsg = "返回源单列表信息失败，未知错误！";
                    return null;
                }
                else
                {
                    if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 0)
                    {
                        return ds;
                    }
                    else
                    {
                        sErrMsg = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]);
                        return null;
                    }
                }
            }
            catch (Exception e)
            {
                sErrMsg = "返回源单列表信息失败！" + e.Message;
                return null;
            }
        }

        #endregion


        #region  桌面条码生成外网版