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); }