/// <summary>
/// hàm thực hiện việc lấy thôgn tin của phường xã
/// </summary>
/// <param name="MaQuanHuyen"></param>
/// <returns></returns>
public static DataTable LayThongTinPhuongXa(string MaQuanHuyen)
{
SqlQuery sqlQuery = new Select().From(DDviDchinh.Schema)
.Where(DDviDchinh.Columns.LoaiDviDchinh).IsEqualTo("PX").And(DDviDchinh.Columns.MaCha).IsEqualTo(MaQuanHuyen)
.OrderAsc(DDviDchinh.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List<string> LAYDSACH_IDKHOTHUOC_CHAN()
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(new Select(QheNhanvienKho.Columns.IdKho)
.From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
if (sqlQuery.HasWhere)
sqlQuery.And(TDmucKho.Columns.KieuKho).In(lstKhochan);
else
{
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhochan);
}
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
if (m_dtKhoThuoc.Rows.Count <= 0) return new List<string>();
return m_dtKhoThuoc.AsEnumerable().Select(c => c.Field<string>(TDmucKho.Columns.IdKho)).ToList<string>();
}
public static DataTable GetStaffListbyDepartmentId(int departmentId)
{
DataTable dataTable = new DataTable();
SqlQuery sqlQuery = new Select().From(DmucNhanvien.Schema)
.Where(DmucNhanvien.Columns.IdKhoa).IsEqualTo(departmentId);
dataTable = sqlQuery.ExecuteDataSet().Tables[0];
return dataTable;
}
private void IntitalData()
{
SqlQuery sqlQuery = new Select().From(LObjectType.Schema).OrderAsc(LObjectType.Columns.SName);
sqlQuery = new Select().From(TTestTypeList.Schema).Where(TTestTypeList.Columns.TestTypeId).IsEqualTo(2).Or(TTestTypeList.Columns.TestTypeId).IsEqualTo(5).OrderAsc(TTestTypeList.Columns.IntOrder);
//DataBinding.BindDataCombox(cboLoaiXetnghiem, sqlQuery.ExecuteDataSet().Tables[0], TTestTypeList.Columns.TestTypeId,
// TTestTypeList.Columns.TestTypeName);
DataBinding.BindDataCombobox(cboLoaiXetnghiem, sqlQuery.ExecuteDataSet().Tables[0], TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName);
}
/// <summary>
/// hàm thực hêện tìm kiếm thông tin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdSearch_Click(object sender, EventArgs e)
{
SqlQuery sqlQuery = new Select().From(RISLink.DataAccessLayer.ErrorLog.Schema)
.Where(RISLink.DataAccessLayer.ErrorLog.Columns.ErrorCode).IsEqualTo(cboKieu.SelectedValue)
.And(RISLink.DataAccessLayer.ErrorLog.Columns.ErrorTime).IsBetweenAnd(dtFromDate.Value.Date,
dtToDate.Value.Date);
m_dtErrorLog = sqlQuery.ExecuteDataSet().Tables[0];
grdLogError.DataSource = m_dtErrorLog;
}
private void cboKhoaNoiTru_SelectedIndexChanged(object sender, EventArgs e)
{
if (bHasloaded)
{
SqlQuery sqlQuery = new Select().From(NoitruDmucBuong.Schema)
.Where(NoitruDmucBuong.Columns.IdKhoanoitru).IsEqualTo(Utility.Int32Dbnull(cboKhoaNoiTru.SelectedValue));
DataBinding.BindDataCombobox(cboPhongNoiTru, sqlQuery.ExecuteDataSet().Tables[0], NoitruDmucBuong.Columns.IdBuong,
NoitruDmucBuong.Columns.TenBuong, "Chọn phòng nội trú",true);
// IntialDataControl();
}
}
/// <summary>
/// LẤY THÔNG TIN của khoa gửi thông tin
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinKhoaGUI()
{
SqlQuery sqlQuery = new Select().From(DPhongBan.Schema)
.Where(DPhongBan.Columns.KieuPban).IsEqualTo("KHOA")
.And(DPhongBan.Columns.LoaiPban).IsEqualTo("GUI")
.OrderAsc(DPhongBan.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// lấy thông tin của loại dịch vụ
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinLoaiDichVu()
{
SqlQuery sqlQuery = new Select().From(DLoaiDvu.Schema)
.OrderAsc(DLoaiDvu.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// hàm thực hiện việc lấy thông tin của vùng khảo sát
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinVungKS()
{
SqlQuery sqlQuery = new Select().From(DVungKsat.Schema)
.OrderAsc(DVungKsat.Columns.TenVungKs);
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LayThongDichVu()
{
DataTable dataTable=new DataTable();
DataTable DataLoaiDV=new DataTable();
// DataLoaiDV = LayThongTinLoaiDichVu();
SqlQuery sqlQuery = new Select(DDichVu.Columns.TenDvu,DDichVu.Columns.IdVungKs,DDichVu.Columns.TrangThai,DDichVu.Columns.SttHthi,DLoaiDvu.Columns.MaLoaiDvu,DDichVu.Columns.IdDvu, DDichVu.Columns.MaDvu,DDichVu.Columns.IdLoaiDvu,
DLoaiDvu.Columns.TenLoaiDvu).From(DDichVu.Schema)
.LeftOuterJoin(DLoaiDvu.IdLoaiDvuColumn, DDichVu.IdLoaiDvuColumn);
dataTable = sqlQuery.ExecuteDataSet().Tables[0];
return dataTable;
}
/// <summary>
///
/// </summary>
/// <param name="dauphancach"></param>
/// <returns></returns>
public static string LAYDSACH_MAKHOTHUOC_LE_NOITRU(string dauphancach)
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(new Select(QheNhanvienKho.Columns.IdKho)
.From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
if (sqlQuery.HasWhere)
sqlQuery.And(TDmucKho.Columns.KieuKho).In(lstKhole);
else
{
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhole);
}
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0).And(TDmucKho.Columns.LoaiBnhan).In(lstKhoNoitru);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
if (m_dtKhoThuoc.Rows.Count <= 0) return "";
return string.Join(dauphancach, m_dtKhoThuoc.AsEnumerable().Select(c => c.Field<string>(TDmucKho.Columns.MaKho)).ToList<string>().ToArray());
}
/// <summary>
/// /hàm thực hiện lấy thông tin của thiết bị
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinThietBi()
{
// SqlQuery sqlQueryNhanVien = new Select(DNhanVien.Columns.Uid).From(DNhanVien.Schema);
SqlQuery sqlQuery = new Select().From(DDmucChung.Schema)
.Where(DDmucChung.Columns.TrangThai).IsEqualTo(1)
.And(DDmucChung.Columns.Loai).IsEqualTo("THIET_BI")
.OrderAsc(DDmucChung.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LayThongTinNhanVienByStaffID(short Staff_ID)
{
SqlQuery sqlQuery = new Select().From(LStaff.Schema)
.Where(LStaff.Columns.StaffId).IsEqualTo(Staff_ID)
.OrderAsc(LStaff.Columns.StaffName);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// HÀM THỰC HIỆN LẤY THÔNG TIN KHO LẺ
/// </summary>
/// <returns></returns>
public static DataTable LAYTHONGTIN_KHOTHUOC_LE_TUTRUC_NOITRU()
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(new Select(QheNhanvienKho.Columns.IdKho)
.From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
if (sqlQuery.HasWhere)
sqlQuery.And(TDmucKho.Columns.KieuKho).In(lstKhole);
else
{
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhole);
}
sqlQuery.And(TDmucKho.Columns.LoaiBnhan).In(lstKhoNoitru);
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
return m_dtKhoThuoc;
}
/// <summary>
/// hàm thực hiện việc lấy thông tin của dược
/// </summary>
/// <returns></returns>
///
public static DataTable LAYTHONGTIN_KHOTHUOC_TATCA()
{
DataTable m_dtKhoThuoc=new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if(!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(
new Select(QheNhanvienKho.Columns.IdKho).From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc=sqlQuery.ExecuteDataSet().Tables[0];
return m_dtKhoThuoc;
}
/// <summary>
/// hàm thực hiện việc lấy thông tin bác sỹ theo khoa chỉ định
/// </summary>
/// <param name="Department_ID"></param>
/// <returns></returns>
public static DataTable LAYTHONGTIN_BACSYTheoKhoaChiDinh(int Department_ID)
{
SqlQuery sqlQuery = new Select().From(LStaff.Schema)
.Where(LStaff.Columns.DepartmentId).IsEqualTo(Department_ID).OrderAsc(LStaff.Columns.StaffName);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// HÀM THỰC HIỆN LẤY THÔNG TIN KHO LẺ
/// </summary>
/// <returns></returns>
public static DataTable LAYTHONGTIN_KHOTHUOC_LE_NGOAI_TRU_KEDON(string MA_DTUONG)
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(new Select(QheNhanvienKho.Columns.IdKho)
.From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
if (sqlQuery.HasWhere)
sqlQuery.And(TDmucKho.Columns.KieuKho).In(lstKhole);
else
{
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhole);
}
if (MA_DTUONG.Trim().ToUpper() != "ALL")
{
sqlQuery.And(TDmucKho.Columns.IdKho).In(new Select(QheDoituongKho.IdKhoColumn).From(QheDoituongKho.Schema).Where(QheDoituongKho.MaDoituongKcbColumn).IsEqualTo(MA_DTUONG));
}
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0)
.And(TDmucKho.Columns.LoaiBnhan).In(lstKhoNgoaitru);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
return m_dtKhoThuoc;
}
/// <summary>
/// hàm thwucj hiện việc lấy thông tin quan hệ kho theo nhân viên
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinQuanHeKHoTheoNhanVien()
{
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(
new Select(QheNhanvienKho.Columns.IdKho).From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LaythongtinQuanheDoituongKhoBanTaiQuay(string MaDoiTuong)
{
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
sqlQuery.Where(TDmucKho.Columns.IdKho).In(
new Select(QheDoituongKho.Columns.IdKho).From(QheDoituongKho.Schema).Where(QheDoituongKho.Columns.MaDoituongKcb)
.IsEqualTo(MaDoiTuong)).And(TDmucKho.Columns.LaQuaythuoc).IsEqualTo(1);
if(!globalVariables.IsAdmin)
{
sqlQuery.And(TDmucKho.Columns.IdKho).In(
new Select(QheNhanvienKho.Columns.IdKho).From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien).IsEqualTo(
globalVariables.gv_intIDNhanvien));
}
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// hàm thực hiện việc lấy uqna hệ đối tượng và kho thuốc
/// </summary>
/// <param name="MaDoiTuong"></param>
/// <returns></returns>
public static DataTable LaythongtinQuanheDoituongKho(string MaDoiTuong)
{
SqlQuery sqlQuery=new Select().From(TDmucKho.Schema);
if(!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(
new Select(QheDoituongKho.Columns.IdKho).From(QheDoituongKho.Schema).Where(QheDoituongKho.Columns.MaDoituongKcb)
.IsEqualTo(MaDoiTuong));
}
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// HÀM THỰC HIỆN VIỆC LẤY THÔNG TIN CỦA PHÒNG THỰC HIỆN
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinPhongThucHien()
{
SqlQuery sqlQuery = new Select().From(DPhongBan.Schema)
.Where(DPhongBan.Columns.KieuPban).IsEqualTo("PHONG")
.And(DPhongBan.Columns.LoaiPban).IsEqualTo("THUCHIEN")
.OrderAsc(DPhongBan.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LayThongTinQuyenNhanVien()
{
SqlQuery sqlQuery = new Select().From(DmucChung.Schema)
.Where(DmucChung.Columns.Loai).IsEqualTo("QUYEN_NHAN_VIEN");
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// hàm thực hiện lấy thông tin của User
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinUser()
{
// SqlQuery sqlQueryNhanVien = new Select(DNhanVien.Columns.Uid).From(DNhanVien.Schema);
SqlQuery sqlQuery = new Select().From(SysUser.Schema)
.OrderAsc(SysUser.Columns.PkSuid);
return sqlQuery.ExecuteDataSet().Tables[0];
}
/// <summary>
/// HÀM THỰC HIỆN LẤY THÔNG TIN KHO LẺ
/// </summary>
/// <returns></returns>
public static DataTable LAYTHONGTIN_KHOTHUOC_VATTU_NOITRU_THEOKHOA(int ID_KHOA)
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
if (!globalVariables.IsAdmin)
{
sqlQuery.Where(TDmucKho.Columns.IdKho).In(new Select(QheNhanvienKho.Columns.IdKho)
.From(QheNhanvienKho.Schema).Where(QheNhanvienKho.Columns.IdNhanvien)
.IsEqualTo(globalVariables.gv_intIDNhanvien));
}
if (sqlQuery.HasWhere)
sqlQuery.And(TDmucKho.Columns.KieuKho).In(lstKhole);//Kho lẻ
else
{
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhole);
}
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0)//Không lấy tủ thuốc
.And(TDmucKho.Columns.LoaiBnhan).In(lstKhoNoitru);//Chỉ lấy các kho nội trú
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuocVT);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
DataTable dt_khovattu=LAYTHONGTIN_VATTU_KHOA(ID_KHOA);
if(dt_khovattu!=null)
{
foreach(DataRow dr in dt_khovattu.Rows)
m_dtKhoThuoc.ImportRow(dr);
}
return m_dtKhoThuoc;
}
/// <summary>
/// hàm thực hiện việc lấy thông tin thiết bị theo khoa phòng
/// </summary>
/// <param name="IDKhoaThucHien"></param>
/// <returns></returns>
public static DataTable LayThongTinThietBiTheoPhong(int IDKhoaThucHien)
{
// SqlQuery sqlQueryNhanVien = new Select(DNhanVien.Columns.Uid).From(DNhanVien.Schema);
SqlQuery sqlQueryPBanTBi = new Select(DPbanThietbi.Columns.MaTbi)
.From(DPbanThietbi.Schema);
if(!globalVariables.IsAdmin)
{
sqlQueryPBanTBi.Where(DPbanThietbi.Columns.IdKhoa).IsEqualTo(IDKhoaThucHien);
}
SqlQuery sqlQuery = new Select().From(DDmucChung.Schema)
.Where(DDmucChung.Columns.TrangThai).IsEqualTo(1)
.And(DDmucChung.Columns.Loai).IsEqualTo("THIET_BI")
.And(DDmucChung.Columns.Ma).In(sqlQueryPBanTBi)
.OrderAsc(DDmucChung.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
void Search()
{
SqlQuery _sqlquery = new Select().From(VDmucDichvucl.Schema);
if (Utility.Int32Dbnull(cboServiceType.SelectedValue, -1) != -1)
if (_sqlquery.HasWhere)
_sqlquery.Where(VDmucDichvucl.Columns.IdLoaidichvu).IsEqualTo(Utility.Int32Dbnull(cboServiceType.SelectedValue, -1));
else
_sqlquery.And(VDmucDichvucl.Columns.IdLoaidichvu).IsEqualTo(Utility.Int32Dbnull(cboServiceType.SelectedValue, -1));
if (Utility.sDbnull(cbonhombaocao.SelectedValue, "-1") != "-1")
if (_sqlquery.HasWhere)
_sqlquery.Where(VDmucDichvucl.Columns.NhomBaocao).IsEqualTo(Utility.sDbnull(cbonhombaocao.SelectedValue, "-1"));
else
_sqlquery.And(VDmucDichvucl.Columns.NhomBaocao).IsEqualTo(Utility.sDbnull(cbonhombaocao.SelectedValue, "-1"));
if (Utility.Int32Dbnull(cboDepartment.SelectedValue, -1) != -1)
if (_sqlquery.HasWhere)
_sqlquery.Where(VDmucDichvucl.Columns.IdKhoaThuchien).IsEqualTo(Utility.Int32Dbnull(cboDepartment.SelectedValue, -1));
else
_sqlquery.And(VDmucDichvucl.Columns.IdKhoaThuchien).IsEqualTo(Utility.Int32Dbnull(cboDepartment.SelectedValue, -1));
if (Utility.Int32Dbnull(cboPhongthuchien.SelectedValue, -1) != -1)
if (_sqlquery.HasWhere)
_sqlquery.Where(VDmucDichvucl.Columns.IdPhongThuchien).IsEqualTo(Utility.Int32Dbnull(cboPhongthuchien.SelectedValue, -1));
else
_sqlquery.And(VDmucDichvucl.Columns.IdPhongThuchien).IsEqualTo(Utility.Int32Dbnull(cboPhongthuchien.SelectedValue, -1));
dtDataCLS = _sqlquery.ExecuteDataSet().Tables[0];
dtDataCLS.AcceptChanges();
Utility.SetDataSourceForDataGridEx(grdList, dtDataCLS, true, true, "1=1", "stt_hthi_loaidvu,ten_loaidichvu,stt_hthi,ten_dichvu");
}
/// <summary>
/// hàm thực heiẹn việc lấy thông tin đối tượng
/// </summary>
/// <returns></returns>
public static DataTable LayThongtinDoiTuong()
{
SqlQuery sqlQuery = new Select().From(DDoiTuong.Schema)
.OrderAsc(DDoiTuong.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LayThongTinNgheNghiep(string MaLoai)
{
SqlQuery sqlQuery = new Select().From(DDmucChung.Schema)
.Where(DDmucChung.Columns.Loai).IsEqualTo(MaLoai)
.OrderAsc(DDmucChung.Columns.SttHthi);
return sqlQuery.ExecuteDataSet().Tables[0];
}
public static DataTable LAYTHONGTIN_KHOTHUOC_TOANBO_LE()
{
DataTable m_dtKhoThuoc = new DataTable();
SqlQuery sqlQuery = new Select().From(TDmucKho.Schema);
sqlQuery.Where(TDmucKho.Columns.KieuKho).In(lstKhole);
sqlQuery.And(TDmucKho.Columns.LaTuthuoc).IsEqualTo(0);
sqlQuery.And(TDmucKho.Columns.LoaiKho).IsEqualTo(0);
sqlQuery.And(TDmucKho.Columns.KhoThuocVt).In(lstKhoThuoc);
sqlQuery.OrderAsc(TDmucKho.Columns.SttHthi);
m_dtKhoThuoc = sqlQuery.ExecuteDataSet().Tables[0];
return m_dtKhoThuoc;
}
private void IntitalData()
{
SqlQuery sqlQuery = new Select().From(LObjectType.Schema).OrderAsc(LObjectType.Columns.SName);
DataBinding.BindDataCombox(cboObjectType, sqlQuery.ExecuteDataSet().Tables[0], LObjectType.Columns.Id,
LObjectType.Columns.SName, "---Đối tượng---");
sqlQuery = new Select().From(LDepartment.Schema).OrderAsc(LDepartment.Columns.SName);
DataBinding.BindDataCombox(cboDepartment, sqlQuery.ExecuteDataSet().Tables[0], LDepartment.Columns.Id,
LDepartment.Columns.SName, "---Chọn khoa phòng---");
sqlQuery = new Select().From(TTestTypeList.Schema).OrderAsc(TTestTypeList.Columns.IntOrder);
DataBinding.BindDataCombox(cboLoaiXetnghiem, sqlQuery.ExecuteDataSet().Tables[0], TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName, "---Loại xét nghiệm---");
}
