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