private void btnTest_Click(object sender, EventArgs e) { if (CheckValue() == false) { MessageBoxHelper.ShowWarningMsg("表名或者字段!!"); return; } try { string sql = "select " + cbxTableColumns.SelectedItem.ToString() + " from " + cbxDataTable.SelectedItem.ToString() + " where 1=2 "; if (comboBoxbx.SelectedItem != null && comboBoxbx.SelectedItem.ToString() != "" && comboBoxbx.SelectedItem.ToString() != "请选择...") { sql = sql + " order by " + comboBoxbx.SelectedItem.ToString() + " DESC"; } var bizService = new BusinessDBProviderService(SystemInfo.WorkFlowDbConnectionString, SystemInfo.WorkFlowDbType); bizService.Fill(SystemInfo.UserInfo, sql); MessageBoxHelper.ShowSuccessMsg("测试连接成功!"); } catch (Exception ex) { MessageBoxHelper.ShowErrorMsg("测试连接失败:" + ex.Message.ToString(CultureInfo.InvariantCulture)); } }
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; }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); SystemInfo.EnableRecordLog = true; SystemInfo.StartupPath = Application.StartupPath; UserConfigHelper.GetConfig(); System.Console.ForegroundColor = ConsoleColor.Red; System.Console.WriteLine(@"服务器端正在启动..."); System.Console.ForegroundColor = ConsoleColor.White; // 读取配置文件 var configuration = ConfigurationManager.OpenExeConfiguration(Assembly.GetEntryAssembly().Location); var serviceModelSectionGroup = (ServiceModelSectionGroup)configuration.GetSectionGroup("system.serviceModel"); // 开启每个服务 var idxService = 1; if (serviceModelSectionGroup != null) { foreach (var serviceHost in from ServiceElement serviceElement in serviceModelSectionGroup.Services.Services let assemblyString = serviceElement.Name.Substring(0, serviceElement.Name.LastIndexOf('.')) select new System.ServiceModel.ServiceHost(Assembly.Load(assemblyString).GetType(serviceElement.Name), serviceElement.Endpoints[0].Address)) { serviceHost.Opened += delegate { Console.WriteLine(@"第{0:00}个服务:{1}", idxService, serviceHost.BaseAddresses[0]); }; serviceHost.Open(); idxService++; } /* V2.7版本时的方法 * foreach (ServiceElement serviceElement in serviceModelSectionGroup.Services.Services) * { * var assemblyString = serviceElement.Name.Substring(0, serviceElement.Name.LastIndexOf('.')); * var serviceHost = * new System.ServiceModel.ServiceHost(Assembly.Load(assemblyString).GetType(serviceElement.Name), * serviceElement.Endpoints[0].Address); * * serviceHost.Opened += delegate * { * Console.WriteLine(@"第{0:00}个服务:{1}", idxService, serviceHost.BaseAddresses[0]); * }; * serviceHost.Open(); * idxService++; * }*/ } System.Console.ForegroundColor = ConsoleColor.Green; System.Console.WriteLine(@"服务器端已正常启动..."); System.Console.ForegroundColor = ConsoleColor.White; System.Console.WriteLine(); System.Console.WriteLine(); System.Console.WriteLine(@"服务器 当前时间:" + DateTime.Now.ToString(SystemInfo.DateTimeFormat)); var dbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType, SystemInfo.RDIFrameworkDbConection); System.Console.WriteLine(@"数据库服务器 当前时间:" + dbProvider.GetDBDateTime()); System.Console.WriteLine(); // 写入调试信息 #if (DEBUG) var rdiDBProviderService = new RDIFrameworkDBProviderService(); System.Console.WriteLine(@"RDIFramework.NET ━ .NET快速信息化系统开发框架 数据库服务器数据库连接:"); System.Console.WriteLine(rdiDBProviderService.ServiceDbConnection); System.Console.WriteLine(rdiDBProviderService.ExecuteScalar(SystemInfo.UserInfo, "SELECT GETDATE()").ToString()); System.Console.WriteLine(); var bizDBProviderService = new BusinessDBProviderService(); System.Console.WriteLine(@"业务数据库服务器 数据库连接:"); System.Console.WriteLine(bizDBProviderService.ServiceDbConnection); System.Console.WriteLine(bizDBProviderService.ExecuteScalar(SystemInfo.UserInfo, "SELECT GETDATE()").ToString()); System.Console.ReadLine(); #endif Application.Run(new FrmServiceHost()); }
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; } }