public static void AutocompleteKieuKham(string madoituongkcb, AutoCompleteTextbox txtAuto) { DataTable m_kieuKham = THU_VIEN_CHUNG.Get_KIEUKHAM(madoituongkcb, -1); try { if (m_kieuKham == null) { return; } if (!m_kieuKham.Columns.Contains("ShortCut")) { m_kieuKham.Columns.Add(new DataColumn("ShortCut", typeof(string))); } foreach (DataRow dr in m_kieuKham.Rows) { string shortcut = ""; string realName = dr[DmucKieukham.Columns.TenKieukham].ToString().Trim() + " " + Utility.Bodau(dr[DmucKieukham.Columns.TenKieukham].ToString().Trim()); shortcut = dr[DmucKieukham.Columns.MaKieukham].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 m_kieuKham.AsEnumerable() select p.Field <Int16>(DmucKieukham.Columns.IdKieukham).ToString() + "#" + p.Field <string>(DmucKieukham.Columns.MaKieukham).ToString() + "@" + p.Field <string>(DmucKieukham.Columns.TenKieukham).ToString() + "@" + p.Field <string>("shortcut").ToString(); source = query.ToList(); txtAuto.AutoCompleteList = source; txtAuto.TextAlign = HorizontalAlignment.Center; txtAuto.CaseSensitive = false; txtAuto.MinTypedCharacters = 1; } }
private void Get_KIEUKHAM(string MA_DTUONG) { m_kieuKham = THU_VIEN_CHUNG.Get_KIEUKHAM(MA_DTUONG, dongia); DataTable _tempt = m_kieuKham.Clone(); foreach (DataRow dr in m_kieuKham.Rows) { if (m_ExamTypeRelationList.Select(DmucDichvukcb.Columns.IdKieukham + "=" + Utility.Int32Dbnull(dr[DmucKieukham.Columns.IdKieukham], -1).ToString()).Length > 0) { _tempt.ImportRow(dr); } } m_kieuKham = _tempt.Copy(); }