public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select dept.* " + "From " + dept.table + " dept " + " " + "Where dept." + dept.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return dt; }
//public DataTable selectAll() //{ // DataTable dt = new DataTable(); // String sql = "select foo.* " + // "From " + ord.table + " foo " + // " " + // "Where foo." + ord.active + " ='1' "; // dt = conn.selectData(conn.conn, sql); // return dt; //} public DataTable selectByPk(String copId) { DataTable dt = new DataTable(); String sql = "select foo.* " + "From " + ord.table + " foo " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where foo." + ord.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select sex.* " + "From " + sex.table + " sex " + " " + "Where sex." + sex.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select cop.* " + "From " + cop.table + " cop " + " " + "Where cop." + cop.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select foo.* " + "From " + bil.table + " foo " + " " + "Where foo." + bil.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select posi.* " + "From " + posi.table + " posi " + " " + "Where posi." + posi.active + " ='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select noom.* " + "From " + noom.table + " noom " + " " + "Where noom." + noom.active + " ='1' " + "Order By noom." + noom.noodle_make_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select foos.* " + "From " + matt.table + " foos " + " " + "Where foos." + matt.active + " ='1' " + "Order By foos." + matt.material_type_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select fooC.* " + "From " + fooC.table + " fooC " + " " + "Where fooC." + fooC.active + " ='1' " + "Order By fooC." + fooC.sort1; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectByYearId(String yearid) { DataTable dt = new DataTable(); String sql = "select matr.*, sum(matrd.price * matrd.qty) as total1, count(matr_code) as cnt " + "From " + matr.table + " matr " + "Left Join t_material_rec_detail matrd on matr.matr_id = matrd.matr_id " + "Where matr." + matr.active + " ='1' and matr." + matr.year_id + "='" + yearid + "' and matrd.active = '1'" + "Group By matr.matr_code " + "Order By matr.matr_id desc"; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select foos.* " + "From " + stkc.table + " foos " + " " + "Where foos." + stkc.qty + " ='1' " + "Order By foos." + stkc.stock_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAll() { DataTable dt = new DataTable(); String sql = "select foos.* " + "From " + foos.table + " foos " + " " + "Where foos." + foos.active + " ='1' " + "Order By foos." + foos.foods_spec_id; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectByCategory(String catid) { DataTable dt = new DataTable(); String sql = "select foo.* " + "From " + foo.table + " foo " + " " + "Where foo." + foo.active + " ='1' and foo." + foo.foods_cat_id + "='" + catid + "' and foo." + foo.status_to_go + "='1' "; dt = conn.selectData(conn.conn, sql); return(dt); }
public DataTable selectAllEmbryo() { DataTable dt = new DataTable(); String sql = "select stf.* " + "From " + stf.table + " stf " + "LEft Join b_position posi on posi.posi_id = stf.posi_id " + " " + "Where stf." + stf.active + " ='1' and posi.status_embryologist = '1' "; dt = conn.selectData(conn.conn, sql); return(dt); }