本文整理汇总了C#中System.Data.Select类的典型用法代码示例。如果您正苦于以下问题:C# Select类的具体用法?C# Select怎么用?C# Select使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
Select类属于System.Data命名空间,在下文中一共展示了Select类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LAYDSACH_IDKHOTHUOC_CHAN
/// <summary>
///
/// </summary>
/// <param name="dauphancach"></param>
/// <returns></returns>
public static string LAYDSACH_IDKHOTHUOC_CHAN(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(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 "";
return string.Join(dauphancach, m_dtKhoThuoc.AsEnumerable().Select(c => c.Field<string>(TDmucKho.Columns.IdKho)).ToList<string>().ToArray());
}
示例2: 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];
}
示例3: GetTestListByTestTypeId
private static DataTable GetTestListByTestTypeId(string pTestTypeId)
{
var testListByTestTypeId =
new Select().From(LStandardTest.Schema.Name).Where(LStandardTest.Columns.TestTypeId).IsEqualTo(
pTestTypeId).OrderAsc(LStandardTest.Columns.DataSequence).ExecuteDataSet().Tables[0];
return testListByTestTypeId;
}
示例4: cls_SignInfor
//ham nay se thuc hien lay thong tin tren server ve
public cls_SignInfor(string sv_sBieuMau, string sv_sDonVi, DataTable ReportSourceTable)
{
exists = true;
SqlCommand cmdNguoiKy = new SqlCommand();
string strSQL = "Select * from tbl_Trinhky Where ReportName = N'" + sv_sBieuMau + "'";
DataTable dtbNguoiKy = new DataTable();
try
{
dtbNguoiKy =new Select().From("tbl_Trinhky").Where("ReportName").IsEqualTo(sv_sBieuMau)
.ExecuteDataSet().Tables[0];
if (dtbNguoiKy.Rows.Count > 0) exists = true;
}
catch (Exception ex)
{
exists = false;
}
if (exists == false) return;
try
{
if (dtbNguoiKy.Rows.Count > 0)
{
//gan cac thong tin co duoc vao bien
mv_TEN_BIEUBC = (string)dtbNguoiKy.Rows[0]["ReportName"];
try
{
mv_TEN_DOITUONG = (string)dtbNguoiKy.Rows[0]["ObjectName"];
}
catch (Exception ex)
{
mv_TEN_DOITUONG = " ";
}
mv_FONT_CHU = (string)dtbNguoiKy.Rows[0]["Font_Name"];
mv_CO_CHU = (int)dtbNguoiKy.Rows[0]["Font_Size"];
mv_KIEU_CHU = (string)dtbNguoiKy.Rows[0]["Font_Stype"];
try
{
mv_NOI_DUNG = (string)dtbNguoiKy.Rows[0]["ObjectContent"];
}
catch (Exception ex)
{
mv_NOI_DUNG = " ";
}
}
else
{
exists = false;
}
}
catch (Exception ex)
{
exists = false;
}
}
示例5: cmdSave_Click
private void cmdSave_Click(object sender, EventArgs e)
{
SqlQuery q = new Select().From(SysUserPrinter.Schema)
.Where(SysUserPrinter.Columns.SysUserName).IsEqualTo(globalVariables.UserName);
if(q.GetRecordCount()<=0)
{
new SysUserPrinterController().Insert(globalVariables.UserName, txtQuantity.Value,
Utility.sDbnull(cboListPrint.Text, ""), txtKetoan.Text,
txtLapBangKe.Text, txtGiamdinhbaohiem.Text,
txtDaidienkhamchuabenh.Text);
}else
{
new Update(SysUserPrinter.Schema)
.Set(SysUserPrinter.Columns.PrinterName).EqualTo(cboListPrint.Text)
.Set(SysUserPrinter.Columns.CreatedBy).EqualTo(txtLapBangKe.Text)
.Set(SysUserPrinter.Columns.AccountName).EqualTo(txtKetoan.Text)
.Set(SysUserPrinter.Columns.InsuranceBy).EqualTo(txtGiamdinhbaohiem.Text)
.Set(SysUserPrinter.Columns.HospitalBy).EqualTo(txtDaidienkhamchuabenh.Text)
.Set(SysUserPrinter.Columns.PagerCopy).EqualTo(Utility.Int32Dbnull(txtQuantity.Text, 1))
.Where(SysUserPrinter.Columns.SysUserName).IsEqualTo(globalVariables.UserName).Execute();
}
Utility.ShowMsg("Bạn cập nhập thông tin thành công","Thông báo");
this.Close();
}
示例6: CreatePhieuXuatBenhNhan
public TPhieuXuatthuocBenhnhan CreatePhieuXuatBenhNhan(KcbDonthuoc objDonthuoc)
{
KcbDanhsachBenhnhan objBenhnhan = KcbDanhsachBenhnhan.FetchByID(objDonthuoc.IdBenhnhan);
KcbLuotkham objLuotkham = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objDonthuoc.MaLuotkham)
.And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objDonthuoc.IdBenhnhan).ExecuteSingle<KcbLuotkham>();
TPhieuXuatthuocBenhnhan objPhieuXuatBnhan = new TPhieuXuatthuocBenhnhan();
objPhieuXuatBnhan.NgayXacnhan = globalVariables.SysDate;
objPhieuXuatBnhan.IdPhongChidinh = Utility.Int16Dbnull(objDonthuoc.IdPhongkham);
objPhieuXuatBnhan.IdKhoaChidinh = Utility.Int16Dbnull(objDonthuoc.IdKhoadieutri);
objPhieuXuatBnhan.IdBacsiKedon = Utility.Int16Dbnull(objDonthuoc.IdBacsiChidinh);
objPhieuXuatBnhan.IdDonthuoc = Utility.Int32Dbnull(objDonthuoc.IdDonthuoc);
objPhieuXuatBnhan.IdNhanvien = globalVariables.gv_intIDNhanvien;
//objPhieuXuatBnhan.HienThi = 1;
objPhieuXuatBnhan.ChanDoan = Utility.sDbnull(objLuotkham.ChanDoan);
objPhieuXuatBnhan.MabenhChinh = Utility.sDbnull(objLuotkham.MabenhChinh);
objPhieuXuatBnhan.IdDoituongKcb = Utility.Int16Dbnull(objLuotkham.IdDoituongKcb);
objPhieuXuatBnhan.MaDoituongKcb = objLuotkham.MaDoituongKcb;
objPhieuXuatBnhan.GioiTinh = objBenhnhan.GioiTinh;
objPhieuXuatBnhan.TenBenhnhan = Utility.sDbnull(objBenhnhan.TenBenhnhan);
objPhieuXuatBnhan.TenKhongdau = Utility.sDbnull(Utility.UnSignedCharacter(objBenhnhan.TenBenhnhan));
objPhieuXuatBnhan.DiaChi = Utility.sDbnull(objBenhnhan.DiaChi);
objPhieuXuatBnhan.NamSinh = Utility.Int32Dbnull(objBenhnhan.NamSinh);
objPhieuXuatBnhan.MatheBhyt = Utility.sDbnull(objLuotkham.MatheBhyt);
objPhieuXuatBnhan.NgayKedon = objDonthuoc.NgayKedon;
objPhieuXuatBnhan.NgayTao = globalVariables.SysDate;
objPhieuXuatBnhan.NguoiTao = globalVariables.UserName;
objPhieuXuatBnhan.Noitru = objDonthuoc.Noitru;
objPhieuXuatBnhan.LoaiPhieu = (byte?)LoaiPhieu.PhieuXuatKhoBenhNhan;
return objPhieuXuatBnhan;
}
示例7: cmdSave_Click
private void cmdSave_Click(object sender, EventArgs e)
{
SqlQuery sqlQuery = new Select().From(SysManagementUnit.Schema)
.Where(SysManagementUnit.Columns.PkSBranchID).IsEqualTo("LIS");
if (sqlQuery.GetRecordCount() <= 0)
{
//LDonVi.Insert("LIS", txtDonViCapTren.Text, txtDonVi.Text, txtDiaChi.Text, txtDienThoai.Text);
SysManagementUnit objSysManagementUnit = new SysManagementUnit();
objSysManagementUnit.PkSBranchID = "LIS";
objSysManagementUnit.SName = txtDonVi.Text;
objSysManagementUnit.SParentBranchName = txtDonViCapTren.Text;
objSysManagementUnit.SAddress = txtDiaChi.Text;
objSysManagementUnit.SPhone = txtDienThoai.Text;
objSysManagementUnit.IsNew = true;
objSysManagementUnit.Save();
}
else
{
SysManagementUnit objSysManagementUnit = new SysManagementUnit();
objSysManagementUnit.MarkOld();
objSysManagementUnit.IsLoaded = true;
objSysManagementUnit.PkSBranchID = "LIS";
objSysManagementUnit.SName = txtDonVi.Text;
objSysManagementUnit.SParentBranchName = txtDonViCapTren.Text;
objSysManagementUnit.SAddress = txtDiaChi.Text;
objSysManagementUnit.SPhone = txtDienThoai.Text;
// objSysManagementUnit.IsNew = true;
objSysManagementUnit.Save();
}
Utility.ShowMsg("Bạn thực hiện lưu thành công","Thông báo");
}
示例8: 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;
}
示例9: CheckExistUserPass
public bool CheckExistUserPass(string UserName,string Password)
{
SqlQuery sqlQuery = new Select().From(SysUser.Schema)
.Where(SysUser.Columns.PkSuid).IsEqualTo(globalVariables.UserName)
.And(SysUser.Columns.SPwd).IsEqualTo(objEncrypt.Mahoa(Password));
if (sqlQuery.GetRecordCount() <= 0) return false;
else return true;
}
示例10: BindData
private void BindData()
{
SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema)
.Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text);
if (sqlQuery.GetRecordCount() > 0)
{
objLuotkham = sqlQuery.ExecuteSingle<KcbLuotkham>();
if (objLuotkham != null)
{
txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham);
txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt);
DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru);
if (objLDepartment != null)
{
txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong);
txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong);
}
KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan);
if (objPatientInfo != null)
{
txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan);
txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan);
txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh);
txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh);
txtPatientSex.Text =objPatientInfo.GioiTinh;// Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ";
}
NoitruPhanbuonggiuong objPhanbuonggiuong = noitru_nhapvien.LaythongtinBuonggiuongHtai(objLuotkham);
if (objPhanbuonggiuong != null)
{
dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa;
txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id);
NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong);
if (objRoom != null)
{
txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong);
txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong);
}
NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong);
if (objNoitruDmucGiuongbenh != null)
{
txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong);
txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong);
}
}
DataTable dtGia = new dmucgiagiuong_busrule().dsGetList("-1").Tables[0];
dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," + NoitruGiabuonggiuong.Columns.TenGia;
txtGia.Init(dtGia, new System.Collections.Generic.List<string>() { NoitruGiabuonggiuong.Columns.IdGia, NoitruGiabuonggiuong.Columns.MaGia, NoitruGiabuonggiuong.Columns.TenGia });
m_dtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text));
Utility.SetDataSourceForDataGridEx_Basic(grdBuong, m_dtDataRoom, true, true, "1=1", "sluong_giuong_trong desc,ten_buong");
if (grdBuong.DataSource != null)
{
grdBuong.MoveFirst();
}
}
}
}
示例11: Select_ColumnList_Specified
public void Select_ColumnList_Specified()
{
SubSonic.SqlQuery qry = new Select("productid", "productname").From(Product.Schema);
ANSISqlGenerator gen = new ANSISqlGenerator(qry);
string selectList = gen.GenerateCommandLine();
Assert.AreEqual("SELECT [dbo].[Products].[ProductID], [dbo].[Products].[ProductName]\r\n", selectList);
}
示例12: LayThongTinThanhPho
/// <summary>
/// hàm thực hiện lấy thông tin của thành phố
/// </summary>
/// <returns></returns>
public static DataTable LayThongTinThanhPho()
{
DataTable dataTable =
new Select().From(DDviDchinh.Schema).Where(DDviDchinh.Columns.LoaiDviDchinh).IsEqualTo("TP").OrderAsc(
DDviDchinh.Columns.SttHthi).ExecuteDataSet().Tables[0];
return dataTable;
}
示例13: LaythongtinBuonggiuongHtai
public static NoitruPhanbuonggiuong LaythongtinBuonggiuongHtai(KcbLuotkham objPatientExam)
{
NoitruPhanbuonggiuong objPhanbuonggiuong = new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham)
.And(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.NoiTru).IsEqualTo(1)
.And(NoitruPhanbuonggiuong.Columns.TrangThai).IsEqualTo(0).ExecuteSingle<NoitruPhanbuonggiuong>();
return objPhanbuonggiuong;
}
示例14: 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);
}
示例15: Acc_ExecuteJoinedDataSet_Should_Accept_Parameters
public void Acc_ExecuteJoinedDataSet_Should_Accept_Parameters()
{
int someProduct = 1;
SubSonic.SqlQuery sq = new Select()
.From(Product.Schema)
.Where(Product.ProductIDColumn).IsEqualTo(someProduct);
DataSet ds = sq.ExecuteJoinedDataSet();
Assert.AreEqual(1, ds.Tables[0].Rows.Count);
}