public static HorasVehiculos Instance()
{
if (frm == null)
{
frm = new HorasVehiculos();
}
return(frm);
}
private void reportViewer1_Hyperlink(object sender, HyperlinkEventArgs e)
{
Uri link = new Uri(e.Hyperlink);
if (link.Authority == "someaction")
{
e.Cancel = true;
char[] sep = new char[] { '=' };
var param = link.Query.Split(sep);
string rowId = param[1];
string id = rowId.Remove(rowId.Length - 1, 1);
string turno = rowId.Substring(rowId.Length - 1, 1);
int boletainicial = 0;
int boletafinal = 0;
string fecha_elegida = kryptonDateTimePicker1.Value.ToShortDateString();
SqlConnection miconexion = new SqlConnection();
miconexion.ConnectionString = Properties.Settings.Default.principalConnectionString;
miconexion.Open();
SqlCommand consulta = new SqlCommand("SELECT boleta_inicial, boleta_final From cierre_z WHERE fecha = @fecha", miconexion);
consulta.Parameters.Add(new SqlParameter("@fecha", fecha_elegida));
SqlDataReader reader = consulta.ExecuteReader();
if (reader.Read())
{
boletainicial = reader.GetInt32(0);
boletafinal = reader.GetInt32(1);
}
HorasVehiculos hv = null;
hv = HorasVehiculos.Instance();
hv.lblCodigo.Text = id;
hv.lblBoletaInicial.Text = Convert.ToString(boletainicial);
hv.lblBoletaFinal.Text = Convert.ToString(boletafinal);
hv.lblTurno.Text = turno;
hv.StartPosition = FormStartPosition.CenterScreen;
hv.Show();
hv.WindowState = FormWindowState.Normal;
hv.Activate();
}
}
