| | |
| | | } |
| | | |
| | | /// <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"; |
| | |
| | | { |
| | | 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 |