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();
}