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);
}
}
}
}
