public SaveDataToDb() { DataAccess = new DataAcc(); DataAccess.ConnectionString = InitConfig.DbConnectionString; DataAccess.ProviderName = InitConfig.DbProvideName; DataAnalyAccess = new Tcs.Libary.DataAccess(); DataAnalyAccess.ConnectionString = InitConfig.AnsyDbConnectionString; dtsPath = InitConfig.DtsPath; CoalSavaItems= new string[150, 2]; }
public UpLoadState() { MessageState.TimeToBeReceived = new TimeSpan(0, 0, 10);//接受目标消息队列所需的最长时间10秒 MessageState.TimeToReachQueue = new TimeSpan(0, 0, 10);//消息到达队列所需的最长时间10秒 MessageState.Formatter = new System.Messaging.BinaryMessageFormatter();//消息队列格式:二进制 mcoper = new MqClientOperation(); //初始化消息队列 mcoper.InitServerQueue(InitConfig.RealStateServerIP, InitConfig.RealStateQueueName, false); dataAcc = new DataAcc(); dataAcc.ConnectionString = InitConfig.AnsyDbConnectionString; }
public SaveDataToDb(string WsDownvalue, string WsUpvalue, string CODownvalue, string COUpvalue,bool checkUserGB) { this.WsDownvalue = WsDownvalue; this.WsUpvalue = WsUpvalue; this.CODownvalue = CODownvalue; this.COUpvalue = COUpvalue; this.userGB = checkUserGB; DataAccess = new DataAcc(); DataAccess.ConnectionString = InitConfig.DbConnectionString; DataAccess.ProviderName = InitConfig.DbProvideName; DataAnalyAccess = new Tcs.Libary.DataAccess(); DataAnalyAccess.ConnectionString = InitConfig.AnsyDbConnectionString; dtsPath = InitConfig.DtsPath; CoalSavaItems = new string[150, 2]; }
private DataAcc GetDataAccess() { string SQL_TRUST = "Server=(ip);Integrated Security=SSPI;database=db;"; string SQL_NOTRUST = "Data Source=ip;Initial Catalog=db; User ID=uid;Password=pwd;"; string uid = this.txtUid.Text; string pwd = this.txtPwd.Text; string dbName = cboxDBName.SelectedItem != null ? cboxDBName.SelectedItem.ToString() : string.Empty; string server = txtServerIP.Text; Tcs.Libary.DataAccess da = new Tcs.Libary.DataAccess(); if (dbName.Length == 0) dbName = "master"; if (cboxTrust.Checked) da.ConnectionString = SQL_TRUST.Replace("ip", server).Replace("db", dbName); else da.ConnectionString = SQL_NOTRUST.Replace("ip", server).Replace("db", dbName).Replace("uid", uid).Replace("pwd", pwd); return da; }