public static Msg EnsureInBunch(Tbl_ProductBatch oBunch, Tbl_ProductStorage oStorage)
{
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
var oPlan = en.Tbl_Plan.Where(a => a.PlanID == oBunch.PlanID).FirstOrDefault();
oPlan.ProductAdmStatus = 128;
en.Tbl_ProductBatch.AddObject(oBunch);
en.SaveChanges();
var obj = en.Tbl_ProductBatch.Where(a => a.MateriesID == oBunch.MateriesID).FirstOrDefault();
oStorage.BuildBatchID = int.Parse(obj.BuildBatchID.ToString());
en.AddToTbl_ProductStorage(oStorage);
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
/// <summary>
/// 更新入库批次表
/// </summary>
/// <param name="matriesId"></param>
/// <param name="count"></param>
/// <param name="oStorage">仓储表</param>
/// <returns></returns>
public static Msg UpdateInBunch(int matriesId, int count, Tbl_ProductStorage oStorage)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == oStorage.BuildBatchID).FirstOrDefault();
obj.Count = count;
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
en.AddToTbl_ProductStorage(oStorage);
en.SaveChanges();
List <Tbl_ProductBatch> list = en.Tbl_ProductBatch.Where(a => a.PlanID == oStorage.PlanID && a.NowAdmStatus == 128).ToList();
int proCount = 0;
foreach (Tbl_ProductBatch oPro in list)
{
proCount += oPro.Count;
}
Tbl_Materies oMa = en.Tbl_Materies.Where(a => a.PlanID == oStorage.PlanID).FirstOrDefault(); //最后如果确认完成对加工主管状态改变
if (oMa.TotalNum == proCount)
{
var oPlan = en.Tbl_Plan.Where(a => a.PlanID == oStorage.PlanID).FirstOrDefault();
oPlan.ProductAdmStatus = 128;
en.SaveChanges();
}
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}