private void viewunderproductioncs_Load(object sender, EventArgs e)
{
if (!BGworker.IsBusy)
{
RetriveTableData TObj = new RetriveTableData();
DGview.Rows.Clear();
BGworker.RunWorkerAsync(TObj);
}
}
private void Viewtoolingisseu_Load(object sender, EventArgs e)
{
if (!BGworker.IsBusy)
{
RetriveTableData TObj = new RetriveTableData();
//SELECT * FROM ToolingReturnedhistory WHERE ToolingIssue_Yes = 'Yes'
DGview.Rows.Clear();
BGworker.RunWorkerAsync(TObj);
}
}
private void BGworker_DoWork(object sender, DoWorkEventArgs e)
{
RetriveTableData Obj = (RetriveTableData)e.Argument;
try
{
SqlConnection connection = new SqlConnection(Mydb.connectionstring);
SqlCommand cmd = new SqlCommand(Querysql, connection);
connection.Open();
using (SqlDataReader Reader = cmd.ExecuteReader())
{
while (Reader.Read())
{
Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim();
Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim();
Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim();
Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim();
Obj.dateTimeReturned1 = Reader["dateTimeReturned"].ToString().Trim();
Obj.Returnby1 = Reader["Returnby"].ToString().Trim();
Obj.ReturnedQTY1 = Reader["ReturnedQTY"].ToString().Trim();
Obj.ToolsStatus1 = Reader["ToolsStatus"].ToString().Trim();
Obj.Reasonnotcompleted1 = Reader["Reasonnotcompleted"].ToString().Trim();
Obj.Usedby1 = Reader["Usedby"].ToString().Trim();
Obj.ToolingIssue_Yes1 = Reader["ToolingIssue_Yes"].ToString().Trim();
Obj.TechnicianansFeedback1 = Reader["TechnicianansFeedback"].ToString().Trim();
Obj.Lifetimeusage1 = Reader["Lifetimeusage"].ToString().Trim();
System.Threading.Thread.Sleep(100);
BGworker.ReportProgress(0, Obj);
}
connection.Close();
}
}
catch (Exception)
{
throw;
}
}
private void BGworker_DoWork(object sender, DoWorkEventArgs e)
{
RetriveTableData Obj = (RetriveTableData)e.Argument;
try
{
SqlConnection connection = new SqlConnection(Mydb.connectionstring);
SqlCommand cmd = new SqlCommand(Querysql, connection);
connection.Open();
using (SqlDataReader Reader = cmd.ExecuteReader())
{
while (Reader.Read())
{
Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim();
Obj.StorageLocation1 = Reader["StorageLocation"].ToString().Trim();
Obj.ActualToolsQty1 = Reader["ActualToolsQty"].ToString().Trim();
Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim();
Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim();
Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim();
Obj.DateTimeout1 = Reader["DateTimeout"].ToString().Trim();
Obj.TakenBy1 = Reader["TakenBy"].ToString().Trim();
Obj.ToolingoutQty1 = Reader["ToolingoutQty"].ToString().Trim();
Obj.WONumber1 = Reader["WONumber"].ToString().Trim();
Obj.WOQty1 = Reader["WOQty"].ToString().Trim();
Obj.Note1 = Reader["Note"].ToString().Trim();
Obj.Status1 = Reader["Status"].ToString().Trim();
System.Threading.Thread.Sleep(100);
BGworker.ReportProgress(0, Obj);
}
connection.Close();
}
}
catch (Exception)
{
throw;
}
}
