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);
}
void GetBarCode(Tbl_ProductBatch oBunch, CallBack call)
{
Msg msg = ProductModel.EditInBunch(oBunch);
if (call != null)
{
call(msg);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string MetriesId = this.Request["BuildBunchId"];
Msg MetriesMsg = ProductModel.GetUnsureInBunch(int.Parse(MetriesId));
Tbl_ProductBatch oMatries = MetriesMsg.UserData as Tbl_ProductBatch;
if (oMatries != null)
{
txbPlanId.Value = oMatries.PlanID.ToString();
txbMateriesID.Value = oMatries.MateriesID.ToString();
txbBuildID.Value = oMatries.BuildID.ToString();
txbBuildName.Value = oMatries.BuildName;
txbCount.Value = oMatries.Count.ToString();
txbMetriesType.Value = oMatries.MateriesType;
txbProductNum.Value = oMatries.ProjectName;
txbProjectName.Value = oMatries.ProjectName;
hiddCount.Value = oMatries.Count.ToString();
txbBuildBatchID.Value = oMatries.BuildBatchID.ToString();
}
}
protected void ensure_Click(object sender, EventArgs e)
{
//首先判断是否存在此批次
string MetriesId = this.Request["MateriesID"];
Tbl_ProductBatch oBunch = new Tbl_ProductBatch();
oBunch.PlanID = int.Parse(txbPlanId.Value);
oBunch.MateriesID = int.Parse(txbMateriesID.Value);
oBunch.BuildID = txbBuildID.Value;
oBunch.BuildName = txbBuildName.Value;
oBunch.MateriesType = txbMetriesType.Value;
oBunch.MateriesTasbleID = int.Parse(txbMateriesID.Value);
oBunch.ProjectName = txbProjectName.Value;
oBunch.Time = DateTime.Now;
oBunch.WorkMapID = txbProductNum.Value;
oBunch.Count = int.Parse(txbCount.Value);
oBunch.PreAdmStatus = 1;
oBunch.NowAdmStatus = 1;
Msg msg = ProductModel.EditInBunch(oBunch);
if (msg.Status)
{
PageHelper.ShowAlertMsg(this, "编辑成功");
}
else
{
PageHelper.ShowAlertMsg(this, "编辑失败:" + msg.Message);
}
//CallBack call =ReturnMsg;
//Thread thread = new Thread(() => GetBarCode(oBunch, call));
//thread.IsBackground = true;
//thread.Start();
}
public static Msg GetUnsureInBunch(int iMateries)
{
Msg msg = null;
Tbl_ProductBatch oMetries = new Tbl_ProductBatch();
try
{
using (var en = new LingYunEntities())
{
oMetries = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == iMateries).FirstOrDefault();
}
if (oMetries != null)
{
msg = new Msg(true)
{
UserData = oMetries
};
}
else
{
msg = new Msg(false)
{
Message = "查找失败"
};
}
}
catch (Exception ex)
{
msg = new Msg(false)
{
Message = ex.Message
};
}
return(msg);
}
public static TrackMsg TrackByBatchId(int iBatchId)
{
TrackMsg track = null;
string list = string.Empty;
// List<string> list = new List<string>();
try
{
track = new TrackMsg();
int res = 0;
using (var en = new LingYunEntities())
{
Tbl_ProductBatch oProIn = en.Tbl_ProductBatch.Where(a => a.BuildBatchID == iBatchId && a.NowAdmStatus == 128).FirstOrDefault();
if (oProIn != null)
{
list += oProIn.NowAdmTime.Value.ToString();
Tbl_OutProductBatch oProOut = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == iBatchId && a.PreAdmStatus == 128).FirstOrDefault();
if (oProOut != null)
{
list += ";" + oProOut.PreAdmTime.Value.ToString();
Tbl_CenterStorageBatch oCenIn = en.Tbl_CenterStorageBatch.Where(a => a.BuildBatchID == iBatchId && a.NowAdmStatus == 128).FirstOrDefault();
if (oCenIn != null)
{
list += ";" + oCenIn.NowAdmTime.Value.ToString();
Tbl_OutCenterStorage oCenOut = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == iBatchId && a.PreAdmStatus == 128).FirstOrDefault();
if (oCenOut != null)
{
list += ";" + oCenOut.PreAdmTime.Value.ToString();
Tbl_SiteStorageBatch oSiteIn = en.Tbl_SiteStorageBatch.Where(a => a.BuildBatchID == iBatchId && a.NowAdmStatus == 128).FirstOrDefault();
if (oSiteIn != null)
{
list += ";" + oSiteIn.NowAdmTime.Value.ToString();
Tbl_OutSiteStorage oSiteOut = en.Tbl_OutSiteStorage.Where(a => a.BuildBatchID == iBatchId && a.PreAdmStatus == 128).FirstOrDefault();
if (oSiteOut != null)
{
list += ";" + oSiteOut.PreAdmTime.Value.ToString();
res = (int)BatchStatus.待领料;
}
else
{
res = (int)BatchStatus.现场仓库待出库审批;
}
}
else
{
res = (int)BatchStatus.现场仓库入库待审批;
}
}
else
{
res = (int)BatchStatus.中心仓库待出库审批;
}
}
else
{
res = (int)BatchStatus.中心仓库入库待审批;
}
}
else
{
res = (int)BatchStatus.加工仓库待出库审批;
}
}
else
{
res = (int)BatchStatus.加工仓库入库待审批;
}
//Tbl_SiteStorage oSite = en.Tbl_SiteStorage.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
//Tbl_CenterStorage oCenter = en.Tbl_CenterStorage.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
//Tbl_ProductStorage oPro = en.Tbl_ProductStorage.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
//if (oSite != null)
//{
// Tbl_OutSiteStorage oOut = en.Tbl_OutSiteStorage.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
// if (oOut ==null)
// res = (int)BatchStatus.现场仓库待出库审批;
// else
// res = (int)BatchStatus.待领料;
//}
//else if (oCenter != null)
//{
// Tbl_OutCenterStorage oOut = en.Tbl_OutCenterStorage.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
// if (oOut==null)
// res = (int)BatchStatus.中心仓库待出库审批;
// else
// res = (int)BatchStatus.现场仓库入库待审批;
//}
//else if (oPro != null)
//{
// Tbl_OutProductBatch oOut = en.Tbl_OutProductBatch.Where(a => a.BuildBatchID == iBatchId).FirstOrDefault();
// if (oOut==null)
// res = (int)BatchStatus.加工仓库待出库审批;
// else
// res = (int)BatchStatus.中心仓库入库待审批;
//}
//else
//{
//
//}
track.STime = list;
track.Status = res;
}
}
catch (Exception ex)
{
track = new TrackMsg()
{
Status = -1
};
}
return(track);
}
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);
}
}
}
/// <summary>
/// 新编辑如库
/// </summary>
/// <param name="oBunch"></param>
/// <returns></returns>
public static Msg NEditInBunch(List <Tbl_ProductBatch> list)
{
Msg msg = null;
//构造调码对象
List <Tbl_BarCodeBatch> lBarcode = new List <Tbl_BarCodeBatch>();
// List<Tbl_BarCodeInfo> lBarCodeInfo = new List<Tbl_BarCodeInfo>();
try
{
using (var en = new LingYunEntities())
{
List <string> BarCodes = new List <string>();
foreach (Tbl_ProductBatch oPro in list)
{
en.Tbl_ProductBatch.AddObject(oPro);
en.SaveChanges();
Tbl_ProductBatch oProduct = en.Tbl_ProductBatch.Where(a => a.MateriesID == oPro.MateriesID).ToList().LastOrDefault();
//批次
List <string> lCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.批次);
BarCodes.Add(lCodes[0]);
Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
oBunchBarCode.BarCodeBatchID = oProduct.BuildBatchID;
oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
oBunchBarCode.BarCodeNo = lCodes[0];
oBunchBarCode.CreateTime = DateTime.Now;
oBunchBarCode.BuildBatchID = oProduct.BuildBatchID;
Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
oBarCodeInfo.BarCodeInfoID = oProduct.BuildBatchID;
oBarCodeInfo.BuildName = oPro.BuildName;
oBarCodeInfo.CreateTime = DateTime.Now;
oBarCodeInfo.MateriesType = oPro.MateriesType;
oBarCodeInfo.WorkMapID = oPro.WorkMapID;
oBarCodeInfo.ProjectName = oPro.ProjectName;
oBarCodeInfo.BarCodeBatchID = oProduct.BuildBatchID;
en.Tbl_BarCodeBatch.AddObject(oBunchBarCode);
en.Tbl_BarCodeInfo.AddObject(oBarCodeInfo);
//
List <string> lSigleCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.单件, oPro.Count);
for (int i = 0; i < lSigleCodes.Count; i++)
{
Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
oSigleBunch.BarCodeBatchID = oProduct.BuildBatchID;
oSigleBunch.BarCodeType = (int)BarCodeType.单件;
oSigleBunch.BarCodeNo = lSigleCodes[i];
oSigleBunch.CreateTime = DateTime.Now;
Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
oSigleInfo.BarCodeBatchID = oProduct.BuildBatchID;
oSigleInfo.BarCodeInfoID = oProduct.BuildBatchID;
oSigleInfo.BuildName = oPro.BuildName;
oSigleInfo.CreateTime = DateTime.Now;
oSigleInfo.MateriesType = oPro.MateriesType;
oSigleInfo.WorkMapID = oPro.WorkMapID;
oSigleInfo.ProjectName = oPro.ProjectName;
en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
}
}
en.SaveChanges();
msg = new Msg(true)
{
UserData = BarCodes
};
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
return(msg);
}
public static Msg EditInBunch(Tbl_ProductBatch oBunch)
{
//构造调码对象
List <Tbl_BarCodeBatch> lBarcode = new List <Tbl_BarCodeBatch>();
// List<Tbl_BarCodeInfo> lBarCodeInfo = new List<Tbl_BarCodeInfo>();
Msg msg = null;
if (oBunch != null)
{
try
{
using (var en = new LingYunEntities())
{
Tbl_ProductBatch obj = en.Tbl_ProductBatch.Where(a => a.PlanID == oBunch.PlanID && oBunch.MateriesID == a.MateriesID).FirstOrDefault();
//if (obj == null)
{
en.Tbl_ProductBatch.AddObject(oBunch);
en.SaveChanges();
Tbl_ProductBatch oProduct = en.Tbl_ProductBatch.Where(a => a.PlanID == oBunch.PlanID).ToList().LastOrDefault();
//批次
List <string> lCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.批次);
Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
oBunchBarCode.BarCodeBatchID = oProduct.BuildBatchID;
oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
oBunchBarCode.BarCodeNo = lCodes[0];
oBunchBarCode.CreateTime = DateTime.Now;
oBunchBarCode.BuildBatchID = oProduct.BuildBatchID;
Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
oBarCodeInfo.BarCodeInfoID = oProduct.BuildBatchID;
oBarCodeInfo.BuildName = oBunch.BuildName;
oBarCodeInfo.CreateTime = DateTime.Now;
oBarCodeInfo.MateriesType = oBunch.MateriesType;
oBarCodeInfo.WorkMapID = oBunch.WorkMapID;
oBarCodeInfo.ProjectName = oBunch.ProjectName;
oBarCodeInfo.BarCodeBatchID = oProduct.BuildBatchID;
en.Tbl_BarCodeBatch.AddObject(oBunchBarCode);
en.Tbl_BarCodeInfo.AddObject(oBarCodeInfo);
//
List <string> lSigleCodes = BarCode.BuildBarCode(oProduct.WorkMapID, (int)BarCodeType.单件, oBunch.Count);
for (int i = 0; i < lSigleCodes.Count; i++)
{
Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
oSigleBunch.BarCodeBatchID = oProduct.BuildBatchID;
oSigleBunch.BarCodeType = (int)BarCodeType.单件;
oSigleBunch.BarCodeNo = lSigleCodes[i];
oSigleBunch.CreateTime = DateTime.Now;
Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
oSigleInfo.BarCodeBatchID = oProduct.BuildBatchID;
oSigleInfo.BarCodeInfoID = oProduct.BuildBatchID;
oSigleInfo.BuildName = oBunch.BuildName;
oSigleInfo.CreateTime = DateTime.Now;
oSigleInfo.MateriesType = oBunch.MateriesType;
oSigleInfo.WorkMapID = oBunch.WorkMapID;
oSigleInfo.ProjectName = oBunch.ProjectName;
en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
}
en.SaveChanges();
msg = new Msg(true)
{
UserData = lCodes
};
}
//else
//{
// obj.Count = oBunch.Count;
// List<Tbl_BarCodeBatch> lDelBunch = en.Tbl_BarCodeBatch.Where(a => a.BuildBatchID == obj.BuildBatchID).ToList();
// List<Tbl_BarCodeInfo> lDelInfo = en.Tbl_BarCodeInfo.Where(a => a.BarCodeBatchID == obj.BuildBatchID).ToList();
// for(int j=0;j<lDelBunch.Count;j++)
// {
// en.Tbl_BarCodeBatch.DeleteObject(lDelBunch[j]);
// en.Tbl_BarCodeInfo.DeleteObject(lDelInfo[j]);
// }en.SaveChanges();
// string conStr = ConfigurationManager.AppSettings["ConStr"];
// SqlConnection con = new SqlConnection(conStr);
// con.Open();
// //插入单件
// // SqlTransaction tran = con.BeginTransaction();//开始事务
// List<string> lSigleCodes = BarCode.BuildBarCode(int.Parse(obj.BuildBatchID.ToString()), (int)BarCodeType.单件, oBunch.Count);
// for (int i = 0; i < lSigleCodes.Count; i++)
// {
// Tbl_BarCodeBatch oSigleBunch = new Tbl_BarCodeBatch();
// oSigleBunch.BuildBatchID = obj.BuildBatchID;
// oSigleBunch.BarCodeType = (int)BarCodeType.单件;
// oSigleBunch.BarCodeNo = lSigleCodes[i];
// oSigleBunch.CreateTime = DateTime.Now;
// Tbl_BarCodeInfo oSigleInfo = new Tbl_BarCodeInfo();
// oSigleInfo.BarCodeBatchID = obj.BuildBatchID;
// oSigleInfo.BuildName = oBunch.BuildName;
// oSigleInfo.CreateTime = DateTime.Now;
// oSigleInfo.MateriesType = oBunch.MateriesType;
// oSigleInfo.WorkMapID = oBunch.WorkMapID;
// oSigleInfo.ProjectName = oBunch.ProjectName;
// //en.Tbl_BarCodeBatch.AddObject(oSigleBunch);
// //en.Tbl_BarCodeInfo.AddObject(oSigleInfo);
// SqlCommand com1 = new SqlCommand("insert into Tbl_BarCodeBatch(BuildBatchID,BarCodeNo,CreateTime,BarCodeType) values(" + oSigleBunch.BuildBatchID + ",'" + oSigleBunch.BarCodeNo + "','" + oSigleBunch.CreateTime + "'," + oSigleBunch.BarCodeType + ")", con);
// SqlCommand com2 = new SqlCommand("insert into Tbl_BarCodeInfo(BarCodeBatchID,CreateTime,ProjectName,BuildName,MateriesType,WorkMapID) values(" + oSigleInfo.BarCodeBatchID + ",'" + oSigleInfo.CreateTime + "','" + oSigleInfo.ProjectName + "','" + oSigleInfo.BuildName + "','" + oSigleInfo.MateriesType + "','" + oSigleInfo.WorkMapID + "')", con);
// com1.ExecuteScalar();
// com2.ExecuteScalar();
// }
// //批次
// List<string> lCodes = BarCode.BuildBarCode(int.Parse(obj.BuildBatchID.ToString()), (int)BarCodeType.批次);
// Tbl_BarCodeBatch oBunchBarCode = new Tbl_BarCodeBatch();
// oBunchBarCode.BuildBatchID = obj.BuildBatchID;
// oBunchBarCode.BarCodeType = (int)BarCodeType.批次;
// oBunchBarCode.BarCodeNo = lCodes[0];
// oBunchBarCode.CreateTime = DateTime.Now;
// Tbl_BarCodeInfo oBarCodeInfo = new Tbl_BarCodeInfo();
// oBarCodeInfo.BarCodeBatchID = obj.BuildBatchID;
// oBarCodeInfo.BuildName = oBunch.BuildName;
// oBarCodeInfo.CreateTime = DateTime.Now;
// oBarCodeInfo.MateriesType = oBunch.MateriesType;
// oBarCodeInfo.WorkMapID = oBunch.WorkMapID;
// oBarCodeInfo.ProjectName = oBunch.ProjectName;
// SqlCommand com3 = new SqlCommand("insert into Tbl_BarCodeBatch(BuildBatchID,BarCodeNo,CreateTime,BarCodeType) values(" + oBunchBarCode.BuildBatchID + ",'" + oBunchBarCode.BarCodeNo + "','" + oBunchBarCode.CreateTime + "'," + oBunchBarCode.BarCodeType + ")", con);
// SqlCommand com4 = new SqlCommand("insert into Tbl_BarCodeInfo(BarCodeBatchID,CreateTime,ProjectName,BuildName,MateriesType,WorkMapID) values(" + oBarCodeInfo.BarCodeBatchID + ",'" + oBarCodeInfo.CreateTime + "','" + oBarCodeInfo.ProjectName + "','" + oBarCodeInfo.BuildName + "','" + oBarCodeInfo.MateriesType + "','" + oBarCodeInfo.WorkMapID + "')", con);
// com3.ExecuteScalar();
// com4.ExecuteScalar();
// // tran.Commit();
// con.Close();
// msg = new Msg(true) { UserData = lCodes };
}
}
catch (Exception ex)
{
msg = new Msg()
{
Status = false, Message = ex.Message
};
}
}
return(msg);
}
