public static DataSet FiltroPersonal(int intIdCliente, string NombrePersonal, string Rut, string FecNac, int intEstado, int Id_Seccion, bool bolListarSinDireccion)
{
DataSet dt = new DataSet();
clsConectorSqlServer Conectar = new clsConectorSqlServer();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = String.Format("pa_ListarPersonalFiltro_sel {0},'{1}','{2}','{3}',{4},{5},{6}", intIdCliente.ToString(), NombrePersonal, Rut, FecNac, intEstado, Id_Seccion, (bolListarSinDireccion?1:0));
cmd.CommandType = CommandType.Text;
dt = Conectar.Listar(Clases.clsBD.BD, cmd);
return(dt);
}
static public void CargarReporteListadoTLD()
{
clsConectorSqlServer Conectar = new clsConectorSqlServer();
SqlCommand cmd = new SqlCommand
{
CommandText = "rtpListaIngresoTLD"
};
//cmd.CommandText = "SELECT Id_Periodo,Anno, Mes,Id_TipoPeriodo FROM conf_periodo WHERE Id_TipoPeriodo=3";
DataSet ds;
ds = Conectar.Listar(Clases.clsBD.BD, cmd);
frmreporte frm3 = new frmreporte(ds, null, 9)
{
ShowInTaskbar = false
};
frm3.Show();
}