public static ObservableCollection <SSBC_Data.Entities.SSBCMixVouchers> GetByVoucherId(int VoucherId) { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.SSBCMixVouchers>(dbcontext.SSBCMixVouchers.Where(x => x.VoucherId == VoucherId)); var Items = (from a in list select new SSBC_Data.Entities.SSBCMixVouchers { VoucherId = a.VoucherId, ColorCo = a.ColorCo, ColorName = a.ColorName, WinlineCo = a.WinlineCo, WinlineName = a.WinlineName, O1 = a.O1, Do1 = a.Do1, BatchNo = a.BatchNo, TotalQty = a.TotalQty, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.SSBCMixVouchers>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.SSBCMixVouchers>()); } }
private void frmCPStation_Load(object sender, EventArgs e) { WriteLog("Khởi động Mix"); lblMsg.Visible = false; ////Kích Hoạt Cân //_listener = new SSBC_Data.Extend.LowLevelKeyboardListener(); //_listener.OnKeyPressed += _listener_OnKeyPressed; //_listener.HookKeyboard(); //Khởi tạo _ScannerInfo = new ScannerInfo(); dbContext = new SSBC_Data.SourceContext(); // _spManager.StartListening(); TrackType = "COMPOUND"; lblStatus.Text = "ĐÙN NHỰA"; tabControl1.SelectedTab = TabPageInput; ReSetControl(); txtBarcode.Focus(); //Tạo ListView }
public static ObservableCollection <SSBC_Data.Entities.SSBCMaterials> ItemsSource() { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.SSBCMaterials>(dbcontext.SSBCMaterials); var Items = (from a in list select new SSBC_Data.Entities.SSBCMaterials { MaterialCo = a.MaterialCo, MaterialName = a.MaterialName, Unit = a.Unit, UserUpdate = a.UserUpdate, ReRe = a.ReRe, CpR = a.CpR, CpN = a.CpN, RESta = a.RESta, UserUpdateTime = a.UserUpdateTime, UserAdded = a.UserAdded, UserAddedTime = a.UserAddedTime, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.SSBCMaterials>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.SSBCMaterials>()); } }
//============= #region Delete public static SSBC_Data.SourceContext.MSG Delete(IEnumerable <SSBC_Data.Entities.SSBCInventoryFirst> items) { var _return = new SSBC_Data.SourceContext.MSG(); try { var dbContext = new SSBC_Data.SourceContext(); foreach (var item in items) { var itemDel = dbContext.SSBCInventoryFirsts.Where(s => s.MaterialCo == item.MaterialCo && s.ColorCode == item.ColorCode).FirstOrDefault(); dbContext.Entry(itemDel).State = System.Data.Entity.EntityState.Deleted; } ; dbContext.SaveChanges(); _return = new SSBC_Data.SourceContext.MSG("Deleted", false); } catch (Exception err) { _return = new SSBC_Data.SourceContext.MSG("Deleted", true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }
public static ObservableCollection <SSBC_Data.Entities.SSBCFormula> ItemsSource() { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.SSBCFormula>(dbcontext.SSBCFormulas); var Items = (from a in list select new SSBC_Data.Entities.SSBCFormula { ColorCode = a.ColorCode, ColorName = a.ColorName, Pp = a.Pp, UserUpdate = a.UserUpdate, UserUpdateTime = a.UserUpdateTime, UserAdded = a.UserAdded, UserAddedTime = a.UserAddedTime, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.SSBCFormula>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.SSBCFormula>()); } }
public static ObservableCollection <SSBC_Data.Entities.SSBCInventoryFirst> ItemsSource() { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.SSBCInventoryFirst>(dbcontext.SSBCInventoryFirsts); var Items = (from a in list select new SSBC_Data.Entities.SSBCInventoryFirst { MaterialCo = a.MaterialCo, MaterialName = a.MaterialName, ColorCode = a.ColorCode, ColorName = a.ColorName, Unit = a.Unit, UserUpdate = a.UserUpdate, MaterialType = a.MaterialType, Qty = a.Qty, UserUpdateTime = a.UserUpdateTime, UserAdded = a.UserAdded, UserAddedTime = a.UserAddedTime, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.SSBCInventoryFirst>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.SSBCInventoryFirst>()); } }
public static vSSBC_MixTracks GetByTrackNo(string TrackNo) { try { var dbContext = new SSBC_Data.SourceContext(); return(dbContext.vSSBC_MixTracks.Where(x => x.TrackNo == TrackNo).FirstOrDefault()); } catch (Exception ex) { ex.ToString(); return(new vSSBC_MixTracks()); } }
public static SSBC_Data.Entities.SSBCMixTrackings GetByTrackNo(string TrackNo) { try { var dbcontext = new SSBC_Data.SourceContext(); return(dbcontext.SSBCMixTrackings.Where(x => x.TrackNo == TrackNo).First()); } catch (Exception ex) { ex.ToString(); return(new SSBC_Data.Entities.SSBCMixTrackings()); } }
public static Decimal GetTotal(string SessionID) { try { var dbContext = new SSBC_Data.SourceContext(); var Total = dbContext.vLAStocks.Where(x => x.SessionID == SessionID).FirstOrDefault().Total; return(Total); } catch (Exception ex) { ex.ToString(); return(0); } }
private void frmCopyStation_Load(object sender, EventArgs e) { lblMsg.Visible = false; //Kích Hoạt Cân //_listener = new SSBC_Data.Extend.LowLevelKeyboardListener(); //_listener.OnKeyPressed += _listener_OnKeyPressed; //_listener.HookKeyboard(); //Khởi tạo _ScannerInfo = new ScannerInfo(); dbContext = new SSBC_Data.SourceContext(); //Get Default Data //LoadDefaultData(); //ListWinline = Data.Views.WinlineProductsItem.ItemsSource().ToList(); ReSetControl(); //Load Winline Product }
private void btnExport_Click(object sender, EventArgs e) { DateTime from = dtFrom.Value.Date; DateTime to = dtTo.Value.Date; var dbContext = new SSBC_Data.SourceContext(); if (rdMix.Checked == true) { var data = dbContext.vSSBC_MixTracks.Where(x => x.ScaleDate >= from && x.ScaleDate <= to).ToList(); DataTable tbl = SSBC_Data.SourceContext.Action.ToDataTable(data); tbl.ExportToExcel(txtUrl.Text); } else if (rdCrush.Checked == true) { var data = dbContext.vSSBC_CrushTracks.Where(x => x.ScaleDate >= from && x.ScaleDate <= to).ToList(); DataTable tbl = SSBC_Data.SourceContext.Action.ToDataTable(data); tbl.ExportToExcel(txtUrl.Text); } }
//Btn Tìm Kiếm private void btnLookUp_Click(object sender, EventArgs e) { _spManager.StopListening(); TrackType = "Lookup"; lblStatus.Text = "Lịch Sử Dữ Liệu"; tabControl1.SelectedTab = TabPageHistory; var dbContext = new SSBC_Data.SourceContext(); var lst = dbContext.vSSBC_CompoundTracks.Take(100).OrderByDescending(x => x.ScaleDate).ToList(); foreach (var item in lst) { item.btnDel = "XÓA"; item.btnPrint = "IN TEM"; } dbContext.Dispose(); dgvData.DataSource = lst; }
public static ObservableCollection <SSBC_Data.Entities.WinlineProducts> ItemsSource() { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.WinlineProducts>(dbcontext.WinlineProducts); var Items = (from a in list select new SSBC_Data.Entities.WinlineProducts { WinlineCode = a.WinlineCode, Name = a.Name, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.WinlineProducts>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.WinlineProducts>()); } }
public static ObservableCollection <SSBC_Data.Entities.SSBCMixTrackings> ItemsSource() { try { var dbcontext = new SSBC_Data.SourceContext(); var list = new ObservableCollection <SSBC_Data.Entities.SSBCMixTrackings>(dbcontext.SSBCMixTrackings); var Items = (from a in list select new SSBC_Data.Entities.SSBCMixTrackings { TrackNo = a.TrackNo, Year = a.Year, Seq = a.Seq, ColorCode = a.ColorCode, MaterialCo = a.MaterialCo, MaterialType = a.MaterialType, ScaleWeight = a.ScaleWeight, ScaleDate = a.ScaleDate, WinlineCode = a.WinlineCode, ProForBacode = a.ProForBacode, UserUpdate = a.UserUpdate, UserUpdateTime = a.UserUpdateTime, UserAdded = a.UserAdded, UserAddedTime = a.UserAddedTime, IsChecked = false, AutoId = SSBC_Data.SourceContext.Action.CreateAutoID(), UpdateStatus = "Unchanged" } ); return(new ObservableCollection <SSBC_Data.Entities.SSBCMixTrackings>(Items)); } catch (Exception ex) { ex.ToString(); return(new ObservableCollection <SSBC_Data.Entities.SSBCMixTrackings>()); } }
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCCrushTrackings item, string Symbol) { var _return = new SSBC_Data.SourceContext.MSG(); try { using (var dbContext = new SSBC_Data.SourceContext()) { //check the ObjectState property and mark appropriate EntityState if (item.UpdateStatus == "Added") { var items = dbContext.SSBCCrushTrackings.Where(x => x.ScaleDate.Value.Year == item.ScaleDate.Value.Year); var itemCheck = items.Where(s => s.TrackNo == item.TrackNo).ToList(); if (itemCheck.Count > 0) { _return.IsError = true; _return.MsgInformation = "Can not save data <<Duplication>>!"; } else { item.UserAdded = tmpLogin.Id; item.UserAddedTime = DateTime.Now; item.UserUpdate = tmpLogin.Id; item.UserUpdateTime = DateTime.Now; int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 : (int)x.Seq); item.Seq = MaxID + 1; item.TrackNo = "CR" + item.ScaleDate.Value.Year.ToString().Substring(2, 2) + item.Seq.ToString("00000#") + "-" + Symbol; dbContext.Entry(item).State = System.Data.Entity.EntityState.Added; } } else if (item.UpdateStatus == "Modified") { item.UserUpdate = tmpLogin.Id; item.UserUpdateTime = DateTime.Now; dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified; dbContext.Entry(item).Property(x => x.Seq).IsModified = false; dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false; dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false; //dbContext.Entry(item).Property(x => x.Isdel).IsModified = false; } else if (item.UpdateStatus == "Deleted") { dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted; } else { dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged; } //========================= if (_return.IsError != true) { dbContext.SaveChanges(); _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false); } } } catch (Exception err) { _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCMixTrackings item, decimal MaxBatchQty) { var _return = new SSBC_Data.SourceContext.MSG(); try { using (var dbContext = new SSBC_Data.SourceContext()) { //check the ObjectState property and mark appropriate EntityState if (item.UpdateStatus == "Added") { var items = dbContext.SSBCMixTrackings.Where(x => x.ScaleDate.Value.Year == item.ScaleDate.Value.Year); var ItemGroup = items.Where(x => x.ProForBacode == item.ProForBacode); var itemCheck = items.Where(s => s.TrackNo == item.TrackNo).ToList(); if (itemCheck.Count > 0) { _return.IsError = true; _return.MsgInformation = "Can not save data <<Duplication>>!"; } else { item.UserAdded = tmpLogin.Id; item.UserAddedTime = DateTime.Now; item.UserUpdate = tmpLogin.Id; item.UserUpdateTime = DateTime.Now; int BatchNo = ItemGroup.Count() == 0 ? 0 : ItemGroup.Max(x => x == null ? 0 : (int)x.BatchNo); decimal Total_BatchQty = 0; if (BatchNo == 0) { BatchNo = 1; Total_BatchQty = 0; } else { Total_BatchQty = (decimal)ItemGroup.Sum(x => x.ScaleWeight); } if (Total_BatchQty + item.ScaleWeight <= MaxBatchQty) { item.BatchNo = BatchNo; } else { item.BatchNo = BatchNo + 1; } int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 : (int)x.Seq); item.Seq = MaxID + 1; item.Year = item.ScaleDate.Value.Year.ToString(); item.TrackNo = "MI" + item.Year.Substring(2, 2) + item.Seq.ToString("00000#"); item.CountLabel = items.Where(x => x.ProForBacode == item.ProForBacode).Count();// dbContext.Entry(item).State = System.Data.Entity.EntityState.Added; } } else if (item.UpdateStatus == "Modified") { item.UserUpdate = tmpLogin.Id; item.UserUpdateTime = DateTime.Now; dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified; dbContext.Entry(item).Property(x => x.Seq).IsModified = false; dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false; dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false; //dbContext.Entry(item).Property(x => x.Isdel).IsModified = false; } else if (item.UpdateStatus == "Deleted") { dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted; } else { dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged; } //========================= if (_return.IsError != true) { dbContext.SaveChanges(); _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false); } } } catch (Exception err) { _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }
public static SSBC_Data.SourceContext.MSG Save(SSBC_Data.Entities.SSBCMixVouchers item) { var _return = new SSBC_Data.SourceContext.MSG(); try { using (var dbContext = new SSBC_Data.SourceContext()) { //check the ObjectState property and mark appropriate EntityState if (item.UpdateStatus == "Added") { var items = dbContext.SSBCMixVouchers; var itemCheck = items.Where(s => s.VoucherId == item.VoucherId).ToList(); if (itemCheck.Count > 0) { _return.IsError = true; _return.MsgInformation = "Can not save data <<Duplication>>!"; } else { //item.UserAdded = tmpLogin.Id; //item.UserAddedTime = DateTime.Now; //item.UserUpdate = tmpLogin.Id; //item.UserUpdateTime = DateTime.Now; // int MaxID = items.Count() == 0 ? 0 : items.Max(x => x == null ? 0 :(int)x.Seq); // item.Seq = MaxID + 1; // item.VoucherId = "I" +item.Seq.ToString(); dbContext.Entry(item).State = System.Data.Entity.EntityState.Added; } } else if (item.UpdateStatus == "Modified") { //item.UserUpdate = tmpLogin.Id; //item.UserUpdateTime = DateTime.Now; dbContext.Entry(item).State = System.Data.Entity.EntityState.Modified; //dbContext.Entry(item).Property(x => x.Seq).IsModified = false; //dbContext.Entry(item).Property(x => x.UserAdded).IsModified = false; //dbContext.Entry(item).Property(x => x.UserAddedTime).IsModified = false; //dbContext.Entry(item).Property(x => x.Isdel).IsModified = false; } else if (item.UpdateStatus == "Deleted") { dbContext.Entry(item).State = System.Data.Entity.EntityState.Deleted; } else { dbContext.Entry(item).State = System.Data.Entity.EntityState.Unchanged; } //========================= if (_return.IsError != true) { dbContext.SaveChanges(); _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, false); } } } catch (Exception err) { _return = new SSBC_Data.SourceContext.MSG(item.UpdateStatus, true); _return.MsgInformation += "\n " + err.ToString(); } return(_return); }