public void LoadDataNG()
{
frm_Loading loading = new frm_Loading();
loading.ShowDialog();
string sql = "SELECT id,Wodate,shift,keycode,modelcode,modelcheck,checktime,linename,empname FROM tb_datamix where wodate between '" + fromdate + "' and '" + todate + "' and shift like '%" + GetShift() + "%' and modelcode like '%" + txtCheck.Text.Trim().ToUpper() + "%'";
DataTable dt = conn.GetDataTable(sql);
dgvNG.DataSource = dt;
}
//DataTable datagood,datang;
public void LoadData()
{
frm_Loading loading = new frm_Loading();
loading.ShowDialog();
string sql = "SELECT Wodate,shift,keycode,modelcode,goodqty,defqty,mixqty,total,starttime,endtime,linename,empname FROM tb_datachecked where wodate between '" + fromdate + "' and '" + todate + "' and shift like '%" + GetShift() + "%' and modelcode like '%" + txtCheck.Text.Trim().ToUpper() + "%' order by wodate desc,starttime desc";
DataTable dt = conn.GetDataTable(sql);
dgvData.DataSource = dt;
}