| | |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | string parameterSql = $"select HValue from Xt_SystemParameter where HKey ='Cg_POInStockBill_ErpAduit'"; |
| | | var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString(); |
| | | string sql = string.Empty; |
| | | if (HValue == "Y") |
| | | { |
| | | var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName"); |
| | | string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string sql = string.Empty; |
| | | DataTable dt = new DataTable(); |
| | | List<string> fidList = new List<string>(); |
| | | if (FCusName == "瑞与祺") |
| | |
| | | } |
| | | } |
| | | } |
| | | } |
| | | var check = Get_ReciveBillCheckDate(HBillNo); |
| | | if (check.code == "0") |
| | | return check; |
| | | //if(check) |
| | | //更新主表状态 审核 |
| | | sql = string.Format(@"update Cg_POInStockBillMain set |
| | | HBillStatus = 2 , |
| | |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | public int GetHinterIDByBillNo(string HBillNo, string type) |
| | | { |
| | | SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); |
| | |
| | | HInterID = Convert.ToInt32(dt.Rows[0]["HInterID"]); |
| | | return HInterID; |
| | | } |
| | | #endregion |
| | | |
| | | #region [收料通知单审核] |
| | | //收料通知单审核 扫条码 |
| | | [Route("POStockInBillList/Get_ReciveBillCheckDate")] |
| | | [HttpGet] |
| | | public object Get_ReciveBillCheckDate(string HBarCode) |
| | | public json Get_ReciveBillCheckDate(string HBarCode) |
| | | { |
| | | json objjson = new json(); |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet 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) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "没有返回任何记录!"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucess!"; |
| | | objJsonResult.data = Ds.Tables[0]; |
| | | return objJsonResult; |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "Sucess!"; |
| | | objjson.data = Ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "没有返回任何记录!" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | |
| | | } |
| | | } |
| | | |
| | | //收料通知单审核 审核提交 |
| | | [Route("POStockInBillList/Exec_ReciveBillCheck")] |