新增找货单列表查询功能

zgq

2021-02-23 5135080c72fb70c98af17d5e27dcf6e9bbfe54e2

 WebAPI/Controllers/LookingForBillController.cs

@@ -93,7 +93,7 @@
        }

        /// <summary>
        /// 根据销售订单 返回此销售订单内的相关信息
        /// 下架找货单根据销售订单 返回此销售订单内的相关信息
        /// </summary>
        /// <returns></returns>
        [Route("LookingFor/getSellOrderList")]
@@ -102,8 +102,7 @@
        {
            try
            {
                string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
                ds = getSellOrderList_s(sWhere);
                ds = getSellOrderList_s(HSourceBillNo);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
@@ -132,7 +131,7 @@
        }

        /// <summary>
        /// 根据实物条码 返回相关信息
        /// 上架归还单根据实物条码 返回相关信息
        /// </summary>
        /// <returns></returns>
        [Route("LookingFor/getBarCodeDetails")]
@@ -329,8 +328,10 @@
            return new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_Kf_getPackUnionBillListDetailed " + "'" + HBarCode + "'", "h_p_Kf_getPackUnionBillListDetailed");
        }

        public static DataSet getSellOrderList_s(string sWhere)
        public static DataSet getSellOrderList_s(string HSourceBillNo)
        {
            string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
            new SQLHelper.ClsCN().RunProcReturn("exec h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO '" + HSourceBillNo + "'", "h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO");
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getSellOrderList_s " + sWhere, "h_v_getSellOrderList_s");
        }