| | |
| | | #endregion |
| | | |
| | | |
| | | #region 惠康 生产领料单校验 扫描源单 获取生产领料单和下游领料单未审核 单据 |
| | | [Route("web/get_BillBarCode_BillCheck_Json_MateOut_HuiKang")] |
| | | [HttpGet] |
| | | public Object get_BillBarCode_BillCheck_Json_MateOut_HuiKang(string HBillNo, string HBillType, string HMaker, Int64 HStockOrgID) |
| | | { |
| | | WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | try |
| | | { |
| | | WebSoBar = null; |
| | | // 1. 查询金蝶云中 所有符合的生产领料单和下游领料单 |
| | | ds = oCN.RunProcReturn($@" |
| | | select HBillNo from h_v_Kf_MateOutBillList_K3 where HBillNo like '%{HBillNo}%' |
| | | ", "h_v_Kf_MateOutBillList_K3"); |
| | | |
| | | List<string> HBillNoList = new List<string>(); |
| | | foreach(var row in ds.Tables[0].Rows) |
| | | { |
| | | HBillNoList.Add(row.ToString()); |
| | | } |
| | | |
| | | // 2. 遍历获取的生产领料单 |
| | | foreach(string HBillNoOne in HBillNoList) |
| | | { |
| | | WebSoBar = oWebs.get_BillBarCode_BillCheck(HBillNo, HBillType, HMaker, HStockOrgID, ref DBUtility.ClsPub.sErrInfo); |
| | | |
| | | if(WebSoBar != null) |
| | | { |
| | | // 3. 获取到符合条件的返回值,立即返回 |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "成功"; |
| | | objJsonResult.data = WebSoBar; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | // 3. 所有单据都被审核,或者没有符合要求的单据,返回错误信息 |
| | | if (WebSoBar == null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "成功"; |
| | | objJsonResult.data = WebSoBar; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "扫描单据条码失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |