/// <summary> /// 绑定列表控件 /// </summary> /// <param name="cbx"></param> /// <param name="kVEntities"></param> /// <param name="displayMember"></param> /// <param name="valueMember"></param> /// <param name="selectedIndex">列表默认选中索引项</param> public static void BindCheckedListBox(CheckedListBox chklst, List <KVEntity> kVEntities, string selectedValue, string displayMember = "K", string valueMember = "V") { if (chklst == null) { return; } chklst.DataSource = kVEntities; chklst.DisplayMember = displayMember; chklst.ValueMember = valueMember; if (!string.IsNullOrEmpty(selectedValue)) { for (int i = 0; i < chklst.Items.Count; i++) { KVEntity kv = chklst.Items[i] as KVEntity; foreach (string item in selectedValue.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { if (kv.V == item) { chklst.SetItemChecked(i, true); } } } } }
private CronExpressionEntity BuildCronExpression() { CronExpressionEntity cronExpression = new CronExpressionEntity(); cronExpression.Second = "0"; cronExpression.CycleTypes = CycleTypes.D; if (rdoOneTimes.Checked) { cronExpression.ExecutingOnce = true; cronExpression.Hour = cbxOneTimesHour.SelectedValue.ToString(); cronExpression.Minute = cbxOneTimesMinute.SelectedValue.ToString(); } else { cronExpression.ExecutingOnce = false; KVEntity kvEntity = (KVEntity)cbxMultiTimesMinute.SelectedItem; if (kvEntity.K.Contains("分")) { cronExpression.Minute = kvEntity.V; cronExpression.Hour = "*"; } else { cronExpression.Minute = "0"; cronExpression.Hour = kvEntity.V; } } return(cronExpression); }
private void cbxDataBaseType_SelectedIndexChanged(object sender, EventArgs e) { KVEntity <int> entity = cbxDataBaseType.SelectedItem as KVEntity <int>; if (entity.V != "-999") { KVEntity dbReservedEntity = Common.DbReservedString((DbTypes)entity.T1); if (dbReservedEntity != null) { txtDbConn.Text = dbReservedEntity.K; txtSql.Text = dbReservedEntity.V; } else { txtDbConn.Text = ""; txtSql.Text = ""; ; } } else { txtDbConn.Text = ""; txtSql.Text = ""; } }
/// <summary> /// 获取数据库预留 /// </summary> /// <param name="dbType"></param> /// <returns></returns> public static KVEntity DbReservedString(DbTypes dbType) { KVEntity entity = new KVEntity();; switch (dbType) { case DbTypes.Sqlserver: entity.K = "server=192.168.0.14;database=T8DataTest;uid=sa;pwd=sa.;min pool size=10;max pool size=300;Connection Timeout=10;"; entity.V = @"SELECT isbn,Title as booktitle,PublishName as publisher_name,price, SalesCount as amount,Author as author_editor,SalesDateTime as selldate,StoreID as werks FROM T8_BookInfo WHERE SalesDateTime>= @StartTime and SalesDateTime<= @EndTime"; break; case DbTypes.Oracle: entity.K = "User ID = ox; Password = ox_pwd; Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.60)(PORT = 18991)))(CONNECT_DATA = (SERVICE_NAME = ORCL12)))"; entity.V = @"SELECT isbn,Title booktitle,price,PublishName publisher_name,WriteTime selldate FROM ob_bookinfo_m WHERE publish1id>0 and WriteTime>= :StartTime and WriteTime <= :EndTime"; break; case DbTypes.MySql: break; case DbTypes.Oledb: break; default: entity = null; break; } return(entity); }
public static string GetCodeByName(string name, string type) { KVEntity entity = DefineTpye.Where(p => p.DefineType.Equals(type) && p.Key.Equals(name)).FirstOrDefault(); if (entity != null) { return(entity.Val); } return(name); }
public static string GetNameByCode(string code, string type) { KVEntity entity = DefineTpye.Where(p => p.DefineType.Equals(type) && p.Val.Equals(code)).FirstOrDefault(); if (entity != null) { return(entity.Key); } return(code); }
private void BindMonthsToListBox() { List <string> months = new List <string>(); for (int index = 0; index < chklstMonths.CheckedItems.Count; index++) { KVEntity kv = chklstMonths.CheckedItems[index] as KVEntity; months.Add(kv.V); } if (months.Count > 0) { _cronExpressionEntity.SelectedTimestamp = string.Join(",", months); } else { _cronExpressionEntity.SelectedTimestamp = ""; } BindlstReecntTimes(); }