////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
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 ViewCountData(int child, Globals global)
{
this.global = global;
this.child = child;
db = new My();
InitializeComponent();
}
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();
}
public ViewCountData(Globals global)
{
this.global = global;
db = new My();
InitializeComponent();
}
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();
}
