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