private void Form1_Load(object sender, EventArgs e)
{
TfSQL tfSql = new TfSQL();
string sqlCMBMC = "select distinct machine from adruino";
tfSql.getComboBoxData(sqlCMBMC, ref cmbMC);
loadDGV(false, DateTime.Now.ToShortDateString() + " 06:00:00", "");
loadDGV_NG(false, DateTime.Now.ToShortDateString() + " 06:00:00", "");
}
public void loadDGV_NG(bool s_date, string dateFrom, string dateTo)
{
TfSQL tfSql = new TfSQL();
string sqlSearch = "select * from adruino_ng where 1=1 ";
if (s_date)
{
sqlSearch += " and date_time >= '" + dateFrom + "' and date_time <= '" + dateTo + "'";
}
else
{
sqlSearch += " and date_time >= '" + dateFrom + "'";
}
sqlSearch += " order by date_time desc";
DataTable dt = new DataTable();
tfSql.sqlDataAdapterFillDatatable(sqlSearch, ref dt);
dgv_NG.DataSource = dt;
/*
* dgv.Columns["machine"].HeaderText = "Machine";
* dgv.Columns["ng1"].HeaderText = "NG1";
* dgv.Columns["ng2"].HeaderText = "NG2";
* dgv.Columns["ng3"].HeaderText = "NG3";
* dgv.Columns["ng4"].HeaderText = "NG4";
* dgv.Columns["ng5"].HeaderText = "NG5";
* dgv.Columns["ng6"].HeaderText = "NG6";
* dgv.Columns["ng7"].HeaderText = "NG7";
* dgv.Columns["ng8"].HeaderText = "NG8";
*/
dgv_NG.Columns["date_time"].HeaderText = "Date Time";
if (dgv_NG.RowCount > 0)
{
int tong = 0;
for (int i = 0; i < dgv_NG.RowCount; i++)
{
for (int j = 1; j < dgv_NG.ColumnCount; j++)
{
if (dgv_NG.Rows[i].Cells[j].Value.ToString() == "1")
{
tong++;
}
}
}
txt_ng.Text = (tong).ToString();
}
ShowChartNG();
}
public void loadDGV(bool s_date, string dateFrom, string dateTo)
{
TfSQL tfSql = new TfSQL();
string sqlSearch = "select * from adruino where 1=1 ";
if (s_date)
{
sqlSearch += " and date_time >= '" + dateFrom + "' and date_time <= '" + dateTo + "'";
}
else
{
sqlSearch += " and date_time >= '" + dateFrom + "'";
}
sqlSearch += " order by date_time desc";
DataTable dt = new DataTable();
tfSql.sqlDataAdapterFillDatatable(sqlSearch, ref dt);
dgv.DataSource = dt;
dgv.Columns["machine"].HeaderText = "Machine";
dgv.Columns["data_"].HeaderText = "Data";
dgv.Columns["date_time"].HeaderText = "Date Time";
if (dgv.RowCount > 0)
{
int tong = 0;
for (int i = 0; i < dgv.RowCount; i++)
{
if (dgv.Rows[i].Cells["data_"].Value.ToString() == "1")
{
tong++;
}
}
txtQty.Text = (tong * 6).ToString();
}
ShowChartOutput();
}
