public void LoadDiscontTime()
{
int inc = 0;
My db = new My();
db.Connect();
db.Query("SELECT * FROM diskont_time");
while (db.Read())
{
DiscontTime[inc, 0] = db.GetString(1);
DiscontTime[inc, 1] = db.GetString(2);
DiscontTime[inc, 2] = db.GetString(3);
DiscontTime[inc, 3] = db.GetString(4);
DiscontTime[inc, 4] = db.GetString(5);
DiscontTime[inc, 5] = db.GetString(6);
inc++;
}
db.Close();
}
private void ViewItemDataInfo_Shown(object sender, EventArgs e)
{
My db = new My();
db.Connect();
string query = "SELECT item_data.title,"
+ " item_data.id,"
+ " item_data.art,"
+ " item_data.code1,"
+ " item_data.code0,"
+ " item_type.title,"
+ " item_measure.title,"
+ " item_data.prize,"
+ " item_groups.title,"
+ " item_section.title,"
+ " item_nalog.title,"
+ " item_data.time"
+ " FROM item_data"
+ " LEFT JOIN item_type ON item_type.id = item_data.type "
+ " LEFT JOIN item_measure ON item_measure.id = item_data.measure "
+ " LEFT JOIN item_groups ON item_groups.id = item_data.group "
+ " LEFT JOIN item_section ON item_section.id = item_data.section "
+ " LEFT JOIN item_nalog ON item_nalog.id = item_data.nalog "
+ " WHERE item_data.id = '" + id + "'";
db.Query(query);
if (db.Read())
{
label23.Text = db.GetString(0);
label24.Text = db.GetString(1);
label22.Text = db.GetString(2);
label21.Text = db.GetString(3);
label20.Text = db.GetString(4);
label19.Text = db.GetString(5);
label18.Text = db.GetString(6);
label17.Text = db.GetString(7);
label16.Text = db.GetString(8);
label15.Text = db.GetString(9);
label14.Text = db.GetString(10);
label10.Text = db.GetString(11);
}
else MessageBox.Show("Записей не найдено");
db.Close();
}
private void button1_Click(object sender, EventArgs e)
{
dataGrid.Rows.Clear();
string[] datarow = { "", "", "", "", "", ""};
int increment = 1;
double sum = 0;
int NowTime = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
int TimeFrom = (int)(new DateTime(Calen1.Value.Year, Calen1.Value.Month, Calen1.Value.Day, 0, 0, 0) - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
int TimeTo = (int)(new DateTime(Calen2.Value.Year, Calen2.Value.Month, Calen2.Value.Day, 23, 59, 59) - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
My db = new My();
db.Connect();
string query = "SELECT * FROM ticket_data WHERE `time` > " + TimeFrom + " AND `time` < " + TimeTo + "";
db.Query(query);
while(db.Read())
{
datarow[0] = Convert.ToString(increment);
datarow[1] = db.GetString(0);
datarow[2] = Convert.ToString((new DateTime(1970, 1, 1, 0, 0, 0)).AddSeconds(Convert.ToInt32(db.GetString(1))));
datarow[3] = db.GetString(2);
if (db.GetString(3) == "1")
{
datarow[4] = "Пробит";
dataGrid.RowTemplate.DefaultCellStyle.BackColor = Color.LightGreen;
}
if (db.GetString(3) == "0")
{
datarow[4] = "Отменен";
dataGrid.RowTemplate.DefaultCellStyle.BackColor = Color.OrangeRed;
}
datarow[5] = db.GetString(5);
dataGrid.Rows.Add(datarow);
increment++;
sum += Convert.ToDouble(db.GetString(2));
}
db.Close();
label5.Text = Convert.ToString(sum);
label6.Text = Convert.ToString(dataGrid.Rows.Count);
label7.Text = Convert.ToString(sum / dataGrid.Rows.Count);
}
///////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////
private void ViewTicketMeta_Shown(object sender, EventArgs e)
{
My db = new My();
db.Connect();
string query = "SELECT * FROM ticket_meta WHERE `26` = '" + data1 + "'";
db.Query(query);
int i = 0;
while (db.Read())
{
for (int j = 0; j < 30; j++)
{
D[i, j] = db.GetString(j);
}
i++;
}
db.Close();
PaintGrid();
}
