void SetupControl() { switch (_type) { case FieldType.text: textBox1.Visible = true; break; case FieldType.number: textBox1.Visible = true; break; case FieldType.dropdown: comboBox1.Visible = true; IList <ComboBoxObject> items; items = ComboBoxObject.LoadFromQuery(_query); comboBox1.DisplayMember = "Text"; comboBox1.ValueMember = "Value"; comboBox1.DataSource = items; break; case FieldType.checkbox: checkBox1.Visible = true; break; default: textBox1.Visible = true; break; } }
private void listModule() { ctxEdit.Enabled = false; tsbEdit.Enabled = false; ctxDelete.Enabled = false; tsbDelete.Enabled = false; var stats = ComboBoxObject.LoadFromQuery("SELECT [FK_MODULE_ID] as Value,cast(ROUND(cast(sum([ACTIVITY_TIME]) as float)/3600,2) as nvarchar) + 'h ('+cast(ROUND((cast(sum([ACTIVITY_TIME]) as float)/cast(sum([OPENED_TIME]) as float))*100,1) as nvarchar)+'%) - ' + CAST(COUNT(Distinct FORMNAME) as nvarchar) + ' Forms - ' + cast(COUNT(DISTINCT USERID) as nvarchar) + ' Users' as Text FROM [SYNAPSE].[dbo].[Synapse_Statistics] GROUP BY FK_MODULE_ID"); usage.Clear(); foreach (ComboBoxObject stat in stats) { usage.Add(stat.Value, stat.Text); } modules = SynapseModule.Load(); foreach (SynapseModule module in modules) { if (File.Exists(Application.StartupPath + "\\ModulesIcons\\" + module.TECHNICALNAME + ".ico")) { LargeImageList.Images.Add(module.TECHNICALNAME, Image.FromFile(Application.StartupPath + "\\ModulesIcons\\" + module.TECHNICALNAME + ".ico")); } else { LargeImageList.Images.Add(module.TECHNICALNAME, Image.FromFile(Application.StartupPath + "\\ModulesIcons\\Default.png")); } } olvModules.SetObjects(modules.OrderBy(x => x.FriendlyName.ToString()).ToList()); }
private static void GenerateDBFields() { var DBFields = ComboBoxObject.LoadFromQuery("select (T.TABLE_NAME+'.'+C.COLUMN_NAME) as Text,C.COLUMN_NAME as Value from INFORMATION_SCHEMA.TABLES T inner join INFORMATION_SCHEMA.COLUMNS C on T.TABLE_NAME=C.TABLE_NAME;"); foreach (ComboBoxObject field in DBFields) { string translated = string.Empty; if (!dic["Default"].ContainsKey(field.Text.ToUpperInvariant())) { dic["Default"].Add(field.Text.ToUpperInvariant(), field.Value.ToString().ToUpperInvariant()); Console.WriteLine("...adding " + field.Text.ToUpperInvariant() + " with value:" + field.Value.ToString().ToUpperInvariant()); } foreach (SynapseLanguage lang in Languages) { if (!dic[lang.CULTURE].ContainsKey(field.Text.ToUpperInvariant())) { dic[lang.CULTURE].Add(field.Text.ToUpperInvariant(), field.Value.ToString().ToUpperInvariant()); Console.WriteLine("...adding " + field.Text.ToUpperInvariant() + " with value:" + field.Value.ToString().ToUpperInvariant()); } } } }