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