public OrderInfo(SqlConnection db_connection, string orderno, bool forPrint) { this.db_connection = db_connection; SqlCommand tmp_cmd = new SqlCommand("SELECT [id_order] as [id], [id_order], [id_user_accept], [id_user_operator], [id_user_designer], [id_user_delivery], [id_client], [guid], [del], [name_accept], [name_operator], [name_delivery], [status], [number], [input_date], [expected_date], [output_date], [advanced_payment], [final_payment], [discont_percent], [discont_code], [preview], [comment], [crop], [type], [bonus], [order_price], [ptype], [auto_export], [id_place], [konvert] FROM [order] WHERE [number] = '" + orderno + "'", db_connection); SqlDataReader tmp_rdr = tmp_cmd.ExecuteReader(); if (tmp_rdr.Read()) { /* * 1 [id_order], * 2 [id_user_accept], * 3 [id_user_operator], * 4 [id_user_designer], * 5 [id_user_delivery], * 6! [id_client], * 7 [guid], * 8 [del], * 9 [name_accept], * 10 [name_operator], * 11 [name_delivery], *! 12 [status], *! 13 [number], *! 14 [input_date], *! 15 [expected_date], * 16 [output_date], *! 17 [advanced_payment], *! 18 [final_payment], *! 19 [discont_percent], *! 20 [discont_code], *! 21 [preview], *! 22 [comment] *! 23 [crop] *! 24 [type] * 25 [bonus] * 26 order_price * 27 ptype */ /////////////////////////////////// if (!tmp_rdr.IsDBNull(9)) _name_accept = tmp_rdr.GetString(9); else _name_accept = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(23)) _crop = tmp_rdr.GetInt32(23); else _crop = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(24)) _type = tmp_rdr.GetInt32(24); else _type = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(22)) _comment = tmp_rdr.GetString(22); else _comment = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(21)) if (tmp_rdr.GetBoolean(21)) _preview = 1; else _preview = 0; else _preview = 0; /////////////////////////////////// if ((!tmp_rdr.IsDBNull(20)) && (!tmp_rdr.IsDBNull(20))) { Discont = new DiscontInfo(tmp_rdr.GetString(20), db_connection); Discont.Id_dcard = 777777777; } //Discont = new DiscontInfo(tmp_rdr.GetString(20), tmp_rdr.GetDecimal(19)); else Discont = new DiscontInfo("", 0); /////////////////////////////////// if (!tmp_rdr.IsDBNull(18)) _finalPayment = tmp_rdr.GetDecimal(18); else _finalPayment = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(25)) _bonus = tmp_rdr.GetDecimal(25); else _bonus = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(26)) _order_price = tmp_rdr.GetDecimal(26); else _order_price = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(27)) _ptype = tmp_rdr.GetInt32(27); else _ptype = -1; /////////////////////////////////// if (!tmp_rdr.IsDBNull(17)) _advancedPayment = tmp_rdr.GetDecimal(17); else _advancedPayment = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(14)) _datein = tmp_rdr.GetDateTime(14).ToShortDateString(); else _datein = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(14)) _timein = tmp_rdr.GetDateTime(14).ToShortTimeString(); else _timein = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(15)) _dateout = tmp_rdr.GetDateTime(15).ToShortDateString(); else _dateout = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(15)) _timeout = tmp_rdr.GetDateTime(15).ToShortTimeString(); else _timeout = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(13)) _orderno = tmp_rdr.GetString(13); else _orderno = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(12)) _distanation = tmp_rdr.GetString(12); else _distanation = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(6)) _client_id = tmp_rdr.GetInt32(6); else _client_id = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(1)) this._id = tmp_rdr.GetInt32(1); else this._id = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(28)) _autoexport = tmp_rdr.GetInt32(28); else _autoexport = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(29)) _place = tmp_rdr.GetInt32(29); else _place = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(30)) _konvert = tmp_rdr.GetInt32(30); else _konvert = 0; } tmp_rdr.Close(); if (_client_id > 0) Client = new ClientInfo(_client_id, db_connection); else Client = null; tmp_cmd.CommandText = "SELECT dbo.orderbody.id_orderbody, dbo.orderbody.id_order, dbo.orderbody.id_good, dbo.orderbody.guid, dbo.orderbody.del, dbo.orderbody.quantity, dbo.orderbody.actual_quantity, dbo.orderbody.sign, dbo.orderbody.price, dbo.good.name, dbo.orderbody.datework, dbo.orderbody.id_user_work, dbo.orderbody.name_work, dbo.orderbody.defect_quantity, dbo.orderbody.id_user_defect, dbo.orderbody.user_defect, dbo.orderbody.tech_defect, dbo.orderbody.name_add, dbo.orderbody.comment FROM dbo.orderbody INNER JOIN dbo.good ON dbo.orderbody.id_good = dbo.good.id_good WHERE (((dbo.orderbody.del <> 1) OR (ISNULL(dbo.orderbody.del, 0) = 0)) AND ([id_order] = " + this.Id + ") AND ((dbo.orderbody.actual_quantity <> 0) OR (dbo.orderbody.quantity <> 0))) ORDER BY dbo.orderbody.id_order, dbo.orderbody.id_orderbody"; //tmp_rdr = tmp_cmd.ExecuteReader(); tmp_cmd.CommandTimeout = 9000; SqlDataAdapter da = new SqlDataAdapter(tmp_cmd); OrderBody = new DataTable("Order"); da.Fill(OrderBody); }
private void SelectClient(string id_client, string guid) { if (CheckState(db_connection)) { if (id_client != "") client = new ClientInfo(int.Parse(id_client), db_connection); else client = new ClientInfo(0, guid, db_connection); lblName.Text = client.Name; lblPhone1.Text = "Телефон: " + client.Phone1; lblPhone2.Text = "Доп телефон: " + client.Phone2; lblAddress.Text = "Адрес: " + client.Address; lblemail.Text = "Эл. почта: " + client.Email; lblicq.Text = "ICQ: " + client.Icq; lbladdon.Text = "Дополнительно: " + client.Addon; lblcategory.Text = "Категория: " + client.Category_name; btnNext.Enabled = true; /* db_command.Connection = db_connection; if (guid != "") { db_command.CommandText = "SELECT [id_client], [name], [phone_1], [phone_2], [address], [email], [icq], [addon], [categoryname] FROM [PSAv1].[dbo].[vwClientFull] WHERE [guid] = '" + guid + "'"; } if (id_client != "") { db_command.CommandText = "SELECT [id_client], [name], [phone_1], [phone_2], [address], [email], [icq], [addon], [categoryname] FROM [PSAv1].[dbo].[vwClientFull] WHERE [id_client] = " + id_client; } db_reader = db_command.ExecuteReader(); if (db_reader.Read()) { if (!db_reader.IsDBNull(1)) lblName.Text = db_reader.GetString(1); else lblName.Text = ""; if (!db_reader.IsDBNull(2)) lblPhone1.Text = "Телефон: " + db_reader.GetString(2); else lblPhone1.Text = "Телефон: -"; if (!db_reader.IsDBNull(3)) lblPhone2.Text = "Доп телефон: " + db_reader.GetString(3); else lblPhone2.Text = "Телефон: -"; if (!db_reader.IsDBNull(4)) lblAddress.Text = "Адрес: " + db_reader.GetString(4); else lblAddress.Text = "Адрес: -"; if (!db_reader.IsDBNull(5)) lblemail.Text = "Эл. почта: " + db_reader.GetString(5); else lblemail.Text = "Эл. почта: -"; if (!db_reader.IsDBNull(6)) lblicq.Text = "ICQ: " + db_reader.GetString(6); else lblicq.Text = "ICQ: -"; if (!db_reader.IsDBNull(7)) lbladdon.Text = "Дополнительно: " + db_reader.GetString(7); else lbladdon.Text = "Дополнительно: -"; if (!db_reader.IsDBNull(8)) lblcategory.Text = "Категория: " + db_reader.GetString(8); else lblcategory.Text = "Категория: ?!"; btnNext.Enabled = true; } else { MessageBox.Show("Ошибка получения данных о клиенте!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); btnNext.Enabled = false; } db_reader.Close(); */ } }
public OrderInfo(SqlConnection db_connection, int id_order) { this.db_connection = db_connection; this._id = id_order; SqlCommand tmp_cmd = new SqlCommand("SELECT [id_order] as [id], [id_order], [id_user_accept], [id_user_operator], [id_user_designer], [id_user_delivery], [id_client], [guid], [del], [name_accept], [name_operator], [name_delivery], [status], [number], [input_date], [expected_date], [output_date], [advanced_payment], [final_payment], [discont_percent], [discont_code], [preview], [comment], [crop], [type], [bonus], [order_price], [ptype], [auto_export], [id_place], [konvert] FROM [order] WHERE [id_order] = " + id_order, db_connection); SqlDataReader tmp_rdr = tmp_cmd.ExecuteReader(); if (tmp_rdr.Read()) { /* * 1 [id_order], * 2 [id_user_accept], * 3 [id_user_operator], * 4 [id_user_designer], * 5 [id_user_delivery], * 6! [id_client], * 7 [guid], * 8 [del], * 9 [name_accept], * 10 [name_operator], * 11 [name_delivery], *! 12 [status], *! 13 [number], *! 14 [input_date], *! 15 [expected_date], * 16 [output_date], *! 17 [advanced_payment], *! 18 [final_payment], *! 19 [discont_percent], *! 20 [discont_code], *! 21 [preview], *! 22 [comment] *! 23 [crop] *! 24 [type] * 25 [bonus] * 26 order_price * 27 ptype */ /////////////////////////////////// if (!tmp_rdr.IsDBNull(9)) _name_accept = tmp_rdr.GetString(9); else _name_accept = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(23)) _crop = tmp_rdr.GetInt32(23); else _crop = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(24)) _type = tmp_rdr.GetInt32(24); else _type = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(22)) _comment = tmp_rdr.GetString(22); else _comment = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(21)) if (tmp_rdr.GetBoolean(21)) _preview = 1; else _preview = 0; else _preview = 0; /////////////////////////////////// if ((!tmp_rdr.IsDBNull(20)) && (!tmp_rdr.IsDBNull(20))) { Discont = new DiscontInfo(tmp_rdr.GetString(20), db_connection); Discont.Id_dcard = 777777777; } else { Discont = new DiscontInfo("", 0); } /////////////////////////////////// if (!tmp_rdr.IsDBNull(18)) _finalPayment = tmp_rdr.GetDecimal(18); else _finalPayment = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(25)) _bonus = tmp_rdr.GetDecimal(25); else _bonus = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(26)) _order_price = tmp_rdr.GetDecimal(26); else _order_price = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(27)) _ptype = tmp_rdr.GetInt32(27); else _ptype = -1; /////////////////////////////////// if (!tmp_rdr.IsDBNull(17)) _advancedPayment = tmp_rdr.GetDecimal(17); else _advancedPayment = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(14)) _datein = tmp_rdr.GetDateTime(14).ToShortDateString(); else _datein = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(14)) _timein = tmp_rdr.GetDateTime(14).ToShortTimeString(); else _timein = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(15)) _dateout = tmp_rdr.GetDateTime(15).ToShortDateString(); else _dateout = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(15)) _timeout = tmp_rdr.GetDateTime(15).ToShortTimeString(); else _timeout = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(13)) _orderno = tmp_rdr.GetString(13); else _orderno = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(12)) _distanation = tmp_rdr.GetString(12); else _distanation = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(6)) _client_id = tmp_rdr.GetInt32(6); else _client_id = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(1)) id_order = tmp_rdr.GetInt32(1); else id_order = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(28)) _autoexport = tmp_rdr.GetInt32(28); else _autoexport = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(29)) _place = tmp_rdr.GetInt32(29); else _place = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(30)) _konvert = tmp_rdr.GetInt32(30); else _konvert = 0; } tmp_rdr.Close(); if (_client_id > 0) Client = new ClientInfo(_client_id, db_connection); else Client = null; tmp_cmd.CommandText = "SELECT dbo.orderbody.id_orderbody, dbo.orderbody.id_order, dbo.orderbody.id_good, dbo.orderbody.guid, dbo.orderbody.del, dbo.orderbody.quantity, dbo.orderbody.actual_quantity, dbo.orderbody.sign, dbo.orderbody.price, dbo.good.name, dbo.orderbody.datework, dbo.orderbody.id_user_work, dbo.orderbody.name_work, dbo.orderbody.defect_quantity, dbo.orderbody.id_user_defect, dbo.orderbody.user_defect, dbo.orderbody.tech_defect, dbo.orderbody.name_add, dbo.orderbody.comment FROM dbo.orderbody INNER JOIN dbo.good ON dbo.orderbody.id_good = dbo.good.id_good WHERE (((dbo.orderbody.del <> 1) OR (ISNULL(dbo.orderbody.del, 0) = 0)) AND ([id_order] = " + this.Id + ") AND ((dbo.orderbody.actual_quantity <> 0) OR (dbo.orderbody.quantity <> 0))) ORDER BY dbo.orderbody.id_order, dbo.orderbody.id_orderbody"; tmp_cmd.CommandTimeout = 9000; tmp_rdr = tmp_cmd.ExecuteReader(); OrderBody = new DataTable("Order"); OrderBody.Columns.Add("check", System.Type.GetType("System.Boolean")); // 0 OrderBody.Columns.Add("Name", System.Type.GetType("System.String")); // 1 OrderBody.Columns.Add("GoodId", System.Type.GetType("System.String")); // 2 OrderBody.Columns.Add("Count", System.Type.GetType("System.Decimal")); // 3 OrderBody.Columns.Add("ActualCount", System.Type.GetType("System.Decimal")); // 4 OrderBody.Columns.Add("Price", System.Type.GetType("System.Decimal")); // 5 OrderBody.Columns.Add("Sum", System.Type.GetType("System.Decimal")); // 6 OrderBody.Columns.Add("ActualSum", System.Type.GetType("System.Decimal")); // 7 OrderBody.Columns.Add("Sign", System.Type.GetType("System.String")); // 8 OrderBody.Columns.Add("old", System.Type.GetType("System.Boolean")); // 9 OrderBody.Columns.Add("guid", System.Type.GetType("System.String")); // 10 OrderBody.Columns.Add("datework", System.Type.GetType("System.String")); // 11 10 OrderBody.Columns.Add("id_user_work", System.Type.GetType("System.Int32")); // 12 11 OrderBody.Columns.Add("name_work", System.Type.GetType("System.String")); // 13 12 OrderBody.Columns.Add("defect_quantity", System.Type.GetType("System.Decimal"));// 14 13 OrderBody.Columns.Add("id_user_defect", System.Type.GetType("System.Int32")); // 15 14 OrderBody.Columns.Add("user_defect", System.Type.GetType("System.String")); // 16 15 OrderBody.Columns.Add("tech_defect", System.Type.GetType("System.Int32")); // 17 16 OrderBody.Columns.Add("name_add", System.Type.GetType("System.String")); // 18 17 OrderBody.Columns.Add("comment", System.Type.GetType("System.String")); // 19 18 /* * 0 [id_orderbody], * 1 [id_order], * 2 [id_good], * 3 [guid], * 4 [del], * 5 [quantity], * 6 [actual_quantity], * 7 [sign], * 8 [price] * 9 [name] * 10 datework, * 11 id_user_work, * 12 name_work, * 13 defect_quantity, * 14 id_user_defect, * 15 user_defect, * 16 tech_defect */ while (tmp_rdr.Read()) { object[] r = new object[20]; r[0] = false; /////////////////////////////////// if (!tmp_rdr.IsDBNull(9)) r[1] = tmp_rdr.GetString(9); else r[1] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(2)) r[2] = tmp_rdr.GetString(2); else r[2] = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(5)) r[3] = tmp_rdr.GetDecimal(5); else r[3] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(6)) r[4] = tmp_rdr.GetDecimal(6); else r[4] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(8)) r[5] = tmp_rdr.GetDecimal(8); else r[5] = 0; /////////////////////////////////// r[6] = (decimal)r[3] * (decimal)r[5]; /////////////////////////////////// r[7] = (decimal)r[4] * (decimal)r[5]; /////////////////////////////////// if (!tmp_rdr.IsDBNull(7)) r[8] = tmp_rdr.GetString(7); else r[8] = 0; /////////////////////////////////// r[9] = true; /////////////////////////////////// if (!tmp_rdr.IsDBNull(3)) r[10] = tmp_rdr.GetString(3); else r[10] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(10)) r[11] = tmp_rdr.GetDateTime(10); else r[11] = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(11)) r[12] = tmp_rdr.GetInt32(11); else r[12] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(12)) r[13] = tmp_rdr.GetString(12); else r[13] = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(13)) r[14] = tmp_rdr.GetDecimal(13); else r[14] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(14)) r[15] = tmp_rdr.GetInt32(14); else r[15] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(15)) r[16] = tmp_rdr.GetString(15); else r[16] = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(16)) r[17] = tmp_rdr.GetInt32(16); else r[17] = 0; /////////////////////////////////// if (!tmp_rdr.IsDBNull(17)) r[18] = tmp_rdr.GetString(17).Trim(); else r[18] = ""; /////////////////////////////////// if (!tmp_rdr.IsDBNull(18)) r[19] = tmp_rdr.GetString(18).Trim(); else r[19] = ""; OrderBody.Rows.Add(r); } tmp_rdr.Close(); }
private void SelectClient(string id) { client = new ClientInfo(int.Parse(id), db_connection); this.DialogResult = DialogResult.OK; }