public void readTablesStates(DateTime date)
{
SqlConnection con = DBSettings.getConnection();
con.Open();
tablesState = new Dictionary <int, List <string> >();
foreach (int ss in SignalsBySubSys.Keys)
{
string tabName = String.Format("data_{0}_tabs", ss);
SqlCommand com = con.CreateCommand();
Status.Text = "Чтение списка таблиц с данными " + ss;
com.CommandText = "Select * from " + tabName;
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
DateTime ds = EPADB.GetDate(reader.GetInt32(1));
DateTime de = EPADB.GetDate(reader.GetInt32(2));
string nm = reader.GetString(0);
if (nm.ToLower().Contains("tmp") || (date >= ds && date <= de))
{
string stTab = reader.GetString(0);
if (!tablesState.ContainsKey(ss))
{
tablesState.Add(ss, new List <string>());
}
tablesState[ss].Add(stTab);
}
}
reader.Close();
}
con.Close();
}
public void readTables()
{
subSystemsByTables = new Dictionary <string, int>();
SqlConnection con = DBSettings.getConnection();
con.Open();
tables = new List <string>();
foreach (int ss in SignalsBySubSys.Keys)
{
string tabName = String.Format("data_{0}_tabs", ss);
SqlCommand com = con.CreateCommand();
Status.Text = "Чтение списка таблиц с данными " + ss;
com.CommandText = "Select * from " + tabName + " order by time_beg";
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
DateTime ds = EPADB.GetDate(reader.GetInt32(1));
DateTime de = EPADB.GetDate(reader.GetInt32(2));
string nm = reader.GetString(0);
if (nm.ToLower().Contains("tmp") || (de >= DateStart && ds <= DateEnd)
/*(ds < DateStart && !(de < DateStart)) || (de > DateEnd && !(ds > DateEnd)) || (ds >= DateStart && de <= DateEnd)*/)
{
string stTab = reader.GetString(0);
tables.Add(stTab);
subSystemsByTables.Add(stTab, ss);
}
}
reader.Close();
}
con.Close();
}
string XAxis_ScaleFormatEvent(ZedGraph.GraphPane pane, ZedGraph.Axis axis, double val, int index)
{
try {
int num = Convert.ToInt32(val);
return(EPADB.GetDate(num).ToString());
}
catch {
return("");
}
}
public Form1()
{
InitializeComponent();
Logger.InitFileLogger("log", "epaLog");
epa = new EPADB();
epa.Status = statusLabel;
epa.Status.TextChanged += Status_TextChanged;
txtDate1.Text = DateTime.Now.AddHours(-2).ToString("dd.MM.yyyy HH:00");
txtDate2.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
txtDate3.Text = DateTime.Now.AddHours(-2).ToString("dd.MM.yyyy HH:00");
txtDate4.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
txtDate.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
textBox1.Text = "300";
}
public Form1()
{
InitializeComponent();
Logger.InitFileLogger("log", "epaLog");
epa = new EPADB();
epa.Status = statusLabel;
epa.Status.TextChanged += Status_TextChanged;
txtDate1.Text = DateTime.Now.AddHours(-2).ToString("dd.MM.yyyy HH:00");
txtDate2.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
txtDate3.Text = DateTime.Now.AddHours(-2).ToString("dd.MM.yyyy HH:00");
txtDate4.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
txtDate.Text = DateTime.Now.ToString("dd.MM.yyyy HH:00");
textBox1.Text = "300";
}
public void readTables()
{
List <int> DiscrSubSystems = new List <int>();
subSystemsByTables = new Dictionary <string, int>();
foreach (KeyValuePair <int, string> de in epa.SubSystems)
{
if (de.Value.Contains("Дискр"))
{
DiscrSubSystems.Add(de.Key);
}
if (epa.SelectedDiscrSignals.Count > 0)
{
if (!SignalsBySubSys.ContainsKey(de.Key))
{
DiscrSubSystems.Remove(de.Key);
}
}
}
SqlConnection con = DBSettings.getConnection();
con.Open();
tables = new List <string>();
foreach (int ss in DiscrSubSystems)
{
string tabName = String.Format("data_{0}_tabs", ss);
SqlCommand com = con.CreateCommand();
Status.Text = "Чтение списка таблиц с данными " + ss;
com.CommandText = "Select * from " + tabName;
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
DateTime ds = EPADB.GetDate(reader.GetInt32(1));
DateTime de = EPADB.GetDate(reader.GetInt32(2));
string nm = reader.GetString(0);
if (nm.ToLower().Contains("tmp") || (de >= DateStart && ds <= DateEnd)
/*(ds < DateStart && !(de < DateStart)) || (de > DateEnd && !(ds > DateEnd)) || (ds >= DateStart && de <= DateEnd)*/)
{
string evTab = reader.GetString(6);
tables.Add(evTab);
subSystemsByTables.Add(evTab, ss);
/*string stTab = reader.GetString(0);
* tables.Add(stTab);*/
}
}
reader.Close();
}
con.Close();
}
public EpaAnalogData(DateTime dateStart, DateTime dateEnd, EPADB epa, int step)
{
DateStart = dateStart;
DateEnd = dateEnd;
Step = step;
this.epa = epa;
Colors = new Dictionary<int, Color>();
Colors.Add(0, Color.Black);
Colors.Add(1, Color.Red);
Colors.Add(2, Color.Blue);
Colors.Add(3, Color.Green);
Colors.Add(4, Color.Orange);
Colors.Add(5, Color.DarkGray);
Colors.Add(6, Color.DarkViolet);
Colors.Add(7, Color.Brown);
}
public EpaAnalogData(DateTime dateStart, DateTime dateEnd, EPADB epa, int step)
{
DateStart = dateStart;
DateEnd = dateEnd;
Step = step;
this.epa = epa;
Colors = new Dictionary <int, Color>();
Colors.Add(0, Color.Black);
Colors.Add(1, Color.Red);
Colors.Add(2, Color.Blue);
Colors.Add(3, Color.Green);
Colors.Add(4, Color.Orange);
Colors.Add(5, Color.DarkGray);
Colors.Add(6, Color.DarkViolet);
Colors.Add(7, Color.Brown);
}
public void readData(string fn, GraphPane graph)
{
SqlConnection con = DBSettings.getConnection();
con.Open();
Int64 timeStart = EPADB.GetIntDate(DateStart);
Int64 timeEnd = EPADB.GetIntDate(DateEnd);
Dictionary <Int64, Dictionary <string, double> > Data = new Dictionary <long, Dictionary <string, double> >();
Int64 time = timeStart;
while (time <= timeEnd)
{
Data.Add(time, new Dictionary <string, double>());
foreach (SignalInfo si in epa.SelectedAnalogSignals)
{
Data[time].Add(si.KKS, double.NaN);
}
time += Step;
}
List <string> kksQList = new List <string>();
List <int> numSignQList = new List <int>();
List <int> timesQList = new List <int>();
Dictionary <int, int> timesDict = new Dictionary <int, int>();
List <int> timesList = new List <int>();
foreach (int ss in SignalsBySubSys.Keys)
{
foreach (string table in tables)
{
if (subSystemsByTables[table] != ss)
{
continue;
}
Status.Text = "Обработка таблицы " + table;
SqlCommand com = con.CreateCommand();
com.CommandText = String.Format("Select * from {0} where time_page>={1} and time_page<={2}", table.Replace("state", "time"), timeStart, timeEnd);
List <Int32> times = new List <int>();
try {
Status.Text += "---|";
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
try {
int tm = reader.GetInt32(0);
times.Add(tm);
}
catch { }
}
times.Sort();
reader.Close();
foreach (SignalInfo si in SignalsBySubSys[ss])
{
kksQList.Add("'" + si.KKS + "'");
numSignQList.Add(si.numSign);
if (kksQList.Count() <= 10 && si != SignalsBySubSys[ss].Last())
{
continue;
}
string kksQ = String.Join(",", kksQList);
string numQ = String.Join(",", numSignQList);
kksQList.Clear();
timesDict.Clear();
numSignQList.Clear();
timesQList.Clear();
foreach (int t in Data.Keys)
{
if (t >= times.First() && t <= times.Last())
{
int valT = times.First(tempT => { return(tempT >= t); });
if (valT - t < Step)
{
timesQList.Add(valT);
timesDict.Add(valT, t);
}
}
if (timesQList.Count < 100 && t != Data.Keys.Last())
{
continue;
}
string timesQ = String.Join(",", timesQList);
timesQList.Clear();
try {
com = con.CreateCommand();
//com.CommandText = String.Format("Select kks_id_signal,time_page,data from {0} where time_page in ({2}) and kks_id_signal in ({1})", table, kksQ, timesQ);
//com.CommandText = String.Format("Select kks_id_signal,time_page,data from {0} where time_page={2} and kks_id_signal = '{1}'", table, kks, valT);
if (!epa.UseNumSignals)
{
com.CommandText = String.Format("Select kks_id_signal,time_page,data from {0} where time_page in ({2}) and kks_id_signal in ({1})", table, kksQ, timesQ);
}
else
{
com.CommandText = String.Format("Select kks_id_signal,time_page,data from {0} where time_page in ({2}) and num_sign in ({1})", table, numQ, timesQ);
}
Status.Text += "---|";
reader = com.ExecuteReader();
while (reader.Read())
{
try {
int timeRes = reader.GetInt32(1);
string kksAsu = reader.GetString(0);
double val = reader.GetFloat(2);
long resultTime = timesDict[timeRes];
Data[resultTime][kksAsu] = val;
}
catch (Exception e) { Logger.Info(e.ToString()); }
}
reader.Close();
}
catch (Exception e) { Logger.Info(e.ToString()); }
}
}
}
catch (Exception e) { Logger.Info(e.ToString()); }
}
}
con.Close();
Status.Text = "Чтение завершено";
List <string> thAsuList = new List <string>();
List <string> thTechList = new List <string>();
foreach (SignalInfo si in epa.SelectedAnalogSignals)
{
thAsuList.Add(String.Format("<th>{0}</th>", si.ShortName));
try {
string kksTech = epa.ASUTechDict[si.KKS];
SignalInfo tech = epa.FindSignal(epa.TechRoot, kksTech, null);
thTechList.Add(String.Format("<th>{0}</th>", tech.ShortName));
}
catch {
thTechList.Add("<th>-</th>");
}
}
OutputData.writeToOutput(fn, String.Format("<table border='1'><tr><th rowspan='2'>Дата</th>{0}</tr><tr>{1}</tr>", string.Join(" ", thAsuList), string.Join(" ", thTechList)));
foreach (int tm in Data.Keys)
{
OutputData.writeToOutput(fn, String.Format("<tr><th>{0}</th><td>{1}</td></tr>", EPADB.GetDate(tm), String.Join("</td><td>", Data[tm].Values)));
}
OutputData.writeToOutput(fn, "</table>");
graph.CurveList.Clear();
graph.XAxis.Scale.Min = Data.Keys.First();
graph.XAxis.Scale.Max = Data.Keys.Last();
graph.XAxis.Scale.MinAuto = false;
graph.XAxis.Scale.MaxAuto = false;
graph.XAxis.Title.IsVisible = false;
graph.YAxis.IsVisible = false;
graph.YAxis.Title.IsVisible = false;
graph.Legend.FontSpec.Size = 6;
graph.Legend.Location.X = 0;
graph.Legend.Location.Y = 0;
graph.Title.IsVisible = false;
graph.YAxis.Scale.FontSpec.Size = 6;
graph.YAxis.IsVisible = false;
graph.XAxis.Scale.FontSpec.Size = 6;
int index = 0;
foreach (SignalInfo si in epa.SelectedAnalogSignals)
{
try {
string name = si.ShortName;
int axInd = graph.AddYAxis("");
graph.YAxisList[axInd].Color = Colors[index % 8];
graph.YAxisList[axInd].Scale.FontSpec.Size = 6;
graph.YAxisList[axInd].Scale.FontSpec.FontColor = Colors[index % 8];
try {
string kksTech = epa.ASUTechDict[si.KKS];
SignalInfo tech = epa.FindSignal(epa.TechRoot, kksTech, null);
name = name + " (" + tech.ShortName + ")";
}
catch { }
PointPairList list = new PointPairList();
foreach (int tm in Data.Keys)
{
list.Add(new PointPair(tm, Data[tm][si.KKS]));
}
graph.AddCurve(name, list, Colors[index % 8], SymbolType.None);
graph.CurveList[index].YAxisIndex = axInd;
}
catch (Exception e) {
Logger.Info(e.ToString());
}
graph.AxisChange();
index++;
}
}
public EpaDiscrData(DateTime dateStart, DateTime dateEnd, EPADB epa)
{
DateStart = dateStart;
DateEnd = dateEnd;
this.epa = epa;
}
public void readState(DateTime date, DataGridView grid)
{
SqlConnection con = DBSettings.getConnection();
con.Open();
Int64 time = EPADB.GetIntDate(date);
grid.Rows.Clear();
Dictionary <string, int> gridRows = new Dictionary <string, int>();
Dictionary <string, SignalInfo> signals = new Dictionary <string, SignalInfo>();
foreach (SignalInfo siAsu in epa.SelectedDiscrSignals)
{
try {
int i = grid.Rows.Add();
SignalInfo siTech = null;
try {
string kksTech = epa.ASUTechDict[siAsu.KKS];
siTech = epa.FindSignal(epa.TechRoot, kksTech, null);
}
catch { }
grid.Rows[i].Cells[0].Value = siAsu.ShortName;
grid.Rows[i].Cells[1].Value = siTech != null ? siTech.ShortName : "-";
grid.Rows[i].Cells[2].Value = "-";
grid.Rows[i].Cells[3].Value = "-";
grid.Rows[i].Cells[4].Value = "-";
gridRows.Add(siAsu.KKS, i);
signals.Add(siAsu.KKS, siAsu);
}
catch { }
}
foreach (int subSys in tablesState.Keys)
{
Status.Text = "Чтение данных подсистемы " + subSys;
foreach (string table in tablesState[subSys])
{
try {
SqlCommand com = con.CreateCommand();
com.CommandText = String.Format("Select top 1 time_page from {0} where time_page>={1}", table.Replace("state", "time"), time);
Object timeObj = com.ExecuteScalar();
if ((Int32)timeObj <= 0)
{
continue;
}
List <string> kksQList = new List <string>();
List <int> numsQList = new List <int>();
foreach (SignalInfo si in SignalsBySubSys[subSys])
{
try {
kksQList.Add("'" + si.KKS + "'");
numsQList.Add(si.numSign);
if (kksQList.Count < 10 && si != SignalsBySubSys[subSys].Last())
{
continue;
}
string kksQ = string.Join(",", kksQList);
string numsQ = string.Join(",", numsQList);
kksQList.Clear();
numsQList.Clear();
Status.Text = Status.Text + "...|";
if (!epa.UseNumSignals)
{
com.CommandText = String.Format("Select time_page,time,kks_id_signal,mcs,data,bsrc from {0} where time_page={1} and kks_id_signal in ({2})", table, timeObj, kksQ);
}
else
{
com.CommandText = String.Format("Select time_page,time,kks_id_signal,mcs,data,bsrc from {0} where time_page={1} and num_sign in ({2})", table, timeObj, numsQ);
}
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
DateTime dt = EPADB.GetDate(reader.GetInt32(0));
DateTime dt_prev = EPADB.GetDate(reader.GetInt32(1));
string kksAsu = reader.GetString(2);
int state = Int32.Parse(reader[4].ToString());
int src = Int32.Parse(reader[5].ToString());
int mcs = Int32.Parse(reader[3].ToString());
dt = dt.AddMilliseconds(mcs / 1000.0);
int index = gridRows[kksAsu];
grid.Rows[index].Cells[2].Value = dt_prev.ToString("dd.MM.yyyy HH:mm:ss,fff");
grid.Rows[index].Cells[3].Value = EPADB.getSignalState(state, signals[kksAsu]);
grid.Rows[index].Cells[4].Value = EPADB.getSignalSrc(src);
}
reader.Close();
}
catch (Exception e) { Logger.Info(e.ToString()); }
}
}
catch (Exception e) { Logger.Info(e.ToString()); }
}
}
Status.Text = "Готово ";
}
public void readData(string fn)
{
OutputData.writeToOutput(fn, "<table border='1'><tr><th>Дата</th><th>kks_asu</th><th>kks_tech</th><th>name_asu</th><th>name_tech</th><th>state</th><th>source</th><th>subsys</th></tr>");
SqlConnection con = DBSettings.getConnection();
con.Open();
Int64 timeStart = EPADB.GetIntDate(DateStart);
Int64 timeEnd = EPADB.GetIntDate(DateEnd);
Dictionary <int, string> colors = new Dictionary <int, string>();
colors.Add(0, "white");
colors.Add(1, "PaleGreen");
colors.Add(2, "LightSkyBlue");
colors.Add(3, "LightCoral");
SortedList <DateTime, string> outputData = new SortedList <DateTime, string>();
foreach (string tab in tables)
{
SqlCommand com = con.CreateCommand();
Status.Text = "Чтение данных из таблицы " + tab;
int index = 0;
try {
com.CommandText = String.Format("Select time,mcs,data,kks_id_signal,bsrc from {0} where time>={1} and time<={2}", tab, timeStart, timeEnd);
if (epa.SelectedDiscrSignals.Count > 0)
{
int ss = subSystemsByTables[tab];
List <string> kksList = new List <string>();
List <int> numsList = new List <int>();
foreach (SignalInfo si in SignalsBySubSys[ss])
{
kksList.Add("'" + si.KKS + "'");
numsList.Add(si.numSign);
}
if (!epa.UseNumSignals)
{
com.CommandText += String.Format(" and kks_id_signal in ({0})", String.Join(",", kksList));
}
else
{
com.CommandText += String.Format(" and num_sign in ({0})", String.Join(",", numsList));
}
}
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
try {
index++;
if (index % 1000 == 0)
{
Status.Text += "...|";
}
DateTime dt = EPADB.GetDate(reader.GetInt32(0));
string kks = reader.GetString(3);
int state = Int32.Parse(reader[2].ToString());
int src = Int32.Parse(reader[4].ToString());
int mcs = Int32.Parse(reader[1].ToString());
dt = dt.AddMilliseconds(mcs / 1000.0);
SignalInfo siAsu = epa.FindSignal(epa.ASURoot, kks, null);
SignalInfo siTech = null;
try {
string kksTech = epa.ASUTechDict[kks];
siTech = epa.FindSignal(epa.TechRoot, kksTech, null);
}
catch { }
string color = "white";
try {
color = colors[state];
}
catch { }
string outStr = String.Format("<tr bgColor='{0}'><th>{1}</th><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td></tr>", color,
dt.ToString("dd.MM.yyyy HH:mm:ss,fff"), kks, siTech == null ? "-" : siTech.KKS, siAsu.ShortName, siTech == null ? "-" : siTech.ShortName,
EPADB.getSignalState(state, siAsu), EPADB.getSignalSrc(src), siAsu.subSys);
if (!outputData.ContainsKey(dt))
{
outputData.Add(dt, "");
}
outputData[dt] += "\r\n" + outStr;
}
catch (Exception e) {
Logger.Info(e.ToString());
}
}
reader.Close();
}
catch { }
}
con.Close();
foreach (string str in outputData.Values)
{
OutputData.writeToOutput(fn, str);
}
OutputData.writeToOutput(fn, "</table>");
Status.Text = "Отчет сформирован";
}
public EpaDiscrData(DateTime dateStart, DateTime dateEnd, EPADB epa)
{
DateStart = dateStart;
DateEnd = dateEnd;
this.epa = epa;
}
