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;
}
}
