/// <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();
}
