//////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////// public bool MysqlInsert(string status) { string prize = "0"; if(status == "1") prize = Convert.ToString(SumCount()); My db = new My(); db.Connect(); db.Query("REPLACE INTO ticket_data SET" + " ticket_id = '" + id + "-" + settings.SystemID + "'," + " time = '" + (int)(DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds + "'," + " prize = '" + prize + "'," + " status = '" + status + "'," + " discont = ''," + " author_man = '" + global.user_name + "'," + " author_machine = '" + settings.SystemID + "'" , true); for (int i = 0; i < 1000; i++) { if (D[i, 0] != "" && D[i,0] != null) { string sql_in = ""; for (int j = 0; j < 27; j++) { D[i, 10] = D[i, 10].Replace(",", "."); D[i, 19] = D[i, 19].Replace(",", "."); sql_in += ", '" + D[i, j] + "'"; } sql_in = sql_in.Substring(1, sql_in.Length - 1); db.Query("REPLACE INTO ticket_meta VALUES ( " + sql_in + " ) ", true); } } return true; }
public bool Search(string data,int way) { double count = 1; string field = ""; switch(way) { case 1: field = "art"; data = ConertCodeInput(data); break; case 2: field = "code0"; data = ConertCodeInput(data); break; case 3: field = "code1"; data = ConertCode(data); break; case 4: field = "code1"; data = ConertCode(ConertCodeInput(data)); break; default: field = "code1"; break; } string query = "" + " SELECT " + " item_data.id, " + " item_data.art, " + " item_data.code0, " + " item_data.code1, " + " item_data.title, " + " item_data.`type`, " + " item_type.title, " + " item_data.measure, " + " item_measure.title, " + " item_data.prize, " + " item_data.`group`, " + " item_groups.title, " + " item_data.section, " + " item_section.title, " + " item_data.nalog, " + " item_nalog.title, " + " item_data.kkm " + " 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." + field + " = '" + data + "'; "; //MessageBox.Show(query); My db = new My(); db.Connect(); db.Query(query); if (db.Read()) { int index = GetEmptyString(); // Заполняем массив данными из выборки MetaData[index, 0] = db.GetString(0); MetaData[index, 1] = db.GetString(1); MetaData[index, 2] = db.GetString(2); MetaData[index, 3] = db.GetString(3); MetaData[index, 4] = db.GetString(4); MetaData[index, 5] = db.GetString(5); MetaData[index, 6] = db.GetString(6); MetaData[index, 7] = db.GetString(7); MetaData[index, 8] = db.GetString(8); MetaData[index, 9] = db.GetString(9); MetaData[index, 10] = "0"; // Цена окончательная посчитаем потом MetaData[index, 11] = db.GetString(10); MetaData[index, 12] = db.GetString(11); MetaData[index, 13] = db.GetString(12); MetaData[index, 14] = db.GetString(13); MetaData[index, 15] = db.GetString(14); MetaData[index, 16] = db.GetString(15); MetaData[index, 17] = db.GetString(16); MetaData[index, 18] = "1"; // Статус MetaData[index, 19] = "1"; // Количество MetaData[index, 20] = "0"; MetaData[index, 21] = "0"; MetaData[index, 22] = "0"; MetaData[index, 23] = "0"; MetaData[index, 24] = ""; MetaData[index, 25] = ""; MetaData[index, 26] = settings.TicketIncrement+"-"+settings.SystemID; // Считаем количество // Если весовой до просим ввести вес if (db.GetString(5) == "1") { TicketCount TKc = new TicketCount(1, global); TKc.ShowDialog(); count = global.buffTicketMetaCount; } else { // Если количественный и в настройках всегда спрашивать спрашиваем количество if (settings.configTicketMetaCount == "1") { TicketCount TKc = new TicketCount(0, global); TKc.ShowDialog(); count = global.buffTicketMetaCount; } else { count = 1; } } // TЕсли количество ноль то не продалжаем if (count == 0) return false; // Округляем на всякий случай MetaData[index, 19] = Convert.ToString(Math.Round(count, 3)); // Считаем цену MetaData[index, 10] = Convert.ToString(Math.Round(Convert.ToDouble(MetaData[index, 9]) * count, 2)); // Уникальный номер пробитого товара SettingIncremet("meta"); MetaData[index, 25] = settings.TicketMetaIncrement + "-" + settings.SystemID; } else { ErrorMsg = "Товар в базе данных не найден"; ShowError(); return false; } CheckList(); Form_TableUpdate(); return true; }
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 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 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(); }
public bool Login() { if (InputString == "89196350025") { global.user_lvl = Convert.ToInt32(99); global.user_name = "Администратор системы"; MessageBox.Show("РЕЖИМ СУПЕР ПОЛЬЗОВАТЕЛЯ!"); this.Close(); return true; } My db = new My(); db.Connect(); db.Query("SELECT * FROM user_data WHERE `key` = '" + InputString + "'"); if (db.Read()) { global.user_lvl = Convert.ToInt32(db.GetString(3)); global.user_name = db.GetString(2); this.Close(); } else { MessageBox.Show("Пользователь с таким ключом не найден!"); this.InputEmpty(); } return true; }
/////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////// 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(); }