protected void ensure_Click(object sender, EventArgs e)
{
int iTotalCount = int.Parse(hiddCount.Value);
string metriesId = this.Request["BuildBunchId"];
int count = int.Parse(txbCount.Value);
// bool isHave=ProductModel.QueryInBunch(int.Parse(metriesId));
Tbl_ProductStorage oStorage = new Tbl_ProductStorage();
oStorage.BuildBatchID = int.Parse(txbBuildBatchID.Value);
oStorage.PlanID = int.Parse(txbPlanId.Value);
oStorage.Time = DateTime.Now;
oStorage.MateriesID = int.Parse(txbMateriesID.Value);
oStorage.BuildID = txbBuildID.Value;
oStorage.BuildName = txbBuildName.Value.ToString();
oStorage.MateriesType = txbMetriesType.Value.ToString();
oStorage.PreAdmTime = DateTime.Now;
oStorage.PreAdmStatus = 128;
oStorage.NowAdmStatus = 1;
oStorage.NowAdmTime = DateTime.Now;
oStorage.ProjectName = txbProjectName.Value;
oStorage.WorkMapID = txbProductNum.Value;
oStorage.InCount = int.Parse(txbCount.Value);
if (iTotalCount >= count)
{
Msg msg = ProductModel.UpdateInBunch(int.Parse(metriesId), count, oStorage);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "编辑并确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, msg.Message);
}
//}
//else
//{
// Tbl_ProductBatch oBunch = new Tbl_ProductBatch();
// oBunch.PlanID = int.Parse(txbPlanId.Value);
// oBunch.MateriesID = int.Parse(txbMateriesID.Value);
// oBunch.BuildID = int.Parse(txbBuildID.Value);
// oBunch.BuildName = txbBuildName.Value.ToString();
// oBunch.MateriesType = txbMetriesType.Value.ToString();
// oBunch.PreAdmTime = DateTime.Now;
// oBunch.WorkMapID = txbProductNum.Value;
// oBunch.ProjectName = txbProjectName.Value;
// oBunch.NowAdmStatus = 128;
// oBunch.NowAdmTime = DateTime.Now;
// oBunch.Count = int.Parse(txbCount.Value);
// Msg bunchMsg = ProductModel.EnsureInBunch(oBunch, oStorage);
// if (bunchMsg.Status)
// {
// PageHelper.ShowAlertMsg(this, "确认成功");
// }
// else
// {
// PageHelper.ShowAlertMsg(this, bunchMsg.Message);
// }
}
}
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);
}
/// <summary>
/// android端确认
/// </summary>
/// <param name="oBunch"></param>
/// <param name="oStorage"></param>
/// <returns></returns>
public static Msg AndroidInBunch(int iBatchId)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
var obj = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
obj.NowAdmStatus = 128;
obj.NowAdmTime = DateTime.Now;
Tbl_ProductStorage oStorage = new Tbl_ProductStorage();
oStorage.PlanID = obj.PlanID;
oStorage.Time = DateTime.Now;
oStorage.MateriesID = obj.MateriesID;
oStorage.BuildID = obj.BuildID;
oStorage.BuildName = obj.BuildName;
oStorage.BuildBatchID = int.Parse(obj.BuildBatchID.ToString());
oStorage.MateriesType = obj.MateriesType;
oStorage.PreAdmTime = DateTime.Now;
oStorage.PreAdmStatus = 128;
oStorage.NowAdmStatus = 1;
oStorage.NowAdmTime = DateTime.Now;
oStorage.ProjectName = obj.ProjectName;
oStorage.WorkMapID = obj.WorkMapID;
oStorage.InCount = obj.Count;
en.Tbl_ProductStorage.AddObject(oStorage);
en.SaveChanges();
msg = Msg.Default;
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
/// <summary>
/// 根据指定的批次编号查询记录
/// </summary>
/// <param name="matries"></param>
/// <returns></returns>
public static Msg QueryProductStorageById(int Id)
{
Msg msg = null;
try
{
using (var en = new LingYunEntities())
{
Tbl_ProductStorage oStorage = en.Tbl_ProductStorage.Where(a => a.BuildBatchID == Id).FirstOrDefault();
if (oStorage != null)
{
msg = new Msg(true)
{
UserData = oStorage
};
}
else
{
msg = new Msg(false)
{
Message = "当前没有待出库的批次表"
};
}
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
private void Save(object data, int identify)
{
if (identify == (int)CurrentType.加工登录入库)
{
List <Tbl_Materies> lMa = data as List <Tbl_Materies>;
List <Tbl_ProductBatch> lObj = new List <Tbl_ProductBatch>();
foreach (Tbl_Materies oPro in lMa)
{
Tbl_ProductBatch oSto = new Tbl_ProductBatch();
oSto.BuildID = oPro.BuildNum;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.TotalNum;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = 0;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 1;
oSto.PreAdmTime = DateTime.Now;
oSto.NowAdmStatus = 1;
oSto.NowAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.ProcessingNum;
lObj.Add(oSto);
}
Msg msg = ProductModel.NEditInBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "编辑成功");
}
// CallBack call = ReturnMsg;
// Thread thread = new Thread(() => GetBarCode(lObj, call));
// thread.IsBackground = true;
// thread.Start();
}
else if (identify == (int)CurrentType.加工确认入库)
{
List <Tbl_ProductBatch> lMa = data as List <Tbl_ProductBatch>;
List <Tbl_ProductStorage> lObj = new List <Tbl_ProductStorage>();
foreach (Tbl_ProductBatch oPro in lMa)
{
Tbl_ProductStorage oSto = new Tbl_ProductStorage();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.InCount = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 128;
oSto.PreAdmTime = DateTime.Now;
oSto.NowAdmStatus = 1;
oSto.NowAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = ProductModel.NEnsureInBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.加工登录出库)
{
List <Tbl_ProductStorage> lMa = data as List <Tbl_ProductStorage>;
List <Tbl_OutProductBatch> lObj = new List <Tbl_OutProductBatch>();
foreach (Tbl_ProductStorage oPro in lMa)
{
Tbl_OutProductBatch oSto = new Tbl_OutProductBatch();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.InCount == null?0:(int)oPro.InCount;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 1;
oSto.PreAdmTime = DateTime.Now;
oSto.NowAdmStatus = 1;
oSto.NowAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = ProductModel.NEditOurBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.加工确认出库)
{
List <Tbl_OutProductBatch> lMa = data as List <Tbl_OutProductBatch>;
List <Tbl_CenterStorageBatch> lObj = new List <Tbl_CenterStorageBatch>();
foreach (Tbl_OutProductBatch oPro in lMa)
{
Tbl_CenterStorageBatch oSto = new Tbl_CenterStorageBatch();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 128;
oSto.PreAdmTime = DateTime.Now;
oSto.NowAdmStatus = 1;
oSto.NowAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = ProductModel.NEnsureOutBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.中心确认入库)
{
List <Tbl_CenterStorageBatch> lMa = data as List <Tbl_CenterStorageBatch>;
List <Tbl_CenterStorage> lObj = new List <Tbl_CenterStorage>();
foreach (Tbl_CenterStorageBatch oPro in lMa)
{
Tbl_CenterStorage oSto = new Tbl_CenterStorage();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.InCount = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 128;
oSto.PreAdmTime = DateTime.Now;
oSto.NowAdmStatus = 1;
oSto.NowAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = Center.NEnsureInBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.中心登录出库)
{
List <Tbl_CenterStorage> lMa = data as List <Tbl_CenterStorage>;
List <Tbl_OutCenterStorage> lObj = new List <Tbl_OutCenterStorage>();
foreach (Tbl_CenterStorage oPro in lMa)
{
Tbl_OutCenterStorage oSto = new Tbl_OutCenterStorage();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 1;
oSto.PreAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = Center.NEditOutBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.中心确认出库)
{
List <Tbl_OutCenterStorage> lMa = data as List <Tbl_OutCenterStorage>;
List <Tbl_SiteStorageBatch> lObj = new List <Tbl_SiteStorageBatch>();
foreach (Tbl_OutCenterStorage oPro in lMa)
{
Tbl_SiteStorageBatch oSto = new Tbl_SiteStorageBatch();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 128;
oSto.PreAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = Center.NEnsureOutBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.现场确认入库)
{
List <Tbl_SiteStorageBatch> lMa = data as List <Tbl_SiteStorageBatch>;
List <Tbl_SiteStorage> lObj = new List <Tbl_SiteStorage>();
foreach (Tbl_SiteStorageBatch oPro in lMa)
{
Tbl_SiteStorage oSto = new Tbl_SiteStorage();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.InCount = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 128;
oSto.PreAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = SiteStorageModel.NEnsureInBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.现场登录出库)
{
List <Tbl_SiteStorage> lMa = data as List <Tbl_SiteStorage>;
List <Tbl_OutSiteStorage> lObj = new List <Tbl_OutSiteStorage>();
foreach (Tbl_SiteStorage oPro in lMa)
{
Tbl_OutSiteStorage oSto = new Tbl_OutSiteStorage();
oSto.BuildBatchID = (int)oPro.BuildBatchID;
oSto.BuildID = oPro.BuildID;
oSto.BuildName = oPro.BuildName;
oSto.Count = oPro.Count;
oSto.MateriesID = oPro.MateriesID;
oSto.MateriesTasbleID = oPro.MateriesTasbleID;
oSto.MateriesType = oPro.MateriesType;
oSto.PlanID = oPro.PlanID;
oSto.PreAdmStatus = 1;
oSto.PreAdmTime = DateTime.Now;
oSto.ProjectName = oPro.ProjectName;
oSto.Time = DateTime.Now;
oSto.WorkMapID = oPro.WorkMapID;
lObj.Add(oSto);
}
Msg msg = SiteStorageModel.NEditOutBunch(lObj);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
else if (identify == (int)CurrentType.现场确认出库)
{
List <Tbl_OutSiteStorage> lMa = data as List <Tbl_OutSiteStorage>;
Msg msg = SiteStorageModel.EnsureOutBunch(lMa);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "确认成功");
}
else
{
PageHelper.ShowAlertMsg(this, "确认失败：" + msg.Message);
}
}
}
