public Report_Form_Print()
{
InitializeComponent();
comboBox1.SelectionChangeCommitted += comboBox1_SelectionChangeCommitted;
comboBox1.SelectedIndex = 0;
//comboBox2.SelectedIndex = 0;
comboBox2.Items.Clear();
comboBox3.SelectedIndex = 0;
scalesEntities2 bd = new scalesEntities2();
IQueryable <ScalesInformation> query = bd.ScalesInformation;
ds_info = query.ToList();
mas_Scales = new int[ds_info.Count];
foreach (var item in ds_info)
{
comboBox2.Items.Add(item.ID + " " + item.Scales_Number);
mas_Scales[IQ] = item.ID;
IQ++;
}
try
{
comboBox2.SelectedIndex = 0;
comboBox2.Items.Add("Все весы");
}
catch (Exception e)
{
}
}
public void TreeUsers(int roleID)
{
treeView2.Nodes.Clear();
treeView2.Nodes.Add(new TreeNode("Администраторы"));
treeView2.Nodes.Add(new TreeNode("Весовщики"));
scalesEntities2 bd1 = new scalesEntities2();
List <Personal> ListPersonel = bd1.Personal.ToList();
foreach (var item in ListPersonel)
{
if (item.Role == 2)
{
treeView2.Nodes[0].Nodes.Add(new TreeNode(item.Name));
}
else
{
treeView2.Nodes[1].Nodes.Add(new TreeNode(item.Name));
}
}
bd1.Dispose();
switch (roleID)
{
case 1: treeView2.Nodes[1].Expand(); break;
case 2: treeView2.Nodes[0].Expand(); break;
case 3: break;
}
}
private void button2_Click(object sender, EventArgs e)
{
int ListPersonelCount;
scalesEntities2 bd = new scalesEntities2();
try
{
ListPersonelCount = bd.Personal.Where(p => p.Name == login.Text).Count();
}
catch (Exception)
{
MessageBox.Show("Не все поля заполнены!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ListPersonelCount > 0)
{
MessageBox.Show("Такой пользователь уже существует", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
bool chek = false;
if (login.Text == "")
{
chek = true;
}
if (passwred.Text == "")
{
chek = true;
}
if (roleCombo.SelectedIndex < 1)
{
chek = true;
}
if (chek == true)
{
MessageBox.Show("Не все поля заполнены!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
Personal pNew = new Personal();
pNew.Name = login.Text.ToLower();
pNew.Password = passwred.Text.ToLower();
pNew.Role = roleCombo.SelectedIndex;
int roleID = roleCombo.SelectedIndex;
bd.Personal.Add(pNew);
bd.SaveChanges();
bd.Dispose();
MessageBox.Show("Пользователь добавлен!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
login.Text = "";
passwred.Text = "";
roleCombo.SelectedIndex = 0;
TreeUsers(roleID);
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
next = 0;
chechko = 15;
textBox2.Text = "";
textBox5.Text = "";
textBox4.Text = "";
textBox3.Text = "";
DateTime dtStart = dateTimePicker1.Value;
DateTime dtEnd;
if (radioButton1.Checked)
{
dtEnd = dtStart.AddMinutes(RadioScale);
}
else
{
dtEnd = dtStart.AddHours(RadioScale);
}
//MessageBox.Show(dtEnd.ToString());
int Combo = int.Parse(comboBox1.SelectedItem.ToString().Split(' ')[0]);
scalesEntities2 bd = new scalesEntities2();
IQueryable <MeasurementData> query_data_mes = bd.MeasurementData.Where(x => (x.TimeOfMeasurement >= dtStart && x.TimeOfMeasurement <= dtEnd) && x.ScalesNumberID == Combo);
arhiveList = query_data_mes.ToList();
if (arhiveList.Count == 0)
{
button2.Enabled = false;
button3.Enabled = false;
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
ChartValuesPOWER_arhive.Clear();
ChartValuesWEIGHT_arhive.Clear();
lableX_arhive.Clear();
}
else
{
ChartValuesPOWER_arhive.Clear();
ChartValuesWEIGHT_arhive.Clear();
lableX_arhive.Clear();
button2.Enabled = true;
button3.Enabled = true;
button4.Enabled = true;
button5.Enabled = true;
button6.Enabled = true;
button7.Enabled = true;
GetDataForArhiveGraph(arhiveList);
button1.Focus();
}
this.WindowState = FormWindowState.Maximized;
}
private void Get_Info_Data_Hour()
{
cartesianChart1.DisableAnimations = true;
scalesEntities2 bd = new scalesEntities2();
IQueryable <ScalesInformation> query = bd.ScalesInformation;
Count_WEIGHT = query.Count();
IQueryable <DataByHours> query_data_hour = bd.DataByHours.OrderByDescending(x => x.ID).Take(Check_Connection_with_Controllers.device_list.Count).OrderBy(x => x.ID);
data_hour = query_data_hour.ToList();
DrawGraph(data_hour);
}
private void archive_Load(object sender, EventArgs e)
{
dateTimePicker1.CustomFormat = "dd.MM.yy HH:mm:ss";
//this.MinimumSize = SystemInformation.VirtualScreen.Size;
scalesEntities2 bd = new scalesEntities2();
List <ScalesInformation> query = bd.ScalesInformation.ToList();
foreach (var item in query)
{
comboBox1.Items.Add(item.ID + " " + item.Scales_Number);
}
}
private void удалитьПользователяToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
scalesEntities2 bd = new scalesEntities2();
var x = bd.Personal.Where(p => p.Name == delUser.Text).First();
bd.Personal.Remove(x);
bd.SaveChanges();
bd.Dispose();
treeView2.Nodes.Remove(delUser);
MessageBox.Show("Пользователь удален!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
catch (Exception)
{
}
}
private void button1_Click(object sender, EventArgs e)
{
Match m = Regex.Match(textBox1.Text, patternIP);//проверяем правильно ли введен ІР-адрес в текстовое поле
if (m.Success)
{
Match m2 = Regex.Match(textBox2.Text, patternMODBUS);//проверяем правильно ли введен ІР-адрес в текстовое поле
if (m2.Success)
{
scalesEntities2 bd = new scalesEntities2();
var CountCopy = bd.ScalesInformation.Where(p => p.IPaddress == textBox1.Text && p.ModbusID == textBox2.Text).Count();
if (CountCopy > 0)
{
MessageBox.Show("Такое устройство уже существует!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ScalesInformation sc = new ScalesInformation();
sc.IPaddress = textBox1.Text;
sc.ModbusID = textBox2.Text;
if (comboBox1.SelectedIndex == 0)
{
sc.Scales_Number = "A";
}
if (comboBox1.SelectedIndex == 1)
{
sc.Scales_Number = "K";
}
bd.ScalesInformation.Add(sc);
bd.SaveChanges();
bd.Dispose();
textBox1.Text = "";
textBox2.Text = "";
DeviceInBD();
MessageBox.Show("Устройство добавлено!\nДля того что бы устройство начало функционировать НЕОБХОДИМО перезапустить программу!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
MessageBox.Show("ModBus адрес введен не верно!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("IP адрес введен не верно!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void DeviceInBD()
{
treeView1.Nodes.Clear();
scalesEntities2 bd1 = new scalesEntities2();
List <string> ListDevice = bd1.ScalesInformation.Select(x => x.IPaddress).Distinct().ToList();
List <ScalesInformation> ListDeviceInfo = bd1.ScalesInformation.ToList();
foreach (var item in ListDevice)
{
TreeNode a = new TreeNode(item);
treeView1.Nodes.Add(a);
foreach (var item2 in ListDeviceInfo)
{
if (item == item2.IPaddress)
{
treeView1.Nodes[a.Index].Nodes.Add(new TreeNode("ModBusID: " + item2.ModbusID + " Номер весов: " + item2.ID + " - " + item2.Scales_Number));
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
}
else
{
string Log = textBox1.Text;
string Pass = textBox2.Text;
scalesEntities2 bd = new scalesEntities2();
try
{
Personal pers = bd.Personal.Where(x => x.Name == Log.ToLower() && x.Password == Pass.ToLower()).First();
if (pers.Role == 1)
{
Role_ID = 1;
Form1.USER = pers.Name;
}
if (pers.Role == 2)
{
Role_ID = 2;
Form1.USER = pers.Name;
}
this.Close();
}
catch (Exception)
{
textBox2.Text = "";
MessageBox.Show("Пользователь не найден!", "Внимание!",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
bd.Dispose();
}
}
private void удалитьУстройствоToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
scalesEntities2 bd = new scalesEntities2();
if (delDevice.Level == 0)
{
IQueryable <ScalesInformation> x = bd.ScalesInformation.Where(p => p.IPaddress == delDevice.Text);
foreach (var item in x)
{
bd.ScalesInformation.Remove(item);
}
bd.SaveChanges();
bd.Dispose();
treeView1.Nodes.Remove(delDevice);
DeviceInBD();
MessageBox.Show("Группа устройств удалена!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
string Eq = delDevice.Text.Split(' ')[1];
var x = bd.ScalesInformation.Where(p => p.ModbusID == Eq && p.IPaddress == delDevice.Parent.Text).First();
bd.ScalesInformation.Remove(x);
bd.SaveChanges();
bd.Dispose();
treeView1.Nodes.Remove(delDevice);
DeviceInBD();
MessageBox.Show("Устройство удалено!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch (Exception)
{
MessageBox.Show("Выберите устройство!\nДля этого нажмите на узел ЛК мышки.", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
scalesEntities2 bd = new scalesEntities2();
if (ds_info.Count < 1)
{
return;
}
if (comboBox2.SelectedItem.ToString() == "Все весы")
{
int NumbShift = 0;
IQueryable <DataByHours> query = null;
switch (comboBox3.SelectedIndex)
{
case 0: NumbShift = 1;
query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && mas_Scales.Contains(x.ScalesNumberID.Value) &&
x.ShiftNumber == NumbShift);
break;
case 1: NumbShift = 2;
TimeSpan tSNE = TimeSpan.Parse("08:00");
TimeSpan tSNEtoday = TimeSpan.Parse("20:00");
DateTime NextDateShift = dateTimePicker1.Value.Date.AddDays(1);
query = bd.DataByHours.Where(x => ((x.Date.Value == dateTimePicker1.Value.Date && x.Time.Value > tSNEtoday) ||
(x.Date.Value == NextDateShift && x.Time.Value < tSNE)) &&
mas_Scales.Contains(x.ScalesNumberID.Value) &&
x.ShiftNumber == NumbShift);
break;
}
//query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && mas_Scales.Contains(x.ScalesNumberID.Value)
//&& x.ShiftNumber == NumbShift);
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable1.Clear();
foreach (var item in ds_info)
{
ds.DataTable1.Rows.Add(item.ID, item.Weight, item.Time.Value.ToString(@"hh\:mm\:ss"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Время"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
bd.Dispose();
}
else
{
int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
int NumbShift = 0;
IQueryable <DataByHours> query = null;
switch (comboBox3.SelectedIndex)
{
case 0:
NumbShift = 1;
query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && x.ScalesNumberID.Value == Predel &&
x.ShiftNumber == NumbShift);
break;
case 1:
NumbShift = 2;
TimeSpan tSNE = TimeSpan.Parse("08:00");
TimeSpan tSNEtoday = TimeSpan.Parse("20:00");
DateTime NextDateShift = dateTimePicker1.Value.Date.AddDays(1);
query = bd.DataByHours.Where(x => ((x.Date.Value == dateTimePicker1.Value.Date && x.Time.Value > tSNEtoday) ||
(x.Date.Value == NextDateShift && x.Time.Value < tSNE)) && x.ScalesNumberID.Value == Predel &&
x.ShiftNumber.Value == NumbShift);
break;
}
//query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && mas_Scales.Contains(x.ScalesNumberID.Value));
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable1.Clear();
foreach (var item in ds_info)
{
ds.DataTable1.Rows.Add(item.ID, item.Weight, item.Time.Value.ToString(@"hh\:mm\:ss"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", comboBox3.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Время"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
bd.Dispose();
}
}
if (comboBox1.SelectedIndex == 1)
{
if (ds_info.Count < 1)
{
return;
}
scalesEntities2 bd = new scalesEntities2();
if (comboBox2.SelectedItem.ToString() == "Все весы")
{
//int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
IQueryable <DataByHours> query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && mas_Scales.Contains(x.ScalesNumberID.Value));
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable1.Clear();
foreach (var item in ds_info)
{
ds.DataTable1.Rows.Add(item.ID, item.Weight, item.Time.Value.ToString(@"hh\:mm\:ss"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Время"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
bd.Dispose();
}
else
{
int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
IQueryable <DataByHours> query = bd.DataByHours.Where(x => x.Date == dateTimePicker1.Value.Date && x.ScalesNumberID == Predel);
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable1.Clear();
foreach (var item in ds_info)
{
ds.DataTable1.Rows.Add(item.ID, item.Weight, item.Time.Value.ToString(@"hh\:mm\:ss"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[0]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Время"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
bd.Dispose();
}
}
if (comboBox1.SelectedIndex == 2)
{
if (ds_info.Count < 1)
{
return;
}
scalesEntities2 bd = new scalesEntities2();
if (comboBox2.SelectedItem.ToString() == "Все весы")
{
IQueryable <DataByDays> query = bd.DataByDays.Where(x => x.Date.Value.Month == dateTimePicker1.Value.Date.Month && mas_Scales.Contains(x.ScalesNumberID.Value));
List <DataByDays> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable2.Clear();
foreach (var item in ds_info)
{
ds.DataTable2.Rows.Add(item.ID, item.Weight, item.Date.Value.ToShortDateString());
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[1]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Дата"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
IQueryable <DataByDays> query = bd.DataByDays.Where(x => x.Date.Value.Month == dateTimePicker1.Value.Date.Month && x.ScalesNumberID == Predel);
List <DataByDays> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable2.Clear();
foreach (var item in ds_info)
{
ds.DataTable2.Rows.Add(item.ID, item.Weight, item.Date.Value.ToShortDateString());
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[1]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Дата"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
}
if (comboBox1.SelectedIndex == 3)
{
if (ds_info.Count < 1)
{
return;
}
scalesEntities2 bd = new scalesEntities2();
if (comboBox2.SelectedItem.ToString() == "Все весы")
{
IQueryable <DataByMonth> query = bd.DataByMonth.Where(x => mas_Scales.Contains(x.ScalesNumberID.Value));
List <DataByMonth> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable3.Clear();
foreach (var item in ds_info)
{
ds.DataTable3.Rows.Add(item.ID, item.Weight, item.NumberMonth.Value.ToString());
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[2]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Месяц"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
IQueryable <DataByMonth> query = bd.DataByMonth.Where(x => x.ScalesNumberID == Predel);
List <DataByMonth> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable3.Clear();
foreach (var item in ds_info)
{
ds.DataTable3.Rows.Add(item.ID, item.Weight, item.NumberMonth.Value.ToString());
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[2]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "Месяц"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
}
if (comboBox1.SelectedIndex == 4)
{
if (ds_info.Count < 1)
{
return;
}
DateTime st = dateTimePicker1.Value;
DateTime end = dateTimePicker2.Value;
//MessageBox.Show(dateTimePicker2.Value.Date.ToString(), "");
//DateTime dtS = new DateTime(st.Year,st.Month,st.Day,0,0,0);
//DateTime dtE = new DateTime(end.Year, end.Month, end.Day, end.Hour, 59, 59);
scalesEntities2 bd = new scalesEntities2();
if (comboBox2.SelectedItem.ToString() == "Все весы")
{
IQueryable <DataByHours> query = bd.DataByHours.Where(x => (mas_Scales.Contains(x.ScalesNumberID.Value)) && (x.Date >= st.Date && x.Date <= end.Date));
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable3.Clear();
foreach (var item in ds_info)
{
ds.DataTable3.Rows.Add(item.ID, item.Weight, item.Date.Value.ToString("dd.MM.yy") + " " + item.Time.Value.ToString(@"hh"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[2]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "День/Час"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
int Predel = int.Parse(comboBox2.SelectedItem.ToString().Split(' ')[0]);
IQueryable <DataByHours> query = bd.DataByHours.Where(x => (x.ScalesNumberID == Predel) && (x.Date >= st.Date && x.Date <= end.Date));
List <DataByHours> ds_info = query.ToList();
DataSet1 ds = new DataSet1();
ds.DataTable3.Clear();
foreach (var item in ds_info)
{
ds.DataTable3.Rows.Add(item.ID, item.Weight, item.Date.Value.ToString("dd.MM.yy") + " " + item.Time.Value.ToString(@"hh"));
}
ReportDataSource a = new ReportDataSource("DataSet1", ds.Tables[2]);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(a);
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter1", comboBox2.SelectedItem.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter2", "-"));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter3", dateTimePicker1.Value.ToString()));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter4", Form1.USER));
reportViewer1.LocalReport.SetParameters(new ReportParameter("ReportParameter5", "День/Час"));
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.Refresh();
//this.reportViewer2.RefreshReport();
this.reportViewer1.RefreshReport();
}
}
}
private void RefreshGraph()
{
chart1DataX.Clear();
chart2DataX.Clear();
chart1DataY.Clear();
chart2DataY.Clear();
scalesEntities2 bd = new scalesEntities2();
IQueryable <ScalesInformation> query = bd.ScalesInformation;
Count_WEIGHT = query.Count();
IQueryable <DataByHours> query_data_hour = bd.DataByHours.OrderByDescending(x => x.ID).Take(Check_Connection_with_Controllers.device_list.Count).OrderBy(x => x.ID);
List <DataByHours> dh_info = query_data_hour.ToList();
if (Count_WEIGHT > 5)
{
for (int i = 0; i < dh_info.Count; i++)
{
if (i < 5)
{
chart1DataY.Add(dh_info[i].Weight.Value);
chart1DataX.Add(dh_info[i].ScalesNumberID.ToString());
}
else
{
chart2DataY.Add(dh_info[i].Weight.Value);
chart2DataX.Add(dh_info[i].ScalesNumberID.ToString());
}
}
try
{
this.Invoke((MethodInvoker) delegate
{
cartesianChart1.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart1DataY,
DataLabels = true
}
};
cartesianChart2.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart2DataY,
DataLabels = true
}
};
});
}
catch (Exception e)
{
}
}
else
{
foreach (var item in dh_info)
{
chart1DataY.Add(item.Weight.Value);
chart1DataX.Add(item.ScalesNumberID.ToString());
}
try
{
this.Invoke((MethodInvoker) delegate
{
cartesianChart1.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart1DataY,
DataLabels = true
}
};
});
}
catch (Exception e)
{ }
}
bd.Dispose();
}
private void GetInfo()
{
//List<Device> NoWork = new List<Device>();
for (int q = 0; q < device_list.Count; q++)
{
NetworkStream serverStream = default(NetworkStream);
try
{
bool NoDevice = false;
TcpClient clientSocket = new TcpClient();
foreach (var dev in device_list)
{
if (device_list[q].device_ip == dev.device_ip)
{
device_list[q].clientSocket = dev.clientSocket;
//serverStream = dev.clientSocket.GetStream();
}
else
{
NoDevice = true;
}
}
//clientSocket.Connect(item.device_ip, 9761);
serverStream = device_list[q].clientSocket.GetStream();
byte NumbDevice = byte.Parse(device_list[q].device_number);
byte[] otvet = new byte[2];
GetCRC16(new byte[] { NumbDevice, 3, 0, 19, 0, 1 }, ref otvet);
string CRC_L = ByteToStrHex(otvet[0]);
string CRC_H = ByteToStrHex(otvet[1]);
String[] message = new String[] { device_list[q].device_number, "03", "00", "13", "00", "01", CRC_L, CRC_H };
Byte[] mes = new Byte[128]; //переменная, которая будет содержать данные для отправки
int i = 0; // счетчик
for (i = 0; i < 8; i++)
{
mes[i] = StrHexToByte(message[i]);
}
serverStream.Write(mes, 0, 8);
serverStream.Flush();
clientSocket.ReceiveTimeout = 1010;
serverStream = device_list[q].clientSocket.GetStream(); //получаем поток
int buffSize = 0;
int bytesRead = 0;
byte[] inStream = new byte[10025]; // инициализируем массив для приема данных
buffSize = device_list[q].clientSocket.ReceiveBufferSize; //получаем размер буфера
bytesRead = serverStream.Read(inStream, 0, buffSize); //считываем данные из потока
this.Invoke((MethodInvoker) delegate
{
this.Text = "";
});
if (bytesRead > 0)
{
string answer_Power = "";
for (int z = 3; z < 7; z++)
{
answer_Power = answer_Power + ByteToStrHex(inStream[z]);
//формируем сообщения для вывода в ListView в 16-ричном виде
}
//int weight_geter = int.Parse(answer_Weight, System.Globalization.NumberStyles.AllowHexSpecifier);
//double REALY_WEIGHT_VARIABLE = weight_geter * 0.001;
int power_geter = int.Parse(answer_Power, System.Globalization.NumberStyles.AllowHexSpecifier);
double REALY_POWER_VARIABLE = power_geter * 0.01;
if (REALY_POWER_VARIABLE < 0)
{
REALY_POWER_VARIABLE = 0;
}
if (Settings.kalibrovka == false)
{
double REALY_WEIGHT_VARIABLE = (REALY_POWER_VARIABLE * 1.35) / 3.6;
scalesEntities2 bd = new scalesEntities2();
MeasurementData inf1 = new MeasurementData();
inf1.ScalesNumberID = device_list[q].device_name;
inf1.CurrentWeight = REALY_WEIGHT_VARIABLE;
inf1.CurrentProductivity = REALY_POWER_VARIABLE;
inf1.TimeOfMeasurement = DateTime.Now;
bd.MeasurementData.Add(inf1);
bd.SaveChanges();
bd.Dispose();
if (REALY_WEIGHT_VARIABLE > 0)
{
if (AllGraphRefresh != null)
{
AllGraphRefresh();
}
RefreshGraph();
}
}
if (device_list[q].device_name.ToString() == WeightInformation.CURRENT_DEVICE_COMBO)
{
scalesEntities2 bd = new scalesEntities2();
DataByShift dbs = new DataByShift();
DataByHours dbh = new DataByHours();
DataByDays dbd = new DataByDays();
DataByMonth dbm = new DataByMonth();
int ee = int.Parse(WeightInformation.CURRENT_DEVICE_COMBO);
dbs = bd.DataByShift.OrderByDescending(x => x.ID).Where(x => x.ScalesNumberID == ee).First();
dbh = bd.DataByHours.OrderByDescending(x => x.ID).Where(x => x.ScalesNumberID == ee).First();
dbd = bd.DataByDays.OrderByDescending(x => x.ID).Where(x => x.ScalesNumberID == ee).First();
dbm = bd.DataByMonth.OrderByDescending(x => x.ID).Where(x => x.ScalesNumberID == ee).First();
WEIGHT_STATIC_SHIFT = WEIGHT_STATIC_SHIFT + (REALY_POWER_VARIABLE / 3600);
double REALY_WEIGHT_VARIABLE = REALY_POWER_VARIABLE / 3.6;
if (DataLive != null)
{
DataLive(dbs.Weight.Value, REALY_POWER_VARIABLE, dbh.Weight.Value, dbd.Weight.Value, dbm.Weight.Value);
}
//dbs.Weight.Value
}
}
}
catch (Exception e)
{
}
}
}
private void RefreshGraph()
{
chart1DataX.Clear();
chart2DataX.Clear();
chart1DataY.Clear();
chart2DataY.Clear();
scalesEntities2 bd = new scalesEntities2();
IQueryable <ScalesInformation> query = bd.ScalesInformation;
Count_WEIGHT = query.Count();
//var ListDevRab = new List<int>() {1 };
int[] devL = new int[device_list.Count];
for (int i = 0; i < devL.Length; i++)
{
devL[i] = device_list[i].device_name;
}
IQueryable <DataByShift> query_data_shift = bd.DataByShift.OrderByDescending(x => x.ID).Take(device_list.Count).Where(x => devL.Contains(x.ScalesNumberID.Value)).OrderBy(x => x.ID);
List <DataByShift> ds_info = query_data_shift.ToList();
if (Count_WEIGHT > 5)
{
for (int i = 0; i < ds_info.Count; i++)
{
if (i < 5)
{
chart1DataY.Add(ds_info[i].Weight.Value);
chart1DataX.Add(ds_info[i].ScalesNumberID.ToString());
}
else
{
chart2DataY.Add(ds_info[i].Weight.Value);
chart2DataX.Add(ds_info[i].ScalesNumberID.ToString());
}
}
this.Invoke((MethodInvoker) delegate
{
cartesianChart1.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart1DataY,
DataLabels = true
}
};
cartesianChart2.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart2DataY,
DataLabels = true
}
};
});
}
else
{
foreach (var item in ds_info)
{
chart1DataY.Add(item.Weight.Value);
chart1DataX.Add(item.ScalesNumberID.ToString());
}
this.Invoke((MethodInvoker) delegate
{
cartesianChart1.Series = new SeriesCollection
{
new ColumnSeries
{
Title = "Вес:",
Values = chart1DataY,
DataLabels = true
}
};
});
}
bd.Dispose();
}
