public void Historico(FRMGridHist h, int idpack, string opcion, string desde, string hasta)
{
string sp = "SP_Historico_Packing";
try
{
con = new SqlConnection(cadena());
SqlCommand com = new SqlCommand(sp, con);
com.CommandType = CommandType.StoredProcedure;
con.Open();
com.Parameters.Add("@opcion", SqlDbType.VarChar).Value = opcion;
com.Parameters.Add("@DESDE", SqlDbType.VarChar).Value = desde;
com.Parameters.Add("@HASTA", SqlDbType.VarChar).Value = hasta;
com.Parameters.Add("@ID", SqlDbType.VarChar).Value = idpack;
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
h.dgvArticulos.Rows.Add(dr["Id_Packing"], dr["Fecha_Creacion"], dr["Fecha_Conclucion"]);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("error al Historico" + ex.Message);
}
}
private void btnXCancel_Click(object sender, EventArgs e)
{
FRMGridHist hist = new FRMGridHist();
hist.TopLevel = false;
hist.StartPosition = FormStartPosition.CenterScreen;
hist.Parent = PnlPrincipal;
hist.Show();
hist.BringToFront();
}