public static DataTable GetGVCN()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM NHANVIEN");
return(dt);
}
public static DataTable GetListDichVu()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM DICHVUYTE");
return(dt);
}
public static DataTable GetListHoatDong()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM HOATDONGNGOAIKHOA");
return(dt);
}
public static DataTable GetListLoaiLop()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM LOAILOP");
return(dt);
}
public static string LayMaCuoi()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("select top 1 MaThucDon from THUCDON order by MaThucDon desc");
foreach (DataRow row in dt.Rows)
{
return(row.ItemArray[0].ToString());
}
return("");
}
public static string GetLastID()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("Select top 1 MaDichVu from DICHVUYTE order by MaDichVu desc");
foreach (DataRow row in dt.Rows)
{
return(row.ItemArray[0].ToString());
}
return("");
}
public static bool KiemTraMonAn(string maMonAn)
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("select * from MONAN where MaMonAn = '" + maMonAn.Trim() + "'");
foreach (DataRow row in dt.Rows)
{
return(true);
}
return(false);
}
public static string LayMaCuoi()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("select top 1 MaPhieu from PHIEUMUANL order by MaPhieu desc");
foreach (DataRow row in dt.Rows)
{
return(row.ItemArray[0].ToString());
}
return("");
}
public static string GetLastID()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("Select top 1 MaHoatDong from HOATDONGNGOAIKHOA order by MaHoatDong desc");
foreach (DataRow row in dt.Rows)
{
return(row.ItemArray[0].ToString());
}
return("");
}
public static int GetNamHoc(string maLop)
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT NamHoc FROM LOP WHERE MaLop = '" + maLop + "'");
foreach (DataRow row in dt.Rows)
{
return((int)row[0]);
}
return(-1);
}
public static List <Tre> GetListTre()
{
DataAccessHelper db = new DataAccessHelper();
DataTable dt = db.GetDataTable("SELECT * FROM TRE");
List <Tre> list = new List <Tre>();
foreach (DataRow row in dt.Rows)
{
list.Add(new Tre(row));
}
return(list);
}
