zgq
2021-02-25 2d41b16e418da7ee8938ef12a5a17f369ae933dd
WebAPI/Controllers/LookingForBillController.cs
@@ -316,17 +316,16 @@
        }
        /// <summary>
        /// 待发区找货根据实物条码 返回相关信息
        /// 待发区找货根据源单号 返回相关信息
        /// </summary>
        /// <returns></returns>
        [Route("LookingFor/getWaitingLookingFor")]
        [HttpGet]
        public object GetWaitingLookingFor(string HBarCode)
        public object GetWaitingLookingFor(string HBillType,string HBillNo,string HSourceBillNo,string HCreateBy,string BenginHCreateDate,string EndHCreateDate)
        {
            try
            {
                string sWhere = " Where 源单号 = '" + HBarCode.Trim() + "'";
                ds = GetWaitingLookingFor_s(sWhere);
                ds = GetWaitingLookingFor_s(HBillType, HBillNo, HSourceBillNo, HCreateBy, BenginHCreateDate, EndHCreateDate);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
@@ -383,9 +382,9 @@
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace");
        }
        public static DataSet GetWaitingLookingFor_s(string sWhere)
        public static DataSet GetWaitingLookingFor_s(string HBillType, string HBillNo, string HSourceBillNo,string HCreateBy,string BenginHCreateDate,string EndHCreateDate)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getWaitingLookingFor " + sWhere, "h_v_getWaitingLookingFor");
            return new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_lookForBillList " + "'" + HBillType + "','" + HBillNo + "','" + HSourceBillNo + "','" + HCreateBy + "','" + HCreateBy + "','" + HCreateBy + "','" + BenginHCreateDate + "','" + EndHCreateDate + "'", "h_p_lookForBillList");
        }
        #endregion