| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取选单号的源单类型 通过选单号单据类型 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetHSourceBillTypeByBillType")] |
| | | [HttpGet] |
| | | public object GetHSourceBillTypeByBillType(string HBillType, int Num) |
| | | { |
| | | try |
| | | { |
| | | ClsCN oCn = new ClsCN(); |
| | | DataSet oDs = new DataSet(); |
| | | //有的单子源单分为红蓝单 0代表蓝单 1代表红单 |
| | | if (Num == 0) |
| | | { //源单为蓝单 |
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HNumber='" + HBillType + "'and HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet"); |
| | | } |
| | | else if (Num == 1) |
| | | { //源单为红单 |
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HNumber='" + HBillType + "' and HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet"); |
| | | } |
| | | else if (Num == 2) |
| | | { //不分红蓝单 |
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HNumber='" + HBillType + "'", "Xt_BillSourceSet"); |
| | | } |
| | | |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = oDs.Tables[0]; |
| | | return objjson; ; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败!异常" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; ; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取选单号的源单类型 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 通过单据类型获取对应视图并通过单据号查询单据信息 |
| | | /// </summary> |
| | | /// <param name="HBillNo"></param> |
| | | /// <param name="HBillType"></param> |
| | | /// <param name="HStoreOrgID"></param> |
| | | /// <returns></returns> |
| | | [Route("Web/GetBillInfo")] |
| | | [HttpGet] |
| | | public object GetBillInfo(string HBillNo, string HBillType, int HStockOrgID) |
| | | { |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Gy_GetBillInfoByHBillTypeAndHBillNo N'" + HBillType + "',N'" + HBillNo + |
| | | "'," + HStockOrgID, "h_p_Gy_GetBillInfoByHBillTypeAndHBillNo"); |
| | | |
| | | if (ds == null) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else if((bool)ds.Tables[1].Rows[0]["returnType"] == false) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ds.Tables[1].Rows[1]["payload"]; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 金帅WMS接口 |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | } |