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