public void Cancela(FRM_agregarArticulos frm, int id_packing, int id_caja, int id_orden)
{
string sp = "Sp_Packing_Insert";
try
{
con = new SqlConnection(cadena());
SqlCommand com = new SqlCommand(sp, con);
con.Open();
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@ID", SqlDbType.Int).Value = id_packing;
com.Parameters.Add("@ORDEN", SqlDbType.Int).Value = id_orden;
com.Parameters.Add("@CAJA", SqlDbType.Int).Value = id_caja;
com.Parameters.Add("@opcion", SqlDbType.VarChar).Value = "G_CANCELA";
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
foreach (DataGridViewRow row in frm.dgvArticulos.Rows)
{
if (row.Cells["Articulo"].Value.ToString() == dr.GetString(0) && row.Cells["SUBCUENTA"].Value.ToString() == dr.GetString(1))
{
frm.lblNUmero.Text = Convert.ToString(Convert.ToInt32(frm.lblNUmero.Text) - Convert.ToInt32(row.Cells["EnCaja"].Value));
row.Cells["EnCaja"].Value = 0;
}
}
}
dr.Close();
con.Close();
}
catch (Exception e)
{
MessageBox.Show("error al generar nueva caja" + e.Message);
}
}
public void InfoArticulosLineal(FRM_agregarArticulos f, int id_v, int orden, int id_pack)
{
string sp = "SP_Detalle_Packing";
try
{
con = new SqlConnection(cadena());
SqlCommand com = new SqlCommand(sp, con);
con.Open();
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@ID", SqlDbType.Int).Value = id_v;
com.Parameters.Add("@opcion", SqlDbType.VarChar).Value = "DET_LINEAL";
com.Parameters.Add("@IdPacking", SqlDbType.Int).Value = id_pack;
com.Parameters.Add("@orden", SqlDbType.Int).Value = orden;
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
f.dgvArticulos.Rows.Add(dr["ID"], dr["Subcuenta"], dr["Articulo"], dr["Familia"], dr["nombre"], dr["Cantidad"], dr["Nombre"], dr["EnCaja"], dr["CODIGO"], dr["MovID"]);
}
dr.Close();
con.Close();
NotSortable(f.dgvArticulos);
}
catch (Exception e)
{
MessageBox.Show("error al desplegar informacion de artriculos" + e.Message);
}
}
public void Modas(FRM_agregarArticulos frm)
{
string sp = "SP_Detalle_Packing";
try
{
con = new SqlConnection(cadena());
SqlCommand com = new SqlCommand(sp, con);
con.Open();
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@ID", SqlDbType.Int).Value = 0;
com.Parameters.Add("@opcion", SqlDbType.VarChar).Value = "MODAS";
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables.Count > 0)
{
frm.cmbXModa.DataSource = ds.Tables[0];
frm.cmbXModa.ValueMember = "ID";
frm.cmbXModa.DisplayMember = "MODA";
}
con.Close();
}
catch (Exception e)
{
MessageBox.Show("error al generar Modas" + e.Message);
}
}
private void swBtnPack_ValueChanged(object sender, EventArgs e)
{
swBtnPack = (DevComponents.DotNetBar.Controls.SwitchButton)sender;
string n = "";
if (swBtnPack.Value == true)
{
n = tabP.SelectedPanel.Name;
//tabP.SelectedTab.AttachedControl.Name = n;
foreach (Control c in tabP.Controls)
{
if (c.Name != n)
{
c.Enabled = false;
}
}
FRM_agregarArticulos AgrArt = new FRM_agregarArticulos(ID_packing, this);
AgrArt.lblXorden.Text = "ORDEN " + tabP.SelectedPanel.Name;
AgrArt.vaciarInfoOrden(Convert.ToInt32(tabP.SelectedPanel.Name));
AgrArt.ShowDialog();
GeneraBrtn();
//if (conex.Orden_Completa(ID_packing, Convert.ToInt32(tabP.SelectedPanel.Name)))
// swBtnPack.Enabled = false;
//else
swBtnPack.Value = false;
DescontarEnGrid(ID_packing, conex.GET_MOVID(Convert.ToInt32(tabP.SelectedPanel.Name)));
}
else
{
n = tabP.SelectedPanel.Name;
//tabP.SelectedTab.AttachedControl.Name = n;
foreach (Control c in tabP.Controls)
{
if (c.Name != n)
{
c.Enabled = true;
}
}
}
}