/// <summary> /// Lấy ra các cấu hình theo đường đẫn của control cha /// </summary> /// <param name="vsdesc">Đường dẫn của control cha, vd: cms/admin/Moduls/QA/Index.ascx</param> private void LoadConfigs(string vsdesc) { string split = "->"; DataTable dt = new DataTable(); dt = Settings.GetSettingsCondition("", SettingsColumns.VsvalueColumn, SettingsTSql.GetSettingsByVsdesc(vsdesc), SettingsColumns.VsvalueColumn); string child = ""; string status = ""; string[] list = new string[4]; for (int i = 0; i < dt.Rows.Count; i++) { list = dt.Rows[i][SettingsColumns.VsvalueColumn].ToString().Split(new string[] { split }, StringSplitOptions.None); child = list[2]; status = list[3]; if (status == "1") { try { plLoadControls.Controls.Add(LoadControl("~/" + child)); } catch (Exception) { } } } }
/// <summary> /// Lấy ra các cấu hình theo đường đẫn của control cha /// </summary> /// <param name="vsdesc">Đường dẫn của control cha, vd: cms/admin/Moduls/New/Index.ascx</param> private void LoadConfigs(string vsdesc) { string split = "->"; DataTable dt = new DataTable(); dt = Settings.GetSettingsCondition("", SettingsColumns.VsvalueColumn, SettingsTSql.GetSettingsByVsdesc(vsdesc), SettingsColumns.VsvalueColumn); string order = ""; string fullkey = ""; string status = ""; string[] list = new string[4]; foreach (Control pnConfig in pnCauHinhTrangChu.Controls) { if (typeof(System.Web.UI.WebControls.Panel) == pnConfig.GetType()) { HiddenField hd1 = new HiddenField(); TextBox tb1 = new TextBox(); CheckBox cb1 = new CheckBox(); foreach (Control pnSubConfig in pnConfig.Controls) { if (typeof(System.Web.UI.WebControls.HiddenField) == pnSubConfig.GetType()) { hd1 = (HiddenField)pnSubConfig; } if (typeof(System.Web.UI.WebControls.TextBox) == pnSubConfig.GetType()) { tb1 = (TextBox)pnSubConfig; } if (typeof(System.Web.UI.WebControls.CheckBox) == pnSubConfig.GetType()) { cb1 = (CheckBox)pnSubConfig; } for (int i = 0; i < dt.Rows.Count; i++) { list = dt.Rows[i][SettingsColumns.VsvalueColumn].ToString().Split(new string[] { split }, StringSplitOptions.None); order = list[0]; fullkey = list[1] + split + list[2]; status = list[3]; if (hd1.Value.Equals(fullkey, StringComparison.CurrentCultureIgnoreCase)) { tb1.Text = order; cb1.Checked = status == "1"; } } } } } }
void Session_Start(object sender, EventArgs e) { //Code that runs when a new session is started DataTable dt = new DataTable(); dt = Settings.GetSettingsCondition("", "*", DataExtension.AndConditon( SettingsTSql.GetSettingsByVskey(SettingsExtension.KeyTotalView), SettingsTSql.GetSettingsByVslang(TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin())), ""); if (dt.Rows.Count > 0) { string[] fields = { "VSVALUE" }; string[] values = { "VSVALUE + 1" }; string condition = DataExtension.AndConditon( SettingsTSql.GetSettingsByVskey(SettingsExtension.KeyTotalView), SettingsTSql.GetSettingsByVslang(TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin())); Settings.UpdateSettings(DataExtension.UpdateTransfer(fields, values), condition); } else { Settings.InsertSettings(SettingsExtension.KeyTotalView, "", "0", TatThanhJsc.LanguageModul.Cookie.GetLanguageValueAdmin()); } }
private void SaveConfig(string fullkey, string order, bool status) { string split = "->"; string encodekey = SecurityExtension.BuildPassword(fullkey); string firstkey = fullkey.Substring(0, fullkey.IndexOf(split)); fullkey = order + split + fullkey + split + (status == true ? "1" : "0"); DataTable dt = new DataTable(); condition = DataExtension.AndConditon( SettingsTSql.GetSettingsByVskey(encodekey), SettingsTSql.GetSettingsByVslang(language) ); dt = Settings.GetSettingsCondition("1", "*", condition, ""); if (dt.Rows.Count < 1) { Settings.InsertSettings(encodekey, firstkey, fullkey, language); } else { Settings.UpdateSettings(SettingsTSql.GetSettingsByVsvalue(fullkey), condition); } }