private void FrmReadSqlServerDBData_Load(object sender, EventArgs e) { #region 初始化下拉框 _dicString.Add("0", "全部提交"); _dicString.Add("1", "单次提交"); _dicString.Add("20", "每20次提交"); _dicString.Add("50", "每50次提交"); _dicString.Add("100", "每100次提交"); _dicString.Add("200", "每200次提交"); _dicString.Add("500", "每500次提交"); UIHelper.BindTypeValueDropDownList(cbbCommitType, _dicString.GetTextValueTable(false), false, true); //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbTargetDbType, dtDbType, false, true); cbbTargetDbType.SelectedIndexChanged += cbbTargetDbType_SelectedIndexChanged; #endregion #region 设置数据库连接控件 _IDBConfigSet = ContainerContext.Container.Resolve <IDBConfigSet>(); //过滤指定数据库类型配置 DataTable dtConn = _IDBConfigSet.QueryDbConfig(_dicQuery).SafeGetDictionaryTable(); uC_DbConnection1.SetDbConnComboBoxSource(dtConn); uC_DbConnection1.IsDbNameNotNull = false; uC_DbConnection1.DBType_SelectedIndexChanged += DataBaseType_SelectedChange; uC_DbConnection1.DBConnName_SelectedIndexChanged += DBConnName_SelectedChange; #endregion tsbExport.Enabled = false; }
private void FrmDBConfigSet_D_Load(object sender, EventArgs e) { //接口对象 _IDBConfigSet = ContainerContext.Container.Resolve <IDBConfigSet>(); _IDataAccess = DataAccessFactory.GetDefaultDataAccess(); #region 绑定下拉框 //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDatabaseType, dtDbType, false, true); //登录类型 IDictionary <string, string> dicQuery = new Dictionary <string, string>(); dicQuery.Add(((int)LoginModeEnum.SQL).ToString(), "SQL身份验证"); dicQuery.Add(((int)LoginModeEnum.Windows).ToString(), "Windows身份验证"); UIHelper.BindTypeValueDropDownList(cbbLoginType, UIHelper.GetTextValueTable(dicQuery, false), false, true); #endregion //设置控件关系 SetControlColumnRelation(); if (_drEdit == null)//新增 { } else //修改 { UIHelper.SetControlValue(_listSupply, _drEdit); } }
private void FrmTableExtendProperty_Load(object sender, EventArgs e) { //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDbType, dtDbType, false, true); // lblTableData.Text = "SQLite不支持注释。MySql只支持增加表注释,因为导入的信息不足以生成列注释!"; }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmVersionInfo_Load(object sender, EventArgs e) { SetTag();//设置Tag //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDbType, dtDbType, true, true); // _IDBConfigSet = ContainerContext.Container.Resolve <IDBConfigSet>(); }
private void UC_DbConnection_Load(object sender, EventArgs e) { #region 绑定下拉框 //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDatabaseType, dtDbType, false, true); //登录类型 IDictionary <string, string> dicQuery = new Dictionary <string, string>(); dicQuery.Add(((int)LoginModeEnum.SQL).ToString(), "SQL身份验证"); dicQuery.Add(((int)LoginModeEnum.Windows).ToString(), "Windows身份验证"); UIHelper.BindTypeValueDropDownList(cbbLoginType, UIHelper.GetTextValueTable(dicQuery, false), false, true); #endregion //数据库类型为只读 cbbDatabaseType.Enabled = false; }
private void FrmExcelImportData_Load(object sender, EventArgs e) { //生成数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDbType, dtDbType, false, true); // _dicString.Add("0", "全部提交"); _dicString.Add("1", "单次提交"); _dicString.Add("20", "每20次提交"); _dicString.Add("50", "每50次提交"); _dicString.Add("100", "每100次提交"); _dicString.Add("200", "每200次提交"); _dicString.Add("500", "每500次提交"); UIHelper.BindTypeValueDropDownList(cbbThree, _dicString.GetTextValueTable(false), false, true); // tsbAutoSQL.Enabled = false; }
private void FrmCopyData_Load(object sender, EventArgs e) { IDictionary <string, string> dic_List = new Dictionary <string, string>(); dic_List.Add("1", "自定义拼接字符串"); dic_List.Add("2", "UNION清单"); dic_List.Add("3", "UNION ALL清单"); UIHelper.BindTypeValueDropDownList(cbbSqlType, dic_List.GetTextValueTable(false), false, true); //数据库类型 DataTable dtDbType = DBToolUIHelper.GetBaseDataTypeTable(); UIHelper.BindTypeValueDropDownList(cbbDbType, dtDbType, false, true); DataTable dtCopy = new DataTable(); dtCopy.TableName = _strTableName; bsTable.DataSource = dtCopy; dgvTableList.DataSource = bsTable; GlobalValue.Instance.SetPublicDataSource(new DataTable[] { dtCopy }); // lblTableData.Text = "可在Excel中复制数据后,点击网格后按ctrl + v粘贴即可。注:第一行为列名!"; }
private void tsbDownLoad_Click(object sender, EventArgs e) { DBToolUIHelper.DownloadFile(@"DataModel\TableStruct\模板_表列说明变更.xlsx", "模板_表列说明变更", true); }
private void tsbDownLoad_Click(object sender, EventArgs e) { DBToolUIHelper.DownloadFile(@"DataModel\DataSql\模板_生成数据.xlsx", "生成数据模板", true); }