static void pvTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
pvTimer.Stop();
try
{
Log.LoadInfo(Utils.pv_name + "定时器触发");
DBConfigModel pvDBModel = Utils.GetPVConfigInfo();
string pv_status = pvDBModel.Run_Status;
string pv_time_interval = pvDBModel.Time_Interval;
pvTimer.Interval = Int16.Parse(pv_time_interval) * 60 * 1000;
#if DEBUG
if (pv_status == "1")
{
pvTimer.Interval = 1000 * 5;
}
#endif
if (pv_status == "1")
{
new PVTimerWorker().GetAndInsertFCSData();
new PVTimerWorker().GetAndInsertFIFSData();
new PVTimerWorker().GetAndInsertFIPData();
new PVTimerWorker().GetAndInsertFPSData();
}
}
catch (Exception ex)
{
Log.LoadInfo(Utils.pv_name + "定时器触发错误:" + ex);
Console.WriteLine(Utils.pv_name + "定时器触发错误:" + ex.Message);
}
finally
{
pvTimer.Start();
}
}
/// <summary>
/// 加载数配置下拉框变化触发
/// </summary>
private void cbo_dbset_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DBConfigModel model = (DBConfigModel)cbo_dbset.SelectedItem;
string def_DB = model.def_DB;
DBInfo.SetConnectionString(model);
var dbList = DBInfo.GetDBsInfo();
if (dbList != null)
{
cbo_db.ValueMember = "name";
cbo_db.DisplayMember = "name";
cbo_db.DataSource = dbList;
cbo_db.SelectedValue = def_DB;
}
else
{
MessageBox.Show("连接失败!");
}
}
catch (Exception ex)
{
MessageBox.Show("连接失败!");
}
}
private void LoadDataJb(DBConfigModel model)
{
var dbTable = DBInfo.GetTablesInfo(model.def_DB);
cbx_TableList.SetDataSource(dbTable, "name");
CbConfigClear();
}
public void SetUpdate(DBConfigModel _dBInfoModel)
{
isUpdate = true;
dBInfoModel = _dBInfoModel;
this.txb_Ip.Text = dBInfoModel.Ip;
this.txb_User.Text = dBInfoModel.User;
this.txb_Pwd.Text = dBInfoModel.pwd;
this.cbx_DbDefault.Text = dBInfoModel.def_DB;
}
/// <summary>
/// 加载面板
/// </summary>
private void LoadCreate(DBConfigModel model)
{
var dbTable = DBInfo.GetTablesInfo(model.def_DB);
dgv_TablesDataSource(dbTable);
DataTable dt = (DataTable)dgv_Column.DataSource;
if (dt != null)
{
dt.Rows.Clear();
dgv_Column.DataSource = dt;
}
}
private void EditOrAdd(DBConfigModel model = null)
{
DBConfig dBConfig = new DBConfig();
if (model != null)
{
dBConfig.SetUpdate(model);
}
if (dBConfig.ShowDialog() == DialogResult.OK)
{
LoadData();
}
;
dBConfig.Activate();
}
public async Task <JsonResult> MyAction(string id, [FromServices] INodeServices nodeServices)
{
var queryStrings = Request.Query;
string config = "pg://*****:*****@[email protected]:5432/postgres";
DBConfigModel model = new DBConfigModel()
{
type = "pg",
config = config,
query = string.Format("SELECT * FROM public.apisrepository {0}", (string.IsNullOrEmpty(id))? string.Empty:"where id = " + id)
};
ResponseObj result = await nodeServices.InvokeAsync <ResponseObj>("./NodeApp/db-config-main", "GET", model);
return(Json(result));
}
/// <summary>
/// 数据库变化时触发
/// </summary>
private void cbo_db_SelectedIndexChanged(object sender, EventArgs e)
{
DataRowView model = (DataRowView)cbo_db.SelectedItem;
DBConfigModel dbInfo = (DBConfigModel)cbo_dbset.SelectedItem;
if (model != null)
{
dbInfo.def_DB = model[0].ToString();
dbInfo.AddOrUpdate();
DBInfo.SetConnectionString(dbInfo);
if (tcl_tabList.SelectedTab.Name == tbp_TableScript.Name)
{
LoadCreate(dbInfo);
}
else
{
LoadDataJb(dbInfo);
}
}
}
/// <summary>
/// 获取PV数据库连接信息
/// </summary>
/// <returns></returns>
public static DBConfigModel GetPVConfigInfo()
{
DBConfigModel pvDBConfigInfo = null;
try
{
pvDBConfigInfo = new DBConfigModel();
string ScvConnStr = ConfigurationManager.ConnectionStrings["ScvConnectionString"].ConnectionString;
using (OracleConnection SCVConn = new OracleConnection(ScvConnStr))
{
SCVConn.Open();
string cmd = @"select * from Interface_Param where Interface_name = '" + Utils.pv_name + "'";
var SCVCmd = new OracleCommand(cmd, SCVConn);
var reader = SCVCmd.ExecuteReader();
while (reader.Read())
{
string ip = reader["IP_ADDRESS"].ToString();
string port = reader["PORT"].ToString();
string db_name = reader["DB_SSID"].ToString();
string user_id = reader["USER_ID"].ToString();
string pwd = reader["password"].ToString();
pwd = string.IsNullOrEmpty(pwd) ? string.Empty : Base64.Base64Decode(pwd);
string connstr = "Data Source=" + ip + "," + port + ";User ID=" + user_id + ";Password="******";Initial Catalog=" + db_name + ";Connect Timeout=10";
pvDBConfigInfo.ConnectionString = connstr;
pvDBConfigInfo.Time_Interval = reader["TIME_INTERVAL"].ToString();
pvDBConfigInfo.Run_Status = reader["RUN_STATUS"].ToString();
Utils.pv_type = reader["Interface_type"].ToString();
}
reader.Dispose();
return(pvDBConfigInfo);
}
}
catch (Exception ex)
{
Log.LoadInfo(Utils.pv_name + "GetPVConfigInfo异常:" + ex);
Console.WriteLine(Utils.pv_name + "GetPVConfigInfo异常:" + ex.Message);
return(pvDBConfigInfo);
}
}
/// <summary>
/// 启动定时器
/// </summary>
public void StartPVTimer()
{
try
{
pvTimer = new System.Timers.Timer();
DBConfigModel pvDBModel = Utils.GetPVConfigInfo();
string pv_status = pvDBModel.Run_Status;
string pv_time_interval = pvDBModel.Time_Interval;
pvTimer.Interval = Int16.Parse(pv_time_interval) * 60 * 1000;
pvTimer.Enabled = true;
pvTimer.AutoReset = true;
#if DEBUG
pvTimer.Interval = 1000 * 5;
#endif
pvTimer.Elapsed += pvTimer_Elapsed;
pvTimer.Start();
Log.LoadInfo("定时器启动成功");
}
catch (Exception ex)
{
Log.LoadInfo(Utils.pv_name + "定时器启动错误:" + ex);
Console.WriteLine(Utils.pv_name + "定时器启动错误:" + ex.Message);
}
}
public static void SetConnectionString(DBConfigModel model)
{
string str = string.Format(ConnectionStringTemp, model.Ip, model.def_DB, model.User, model.pwd);
SQLHelper.Instance.ConnectionString = str;
}
public DBConfig()
{
InitializeComponent();
dBInfoModel = new DBConfigModel();
}
