| | |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | #region 到货确认 |
|---|
| | | [Route("POStockInBillList/Get_ReciveBill")] |
|---|
| | | [HttpGet] |
|---|
| | |
|---|
| | | DataSet Ds; |
|---|
| | | string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称 |
|---|
| | | if (FCusName.Contains("安瑞")) |
|---|
| | | Ds= oCn.RunProcReturn("exec h_p_GetPOInStockByBarCode'" + HBarCode + "'", "h_p_GetPOInStockByBarCode"); |
|---|
| | | Ds = oCn.RunProcReturn("exec h_p_GetPOInStockByBarCode'" + HBarCode + "'", "h_p_GetPOInStockByBarCode"); |
|---|
| | | else |
|---|
| | | Ds = oCn.RunProcReturn("exec h_p_KF_PonderationBillMain_Temp_Add_POInStockCheck2 '" + HBarCode + "'", "h_p_KF_PonderationBillMain_Temp_Add_POInStockCheck2"); |
|---|
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
|---|
| | |
|---|
| | | JOIN {0}..T_PUR_POORDERFIN E ON C.FID =E.FID |
|---|
| | | LEFT JOIN {0}..T_BD_CURRENCY EC ON E. FSETTLECURRID =EC.FCURRENCYID |
|---|
| | | WHERE b.hinterid in ({1}) and M.HERPInterID = 0 |
|---|
| | | ", kdTbaleName, HInterID); |
|---|
| | | ", kdTbaleName, hinterID); |
|---|
| | | DataTable dt = oCn.RunProcReturn(sql, "sltz").Tables[0]; |
|---|
| | | List<string> fidList = new List<string>(); |
|---|
| | | if (dt.Rows.Count > 0) |
|---|
| | |
|---|
| | | { |
|---|
| | | Ids = FID, |
|---|
| | | }; |
|---|
| | | //LogService.Write(json); |
|---|
| | | //提交 |
|---|
| | | var _result = InvokeHelper.Submit("PUR_ReceiveBill", JsonConvert.SerializeObject(json)); |
|---|
| | | var _saveObj = JObject.Parse(_result); |
|---|
| | |
|---|
| | | string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称 |
|---|
| | | string sql = string.Empty; |
|---|
| | | if (FCusName.Contains("安瑞")) |
|---|
| | | sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode}'"; |
|---|
| | | sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'"; |
|---|
| | | else |
|---|
| | | sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}"; |
|---|
| | | DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList"); |
|---|
