22

zgq

2021-02-25 ca089c3c0de722bdd1e4d49c40c8bff0d3a26fc2

 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")]
@@ -316,6 +315,45 @@
            }
        }

        /// <summary>
        /// 待发区找货根据实物条码 返回相关信息
        /// </summary>
        /// <returns></returns>
        [Route("LookingFor/getWaitingLookingFor")]
        [HttpGet]
        public object GetWaitingLookingFor(string HBarCode)
        {
            try
            {
                string sWhere = " Where HBarCode = '" + HBarCode.Trim() + "'";
                ds = GetWaitingLookingFor_s(sWhere);
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有返回任何记录！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "返回记录成功！";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception ex)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + ex.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }


        #region sql语句

@@ -329,8 +367,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)
        {
            new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO '" + HSourceBillNo+ "'", "h_p_IFCLD_ERPSourceBillToLocal_SEOrderToICMO");
            string sWhere = " Where HSourceBillNo = '" + HSourceBillNo.Trim() + "'";
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getSellOrderList_s " + sWhere, "h_v_getSellOrderList_s");
        }

@@ -343,6 +383,10 @@
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_StockPlace " + sWhere, "h_v_IF_StockPlace");
        }
        public static DataSet GetWaitingLookingFor_s(string sWhere)
        {
            return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_getWaitingLookingFor " + sWhere, "h_v_getWaitingLookingFor");
        }

        #endregion