private void cbxDatatable_SelectedIndexChanged(object sender, EventArgs e) { if (cbxDataTable.SelectedIndex == 0) { return; } var bizService = new BusinessDBProviderService(SystemInfo.WorkFlowDbConnectionString, SystemInfo.WorkFlowDbType); DataTable dtColumns = bizService.Fill(SystemInfo.UserInfo, this.GetTableColumnsSql(VarDataBaseName, cbxDataTable.Text)); BasePageLogic.BindCombo(cbxTableColumns, dtColumns, "name", "name"); cbxTableColumns.SelectedIndex = 0; BasePageLogic.BindCombo(comboBoxbx, dtColumns, "name", "name"); comboBoxbx.SelectedIndex = 0; }
private void InitData() { if (cbxVarType.SelectedIndex < 0) { cbxVarType.SelectedIndex = 0; //默认值 } if (cbxVarModule.SelectedIndex < 0) { cbxVarModule.SelectedIndex = 0; } this.VarDataBaseName = "RDIFrameworkWFV3.0"; var bizService = new BusinessDBProviderService(SystemInfo.WorkFlowDbConnectionString, SystemInfo.WorkFlowDbType); string sqlString = string.Empty; switch (SystemInfo.RDIFrameworkDbType) { case CurrentDbType.Access: case CurrentDbType.SqlServer: sqlString = string.IsNullOrEmpty(VarDataBaseName) ? "SELECT * FROM ..SysObjects Where XType='U' ORDER BY Name" : "SELECT * FROM [" + VarDataBaseName + "]..SysObjects Where XType='U' ORDER BY Name"; break; case CurrentDbType.MySql: varDataBaseName = "rdiframework_wf_v30"; this.txtCurrentDataBase.Text = varDataBaseName; sqlString = string.IsNullOrEmpty(varDataBaseName) ? "SELECT TABLE_NAME name FROM information_schema.tables WHERE TABLE_TYPE = 'BASE TABLE'" : "SELECT TABLE_NAME name FROM information_schema.tables WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='" + VarDataBaseName + "'"; break; case CurrentDbType.Oracle: sqlString = "select table_name name from user_tables"; break; } DataTable dtTables = bizService.Fill(SystemInfo.UserInfo, sqlString); BasePageLogic.BindCombo(cbxDataTable, dtTables, "name", "name"); //绑定指定表的所有列: //select name from [RDIFrameworkWFV3.0].dbo.syscolumns where id=(select id from [RDIFrameworkWFV2.8].dbo.sysobjects where name='testQingjia') if (!string.IsNullOrEmpty(VarDataTableName)) { switch (SystemInfo.RDIFrameworkDbType) { case CurrentDbType.Access: case CurrentDbType.SqlServer: sqlString = "select name from [" + VarDataBaseName + "].dbo.syscolumns where id=(select id from [" + VarDataBaseName + "].dbo.sysobjects where name='" + VarDataTableName + "')"; break; case CurrentDbType.Oracle: sqlString = "SELECT column_name name FROM USER_TAB_COLS WHERE TABLE_NAME = '" + VarDataTableName + "'"; break; case CurrentDbType.MySql: sqlString = "SELECT COLUMN_NAME name FROM information_schema.COLUMNS WHERE TABLE_NAME = '" + VarDataTableName + "'"; break; } DataTable dtColumns = bizService.Fill(SystemInfo.UserInfo, sqlString); BasePageLogic.BindCombo(cbxTableColumns, dtColumns, "name", "name"); } if (FmSate == WorkConst.STATE_MOD) { cbxDataTable.Text = VarDataTableName; cbxTableColumns.Text = VarTableColumnName; comboBoxbx.Text = SortField; } }