public void gettable()
{
DataTable dts = new DataTable();
DataTable dti = new DataTable();
string cmd = "select serno, lot, model, site, factory, line, process, inspectdate from laa10_003201908 where serno like 'K820%' and inspectdate > '2019-08-20 06:00' and inspectdate < '2019-08-20 12:00'";
dts = ConnectionDataTableSql.callsql(cmd);
string cmd2 = "select serno, inspectdate, inspect, inspectdata from laa10_003201908data where serno like 'K820%' and inspectdate > '2019-08-20 06:00' and inspectdate < '2019-08-20 12:00'";
dti = ConnectionDataTableSql.callsql(cmd2);
DataTable view = dti.DefaultView.ToTable(true, "inspect");
for (int i = 0; i < view.Rows.Count; i++)
{
dts.Columns.Add(view.Rows[i]["inspect"].ToString());
}
for (int row = 0; row < dts.Rows.Count; row++)
{
for (int irow = 0; irow < dti.Rows.Count; irow++)
{
if (dts.Rows[row]["serno"].ToString() == dti.Rows[irow]["serno"].ToString())
{
for (int col = 0; col < dts.Columns.Count; col++)
{
if (dts.Columns[col].ToString() == dti.Rows[irow]["inspect"].ToString())
{
dts.Rows[row][col] = dti.Rows[irow]["inspectdata"].ToString();
}
}
}
}
}
ds = dts;
}
/// <summary>
/// Get model list
/// </summary>
void ModelList()
{
DataTable dt = ConnectionDataTableSql.callsql("select distinct model from procinsplink");
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbModel.Items.Add(dt.Rows[i]["model"]);
}
}
/// <summary>
/// Get treeview
/// </summary>
/// <param name="model"></param>
void GetTreeview(string model)
{
if (model != "")
{
TreeNode root = new TreeNode(model);
trInspect.Nodes.Add(root);
DataTable dt = ConnectionDataTableSql.callsql("select distinct inspect from procinsplink"
+ " where model = '" + model + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
root.Nodes.Add(dt.Rows[i]["inspect"].ToString());
}
}
}
public void gettable()
{
string serno = multxt();
string inspect = inspects();
DataTable dts = new DataTable();
DataTable dti = new DataTable();
string cmd;
string cmd2;
if (serno != "''")
{
cmd = "select serno, lot, model, site, factory, line, process, inspectdate from " + sernodb + " where serno in(" + serno + ") ";
cmd2 = "select serno, inspectdate, inspect, inspectdata from " + inspectdb + " where serno in(" + serno + ") and inspect in(" + inspect + ")";
}
else if (serno == "''" && datef != "" && datet != "")
{
cmd = "select serno, lot, model, site, factory, line, process, inspectdate from " + sernodb + " where inspectdate > '" + datef + "' and inspectdate < '" + datet + "'";
cmd2 = "select serno, inspectdate, inspect, inspectdata from " + inspectdb + " where inspect in(" + inspect + ") and inspectdate > '" + datef + "' and inspectdate < '" + datet + "'";
}
else
{
cmd = "select serno, lot, model, site, factory, line, process, inspectdate from " + sernodb;
cmd2 = "select serno, inspectdate, inspect, inspectdata from " + inspectdb + " where inspect in(" + inspect + ")";
}
dts = ConnectionDataTableSql.callsql(cmd);
dti = ConnectionDataTableSql.callsql(cmd2);
DataTable view = dti.DefaultView.ToTable(true, "inspect");
for (int i = 0; i < view.Rows.Count; i++)
{
dts.Columns.Add(view.Rows[i]["inspect"].ToString());
}
//string filename = "data";
//string path = filename + ".csv";
//if (File.Exists(path))
//{
// filename = filename + 1;
// path = filename + "csv";
//}
//using (StreamWriter sw = new StreamWriter(path, false, Encoding.UTF8))
{
for (int row = 0; row < dts.Rows.Count; row++)
{
for (int irow = 0; irow < dti.Rows.Count; irow++)
{
if (dts.Rows[row]["serno"].ToString() == dti.Rows[irow]["serno"].ToString())
{
for (int col = 0; col < dts.Columns.Count; col++)
{
if (dts.Columns[col].ToString() == dti.Rows[irow]["inspect"].ToString())
{
dts.Rows[row][col] = dti.Rows[irow]["inspectdata"].ToString();
//sw.WriteLine(dts.Rows[row]);
//sw.Flush();
}
}
}
}
}
//sw.Close();
}
ds = dts;
}