private void UC_Home_Load(object sender, EventArgs e)
{
try
{
DGVFrontGear.ColumnInitial(typeof(TB_GearFront));
DGVFrontCase.ColumnInitial(typeof(TB_FrontCase));
Task.Run(() => ShowData(201910209));
}
catch (Exception ex)
{
StackTrace trace = new StackTrace(ex, true);
StackFrame stackFrame = trace.GetFrame(trace.FrameCount - 1);
int lineNumber = stackFrame.GetFileLineNumber();
I_Home.ErrorLog(($" ({lineNumber}) : {ex.ToString()}"));
}
}
internal async Task ShowData(int iworkdate)
{
try
{
using (GEN2_MEASUREDBEntities db = new GEN2_MEASUREDBEntities())
{
lstGearfrt = await db.TB_GearFront.SqlQuery($"Select * from TB_GearFront ").ToListAsync();
lstFrtCase = await db.TB_FrontCase.SqlQuery($"Select * from TB_FrontCase ").ToListAsync();
for (int i = 0; i < lstGearfrt.Count; i++)
{
List <string> addrow = new List <string>();
addrow.Add(lstGearfrt[i].Insert_Time.ToString());
addrow.Add(lstGearfrt[i].Work_Date.ToString());
addrow.Add(lstGearfrt[i].Work_No.ToString());
addrow.Add(lstGearfrt[i].GearNo_Front.ToString());
addrow.Add(lstGearfrt[i].GearNo_4WD.ToString());
addrow.Add(lstGearfrt[i].Part_Name.ToString());
addrow.Add(lstGearfrt[i].FGear_G4_Min.ToString());
addrow.Add(lstGearfrt[i].FGear_G4_Val.ToString());
addrow.Add(lstGearfrt[i].FGear_G4_Max.ToString());
addrow.Add(lstGearfrt[i].FGear_G2_Min.ToString());
addrow.Add(lstGearfrt[i].FGear_G2_Val.ToString());
addrow.Add(lstGearfrt[i].FGear_G2_Max.ToString());
BeginInvoke((Action)(() =>
{
DGVFrontGear.AddGridrow(addrow.ToArray());
}));
}
for (int i = 0; i < lstFrtCase.Count; i++)
{
List <string> addrow = new List <string>();
addrow.Add(lstFrtCase[i].Insert_Time.ToString());
addrow.Add(lstFrtCase[i].Work_Date.ToString());
addrow.Add(lstFrtCase[i].Work_No.ToString());
addrow.Add(lstFrtCase[i].FrontCase_Bar.ToString());
addrow.Add(lstFrtCase[i].Part_Name.ToString());
addrow.Add(lstFrtCase[i].FCase_4WD_Min.ToString());
addrow.Add(lstFrtCase[i].FCase_4WD_Val.ToString());
addrow.Add(lstFrtCase[i].FCase_4WD_Max.ToString());
addrow.Add(lstFrtCase[i].FCase_G4_Min.ToString());
addrow.Add(lstFrtCase[i].FCase_G4_Val.ToString());
addrow.Add(lstFrtCase[i].FCase_G4_Max.ToString());
BeginInvoke((Action)(() =>
{
DGVFrontCase.AddGridrow(addrow.ToArray());
}));
}
}
}
catch (Exception ex)
{
StackTrace trace = new StackTrace(ex, true);
StackFrame stackFrame = trace.GetFrame(trace.FrameCount - 1);
int lineNumber = stackFrame.GetFileLineNumber();
I_Home.ErrorLog(($" ({lineNumber}) : {ex.ToString()}"));
}
}
