private void OpenOrder(string id) { if (usr.prmCanEditInventory) { using (SqlConnection con = new SqlConnection(settings.Connection_string)) { using ( SqlCommand cmd = new SqlCommand( "SELECT dbo.[order].id_order FROM dbo.[order] WHERE (dbo.[order].number = '" + id + "')", con)) { int id_order = -1; con.Open(); SqlDataReader r = cmd.ExecuteReader(); if (r.Read()) { id_order = r.GetInt32(0); } r.Close(); if (id_order > -1) { using ( Photoland.Forms.Interface.frmOrderCloseRO f = new Photoland.Forms.Interface.frmOrderCloseRO(con, usr, id_order)) { if (data.GetData(data.Row, 11).ToString().Trim() != "") f.RO = true; f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { if (inv.UpdateBodyRow(data.GetData(data.Row, 1).ToString(), f.TAction, f.Action, usr.Id_user)) { data.SetData(data.Row, 11, f.Action); data.SetData(data.Row, 7, f.TAction); } } } } else { MessageBox.Show("Заказ не найден в базе!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } }
private void OpenOrder(string id) { using (SqlConnection con = new SqlConnection(prop.Connection_string)) { using (SqlCommand cmd = new SqlCommand("SELECT dbo.[order].id_order FROM dbo.[order] WHERE (dbo.[order].id_order = " + id + ")", con)) { int id_order = -1; con.Open(); SqlDataReader r = cmd.ExecuteReader(); if (r.Read()) { id_order = r.GetInt32(0); } r.Close(); if (id_order > -1) { using (Photoland.Forms.Interface.frmOrderCloseRO f = new Photoland.Forms.Interface.frmOrderCloseRO(con, usr, id_order)) { f.btnChangeStatusAndBay.Visible = false; f.btnChangeStatus.Text = "Изменить статус"; f.RO = false; f.ShowDialog(); LoadData(); } } else { MessageBox.Show("Заказ не найден в базе!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }