| | |
| | | } |
| | | |
| | | /// <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 |
| | |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>02/25/2021 11:42:33</publishTime> |
| | | <publishTime>02/25/2021 22:10:11</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>02/25/2021 11:42:33</publishTime> |
| | | <publishTime>02/25/2021 22:10:11</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.XmlSerializers.dll"> |
| | | <publishTime>02/04/2021 21:35:21</publishTime> |
| | |
| | | <publishTime>02/22/2021 09:25:20</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>02/25/2021 11:42:44</publishTime> |
| | | <publishTime>02/25/2021 22:10:21</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |