public static void InitCtrlDanhSachLich(PLLookupEdit lookup)
{
string sql = string.Format(@"SELECT ID, NAME, LOAI_LICH,'' LOAI_LICH_NAME
From {0}
where VISIBLE_BIT='Y' and LOAI_LICH IS NOT NULL AND LOAI_LICH>0 AND 1=1", TABLE_MAP);
var query = new QueryBuilder(sql);
query.setAscOrderBy("lower(NAME)");
DataSet ds = HelpDB.getDatabase().LoadDataSet(query, TABLE_MAP);
if (ds != null && ds.Tables.Count > 0)
{
var dt = ds.Tables[0];
foreach (DataRow r in dt.Rows)
{
r["LOAI_LICH_NAME"] = AppUtil.GetTitleLoaiLich((LoaiLich) HelpNumber.ParseInt32(r["LOAI_LICH"]));
}
lookup._init(dt, "NAME", "ID", "",
new[]
{
"NAME", "LOAI_LICH_NAME"
},
new[]
{
"Kênh phát", "Loại lịch"
},
new[] {100, 100},
false
);
if (dt.Rows.Count > 0)
{
var kenhphat = AppCtrl.GetDefaultKenhPhat();
if (dt.Select("ID=" + kenhphat).Length == 0)
{
kenhphat = HelpNumber.ParseInt64(dt.Rows[0]["ID"]);
}
lookup._setSelectedID(kenhphat);
}
}
}
