public static void InitCtrl(PLMultiCombobox Input, bool? IsAdd) { string sql = string.Format(@"SELECT * From {0} where 1=1", TABLE_MAP); QueryBuilder query = new QueryBuilder(sql); if (IsAdd == true) query.addCondition("VISIBLE_BIT='Y'"); query.setAscOrderBy("lower(NAME)"); DataSet ds = HelpDB.getDatabase().LoadDataSet(query,TABLE_MAP); Input.DataSource = ds.Tables[0]; Input.DisplayField = "NAME"; Input.ValueField = "ID"; Input._init(); }
public static void InitCtrlNhanVien(PLMultiCombobox input, bool? isAdd) { string sql = string.Format(@"SELECT * From DM_NHAN_VIEN where 1=1"); var query = new QueryBuilder(sql); if (isAdd == true) query.addCondition("VISIBLE_BIT='Y'"); query.setAscOrderBy("lower(NAME)"); var ds = HelpDB.getDatabase().LoadDataSet(query, "DM_NHAN_VIEN"); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input._init(); }
public static void InitCtrlThuTrongTuan(PLMultiCombobox input) { string sql = string.Format(@"SELECT * From DAY_OF_WEEK where 1=1"); var query = new QueryBuilder(sql); query.setAscOrderBy("ID"); var ds = HelpDB.getDatabase().LoadDataSet(query, "DAY_OF_WEEK"); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input.UseSort = false; input._init(); input.Properties.SelectAllItemCaption = "(Cả tuần)"; }
public static void InitCtrl(PLMultiCombobox Input, bool? IsAdd) { string sql = string.Format(@"SELECT * From {0} where 1=1", TABLE_MAP); QueryBuilder query = new QueryBuilder(sql); if (IsAdd == true) { query.addCondition("VISIBLE_BIT='Y'"); } query.addID("CONG_TY", FrameworkParams.LoginCompanyID); query.setAscOrderBy("lower(NAME)"); DataSet ds = HelpDB.getDatabase().LoadDataSet(query, TABLE_MAP); Input.UseSort = false; Input.DataSource = AppUtil.SortLogicalTable(ds.Tables[0], "NAME"); Input.DisplayField = "NAME"; Input.ValueField = "ID"; Input._init(); }
public static void InitCtrlBudgetPlanState(PLMultiCombobox input) { var dt = new DataTable(); dt.Columns.Add("ID", typeof(Int64)); dt.Columns.Add("NAME"); var ds = new DataSet(); ds.Tables.Add(dt); dt.Rows.Add(BudgetPlanStatus.GENERAL, "Tổng quát"); dt.Rows.Add(BudgetPlanStatus.DETAIL, "Chi tiết"); dt.Rows.Add(BudgetPlanStatus.COMPLETE, "Hoàn thành"); input.ValueField = "ID"; input.DisplayField = "NAME"; input.DataSource = dt; input._init(); }
public static void InitCtrlLPS(PLMultiCombobox input, bool defaultValue) { string sql = string.Format(@"select dth.* from {0} dth inner join (select distinct kenh_phat from ql_lich_phat_song ) lps on lps.kenh_phat=dth.id order by name", TABLE_MAP); DataSet ds = HelpDB.getDatabase().LoadDataSet(sql, TABLE_MAP); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input._init(); if (defaultValue) { var defaultkenhPhat = AppCtrl.GetDefaultKenhPhat(); if (ds.Tables[0].Select("ID=" + defaultkenhPhat).Length > 0) { input._setSelectedIDs(new[] {defaultkenhPhat}); } } }
public static void InitCtrlKHLPS(PLMultiCombobox input, bool isDelete) { string sql = string.Format(@"select dth.* from {0} dth inner join (select distinct kenh_phat from ke_hoach_lps lps where {1} ) lps on lps.kenh_phat=dth.id order by name", TABLE_MAP, isDelete ? " lps.is_delete='Y'" : "lps.is_delete='N' or lps.is_delete is null"); DataSet ds = HelpDB.getDatabase().LoadDataSet(sql, TABLE_MAP); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input._init(); }
public static void InitCtrl(PLMultiCombobox input, bool? isAdd, bool defaultValue) { string sql = string.Format(@"SELECT * From {0} where 1=1", TABLE_MAP); var query = new QueryBuilder(sql); if (isAdd == true) query.addCondition("VISIBLE_BIT='Y'"); query.setAscOrderBy("lower(NAME)"); DataSet ds = HelpDB.getDatabase().LoadDataSet(query, TABLE_MAP); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input._init(); if (defaultValue) { input._setSelectedIDs(new[] { AppCtrl.GetDefaultKenhPhat() });} }
private void InitVTUT(PLMultiCombobox Input, bool? IsAdd) { bool IsVisible = false; if (IsAdd == true) IsVisible = true; QueryBuilder query = null; if (IsVisible) query = new QueryBuilder("SELECT * FROM DM_VI_TRI_UNG_TUYEN where VISIBLE_BIT = 'Y' AND 1=1"); else query = new QueryBuilder("SELECT * FROM DM_VI_TRI_UNG_TUYEN where 1=1"); query.setAscOrderBy("NAME"); DataSet ds = HelpDB.getDatabase().LoadReadOnlyDataSet(query); Input._init(ds.Tables[0], "NAME", "ID"); }
public static void InitCtrlKenhPhatKHPS(PLMultiCombobox input) { string sql = string.Format(@"select * from {0} dth where exists(select first 1 1 from {1} ct where ct.{2}=dth.id) order by name", DMDaiTruyenHinh.TABLE_MAP, KE_HOACH_LPS.TABLE_NAME, KE_HOACH_LPS.KENH_PHAT); DataSet ds = HelpDB.getDatabase().LoadDataSet(sql, DMDaiTruyenHinh.TABLE_MAP); input.DataSource = ds.Tables[0]; input.DisplayField = "NAME"; input.ValueField = "ID"; input._init(); }