private void getdatatable(ref DataTable dt1, ref DataTable dt2, string tb1, string dfr, string dto)
{
dt1.Clear();
dt2.Clear();
string serno = multxt();
string inspect = inspects(ref inslist);
string tb2 = tb1 + "data";
string cmd = "select serno, lot, model, site, factory, line, process, inspectdate from "
+ tb1 + " where 1=1 ";
string cmd2 = "select serno, inspectdate, inspect, inspectdata from " + tb2 + " where 1=1 ";
if (serno != "")
{
cmd += "and serno in(" + serno + ") order by inspectdate asc ";
cmd2 += "and serno in(" + serno + ") and inspect in(" + inspect + ") order by inspect asc, inspectdate asc";
}
else
{
cmd += "and inspectdate > '" + dfr + "' and inspectdate < '" + dto
+ "' order by inspectdate asc";
cmd2 += "and inspect in(" + inspect + ") and inspectdate > '" + dfr + "' and inspectdate < '" + dto + "' order by inspect asc, inspectdate asc";
}
sql.sqlDataAdapterFillDatatable(cmd, ref dt1);
sql.sqlDataAdapterFillDatatable(cmd2, ref dt2);
}
private void GetDatatable(string tb1, ref DataTable table, string dfrom, string dto)
{
string tb2 = tb1 + "data";
string cmd = "select a.*,b.inspectdata from " + tb1 + " a left join " + tb2
+ " b on a.serno = b.serno and a.inspectdate = b.inspectdate where b.inspect ='" + inspect + "'";
if (sernolist != "")
{
cmd += " and a.serno in(" + sernolist + ")";
}
else
{
cmd += " and a.inspectdate > '" + dfrom + "' and a.inspectdate < '" + dto + "'";
}
if (lot != "")
{
cmd += " and a.lot ='" + lot + "'";
}
if (judge == "OK")
{
cmd += " and a.tjudge ='0'";
}
else if (judge == "NG")
{
cmd += " and a.tjudge ='1'";
}
cmd += " order by a.inspectdate asc";
sql.sqlDataAdapterFillDatatable(cmd, ref table);
}
