public void BDReadСобытие(ClassZapicBD100 classZapicBD100, bool bad, bool test)
{
if (FlagSaveBD)
{
if (wayDataBD.Split('.')[1] == "db" || wayDataBD.Split('.')[1] == "db3")
{
if (!test)
{
DataAccesBDData.Path = wayDataBD;
int x = 0;
if (bad)
{
x = 1;
}
int[] nll = new int[12];
for (int i = 0; i < 12; i++)
{
nll[i] = Convert.ToInt32(classZapicBD100.Nl[i]);
}
DataAccesBDData.AddDataTablSob100(classZapicBD100.nameRanBD, classZapicBD100.nameFileBD, classZapicBD100.nameBAAKBD, classZapicBD100.timeBD, classZapicBD100.Amp, classZapicBD100.nameklasterBD, classZapicBD100.Amp, classZapicBD100.TmaxACh,
classZapicBD100.TfACh, classZapicBD100.TeACh, classZapicBD100.TpmA, classZapicBD100.TA14Ch, classZapicBD100.TA34Ch, classZapicBD100.QCh, classZapicBD100.SBCh, classZapicBD100.SCh, classZapicBD100.Nl, classZapicBD100.sig, x);
}
}
else
{
}
}
}
public List <Sob> SobListBD()
{
List <Sob> sobs2 = new List <Sob>();
if (pathBD.Split('.')[1] == "db" || pathBD.Split('.')[1] == "db3")
{
DataAccesBDData.Path = pathBD;
string uslovietime = String.Empty;
string sz = " order by Primary_Key";
// CommandText = "select * from [Событие] Where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."+ dateTime.Month.ToString("00")+".2019 %' ) order by Код desc"
var ListSob = DataAccesBDData.GetDataSobTop10("10");
foreach (var d in ListSob)
{
sobs2.Add(new Sob()
{
dataTime = DateTime.Now
});;
}
}
return(sobs2);
}
public virtual void BDReadFile(string nameFile, string nameBAAK, string timeFile, string nameRan)
{
try
{
if (FlagSaveBD)
{
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataBD;
if (wayDataBD.Split('.')[1] == "db" || wayDataBD.Split('.')[1] == "db3")
{
DataAccesBDData.Path = wayDataBD;
DataAccesBDData.AddDataTablФайлы(nameFile, nameBAAK, timeFile, nameRan);
}
else
{
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Файлы](" + "ИмяФайла, Плата, ВремяСоздания, НомерRAN) VALUES (" + "'" + nameFile + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + timeFile + "'" + ", " + "'" + nameRan + "'" + ") "
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Connection = podg;
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Файлы](" + "ИмяФайла, Плата, ВремяСоздания, НомерRAN) VALUES (" + "'" + nameFile + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + timeFile + "'" + ", " + "'" + nameRan + "'" + ") "
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.ExecuteNonQuery();
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Файлы](" + "ИмяФайла, Плата, ВремяСоздания, НомерRAN) VALUES (" + "'" + nameFile + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + timeFile + "'" + ", " + "'" + nameRan + "'" + ") "
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "BDReadFile");
}
finally
{
// закрываем подключение
podg.Close();
podg.Dispose();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public override void BDReadCloseFile(string nameFile, string time)
{
if (FlagSaveBD)
{
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataBD;
if (wayDataBD.Split('.')[1] == "db" || wayDataBD.Split('.')[1] == "db3")
{
DataAccesBDData.Path = wayDataBD;
DataAccesBDData.updateTimeStopDataTablФайл(time, nameFile);
}
else
{
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
new OleDbCommand
{
Connection = podg,
CommandText = "update [Файлы] set ВремяЗакрытия=" + "'" + time + "'" + " where ИмяФайла=" + "'" + nameFile + "'" + ""
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Connection = podg;
new OleDbCommand
{
Connection = podg,
CommandText = "update [Файлы] set ВремяЗакрытия=" + "'" + time + "'" + " where ИмяФайла=" + "'" + nameFile + "'" + ""
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.ExecuteNonQuery();
new OleDbCommand
{
Connection = podg,
CommandText = "update [Файлы] set ВремяЗакрытия=" + "'" + time + "'" + " where ИмяФайла=" + "'" + nameFile + "'" + ""
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Dispose();
}
catch
{
}
finally
{
podg.Close();
}
}
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
FolderBrowserDialog folderBrowser = new FolderBrowserDialog();
DialogResult result = folderBrowser.ShowDialog();
if (!string.IsNullOrWhiteSpace(folderBrowser.SelectedPath))
{
var dir = new System.IO.DirectoryInfo(folderBrowser.SelectedPath);
string pp = folderBrowser.SelectedPath + @"\BD_Data.db";
DataAccesBDData.Path = folderBrowser.SelectedPath + @"\BD_Data.db";
Path.Text = folderBrowser.SelectedPath;
DataAccesBDData.CreateDB();
DataAccesBDData.InitializeDatabase();
RanGrid.ItemsSource = DataAccesBDData.GetDataRun();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog myDialog = new OpenFileDialog
{
Filter = "База данных(*.MDB;*.MDB;*.accdb; *.db; *.db3)|*.MDB;*.MDB;*.ACCDB;*DB; *DB3;" + "|Все файлы (*.*)|*.* ",
CheckFileExists = true,
Multiselect = true
};
if (myDialog.ShowDialog() == DialogResult.OK)
{
Path.Text = myDialog.FileName;
DataAccesBDData.Path = myDialog.FileName;
RanGrid.ItemsSource = DataAccesBDData.GetDataRun();
SobGrid1.ItemsSource = DataAccesBDData.GetDataSob();
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
FolderBrowserDialog folderBrowser = new FolderBrowserDialog();
DialogResult result = folderBrowser.ShowDialog();
if (!string.IsNullOrWhiteSpace(folderBrowser.SelectedPath))
{
var dir = new System.IO.DirectoryInfo(folderBrowser.SelectedPath);
string pp = folderBrowser.SelectedPath + @"\BD_Data_100.db";
DataAccesBDData.Path = folderBrowser.SelectedPath + @"\BD_Data_100.db";
WayBd.Text = folderBrowser.SelectedPath;
set.WaySetup = WayBd.Text;
DataAccesBDData.CreateDB();
DataAccesBDData.InitializeDatabase100();
}
System.Windows.MessageBox.Show("База данных создана");
}
/// <summary>
/// добавление информации ран о времени пуска
/// </summary>
/// <param name="nameRan"></param>
/// <param name="time"></param>
private void BdAddRANTimeПуск(string nameRan, string time)
{
if (set.FlagSaveBD)
{
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + set.WayDATABd;
DataAccesBDData.Path = set.WayDATABd;
if (set.WayDATABd.Split('.')[1] == "db" || set.WayDATABd.Split('.')[1] == "db3")
{
DataAccesBDData.updateTimeZapuskDataTablRun(time, nameRan);
}
else
{
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
new OleDbCommand
{
Connection = podg,
//CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер, ЗначениеТаймера) VALUES (" + "'" + nameRan + "'" + "," + sinx + ", " + allPorog + "," + porog + ", " + trg + "," + "'" + time + "'" + ") "
CommandText = "update [RAN] set ВремяЗапуска=" + "'" + time + "'" + " where НомерRAN=" + "'" + nameRan + "'" + ""
}.Connection = podg;
new OleDbCommand
{
Connection = podg,
//CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер, ЗначениеТаймера) VALUES (" + "'" + nameRan + "'" + "," + sinx + ", " + allPorog + "," + porog + ", " + trg + "," + "'" + time + "'" + ") "
CommandText = "update [RAN] set ВремяЗапуска=" + "'" + time + "'" + " where НомерRAN=" + "'" + nameRan + "'" + ""
}.ExecuteNonQuery();
}
catch
{
}
finally
{
// закрываем подключение
podg.Close();
}
}
}
}
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
DataAccesBDData.AddDataTablRun(new ViewTaiblBDData.ClassTablRun()
{
НомерRun = "18.12.2019 14:18:14:597",
ВремяЗапуска = "18.12.2019 14:18:52:818",
ЗначениеТаймер = "18 14:18:30:0",
ОбщийПорог = 1,
Порог = 10,
Синхронизация = 0,
Триггер = 2
});
// DataAccesBDData.updateTimeZapuskDataTablRun("18.12.2019 14:18:52:818", "18.12.2019 14:18:14:597");
// DataAccesBDData.updateTimeStopDataTablRun("18.12.2019 14:18:52:818", "18.12.2019 14:18:14:597");
RanGrid.ItemsSource = DataAccesBDData.GetDataRun();
// DataAccesBDData.AddDataTablФайлы("1_19.12.2019 00.10.23_N", "У6", "19.12.2019 00.10.23", "18.12.2019 14:18:14:597");
// DataAccesBDData.updateTimeStopDataTablФайл("19.12.2019 00.10.23", "18.12.2019 14:18:14:597");
int[] amp = new int[12];
double[] sig = new double[12];
DataAccesBDData.AddDataTablSob("1_19.12.2019 00.10.23_N", "Y4", "18.12.2019 14:18:14:597", amp, "1", amp, amp, sig, 1);
DataAccesBDData.AddDataTablSobNeutron("1_19.12.2019 00.10.23_N", 1, 10, 5, 9, "18.12.2019 14:18:14:597", 7, 4, 8, 1);
}
public void SobListBD()
{
if (pathBD.Split('.')[1] == "db" || pathBD.Split('.')[1] == "db3")
{
DataAccesBDData.Path = pathBD;
string uslovietime = String.Empty;
string sz = " order by Primary_Key";
// CommandText = "select * from [Событие] Where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."+ dateTime.Month.ToString("00")+".2019 %' ) order by Код desc"
var ListSob = DataAccesBDData.GetDataSobTop10(textColSobList.Text);
list.ItemsSource = ListSob;
try
{
if (chekNoise.IsChecked == true)
{
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show("Error1" + ex.ToString());
}
}
else
{
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + pathBD;
var podg = new OleDbConnection(connectionString);
podg.Open();
int timenaz = Convert.ToInt32(textH.Text);
DateTime dateTime = new DateTime();
dateTime = DateTime.UtcNow;
DateTime dateTime1 = new DateTime();
dateTime1 = DateTime.UtcNow;
dateTime1 = dateTime1.AddHours(-timenaz);
string uslovietime = String.Empty;
var camand = new OleDbCommand
{
Connection = podg,
CommandText = "select TOP 10 from [Событие] order by Код"
// CommandText = "select * from [Событие] Where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."+ dateTime.Month.ToString("00")+".2019 %' ) order by Код desc"
};
try
{
var chit = camand.ExecuteReader();
while (chit.Read() == true)
{
if (chekNoise.IsChecked == true)
{
if (!String.IsNullOrEmpty(chit.GetValue(55).ToString()) && Convert.ToBoolean(chit.GetValue(55)))
{
}
else
{
int[] masA = new int[12];
int[] masN = new int[12];
// MessageBox.Show((chit.GetValue(3)).ToString() + "\n" + (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
masA[0] = Convert.ToInt32(chit.GetValue(5));
masA[1] = Convert.ToInt32(chit.GetValue(6));
masA[2] = Convert.ToInt32(chit.GetValue(7));
masA[3] = Convert.ToInt32(chit.GetValue(8));
masA[4] = Convert.ToInt32(chit.GetValue(9));
masA[5] = Convert.ToInt32(chit.GetValue(10));
masA[6] = Convert.ToInt32(chit.GetValue(11));
masA[7] = Convert.ToInt32(chit.GetValue(12));
masA[8] = Convert.ToInt32(chit.GetValue(13));
masA[9] = Convert.ToInt32(chit.GetValue(14));
masA[10] = Convert.ToInt32(chit.GetValue(15));
masA[11] = Convert.ToInt32(chit.GetValue(16));
masN[0] = Convert.ToInt32(chit.GetValue(18));
masN[1] = Convert.ToInt32(chit.GetValue(19));
masN[2] = Convert.ToInt32(chit.GetValue(20));
masN[3] = Convert.ToInt32(chit.GetValue(21));
masN[4] = Convert.ToInt32(chit.GetValue(22));
masN[5] = Convert.ToInt32(chit.GetValue(23));
masN[6] = Convert.ToInt32(chit.GetValue(24));
masN[7] = Convert.ToInt32(chit.GetValue(25));
masN[8] = Convert.ToInt32(chit.GetValue(26));
masN[9] = Convert.ToInt32(chit.GetValue(27));
masN[10] = Convert.ToInt32(chit.GetValue(28));
masN[11] = Convert.ToInt32(chit.GetValue(29));
// MessageBox.Show((chit.GetValue(3)).ToString()+"\n"+ (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
// sobs.Add(new Sob() { namePSB= chit.GetValue(3).ToString(), kl=Convert.ToInt32(chit.GetValue(2)), masA=masA, masN=masN, dataTime=new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0) });
// x = Convert.ToInt32(chit.GetValue(1));
sobs.Add(new Sob()
{
namePSB = chit.GetValue(3).ToString(), kl = Convert.ToInt32(chit.GetValue(4)), masA = masA, masN = masN, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0)
});
}
}
else
{
//Debug.WriteLine("dfgd"+chit.FieldCount.ToString());
int[] masA = new int[12];
int[] masN = new int[12];
// MessageBox.Show((chit.GetValue(3)).ToString() + "\n" + (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
masA[0] = Convert.ToInt32(chit.GetValue(5));
masA[1] = Convert.ToInt32(chit.GetValue(6));
masA[2] = Convert.ToInt32(chit.GetValue(7));
masA[3] = Convert.ToInt32(chit.GetValue(8));
masA[4] = Convert.ToInt32(chit.GetValue(9));
masA[5] = Convert.ToInt32(chit.GetValue(10));
masA[6] = Convert.ToInt32(chit.GetValue(11));
masA[7] = Convert.ToInt32(chit.GetValue(12));
masA[8] = Convert.ToInt32(chit.GetValue(13));
masA[9] = Convert.ToInt32(chit.GetValue(14));
masA[10] = Convert.ToInt32(chit.GetValue(15));
masA[11] = Convert.ToInt32(chit.GetValue(16));
masN[0] = Convert.ToInt32(chit.GetValue(18));
masN[1] = Convert.ToInt32(chit.GetValue(19));
masN[2] = Convert.ToInt32(chit.GetValue(20));
masN[3] = Convert.ToInt32(chit.GetValue(21));
masN[4] = Convert.ToInt32(chit.GetValue(22));
masN[5] = Convert.ToInt32(chit.GetValue(23));
masN[6] = Convert.ToInt32(chit.GetValue(24));
masN[7] = Convert.ToInt32(chit.GetValue(25));
masN[8] = Convert.ToInt32(chit.GetValue(26));
masN[9] = Convert.ToInt32(chit.GetValue(27));
masN[10] = Convert.ToInt32(chit.GetValue(28));
masN[11] = Convert.ToInt32(chit.GetValue(29));
// MessageBox.Show((chit.GetValue(3)).ToString()+"\n"+ (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
// sobs.Add(new Sob() { namePSB= chit.GetValue(3).ToString(), kl=Convert.ToInt32(chit.GetValue(2)), masA=masA, masN=masN, dataTime=new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0) });
// x = Convert.ToInt32(chit.GetValue(1));
// sobs.Add(new Sob() { namePSB = chit.GetValue(3).ToString(), kl = Convert.ToInt32(chit.GetValue(4)), masA = masA, masN = masN, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0) });
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error1" + ex.ToString());
}
podg.Close();
}
}
public void TempBD()
{
sobs.Clear();
if (pathBD.Split('.')[1] == "db" || pathBD.Split('.')[1] == "db3")
{
DataAccesBDData.Path = pathBD;
int timenaz = Convert.ToInt32(textH.Text);
DateTime dateTime = new DateTime();
dateTime = DateTime.UtcNow;
DateTime dateTime1 = new DateTime();
dateTime1 = DateTime.UtcNow;
dateTime1 = dateTime1.AddHours(-timenaz);
string uslovietime = String.Empty;
DateTime dateTime1Naz = new DateTime();
int x3 = 0;
for (int i = timenaz; i > 0; i--)
{
dateTime1Naz = DateTime.UtcNow;
dateTime1Naz = dateTime1Naz.AddHours(-i);
if (x3 > 0)
{
uslovietime += "or Время Like '" + dateTime1Naz.Day.ToString("00") + "." + dateTime1Naz.Hour.ToString("00") + "%' ";
}
else
{
uslovietime += "Время Like '" + dateTime1Naz.Day.ToString("00") + "." + dateTime1Naz.Hour.ToString("00") + "%' ";
// "(Время Like '" + dateTime1.Day.ToString("00") + "." + dateTime1.Hour.ToString("00") + "%' or Время Like '" + dateTime.Day.ToString("00") + "." + dateTime.Hour.ToString("00") + "%')";
}
x3++;
}
string sz = " (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."
+ dateTime.Month.ToString("00") + "." + dateTime.Year.ToString() + "%') and (" + uslovietime + "or Время Like '" + dateTime.Day.ToString("00") +
"." + dateTime.Hour.ToString("00") + "%') order by Primary_Key";
// CommandText = "select * from [Событие] Where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."+ dateTime.Month.ToString("00")+".2019 %' ) order by Код desc"
var ListSob = DataAccesBDData.GetDataSob(sz);
try
{
if (chekNoise.IsChecked == true)
{
foreach (var d in (from ssob in ListSob where ssob.bad == false select ssob))
{
sobs.Add(new Sob()
{
namePSB = d.Плата, kl = Convert.ToInt32(d.Кластер), masA = d.АмпCh, masN = d.NCh, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(d.Time.ToString().Split('.')[1]), Convert.ToInt32(d.Time.ToString().Split('.')[2]), 0, 0)
});
}
}
else
{
foreach (var d in ListSob)
{
sobs.Add(new Sob()
{
namePSB = d.Плата, kl = Convert.ToInt32(d.Кластер), masA = d.АмпCh, masN = d.NCh, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(d.Time.ToString().Split('.')[1]), Convert.ToInt32(d.Time.ToString().Split('.')[2]), 0, 0)
});
}
}
List <WorkBD.ViewTaiblBDData.ClassTablSob> ff = (from s in ListSob where s.Кластер == "1" select s).ToList();
if (ff.Count > 0)
{
TKl1.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
ff = (from s in ListSob where s.Кластер == "2" select s).ToList();
if (ff.Count > 0)
{
TKl2.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
ff = (from s in ListSob where s.Кластер == "3" select s).ToList();
if (ff.Count > 0)
{
TKl3.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
ff = (from s in ListSob where s.Кластер == "4" select s).ToList();
if (ff.Count > 0)
{
TKl4.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
ff = (from s in ListSob where s.Кластер == "5" select s).ToList();
if (ff.Count > 0)
{
TKl5.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
ff = (from s in ListSob where s.Кластер == "6" select s).ToList();
if (ff.Count > 0)
{
TKl6.Text = ff.ElementAt(ff.Count - 1).Time.ToString();
}
sobs = (from s in sobs where s.dataTime.CompareTo(dateTime1) >= 0 select s).ToList <Sob>();
int colS = (from s in sobs where s.kl == 1 select s).Count();
int colN = (from s in sobs where s.kl == 1 select s.masN.Sum()).Sum();
textSAllKl1.Text = " " + colS.ToString();
textnAllKl1.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 2 select s).Count();
colN = (from s in sobs where s.kl == 2 select s.masN.Sum()).Sum();
textSAllKl2.Text = " " + colS.ToString();
textnAllKl2.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 3 select s).Count();
colN = (from s in sobs where s.kl == 3 select s.masN.Sum()).Sum();
textSAllKl3.Text = " " + colS.ToString();
textnAllKl3.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 4 select s).Count();
colN = (from s in sobs where s.kl == 4 select s.masN.Sum()).Sum();
textSAllKl4.Text = " " + colS.ToString();
textnAllKl4.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 5 select s).Count();
colN = (from s in sobs where s.kl == 5 select s.masN.Sum()).Sum();
textSAllKl5.Text = " " + colS.ToString();
textnAllKl5.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 6 select s).Count();
colN = (from s in sobs where s.kl == 6 select s.masN.Sum()).Sum();
textSAllKl6.Text = " " + colS.ToString();
textnAllKl6.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
ShowDeteClea();
try
{
//ToDo
foreach (var d in detectors)
{
Debug.WriteLine(d.Klaster().ToString());
bool activ = false;
foreach (var sd in _DataColecViev)
{
if (sd.NamKl == d.Klaster().ToString())
{
activ = true;
}
}
d.ColS = (from x in sobs where x.kl == d.Klaster() && x.masA[d.nomerDetectora - ((x.kl - 1) * 12) - 1] > 5 select x).Count();
d.SumSobAll = (from s in sobs where s.kl == d.Klaster() select s).Count();
vizualDetectorA(d.nomerDetectora, d.ColorTextSob);
d.ColN = (from x in sobs where x.kl == d.Klaster() && x.masN[d.nomerDetectora - ((x.kl - 1) * 12) - 1] > 0 select x.masN[d.nomerDetectora - ((x.kl - 1) * 12) - 1]).Sum();
vizualDetectorN(d.nomerDetectora, d.ColorTextNeutron, activ);
}
// MessageBox.Show(chit.GetValue(2).ToString()+"\n"+ chit.GetValue(1).ToString()+"\n"+ dateTime1.ToString()+"\t"+s1.dataTime.ToString() +"\n"+ s1.dataTime.CompareTo(dateTime1).ToString());
}
catch (Exception ex)
{
MessageBox.Show("Error" + "\n" + ex.ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Error1" + ex.ToString());
}
}
else
{
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + pathBD;
var podg = new OleDbConnection(connectionString);
podg.Open();
int timenaz = Convert.ToInt32(textH.Text);
DateTime dateTime = new DateTime();
dateTime = DateTime.UtcNow;
DateTime dateTime1 = new DateTime();
dateTime1 = DateTime.UtcNow;
dateTime1 = dateTime1.AddHours(-timenaz);
string uslovietime = String.Empty;
DateTime dateTime1Naz = new DateTime();
int x3 = 0;
for (int i = timenaz; i > 0; i--)
{
dateTime1Naz = DateTime.UtcNow;
dateTime1Naz = dateTime1Naz.AddHours(-i);
if (x3 > 0)
{
uslovietime += "or Время Like '" + dateTime1Naz.Day.ToString("00") + "." + dateTime1Naz.Hour.ToString("00") + "%' ";
}
else
{
uslovietime += "Время Like '" + dateTime1Naz.Day.ToString("00") + "." + dateTime1Naz.Hour.ToString("00") + "%' ";
// "(Время Like '" + dateTime1.Day.ToString("00") + "." + dateTime1.Hour.ToString("00") + "%' or Время Like '" + dateTime.Day.ToString("00") + "." + dateTime.Hour.ToString("00") + "%')";
}
x3++;
}
var camand = new OleDbCommand
{
Connection = podg,
CommandText = "select * from [Событие] where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."
+ dateTime.Month.ToString("00") + "." + dateTime.Year.ToString() + "%') and (" + uslovietime + "or Время Like '" + dateTime.Day.ToString("00") +
"." + dateTime.Hour.ToString("00") + "%') order by Код"
// CommandText = "select * from [Событие] Where (ИмяФайла Like '%_" + dateTime.Day.ToString("00") + "."+ dateTime.Month.ToString("00")+".2019 %' ) order by Код desc"
};
try
{
var chit = camand.ExecuteReader();
while (chit.Read() == true)
{
if (chekNoise.IsChecked == true)
{
if (!String.IsNullOrEmpty(chit.GetValue(55).ToString()) && Convert.ToBoolean(chit.GetValue(55)))
{
}
else
{
int[] masA = new int[12];
int[] masN = new int[12];
// MessageBox.Show((chit.GetValue(3)).ToString() + "\n" + (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
masA[0] = Convert.ToInt32(chit.GetValue(5));
masA[1] = Convert.ToInt32(chit.GetValue(6));
masA[2] = Convert.ToInt32(chit.GetValue(7));
masA[3] = Convert.ToInt32(chit.GetValue(8));
masA[4] = Convert.ToInt32(chit.GetValue(9));
masA[5] = Convert.ToInt32(chit.GetValue(10));
masA[6] = Convert.ToInt32(chit.GetValue(11));
masA[7] = Convert.ToInt32(chit.GetValue(12));
masA[8] = Convert.ToInt32(chit.GetValue(13));
masA[9] = Convert.ToInt32(chit.GetValue(14));
masA[10] = Convert.ToInt32(chit.GetValue(15));
masA[11] = Convert.ToInt32(chit.GetValue(16));
masN[0] = Convert.ToInt32(chit.GetValue(18));
masN[1] = Convert.ToInt32(chit.GetValue(19));
masN[2] = Convert.ToInt32(chit.GetValue(20));
masN[3] = Convert.ToInt32(chit.GetValue(21));
masN[4] = Convert.ToInt32(chit.GetValue(22));
masN[5] = Convert.ToInt32(chit.GetValue(23));
masN[6] = Convert.ToInt32(chit.GetValue(24));
masN[7] = Convert.ToInt32(chit.GetValue(25));
masN[8] = Convert.ToInt32(chit.GetValue(26));
masN[9] = Convert.ToInt32(chit.GetValue(27));
masN[10] = Convert.ToInt32(chit.GetValue(28));
masN[11] = Convert.ToInt32(chit.GetValue(29));
// MessageBox.Show((chit.GetValue(3)).ToString()+"\n"+ (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
// sobs.Add(new Sob() { namePSB= chit.GetValue(3).ToString(), kl=Convert.ToInt32(chit.GetValue(2)), masA=masA, masN=masN, dataTime=new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0) });
// x = Convert.ToInt32(chit.GetValue(1));
sobs.Add(new Sob()
{
namePSB = chit.GetValue(3).ToString(), kl = Convert.ToInt32(chit.GetValue(4)), masA = masA, masN = masN, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0)
});
}
}
else
{
//Debug.WriteLine("dfgd"+chit.FieldCount.ToString());
int[] masA = new int[12];
int[] masN = new int[12];
// MessageBox.Show((chit.GetValue(3)).ToString() + "\n" + (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
masA[0] = Convert.ToInt32(chit.GetValue(5));
masA[1] = Convert.ToInt32(chit.GetValue(6));
masA[2] = Convert.ToInt32(chit.GetValue(7));
masA[3] = Convert.ToInt32(chit.GetValue(8));
masA[4] = Convert.ToInt32(chit.GetValue(9));
masA[5] = Convert.ToInt32(chit.GetValue(10));
masA[6] = Convert.ToInt32(chit.GetValue(11));
masA[7] = Convert.ToInt32(chit.GetValue(12));
masA[8] = Convert.ToInt32(chit.GetValue(13));
masA[9] = Convert.ToInt32(chit.GetValue(14));
masA[10] = Convert.ToInt32(chit.GetValue(15));
masA[11] = Convert.ToInt32(chit.GetValue(16));
masN[0] = Convert.ToInt32(chit.GetValue(18));
masN[1] = Convert.ToInt32(chit.GetValue(19));
masN[2] = Convert.ToInt32(chit.GetValue(20));
masN[3] = Convert.ToInt32(chit.GetValue(21));
masN[4] = Convert.ToInt32(chit.GetValue(22));
masN[5] = Convert.ToInt32(chit.GetValue(23));
masN[6] = Convert.ToInt32(chit.GetValue(24));
masN[7] = Convert.ToInt32(chit.GetValue(25));
masN[8] = Convert.ToInt32(chit.GetValue(26));
masN[9] = Convert.ToInt32(chit.GetValue(27));
masN[10] = Convert.ToInt32(chit.GetValue(28));
masN[11] = Convert.ToInt32(chit.GetValue(29));
// MessageBox.Show((chit.GetValue(3)).ToString()+"\n"+ (chit.GetValue(4)).ToString() + "\n" + (chit.GetValue(5)).ToString());
// sobs.Add(new Sob() { namePSB= chit.GetValue(3).ToString(), kl=Convert.ToInt32(chit.GetValue(2)), masA=masA, masN=masN, dataTime=new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0) });
// x = Convert.ToInt32(chit.GetValue(1));
sobs.Add(new Sob()
{
namePSB = chit.GetValue(3).ToString(), kl = Convert.ToInt32(chit.GetValue(4)), masA = masA, masN = masN, dataTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[1]), Convert.ToInt32(chit.GetValue(1).ToString().Split('.')[2]), 0, 0)
});
}
}
sobs = (from s in sobs where s.dataTime.CompareTo(dateTime1) >= 0 select s).ToList <Sob>();
int colS = (from s in sobs where s.kl == 1 select s).Count();
int colN = (from s in sobs where s.kl == 1 select s.masN.Sum()).Sum();
textSAllKl1.Text = " " + colS.ToString();
textnAllKl1.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 2 select s).Count();
colN = (from s in sobs where s.kl == 2 select s.masN.Sum()).Sum();
textSAllKl2.Text = " " + colS.ToString();
textnAllKl2.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 3 select s).Count();
colN = (from s in sobs where s.kl == 3 select s.masN.Sum()).Sum();
textSAllKl3.Text = " " + colS.ToString();
textnAllKl3.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 4 select s).Count();
colN = (from s in sobs where s.kl == 4 select s.masN.Sum()).Sum();
textSAllKl4.Text = " " + colS.ToString();
textnAllKl4.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 5 select s).Count();
colN = (from s in sobs where s.kl == 5 select s.masN.Sum()).Sum();
textSAllKl5.Text = " " + colS.ToString();
textnAllKl5.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
colS = (from s in sobs where s.kl == 6 select s).Count();
colN = (from s in sobs where s.kl == 6 select s.masN.Sum()).Sum();
textSAllKl6.Text = " " + colS.ToString();
textnAllKl6.Text = " " + colN.ToString() + "(" + ((double)colN / (double)colS).ToString("0.00") + ")";
//MessageBox.Show("Read" + "\n" + sobs.Count.ToString());
ShowDeteClea();
// MessageBox.Show("Clea" + "\n" + sobs.Count.ToString());
try
{
bool activ = false;
foreach (var d in detectors)
{
foreach (var sd in _DataColecViev)
{
if (sd.NamKl == d.Klaster().ToString())
{
activ = true;
}
}
d.ColS = (from x in sobs where x.kl == d.Klaster() && x.masA[d.nomerDetectora - ((x.kl - 1) * 12) - 1] > 5 select x).Count();
d.SumSobAll = (from s in sobs where s.kl == d.Klaster() select s).Count();
vizualDetectorA(d.nomerDetectora, d.ColorTextSob);
d.ColN = (from x in sobs where x.kl == d.Klaster() && x.masN[d.nomerDetectora - ((x.kl - 1) * 12) - 1] > 0 select x.masN[d.nomerDetectora - ((x.kl - 1) * 12) - 1]).Sum();
vizualDetectorN(d.nomerDetectora, d.ColorTextNeutron, activ);
}
// MessageBox.Show(chit.GetValue(2).ToString()+"\n"+ chit.GetValue(1).ToString()+"\n"+ dateTime1.ToString()+"\t"+s1.dataTime.ToString() +"\n"+ s1.dataTime.CompareTo(dateTime1).ToString());
}
catch (Exception ex)
{
MessageBox.Show("Error" + "\n" + ex.ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Error1" + ex.ToString());
}
podg.Close();
}
try
{
if (Convert.ToBoolean(checList.IsChecked))
{
SobListBD();
}
}
catch (Exception ex)
{
}
}
private void BDReadNeutron(string nameFile, int D, int Amp, int TimeFirst, int TimeEnd, string time, int TimeAmp, int TimeFirst3, int TimeEnd3, bool test, bool bad)
{
if (FlagSaveBD)
{
if (wayDataBD.Split('.')[1] == "db" || wayDataBD.Split('.')[1] == "db3")
{
if (!test)
{
DataAccesBDData.Path = wayDataBD;
int x = 0;
if (bad)
{
x = 1;
}
DataAccesBDData.AddDataTablSobNeutron(nameFile, D, Amp, TimeFirst, TimeEnd, time, TimeAmp, TimeFirst3, TimeEnd3, x);
}
}
else
{
string connectionString;
if (test)
{
connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataTestBD;
}
else
{
connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataBD;
}
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
OleDbCommand oleDbCommand = new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Нейтроны](" + "ИмяФайла, Dn, Amp, TimeFirst, TimeEnd, Время, TimeFirst3, TimeEnd3, TimeAmp, bad) VALUES (" + "'" + nameFile + "'" + "," + "'" + D + "'" + ", " + "'" + Amp + "'" + ", " + "'" + TimeFirst + "'" + ", " + "'" + TimeEnd + "'" + ", " + "'" + time + "'" + ", " + "'" + TimeFirst3 + "'" + ", " + "'" + TimeEnd3 + "'" + ", " + "'" + TimeAmp + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
};
oleDbCommand.Connection = podg;
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Нейтроны](" + "ИмяФайла, Dn, Amp, TimeFirst, TimeEnd, Время, TimeFirst3, TimeEnd3, TimeAmp, bad) VALUES (" + "'" + nameFile + "'" + "," + "'" + D + "'" + ", " + "'" + Amp + "'" + ", " + "'" + TimeFirst + "'" + ", " + "'" + TimeEnd + "'" + ", " + "'" + time + "'" + ", " + "'" + TimeFirst3 + "'" + ", " + "'" + TimeEnd3 + "'" + ", " + "'" + TimeAmp + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.ExecuteNonQuery();
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Нейтроны](" + "ИмяФайла, Dn, Amp, TimeFirst, TimeEnd, Время, TimeFirst3, TimeEnd3, TimeAmp, bad) VALUES (" + "'" + nameFile + "'" + "," + "'" + D + "'" + ", " + "'" + Amp + "'" + ", " + "'" + TimeFirst + "'" + ", " + "'" + TimeEnd + "'" + ", " + "'" + time + "'" + ", " + "'" + TimeFirst3 + "'" + ", " + "'" + TimeEnd3 + "'" + ", " + "'" + TimeAmp + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Dispose();
}
catch (Exception ex)
{
}
finally
{
// закрываем подключение
podg.Close();
}
}
}
}
public virtual void BDReadСобытие(string nameFile, string nameBAAK, string time, int[] Amp, string nameklaster, int[] Nnut, double[] Nl, double[] sig, bool test, bool bad)
{
if (FlagSaveBD)
{
if (wayDataBD.Split('.')[1] == "db" || wayDataBD.Split('.')[1] == "db3")
{
if (!test)
{
DataAccesBDData.Path = wayDataBD;
int x = 0;
if (bad)
{
x = 1;
}
int[] nll = new int[12];
for (int i = 0; i < 12; i++)
{
nll[i] = Convert.ToInt32(Nl[i]);
}
DataAccesBDData.AddDataTablSob(nameFile, nameBAAK, time, Amp, nameklaster, Nnut, nll, sig, x);
}
}
else
{
string connectionString;
if (test)
{
connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataTestBD;
}
else
{
connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + wayDataBD;
}
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Событие](" + "ИмяФайла, Кластер, Плата, Время, АмплитудаКанал1, АмплитудаКанал2, АмплитудаКанал3, АмплитудаКанал4, АмплитудаКанал5, АмплитудаКанал6, АмплитудаКанал7, АмплитудаКанал8, АмплитудаКанал9," +
"АмплитудаКанал10, АмплитудаКанал11, АмплитудаКанал12, n1, n2, n3, n4, n5, n6, n7, n8, n9, n10, n11, n12, Nul1, Nul2, Nul3, Nul4, Nul5, Nul6, Nul7, Nul8, Nul9, Nul10, Nul11, Nul12, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, bad) VALUES (" +
"'" + nameFile + "'" + "," + "'" + nameklaster + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + time + "'" + ", " + "'" + Amp[0] + "'" + ", " + "'" + Amp[1] + "'" + ", " + "'" + Amp[2] + "'" + ", " + "'" + Amp[3] + "'" + ", " + "'"
+ Amp[4] + "'" + ", " + "'" + Amp[5] + "'" + ", " + "'" + Amp[6] + "'" + ", " + "'" + Amp[7] + "'" + ", " + "'" + Amp[8] + "'" + ", " + "'" + Amp[9] + "'" + ", " + "'" + Amp[10] + "'" + ", " + "'" + Amp[11] + "'" + ", " + "'" + Nnut[0] + "'"
+ ", " + "'" + Nnut[1] + "'" + ", " + "'" + Nnut[2] + "'" + ", " + "'" + Nnut[3] + "'" + ", " + "'" + Nnut[4] + "'" + ", " + "'" + Nnut[5] + "'" + ", " + "'" + Nnut[6] + "'" + ", " + "'" + Nnut[7] + "'" + ", " + "'" + Nnut[8]
+ "'" + ", " + "'" + Nnut[9] + "'" + ", " + "'" + Nnut[10] + "'" + ", " + "'" + Nnut[11] + "'" + ", " + "'" + Nl[0] + "'" + ", " + "'" + Nl[1] + "'" + ", " + "'" + Nl[2] + "'" + ", " + "'" + Nl[3] + "'" + ", " + "'" + Nl[4]
+ "'" + ", " + "'" + Nl[5] + "'" + ", " + "'" + Nl[6] + "'" + ", " + "'" + Nl[7] + "'" + ", " + "'" + Nl[8] + "'" + ", " + "'" + Nl[9] + "'" + ", " + "'" + Nl[10] + "'" + ", " + "'" + Nl[11] + "'" + ", " + "'" + sig[0].ToString("0.000") + "'"
+ ", " + "'" + sig[1].ToString("0.000") + "'" + ", " + "'" + sig[2].ToString("0.000") + "'" + ", " + "'" + sig[3].ToString("0.000") + "'" + ", " + "'" + sig[4].ToString("0.000") + "'" + ", " + "'" + sig[5].ToString("0.000") + "'" + ", " + "'" + sig[6].ToString("0.000") + "'" + ", " + "'" + sig[7].ToString("0.000") + "'" + ", " + "'" + sig[8].ToString("0.000") + "'"
+ ", " + "'" + sig[9].ToString("0.000") + "'" + ", " + "'" + sig[10].ToString("0.000") + "'" + ", " + "'" + sig[11].ToString("0.000") + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Connection = podg;
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Событие](" + "ИмяФайла, Кластер, Плата, Время, АмплитудаКанал1, АмплитудаКанал2,АмплитудаКанал3,АмплитудаКанал4,АмплитудаКанал5,АмплитудаКанал6,АмплитудаКанал7,АмплитудаКанал8,АмплитудаКанал9," +
"АмплитудаКанал10,АмплитудаКанал11,АмплитудаКанал12, n1, n2, n3, n4, n5, n6, n7, n8, n9, n10, n11, n12, Nul1, Nul2, Nul3, Nul4, Nul5, Nul6, Nul7, Nul8, Nul9, Nul10, Nul11, Nul12, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, bad) VALUES (" +
"'" + nameFile + "'" + "," + "'" + nameklaster + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + time + "'" + ", " + "'" + Amp[0] + "'" + ", " + "'" + Amp[1] + "'" + ", " + "'" + Amp[2] + "'" + ", " + "'" + Amp[3] + "'" + ", " + "'"
+ Amp[4] + "'" + ", " + "'" + Amp[5] + "'" + ", " + "'" + Amp[6] + "'" + ", " + "'" + Amp[7] + "'" + ", " + "'" + Amp[8] + "'" + ", " + "'" + Amp[9] + "'" + ", " + "'" + Amp[10] + "'" + ", " + "'" + Amp[11] + "'" + ", " + "'" + Nnut[0] + "'"
+ ", " + "'" + Nnut[1] + "'" + ", " + "'" + Nnut[2] + "'" + ", " + "'" + Nnut[3] + "'" + ", " + "'" + Nnut[4] + "'" + ", " + "'" + Nnut[5] + "'" + ", " + "'" + Nnut[6] + "'" + ", " + "'" + Nnut[7] + "'" + ", " + "'" + Nnut[8]
+ "'" + ", " + "'" + Nnut[9] + "'" + ", " + "'" + Nnut[10] + "'" + ", " + "'" + Nnut[11] + "'" + ", " + "'" + Nl[0] + "'" + ", " + "'" + Nl[1] + "'" + ", " + "'" + Nl[2] + "'" + ", " + "'" + Nl[3] + "'" + ", " + "'" + Nl[4]
+ "'" + ", " + "'" + Nl[5] + "'" + ", " + "'" + Nl[6] + "'" + ", " + "'" + Nl[7] + "'" + ", " + "'" + Nl[8] + "'" + ", " + "'" + Nl[9] + "'" + ", " + "'" + Nl[10] + "'" + ", " + "'" + Nl[11] + "'" + ", " + "'" + sig[0].ToString("0.000") + "'"
+ ", " + "'" + sig[1].ToString("0.000") + "'" + ", " + "'" + sig[2].ToString("0.000") + "'" + ", " + "'" + sig[3].ToString("0.000") + "'" + ", " + "'" + sig[4].ToString("0.000") + "'" + ", " + "'" + sig[5].ToString("0.000") + "'" + ", " + "'" + sig[6].ToString("0.000") + "'" + ", " + "'" + sig[7].ToString("0.000") + "'" + ", " + "'" + sig[8].ToString("0.000") + "'"
+ ", " + "'" + sig[9].ToString("0.000") + "'" + ", " + "'" + sig[10].ToString("0.000") + "'" + ", " + "'" + sig[11].ToString("0.000") + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.ExecuteNonQuery();
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[Событие](" + "ИмяФайла, Кластер, Плата, Время, АмплитудаКанал1,АмплитудаКанал2,АмплитудаКанал3,АмплитудаКанал4,АмплитудаКанал5,АмплитудаКанал6,АмплитудаКанал7,АмплитудаКанал8,АмплитудаКанал9," +
"АмплитудаКанал10,АмплитудаКанал11,АмплитудаКанал12, n1, n2, n3, n4, n5, n6, n7, n8, n9, n10, n11, n12, Nul1, Nul2, Nul3, Nul4, Nul5, Nul6, Nul7, Nul8, Nul9, Nul10, Nul11, Nul12, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, bad) VALUES (" +
"'" + nameFile + "'" + "," + "'" + nameklaster + "'" + "," + "'" + nameBAAK + "'" + ", " + "'" + time + "'" + ", " + "'" + Amp[0] + "'" + ", " + "'" + Amp[1] + "'" + ", " + "'" + Amp[2] + "'" + ", " + "'" + Amp[3] + "'" + ", " + "'"
+ Amp[4] + "'" + ", " + "'" + Amp[5] + "'" + ", " + "'" + Amp[6] + "'" + ", " + "'" + Amp[7] + "'" + ", " + "'" + Amp[8] + "'" + ", " + "'" + Amp[9] + "'" + ", " + "'" + Amp[10] + "'" + ", " + "'" + Amp[11] + "'" + ", " + "'" + Nnut[0] + "'"
+ ", " + "'" + Nnut[1] + "'" + ", " + "'" + Nnut[2] + "'" + ", " + "'" + Nnut[3] + "'" + ", " + "'" + Nnut[4] + "'" + ", " + "'" + Nnut[5] + "'" + ", " + "'" + Nnut[6] + "'" + ", " + "'" + Nnut[7] + "'" + ", " + "'" + Nnut[8]
+ "'" + ", " + "'" + Nnut[9] + "'" + ", " + "'" + Nnut[10] + "'" + ", " + "'" + Nnut[11] + "'" + ", " + "'" + Nl[0] + "'" + ", " + "'" + Nl[1] + "'" + ", " + "'" + Nl[2] + "'" + ", " + "'" + Nl[3] + "'" + ", " + "'" + Nl[4]
+ "'" + ", " + "'" + Nl[5] + "'" + ", " + "'" + Nl[6] + "'" + ", " + "'" + Nl[7] + "'" + ", " + "'" + Nl[8] + "'" + ", " + "'" + Nl[9] + "'" + ", " + "'" + Nl[10] + "'" + ", " + "'" + Nl[11] + "'" + ", " + "'" + sig[0].ToString("0.000") + "'"
+ ", " + "'" + sig[1].ToString("0.000") + "'" + ", " + "'" + sig[2].ToString("0.000") + "'" + ", " + "'" + sig[3].ToString("0.000") + "'" + ", " + "'" + sig[4].ToString("0.000") + "'" + ", " + "'" + sig[5].ToString("0.000") + "'" + ", " + "'" + sig[6].ToString("0.000") + "'" + ", " + "'" + sig[7].ToString("0.000") + "'" + ", " + "'" + sig[8].ToString("0.000") + "'"
+ ", " + "'" + sig[9].ToString("0.000") + "'" + ", " + "'" + sig[10].ToString("0.000") + "'" + ", " + "'" + sig[11].ToString("0.000") + "'" + ", " + "'" + bad.ToString() + "'" + ")"
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Dispose();
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message+ "BDReadСобытие");
}
finally
{
// закрываем подключение
podg.Close();
}
}
}
}
/// <summary>
/// Запис в бд информации о ран
/// </summary>
/// <param name="nameRan"></param>
/// <param name="sinx"></param>
/// <param name="allPorog"></param>
/// <param name="porog"></param>
/// <param name="trg"></param>
/// <param name="time"></param>
private void BDReadRAN(string nameRan, bool sinx, bool allPorog, uint porog, UInt32 trg, string time)
{
if (set.FlagSaveBD)
{
int pp = 0;
int ds = 0;
string connectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + set.WayDATABd;
if (allPorog)
{
pp = 1;
}
if (sinx)
{
ds = 1;
}
DataAccesBDData.Path = set.WayDATABd;
if (set.WayDATABd.Split('.')[1] == "db" || set.WayDATABd.Split('.')[1] == "db3")
{
DataAccesBDData.AddDataTablRun(new WorkBD.ViewTaiblBDData.ClassTablRun()
{
НомерRun = nameRan,
ЗначениеТаймер = time,
ОбщийПорог = pp,
Порог = (int)porog,
Синхронизация = ds,
Триггер = (int)trg
});
}
else
{
// Создание подключения
var podg = new OleDbConnection(connectionString);
try
{
// Открываем подключение
podg.Open();
// MessageBox.Show("Подключение открыто");
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер, ЗначениеТаймера) VALUES (" + "'" + nameRan + "'" + "," + sinx + ", " + allPorog + "," + porog + ", " + trg + "," + "'" + time + "'" + ") "
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.Connection = podg;
new OleDbCommand
{
Connection = podg,
CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер, ЗначениеТаймера) VALUES (" + "'" + nameRan + "'" + "," + sinx + ", " + allPorog + "," + porog + ", " + trg + "," + "'" + time + "'" + ") "
// CommandText = "INSERT INTO[RAN](" + "НомерRAN, Синхронизация, ОбщийПорог, Порог,Триггер,ЗначениеТаймера,ВремяЗапуска) VALUES (nameRan, sinx, allPorog, porog, trg, time, timeStart)"
}.ExecuteNonQuery();
}
catch
{
// MessageBox.Show(ex.Message);
}
finally
{
// закрываем подключение
podg.Close();
}
}
}
}
