| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 根据销售订单 返回此销售订单内的相关信息 |
|---|
| | | /// 下架找货单根据销售订单 返回此销售订单内的相关信息 |
|---|
| | | /// </summary> |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("LookingFor/getSellOrderList")] |
|---|
| | |
|---|
| | | { |
|---|
| | | 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"; |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 根据实物条码 返回相关信息 |
|---|
| | | /// 上架归还单根据实物条码 返回相关信息 |
|---|
| | | /// </summary> |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("LookingFor/getBarCodeDetails")] |
|---|
| | |
|---|
| | | 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"); |
|---|
| | | } |
|---|
| | | |
|---|
