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(); }