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