public void RefreshCBox()
{
switch (YearSource)
{
case YearsOf.Components:
ListHelper.FillMetroCombo(mcboYear, combal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
case YearsOf.MaintainanceTable:
switch (YearofMaintenanceTable_Sub)
{
case MaintainanceTableSub.PlasticInjection:
ListHelper.FillMetroCombo(mcboYear, pibal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
case MaintainanceTableSub.VacuumPlating:
ListHelper.FillMetroCombo(mcboYear, vpbal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
case MaintainanceTableSub.Assembly:
ListHelper.FillMetroCombo(mcboYear, assybal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
}
break;
case YearsOf.ProcessSetup:
ListHelper.FillMetroCombo(mcboYear, procbal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
case YearsOf.Items:
ListHelper.FillMetroCombo(mcboYear, itmbal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
break;
}
}
private void RefreshCBox()
{
try
{
ListHelper.FillMetroCombo(mcboYear, itmbal.GetAll().Select(i => new { i.YEARUSED }).Distinct().OrderByDescending(m => m.YEARUSED).Where(i => i.YEARUSED != UserSettings.LogInYear && i.YEARUSED < UserSettings.LogInYear).ToList(), "YEARUSED", "YEARUSED");
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
}
public void RefreshGrid()
{
try
{
var list = itmbal.GetAll().Select(s => new { s.YEARUSED, s.ItemNo, Selection = "Load" }).Where(w => w.ItemNo == itemno).ToList();
mgridList.DataSource = list;
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
}
public void RefreshGrid()
{
try
{
switch (KindOfList)
{
#region Materials/ Compo
case "CL":
var list_CL = combal.GetAll().Select(i => new
{
i.DocID,
i.YEARUSED,
Part_No = i.PartNo,
Name = i.PartName,
Whddd_Qty = i.WholeQty,
Whddd_Unit = i.WholeUnit,
Conddd_Qty = i.ConversionQty,
Conddd_Unit = i.ConversionUnit,
Whddd_Price = i.WholePrice,
Conddd_Price = i.ConversionPrice,
Prevddd_Price = i.PreviousPrice,
Locked = i.IsLocked,
}
).OrderBy(m => m.DocID).Where(r => r.YEARUSED == UserSettings.LogInYear).ToList();
this.mgridList.DataSource = list_CL;
break;
#endregion
#region Plastic Injection
case "MT_PI":
var list_PI = pibal.GetAll().Select(i => new
{
i.DocID,
i.YEARUSED,
Mold_No = i.MoldNo,
Mold_Name = i.MoldName,
i.Oz,
Purge_Per_Gram = i.PurgePerG,
Shots_Per_Hour = i.SPH,
Cavity = i.Cavity,
Pieces_Per_Hour = i.PPH,
}).OrderBy(m => m.DocID).Where(r => r.YEARUSED == UserSettings.LogInYear).ToList();
mgridList.DataSource = list_PI;
break;
#endregion
#region Vacuum Plating
case "MT_VP":
var list_VP = vpbal.GetAll().Select(i => new
{
DocID = i.DocID,
YEARUSED = i.YEARUSED,
Part_No = i.PartNo,
Part_Name = i.PartName,
Source_Data = i.SourceData,
}).OrderBy(m => m.DocID).Where(r => r.YEARUSED == UserSettings.LogInYear).ToList();
mgridList.DataSource = list_VP;
break;
#endregion
#region Assymbly
case "MT_ASSY":
var list_ASSY = assybal.GetAll().Select(i => new
{
DocID = i.DocID,
YEARUSED = i.YEARUSED,
Part_No = i.PartNo,
Part_Name = i.PartName,
Rate_Per_Hour = i.RATEPERHOUR,
}).OrderBy(m => m.DocID).Where(r => r.YEARUSED == UserSettings.LogInYear).ToList();
mgridList.DataSource = list_ASSY;
break;
#endregion
#region MPT
case "MPT":
var list_MR = mrbal.GetAll().Select(i => new
{
Code = i.SectionCode,
Description = i.Description,
Time = i.Time,
Active = i.IsActive,
IsCosting = i.IsCosting
}).Distinct().OrderBy(m => m.Code).ToList();
this.mgridList.DataSource = list_MR;
break;
#endregion
#region Items
case "ITEM":
int yeartouse = UserSettings.LogInYear;
if (IsPrevious)
{
yeartouse = PreviousYear;
}
var list_ITEM = itembal.GetAll().Select(i => new
{
i.DocID,
i.YEARUSED,
i.ItemNo,
i.Description,
i.IsLocked
}).Where(w => w.YEARUSED == yeartouse).Distinct().OrderBy(m => m.Description).ToList();
DataTable itmTable = new DataTable();
using (var reader = ObjectReader.Create(list_ITEM,
"DocID",
"YEARUSED",
"ItemNo",
"Description",
"IsLocked"))
{
itmTable.Load(reader);
mgridList.DataSource = itmTable;
}
break;
#endregion
#region
case "CAT":
var list_CAT = catbal.GetAll().Select(i => new
{
DocID = i.RecID,
i.YEARUSED,
Code = i.CATCODE,
Description = i.CATDESC
}).Where(w => w.YEARUSED == PreviousYear).Distinct().OrderBy(m => m.Code).ToList();
DataTable catTable = new DataTable();
using (var reader = ObjectReader.Create(list_CAT,
"DocID",
"YEARUSED",
"Code",
"Description"))
{
catTable.Load(reader);
mgridList.DataSource = catTable;
}
break;
#endregion
}
ColumnManager();
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
}
private void bindGrid()
{
DataTable data = item.GetAll();
dgvItem.DataSource = data;
}
