/// <summary> /// 获取某批号在某工序的数量 /// </summary> /// <param name="WorkProcedure">工序</param> /// <param name="BatchNo">批号</param> /// <returns></returns> public Object GetAmount(string WorkProcedure, string BatchNo) { decimal Amount = 0; WorkProcedure = WorkProcedure != null ? WorkProcedure : ""; WorkProcedure = WorkProcedure.Replace(" ", "").Trim().Replace("车间", ""); BatchNo = BatchNo.Replace(" ", "").Trim(); using (SqlConnection con = new SqlConnection(GHConString)) { FeedbackBaseService BllBase = new FeedbackBaseService(con); RateTotal.tm_dTempStoreIO obj = new RateTotal.tm_dTempStoreIO(); if (WorkProcedure.Contains("流延") || WorkProcedure.Contains("丝印") || WorkProcedure.Contains("新工艺")) { //chrBatchID,chrType,intChipAmount List <tp_carCraft> carCraftList = new List <tp_carCraft>(); carCraftList = BllBase.GetInfo(BatchNo); obj.decSumQty = carCraftList != null?Convert.ToDecimal(carCraftList.FirstOrDefault().intChipAmount) : 0; } else { obj = BllBase.GetTempStoreAmount(BatchNo, WorkProcedure); } return(obj); } }
public Object GetBatchInfo(string chrBatchID, string WorkProcedure) { ResultData result = new ResultData(); WorkProcedure = WorkProcedure != null ? WorkProcedure : ""; WorkProcedure = WorkProcedure.Replace(" ", "").Trim().Replace("车间", ""); using (SqlConnection sqlconnection = new SqlConnection(GHConString)) { try { FeedbackBaseService service = new FeedbackBaseService(sqlconnection); List <tp_carCraft> carCraftList = new List <tp_carCraft>(); if (WorkProcedure.Contains("流延") || WorkProcedure.Contains("丝印") || WorkProcedure.Contains("新工艺") || WorkProcedure == "") { carCraftList = service.GetInfo(chrBatchID); } else { carCraftList = service.GetInfo(chrBatchID); RateTotal.tm_dTempStoreIO obj = new RateTotal.tm_dTempStoreIO(); obj = service.GetTempStoreAmount(chrBatchID, WorkProcedure); if (carCraftList.Count > 0) { carCraftList[0].intChipAmount = obj != null?Convert.ToInt64(obj.decSumQty).ToString() : "0"; } } return(carCraftList); } catch (Exception ex) { string message = ex.Message; throw; } } }