private void Connect_Btn_Click(object sender, EventArgs e)
{
string connectionString = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3};", Server_cmbBox.Text, Database_TxtBox.Text, Username_TxtBox.Text, Password_TxtBox.Text);
try
{
SqlHelper helper = new SqlHelper(connectionString);
if (helper.IsConnection)
{
StartForm.showBalloon("Sql Connection", "connection succeeded...");
StartForm.ConnectionString_main = connectionString;
connectionString = string.Format("metadata=res://*/myModel.csdl|res://*/myModel.ssdl|res://*/myModel.msl;provider=System.Data.SqlClient;provider connection string="data source={0};initial catalog={1};persist security info=True;user id={2};password={3};MultipleActiveResultSets=True;App=EntityFramework"", Server_cmbBox.Text, Database_TxtBox.Text, Username_TxtBox.Text, Password_TxtBox.Text);
AppSetting setting = new AppSetting();
string apps = setting.GetConnectionString("EmployeeCardentities");
setting.SaveConnectionString("EmployeeCardentities", connectionString);
StartForm.showBalloon("App Config", "Your connection string has been successfully saved.");
apps = setting.GetConnectionString("EmployeeCardentities");
this.Hide();
pass form = new pass();
form.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
static void Main(string[] args)
{
AppSetting appconfig = new AppSetting("appsettings.json");
AbsMqttBase.SetDefaultLoggerName("nlog.config", true);
string mysql_connectionString = appconfig.GetConnectionString("peiudb");
ISessionFactory sessionFactory = CreateSessionFactory(mysql_connectionString, appconfig.GetAssembly());
var redisConfiguration = appconfig.GetSection <RedisConfiguration>("redis");
ConnectionMultiplexer conn = ConnectionMultiplexer.Connect(redisConfiguration.ConfigurationOptions);
// NLog: setup the logger first to catch all errors
NLog.LogManager.Configuration = new NLog.Config.XmlLoggingConfiguration("nlog.config");
Console.CancelKeyPress += Console_CancelKeyPress;
EventSubscribeWorker worker = new EventSubscribeWorker(sessionFactory, conn);
CancellationToken token = cancellationTokenSource.Token;
worker.Initialize();
while (true)
{
try
{
token.ThrowIfCancellationRequested();
Task workTask = worker.MqttSubscribeAsync(token);
workTask.Wait();
Task.Delay(100);
}
catch (Exception ex)
{
}
}
}
public LayoutDetails()
{
int _conTimeOut = 300;
DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty, ref _conTimeOut);
DataExecutor.ConnectionTimeout = _conTimeOut;
}
private void FormAturan_Load(object sender, EventArgs e)
{
this.url = setting.GetConnectionString("api");
var parser = new FileIniDataParser();
IniData data = parser.ReadFile("app.ini");
this.id = data["Sekolah"]["IDSekolah"];
this.nama = data["Sekolah"]["NamaSekolah"];
this.lokasi = data["Sekolah"]["LokasiSekolah"];
this.mesin = data["Sekolah"]["SupportMesin"];
_ = GetKantorAsync();
}
/// <summary>
/// 获取数据库连接
/// </summary>
/// <returns></returns>
public static IDbConnection CreateConnection()
{
IDbConnection connection = null;
//获取配置进行转换
var type = AppSetting.GetConfig("ComponentDbType");
var dbType = GetDataBaseType(type);
//DefaultDatabase 根据这个配置项获取对应连接字符串
var database = AppSetting.GetConfig("DefaultDatabase");
if (string.IsNullOrEmpty(database))
{
database = "sqlserver";//默认配置
}
// var strConn = AppConfig.Configuration.GetConnectionString(database);
var strConn = AppSetting.GetConnectionString(database);
switch (dbType)
{
case DatabaseType.SqlServer:
connection = new System.Data.SqlClient.SqlConnection(strConn);
break;
case DatabaseType.MySql:
// connection = new MySql.Data.MySqlClient.MySqlConnection(strConn);
break;
case DatabaseType.Npgsql:
// connection = new Npgsql.NpgsqlConnection(strConn);
break;
case DatabaseType.Sqlite:
// connection = new SQLiteConnection(strConn);
break;
case DatabaseType.Oracle:
// connection = new Oracle.ManagedDataAccess.Client.OracleConnection(strConn);
//connection = new System.Data.OracleClient.OracleConnection(strConn);
break;
case DatabaseType.DB2:
//connection = new System.Data.OleDb.OleDbConnection(strConn);
break;
}
return(connection);
}
public FormProsesUploadPegawaiKeWeb()
{
InitializeComponent();
this.url = setting.GetConnectionString("api");
try
{
var parser = new FileIniDataParser();
IniData data = parser.ReadFile("app.ini");
this.kantor = data["Sekolah"]["IDSekolah"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public CommonDetails()
{
DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty);
}
public ZodiacWebDetails()
{
DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty);
}
