public static void AutocompletePhongKham(string madoituongkcb, AutoCompleteTextbox txtAuto)
{
DataTable m_PhongKham = THU_VIEN_CHUNG.Get_PHONGKHAM(madoituongkcb);
try
{
if (m_PhongKham == null)
{
return;
}
if (!m_PhongKham.Columns.Contains("ShortCut"))
{
m_PhongKham.Columns.Add(new DataColumn("ShortCut", typeof(string)));
}
foreach (DataRow dr in m_PhongKham.Rows)
{
string shortcut = "";
string realName = dr[DmucKhoaphong.Columns.TenKhoaphong].ToString().Trim() + " " +
Utility.Bodau(dr[DmucKhoaphong.Columns.TenKhoaphong].ToString().Trim());
shortcut = dr[DmucKhoaphong.Columns.MaKhoaphong].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_PhongKham.AsEnumerable()
select p.Field <Int16>(DmucKhoaphong.Columns.IdKhoaphong).ToString() + "#" + p.Field <string>(DmucKhoaphong.Columns.MaKhoaphong).ToString() + "@" + p.Field <string>(DmucKhoaphong.Columns.TenKhoaphong).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_PHONGKHAM(string MA_DTUONG)
{
m_PhongKham = THU_VIEN_CHUNG.Get_PHONGKHAM(MA_DTUONG);
DataTable _tempt = m_PhongKham.Clone();
foreach (DataRow dr in m_PhongKham.Rows)
{
if (m_ExamTypeRelationList.Select(DmucDichvukcb.Columns.IdPhongkham + "=" + Utility.Int32Dbnull(dr[DmucKhoaphong.Columns.IdKhoaphong], -1).ToString()).Length > 0)
{
_tempt.ImportRow(dr);
}
}
m_PhongKham = _tempt.Copy();
}