本文整理汇总了C#中System.Data.Select类的典型用法代码示例。如果您正苦于以下问题:C# Select类的具体用法?C# Select怎么用?C# Select使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
Select类属于System.Data命名空间,在下文中一共展示了Select类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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());
}
开发者ID:vmshis2020,项目名称:VMSHISServer,代码行数:30,代码来源:CommonLoadDuoc.cs
示例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];
}
开发者ID:khaha2210,项目名称:radio,代码行数:12,代码来源:CommonBusiness.cs
示例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;
}
开发者ID:khaha2210,项目名称:CodeNewTeam,代码行数:7,代码来源:frmQuickReorderTestSequence.cs
示例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;
}
}
开发者ID:khaha2210,项目名称:CodeNewTeam,代码行数:61,代码来源:cls_SignInfor.cs
示例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();
}
开发者ID:khaha2210,项目名称:CodeNewHis,代码行数:25,代码来源:frm_DM_ConfigPaymentPrint.cs
示例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;
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:32,代码来源:XuatThuoc.cs
示例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");
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:33,代码来源:frm_DonVi_LamViec.cs
示例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;
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:8,代码来源:DMUC_CHUNG.cs
示例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;
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:8,代码来源:LoginService.cs
示例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();
}
}
}
}
开发者ID:khaha2210,项目名称:CodeNewHis,代码行数:58,代码来源:frm_Chuyengiuong.cs
示例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);
}
开发者ID:khurram063,项目名称:SubSonic-2.0,代码行数:9,代码来源:SqlServerGeneratorTests.cs
示例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;
}
开发者ID:khaha2210,项目名称:radio,代码行数:13,代码来源:CommonBusiness.cs
示例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;
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:9,代码来源:noitru_nhapvien.cs
示例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);
}
开发者ID:khaha2210,项目名称:CodeNewTeam,代码行数:9,代码来源:frm_DA_BAOCAO_THOIGIAN_XETNGHIEM.cs
示例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);
}
开发者ID:RyanDansie,项目名称:SubSonic-2.0,代码行数:10,代码来源:QueryTest.cs
示例16: 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;
}
开发者ID:khaha2210,项目名称:radio,代码行数:15,代码来源:frm_LogError.cs
示例17: CheckValidData
private bool CheckValidData()
{
SysReport obj = null;
if (string.IsNullOrEmpty(txtMa.Text))
{
Utility.ShowMsg("Chưa nhập mã báo cáo", "Thông báo", MessageBoxIcon.Information);
txtMa.Focus();
txtMa.SelectAll();
return false;
}
if (string.IsNullOrEmpty(txtTieude.Text))
{
Utility.ShowMsg("Chưa nhập tiêu đề báo cáo", "Thông báo", MessageBoxIcon.Information);
txtTieude.Focus();
txtTieude.SelectAll();
return false;
}
if (cboNhom.Items.Count<=0)
{
Utility.ShowMsg("Chưa khởi tạo danh mục nhóm báo cáo", "Thông báo", MessageBoxIcon.Information);
cboNhom.Focus();
return false;
}
if (txtTenFileMacDinh.Text.Trim() == "")
{
Utility.ShowMsg("Chưa nhập tên file chuẩn", "Thông báo", MessageBoxIcon.Information);
txtTenFileMacDinh.Focus();
txtMa.SelectAll();
return false;
}
if (objReport.IsNew)
{
obj = new SysReportController().FetchByID(txtMa.Text).FirstOrDefault();
if (obj != null)
{
Utility.ShowMsg("Mã báo cáo đã tồn tại. Chọn mã khác", "Thông báo", MessageBoxIcon.Information);
txtMa.Focus();
txtMa.SelectAll();
return false;
}
}
else
{
obj = new Select().From(SysReport.Schema).Where(SysReport.Columns.MaBaocao).IsEqualTo(Utility.DoTrim(txtMa.Text))
.And(SysReport.Columns.MaBaocao).IsNotEqualTo(objReport.MaBaocao).ExecuteSingle<SysReport>();
if (obj != null)
{
Utility.ShowMsg("Mã báo cáo đã tồn tại. Chọn mã khác", "Thông báo", MessageBoxIcon.Information);
txtMa.Focus();
txtMa.SelectAll();
return false;
}
}
return true;
}
开发者ID:khaha2210,项目名称:CodeNewHis,代码行数:55,代码来源:frm_themmoi_baocao.cs
示例18: LayDulieuDanhmucChung
public static DataTable LayDulieuDanhmucChung(List<string> lstLoai)
{
DataTable m_NN = new DataTable();
m_NN =
new Select(DmucChung.Columns.Ma, DmucChung.Columns.Ten, DmucChung.Columns.Loai).From(DmucChung.Schema)
.Where(DmucChung.Columns.Loai).In(lstLoai)
.OrderAsc(DmucChung.Columns.SttHthi)
.ExecuteDataSet().Tables[0];
return m_NN;
}
开发者ID:khaha2210,项目名称:VXIS,代码行数:11,代码来源:DMUC_CHUNG.cs
示例19: AutocompleteLoaithuoc
private void AutocompleteLoaithuoc()
{
DataTable dtLoaithuoc = null;
try
{
dtLoaithuoc =
new Select().From(DmucLoaithuoc.Schema).Where(DmucLoaithuoc.KieuThuocvattuColumn).IsEqualTo(KIEU_THUOC_VT).ExecuteDataSet().Tables[0];
if (dtLoaithuoc == null) return;
if (!dtLoaithuoc.Columns.Contains("ShortCut"))
dtLoaithuoc.Columns.Add(new DataColumn("ShortCut", typeof(string)));
foreach (DataRow dr in dtLoaithuoc.Rows)
{
string shortcut = "";
string realName = dr[DmucLoaithuoc.TenLoaithuocColumn.ColumnName].ToString().Trim() + " " +
Utility.Bodau(dr[DmucLoaithuoc.TenLoaithuocColumn.ColumnName].ToString().Trim());
shortcut = dr[DmucLoaithuoc.MaLoaithuocColumn.ColumnName].ToString().Trim();
string[] arrWords = realName.ToLower().Split(' ');
string _space = "";
string _Nospace = "";
foreach (string word in arrWords)
{
if (word.Trim() != "")
{
_space += word + " ";
//_Nospace += word;
}
}
shortcut += _space; // +_Nospace;
foreach (string word in arrWords)
{
if (word.Trim() != "")
shortcut += word.Substring(0, 1);
}
dr["ShortCut"] = shortcut;
}
}
catch
{
}
finally
{
var source = new List<string>();
var query = from p in dtLoaithuoc.AsEnumerable()
select p[DmucLoaithuoc.IdLoaithuocColumn.ColumnName].ToString() + "#" + p[DmucLoaithuoc.MaLoaithuocColumn.ColumnName].ToString()
+ "@" + p[DmucLoaithuoc.TenLoaithuocColumn.ColumnName].ToString() + "@" + p.Field<string>("shortcut").ToString();
source = query.ToList();
this.txtLoaithuoc.AutoCompleteList = source;
this.txtLoaithuoc.TextAlign = HorizontalAlignment.Left;
this.txtLoaithuoc.CaseSensitive = false;
this.txtLoaithuoc.MinTypedCharacters = 1;
}
}
开发者ID:khaha2210,项目名称:CodeNewHis,代码行数:54,代码来源:frm_baocao_nhapthuoctheoNhacungcap.cs
示例20: 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();
}
}
开发者ID:khaha2210,项目名称:CodeNewHis,代码行数:11,代码来源:frm_dmuc_buonggiuong.cs
注:本文中的System.Data.Select类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论