public string getMaNV_DN(string uid) { System.Data.DataTable dt = new System.Data.DataTable(); dt = dao.executeQueryDataSet(string.Format("select [dbo].[f_getMaNV_TheoLogin]('{0}')", uid)).Tables[0]; return(dt.Rows[0][0].ToString()); }
public DataSet getDVT() { return(da.executeQueryDataSet("select * from f_showDVT()")); }
public DataSet getLoaiThuoc() { return(da.executeQueryDataSet("select * from f_showLoaiThuoc()")); }
public DataSet getMAXCau() { string sql = string.Format("select MAX(MaCauHoi) from tblNganHangCauHoi"); return(da.executeQueryDataSet(sql)); }
public DataSet getLichTruc(string MaNV) { return(da.executeQueryDataSet(string.Format("select * from f_showLichTruc('{0}')", MaNV))); }
public DataSet getChiTietHoaDon(string MaHD) { return(da.executeQueryDataSet("select * from f_showCTHD('" + MaHD + "')")); }
public DataSet getAllThongTu() { string sql = string.Format("select * from tblThongTu order by Ngay desc"); return(da.executeQueryDataSet(sql)); }
public DataSet getLichTaiKham() { return(da.executeQueryDataSet("select * from f_showLichTaiKham()")); }
public DataSet getThongTu() { string sql = string.Format("select * from tblThongTu"); return(da.executeQueryDataSet(sql)); }
public DataSet getAllUser() { string sql = string.Format("select UserName, HoTen, QueQuan, NgaySinh, Avatar from tblTaiKhoan where UserName!=N'ADMIN'"); return(da.executeQueryDataSet(sql)); }
public int getMaLanThiMoiNhat() { string sql = string.Format("select [dbo].[F_LayMaLanThiMoiNhat]()"); return(da.executeQueryDataSet(sql).Tables[0].Rows.Count > 0 ?int.Parse(da.executeQueryDataSet(sql).Tables[0].Rows[0][0].ToString()):-1); }
public DataSet getBenhNhan() { return(da.executeQueryDataSet("select * from f_showBenhNhan()")); }
public DataSet getNhanVien() { return(da.executeQueryDataSet("select * from f_showNhanVien()")); }
public DataSet getHoaDon() { return(da.executeQueryDataSet("select * from f_showHD()")); }
public DataSet getChiTietThuoc() { return(da.executeQueryDataSet("select * from f_showChiTietThuoc()")); }
public DataSet getAllLanThiUser(string user) { string sql = string.Format("select MaLanThi, Diem from tblThiTracNghiem where UserName='******'", user); return(da.executeQueryDataSet(sql)); }
public DataSet infoUser(string username) { string sql = string.Format("select * from tblTaiKhoan where Username=N'{0}' ", username); return(da.executeQueryDataSet(sql)); }
public DataSet LayLoaiKinhNghiem() { string sql = string.Format("select * from tblLoaiKinhNghiem"); return(da.executeQueryDataSet(sql)); }