/// <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;
}
}
}
