本文整理汇总了C#中System.Data.Select.ExecuteDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# Select.ExecuteDataSet方法的具体用法？C# Select.ExecuteDataSet怎么用？C# Select.ExecuteDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Select的用法示例。
在下文中一共展示了Select.ExecuteDataSet方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LayThongTinPhuongXa
/// <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];
}示例2: LAYDSACH_IDKHOTHUOC_CHAN
/// <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>();
}示例3: GetStaffListbyDepartmentId
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;
}示例4: cmdSearch_Click
/// <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;
}示例5: IntitalData
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);
}示例6: cboKhoaNoiTru_SelectedIndexChanged
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();
}
}示例7: LayThongTinKhoaGUI
/// <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];
}示例8: LayThongTinLoaiDichVu
/// <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];
}示例9: LayThongTinVungKS
/// <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];
}示例10: LayThongDichVu
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;
}示例11: LAYDSACH_MAKHOTHUOC_LE_NOITRU
/// <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());
}示例12: LayThongTinThietBi
/// <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];
}示例13: LayThongTinNhanVienByStaffID
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];
}示例14: LAYTHONGTIN_KHOTHUOC_LE_TUTRUC_NOITRU
/// <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;
}示例15: LAYTHONGTIN_KHOTHUOC_TATCA
/// <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;
}