private void btnSelectClient_Click(object sender, EventArgs e)
{
tmr.Stop();
frmSelectClient fClient = new frmSelectClient(db_connection, usr);
fClient.ShowDialog();
if (fClient.DialogResult == DialogResult.OK)
{
if ((fClient.client.Category_name.Trim().ToLower() == "терминал") ||
(fClient.client.Category_name.Trim().ToLower() == "фототерминал"))
{
MessageBox.Show("Внимание! Выбран клиент фототерминала");
}
else
{
this.order.Client = fClient.client;
lblClientName.Text = this.order.Client.Name;
RebildTable();
}
}
tmr.Start();
}
private void btnImport_Click(object sender, EventArgs e)
{
lblSaving.Visible = true;
if (CheckState(db_connection))
{
string f = "";
string str = "";
string flag = "";
string order = "";
dlgOpen.ShowDialog();
if (dlgOpen.FileName != "")
{
DataTable _order = new DataTable();
_order.Columns.Add("c0", System.Type.GetType("System.Boolean"));
_order.Columns.Add("c1", System.Type.GetType("System.String"));
_order.Columns.Add("c2", System.Type.GetType("System.String"));
_order.Columns.Add("c3", System.Type.GetType("System.String"));
_order.Columns.Add("c4", System.Type.GetType("System.String"));
_order.Columns.Add("c5", System.Type.GetType("System.String"));
_order.Columns.Add("c6", System.Type.GetType("System.String"));
_order.Columns.Add("c7", System.Type.GetType("System.String"));
_order.Columns.Add("c8", System.Type.GetType("System.String"));
_order.Columns.Add("c9", System.Type.GetType("System.String"));
_order.Columns.Add("c10", System.Type.GetType("System.String"));
_order.Columns.Add("c11", System.Type.GetType("System.String"));
_order.Columns.Add("c12", System.Type.GetType("System.String"));
_order.Columns.Add("c13", System.Type.GetType("System.String"));
_order.Columns.Add("c14", System.Type.GetType("System.String"));
_order.Columns.Add("c15", System.Type.GetType("System.String"));
_order.Columns.Add("c16", System.Type.GetType("System.String"));
_order.Columns.Add("c17", System.Type.GetType("System.String"));
_order.Columns.Add("c18", System.Type.GetType("System.String"));
_order.Columns.Add("c19", System.Type.GetType("System.String"));
_order.Columns.Add("c20", System.Type.GetType("System.String"));
_order.Columns.Add("c21", System.Type.GetType("System.String"));
_order.Columns.Add("c22", System.Type.GetType("System.String"));
_order.Columns.Add("c23", System.Type.GetType("System.String"));
_order.Columns.Add("c24", System.Type.GetType("System.String"));
_order.Columns.Add("c25", System.Type.GetType("System.String"));
_order.Columns.Add("c26", System.Type.GetType("System.String"));
f = dlgOpen.FileName;
StreamReader fs = new StreamReader(f, Encoding.GetEncoding(1251));
while (fs.Peek() >= 0)
{
str = fs.ReadLine();
if (str == "[order]")
{
flag = "order";
}
else if (str == "[order body]")
{
flag = "body";
}
switch (flag)
{
case "order":
{
str = "False;" + str;
str = str.Replace(";000100;", ";В очереди на печать;");
str = str.Replace(";000200;", ";В очереди на обработку;");
str = str.Replace(";000110;", ";В процессе печати;");
str = str.Replace(";000210;", ";В процессе обработки;");
str = str.Replace(";000000;", ";На выдаче;");
str = str.Replace(";000010;", ";На предпросмотре;");
str = str.Replace(";000001;", ";В ожидании оплаты;");
str = str.Replace(";100000;", ";Выдано;");
str = str.Replace(";010000;", ";Отменено;");
str = str.Replace(";000111;", ";Готово после печати;");
str = str.Replace(";000211;", ";Готово после обработки;");
str = str.Replace(";000212;", ";Готово после обработки, предпросмотр;");
str = str.Replace(";200000;", ";выдано без оплаты;");
str = str.Replace(";300000;", ";Утерян;");
string[] r = str.Split(';');
if (r.Length > 2)
{
_order.Rows.Add(r);
}
break;
}
case "body":
{
string[] r = str.Split(';');
if (r.Length > 1)
{
}
break;
}
}
}
fs.Close();
frmLoadOrders frm = new frmLoadOrders(_order);
frm.ShowDialog();
bool print = frm.checkPrintCheck.Checked;
List<string> orderToPrint = new List<string>();
int clientid = 0;
if (frm.DialogResult == DialogResult.OK)
{
frmSelectClient fClient = new frmSelectClient(db_connection, usr, "Укажите клиента, который будет указан во всех новых заказах", 8);
fClient.ShowDialog();
if (fClient.DialogResult == DialogResult.OK)
{
clientid = fClient.client.Id;
}
else
{
frm.DialogResult = DialogResult.Cancel;
}
}
bool globalUpdate = false;
bool globalInsert = false;
bool globalNoUpdate = false;
bool globalNoInsert = false;
if (frm.DialogResult == DialogResult.OK)
{
bool loadthis = false;
bool loadbody = false;
string orderid = "";
fs = new StreamReader(f, Encoding.GetEncoding(1251));
while (fs.Peek() >= 0)
{
str = fs.ReadLine();
if (str == "[order]")
{
flag = "order";
loadthis = false;
orderid = "";
}
else if (str == "[order body]")
{
if (loadbody)
flag = "body";
else
flag = "_body";
}
else if (str == "[order events]")
{
if (loadbody)
flag = "events";
else
flag = "_events";
}
switch (flag)
{
case "order":
{
string[] r = str.Split(';');
if (r.Length > 2)
{
for (int j = 0; j < frm.load.Rows.Count; j++)
{
if (r[0].ToString() == frm.load.Rows[j][0].ToString())
{
loadthis = true;
break;
}
}
if (loadthis)
{
string query = "SELECT * FROM [order] WHERE [guid] = '" + r[6] + "'";
SqlCommand order_cmd = new SqlCommand(query, db_connection);
SqlDataReader rdr = order_cmd.ExecuteReader();
orderToPrint.Add(r[13].Trim());
if (rdr.Read())
{
bool localUpdate = false;
if ((!globalUpdate) && (!globalNoUpdate))
{
frmAskDialog frma =
new frmAskDialog("Заказ с номером " + r[13] + " уже существует в базе!\nПерезаписать данные?");
frma.ShowDialog();
switch (frma.DialogResult)
{
case System.Windows.Forms.DialogResult.OK:
{
localUpdate = true;
break;
}
case System.Windows.Forms.DialogResult.Yes:
{
globalUpdate = true;
localUpdate = true;
break;
}
case System.Windows.Forms.DialogResult.No:
{
globalNoUpdate = false;
localUpdate = false;
break;
}
case System.Windows.Forms.DialogResult.Abort:
{
globalUpdate = false;
globalNoUpdate = true;
localUpdate = false;
break;
}
}
}
else
{
if (globalUpdate)
localUpdate = true;
if (globalNoUpdate)
localUpdate = false;
}
if (localUpdate)
{
loadbody = true;
try
{
string prev = "";
if (r[21] == "True")
prev = "1";
else
prev = "0";
query = "UPDATE [order] " +
"SET [id_user_accept] = " + r[0] + " " +
",[id_user_operator] = " + r[0] + " " +
",[id_user_designer] = " + r[0] + " " +
",[id_user_delivery] = " + r[0] + " " +
",[name_accept] = '" + r[8] + "' " +
",[name_operator] = '" + r[9] + "' " +
",[name_designer] = '" + r[10] + "' " +
",[name_delivery] = '" + r[11] + "' " +
",[status] = '" + r[12] + "' " +
",[preview] = " + prev + " " +
",[auto_export] = 0 " +
",[comment] = '" + r[22].Replace("!Экспорт", "").Trim() + "' " +
"WHERE [guid] = '" + r[6] + "'";
using (SqlConnection cn = new SqlConnection(prop.Connection_string))
{
cn.Open();
SqlCommand u = new SqlCommand(query, cn);
u.CommandTimeout = 9000;
u.ExecuteNonQuery();
u = new SqlCommand("SELECT [id_order] FROM [order] WHERE [guid] = '" + r[6] + "'", cn);
orderid = u.ExecuteScalar().ToString().Trim();
cn.Close();
}
if (orderid != "")
AddEvent("Заказ был импортирован (обновлен)", int.Parse(orderid));
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
MessageBox.Show("Ошибка во время обновления шапки заказа номер " + r[13] + "\n" + ex.Message + "\n" +
ex.Source + "\n" + ex.StackTrace);
}
}
else
{
loadbody = false;
}
}
else
{
bool localInsert = false;
if ((!globalInsert) && (!globalNoInsert))
{
frmAskDialog frma =
new frmAskDialog("Заказ с номером " + r[13] + " не существует в базе!\nСоздать новый?");
frma.ShowDialog();
switch (frma.DialogResult)
{
case System.Windows.Forms.DialogResult.OK:
{
localInsert = true;
break;
}
case System.Windows.Forms.DialogResult.Yes:
{
globalInsert = true;
localInsert = true;
break;
}
case System.Windows.Forms.DialogResult.No:
{
globalNoInsert = false;
localInsert = false;
break;
}
case System.Windows.Forms.DialogResult.Abort:
{
globalInsert = false;
globalNoInsert = true;
localInsert = false;
break;
}
}
}
else
{
if (globalInsert)
localInsert = true;
if (globalNoInsert)
localInsert = false;
}
if (localInsert)
{
loadbody = true;
try
{
string prev = "";
string newguid = r[6];
if (r[21] == "True")
prev = "1";
else
prev = "0";
query =
"INSERT INTO [order] ([id_user_accept],[id_client],[guid],[del],[name_accept],[status],[number],[input_date],[expected_date],[advanced_payment],[final_payment],[preview],[comment],[crop],[type]) VALUES (" +
usr.Id_user.ToString() + "," + clientid + ",'" + newguid + "',0,'" + usr.Name +
"','" + r[12] + "','" + r[13] + "',CONVERT(DATETIME, '" + DateToSql(r[14]) +
"', 120),CONVERT(DATETIME, '" +
DateToSql(r[15]) + "', 120),0,0," + prev + ",'" + r[22].Replace("!Экспорт", "").Trim() + "'," + r[23] + "," + r[24] + ")";
using (SqlConnection cn = new SqlConnection(prop.Connection_string))
{
cn.Open();
SqlCommand u = new SqlCommand(query, cn);
u.CommandTimeout = 9000;
u.ExecuteNonQuery();
u = new SqlCommand("SELECT [id_order] FROM [order] WHERE [guid] = '" + newguid + "'", cn);
orderid = u.ExecuteScalar().ToString().Trim();
cn.Close();
}
if (orderid != "")
AddEvent("Заказ был импортирован (новый)", int.Parse(orderid));
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
MessageBox.Show("Ошибка во время добавления нового заказа номер " + r[13] + "\n" + ex.Message + "\n" +
ex.Source + "\n" + ex.StackTrace);
}
}
else
{
loadbody = false;
}
}
rdr.Close();
}
}
break;
}
case "body":
{
string[] r = str.Split(';');
if (r.Length > 1)
{
if (loadthis)
{
//MessageBox.Show(str + " " + r.Length.ToString());
string query = "SELECT * FROM [orderbody] WHERE [guid] = '" + r[4] + "'";
SqlCommand body_cmd = new SqlCommand(query, db_connection);
body_cmd.CommandTimeout = 9000;
SqlDataReader rdr = body_cmd.ExecuteReader();
if (rdr.Read())
{
try
{
string tmp_datework = "";
if (rdr.IsDBNull(14))
tmp_datework = DateTime.Now.AddYears(-20).ToString();
else
tmp_datework = rdr.GetDateTime(14).ToString();
string idwork = "0";
string namework = "";
string iddefect = "0";
string namedefect = "";
if (DateTime.Parse(tmp_datework) < DateTime.Parse(DateToSql(r[13])))
{
if ((rdr.GetString(16).Trim() == r[15].Trim()) && (rdr.GetInt32(15).ToString() == r[14].Trim()))
{
idwork = r[14];
namework = r[15];
iddefect = r[14];
namedefect = r[15];
}
else
{
idwork = "0";
namework = r[15];
iddefect = "0";
namedefect = r[18];
}
}
else
{
idwork = "-1";
}
query = "UPDATE [orderbody] " +
"SET [id_order] = " + orderid + " ";
if (r[1] != "")
query += ",[id_mashine] = " + r[1] + " ";
if (r[2] != "")
query += ",[id_material] = " + r[2] + " ";
if (idwork != "-1")
{
query += ",[id_user_work] = " + idwork + " " +
",[name_work] = '" + namework + "' ";
if (r[13] != "")
query += ",[datework] = CONVERT(DATETIME, '" + DateToSql(r[13]) + "', 120) ";
if (r[7] != "")
query += ",[actual_quantity] = " + r[7].Replace(",", ".") + " ";
}
if (r[16] != "")
query += ",[defect_quantity] = " + r[16].Replace(",", ".") + " ";
if (r[17] != "")
query += ",[id_user_defect] = " + iddefect + " ";
if (r[18] != "")
query += ",[user_defect] = '" + namedefect + "' ";
if (r[19] != "")
query += ",[tech_defect] = " + r[19] + " ";
query += "WHERE [guid] = '" + r[4] + "'";
using (SqlConnection cn = new SqlConnection(prop.Connection_string))
{
cn.Open();
SqlCommand u = new SqlCommand(query, cn);
u.CommandTimeout = 9000;
u.ExecuteNonQuery();
cn.Close();
}
if (orderid != "")
AddEvent("Обновление строки в заказе при импорте", int.Parse(orderid));
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
MessageBox.Show("Ошибка во время обновления табличной части заказа!" + "\n" + ex.Message + "\n" +
ex.Source + "\n" + ex.StackTrace);
}
}
else
{
try
{
string idwork = r[14];
//все новые это новые, значит id = 0
/*
if ((idwork == "0") || (idwork == ""))
idwork = "0";
else
idwork = r[14];
*/
idwork = "0";
string namework = r[15];
string iddefect = "0";
string namedefect = r[18];
query = "INSERT INTO [orderbody] " +
"([id_order]";
if (r[1] != "")
query += ",[id_mashine]";
if (r[2] != "")
query += ",[id_material]";
if (r[3] != "")
query += ",[id_good]";
query += ",[guid]";
if (r[6] != "")
query += ",[quantity]";
if (r[7] != "")
query += ",[actual_quantity]";
query += ",[sign]";
if (r[9] != "")
query += ",[price]";
if (r[10] != "")
query += ",[dateadd]";
query += ",[id_user_add]" +
",[name_add]";
if (r[13] != "")
query += ",[datework]";
query += ",[id_user_work]" +
",[name_work]" +
",[defect_quantity]" +
",[id_user_defect]" +
",[user_defect]" +
",[tech_defect])" +
"VALUES" +
"(" + orderid + " ";
if (r[1] != "")
query += "," + r[1] + " ";
if (r[2] != "")
query += "," + r[2] + " ";
if (r[3] != "")
query += ",'" + r[3] + "' ";
query += ",'" + r[4] + "' ";
if (r[6] != "")
query += "," + r[6].Replace(",", ".") + " ";
if (r[7] != "")
query += "," + r[7].Replace(",", ".") + " ";
query += ",'" + r[8] + "' ";
if (r[9] != "")
query += "," + r[9].Replace(",", ".") + " ";
if (r[10] != "")
query += ",CONVERT(DATETIME, '" + DateToSql(r[10]) + "', 120) ";
query += "," + usr.Id_user + " " +
",'" + usr.Name + "' ";
if (r[13] != "")
query += ",CONVERT(DATETIME, '" + DateToSql(r[13]) + "', 120) ";
query += "," + idwork + " " +
",'" + namework + "' " +
"," + r[16].Replace(",", ".") + " " +
"," + iddefect + " " +
",'" + namedefect + "'" +
"," + r[19] + ")";
using (SqlConnection cn = new SqlConnection(prop.Connection_string))
{
cn.Open();
SqlCommand u = new SqlCommand(query, cn);
u.CommandTimeout = 9000;
u.ExecuteNonQuery();
cn.Close();
}
if (orderid != "")
AddEvent("Добавление строки в заказ при импорте", int.Parse(orderid));
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
MessageBox.Show("Ошибка во время обновления табличной части заказа!" + "\n" + ex.Message + "\n" +
ex.Source + "\n" + ex.StackTrace);
}
}
rdr.Close();
}
}
break;
}
case "events":
{
string[] r = str.Split(';');
if (r.Length > 1)
{
if (loadthis)
{
//MessageBox.Show(str + " " + r.Length.ToString());
string query = "SELECT * FROM [orderevent] WHERE [guid] = '" + r[2] + "'";
SqlCommand body_cmd = new SqlCommand(query, db_connection);
SqlDataReader rdr = body_cmd.ExecuteReader();
if (rdr.Read())
{
}
else
{
try
{
DateTime _d;
try
{
_d = DateTime.Parse(r[4]);
}
catch (Exception)
{
_d = DateTime.Now;
}
query = "INSERT INTO [dbo].[orderevent]" +
"([id_order]" +
",[event_user]" +
",[event_status]" +
",[event_point]" +
",[event_date]" +
",[guid]" +
",[event_text])" +
"VALUES " +
"(" + orderid + "" +
",'" + r[5].Trim() + "' " +
",'" + r[6].Trim() + "' " +
",'" + r[7] + "' " +
", CONVERT(DATETIME, '" + DateToSql(r[4]) + "', 120) " +
",'" + r[2] + "'" +
",'" + r[8] + "')";
using (SqlConnection cn = new SqlConnection(prop.Connection_string))
{
cn.Open();
SqlCommand u = new SqlCommand(query, cn);
u.CommandTimeout = 9000;
u.ExecuteNonQuery();
cn.Close();
}
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
MessageBox.Show("Ошибка во время переноса истории заказа!" + "\n" + ex.Message + "\n" +
ex.Source + "\n" + ex.StackTrace);
}
}
rdr.Close();
}
}
break;
}
}
}
fs.Close();
if (print)
{
foreach (string n in orderToPrint)
{
while (rep.IsBusy)
{
Application.DoEvents();
}
PrintCheck(n);
}
}
}
}
}
lblSaving.Visible = false;
}