protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.dvwFuerzaLaboral.Table = this.dsPerfil.SA_LKP_TEDS_NO_FUERZA_LABORAL;
this.dvwUltGrado.Table = this.dsPerfil.SA_LKP_TEDS_GRADO;
this.dvwFreqAutoAyuda.Table = this.dsPerfil.SA_LKP_TEDS_FRECUENCIA_AUTOAYUDA;
if (this.Session["pk_administracion"].ToString() == "1")//Niños y adolecentes
{
this.dvwFuerzaLaboral.RowFilter = "PK_NoFuerzaLaboral <> 9";
this.dvwUltGrado.RowFilter = "(PK_grado <> 22) AND (PK_grado <> 23) AND (PK_grado <> 24) AND (PK_grado <> 25)";
}
this.DataBind();
lbxCompFamiliar();//multi
if (this.m_frmAction == frmAction.Create || this.m_frmAction == frmAction.Update)
{
this.EditarRegistro();
if (this.m_frmAction == frmAction.Update)
{
this.ActualizarCampos();
}
}
else
{
this.LeerRegistro();
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.dvwSeguroSalud.Table = this.dsPerfil.SA_LKP_TEDS_SEGURO_SALUD;
if (this.Session["pk_administracion"].ToString() == "1")
{
this.dvwSeguroSalud.RowFilter = "PK_SeguroSalud <> 4";
}
this.DataBind();
switch (this.m_frmAction)
{
case frmAction.Update:
this.EditarRegistro();
this.ActualizarCampos();
this.lblPerfil.Visible = true;
this.lblEpisodio.Visible = true;
break;
case frmAction.Create:
this.EditarRegistro();
this.lblPerfil.Visible = false;
this.lblPerfilNuevo.Visible = true;
this.lblEpisodio.Visible = false;
this.lblEpisodioNuevo.Visible = true;
break;
default:
this.LeerRegistro();
break;
}
}
}
/// <summary>
/// Método necesario para admitir el Diseñador. No se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
this.dsPerfil = new ASSMCA.perfiles.dsPerfil();
this.dvwIngresoIndividual = new System.Data.DataView();
this.dvwIngresoFamiliar = new System.Data.DataView();
this.dvwFemina = new System.Data.DataView();
this.dvwFuerzaLaboral = new System.Data.DataView();
this.dvwUltGrado = new System.Data.DataView();
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwIngresoIndividual)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwIngresoFamiliar)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFemina)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFuerzaLaboral)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwUltGrado)).BeginInit();
//
// dsPerfil
//
this.dsPerfil.DataSetName = "dsPerfil";
this.dsPerfil.Locale = new System.Globalization.CultureInfo("en-US");
//
// dvwIngresoIndividual
//
this.dvwIngresoIndividual.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
//
// dvwIngresoFamiliar
//
this.dvwIngresoFamiliar.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwIngresoIndividual)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwIngresoFamiliar)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFuerzaLaboral)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwUltGrado)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFemina)).EndInit();
}
protected void Page_Load(object sender, System.EventArgs e)
{
tipoDePerfilHidden.Value = this.Session["Tipo_Perfil"].ToString();
if (!this.IsPostBack)
{
FechaAdmisionHidden.Value = Session["FechaAdmision"].ToString();
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.DataBind();
if (this.m_frmAction == frmAction.Create || this.m_frmAction == frmAction.Update)
{
this.EditarRegistro();
if (this.m_frmAction == frmAction.Update)
{
this.ActualizarCampos();
this.lblPerfil.Visible = true;
}
else //es crear
{
this.lblPerfil.Visible = false;
this.lblPerfilNuevo.Visible = true;
}
}
else
{
this.LeerRegistro();
}
}
}
private void InitializeComponent()
{
this.dsPerfil = new ASSMCA.perfiles.dsPerfil();
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).BeginInit();
this.dsPerfil.DataSetName = "dsPerfil";
this.dsPerfil.Locale = new System.Globalization.CultureInfo("en-US");
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).EndInit();
}
private void InitializeComponent()
{
this.daPersona = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.cnn = new System.Data.SqlClient.SqlConnection();
this.dsPerfil = new ASSMCA.perfiles.dsPerfil();
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).BeginInit();
//
// daPersona
//
this.daPersona.SelectCommand = this.sqlSelectCommand1;
this.daPersona.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "SA_PERSONA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Persona", "PK_Persona"),
new System.Data.Common.DataColumnMapping("NR_SeguroSocial", "NR_SeguroSocial"),
new System.Data.Common.DataColumnMapping("FK_Sexo", "FK_Sexo"),
new System.Data.Common.DataColumnMapping("DE_Sexo", "DE_Sexo"),
new System.Data.Common.DataColumnMapping("AP_Primero", "AP_Primero"),
new System.Data.Common.DataColumnMapping("AP_Segundo", "AP_Segundo"),
new System.Data.Common.DataColumnMapping("NB_Primero", "NB_Primero"),
new System.Data.Common.DataColumnMapping("NB_Segundo", "NB_Segundo"),
new System.Data.Common.DataColumnMapping("FE_Nacimiento", "FE_Nacimiento"),
new System.Data.Common.DataColumnMapping("NR_Edad", "NR_Edad"),
new System.Data.Common.DataColumnMapping("FK_Veterano", "FK_Veterano"),
new System.Data.Common.DataColumnMapping("DE_Veterano", "DE_Veterano"),
new System.Data.Common.DataColumnMapping("FK_GrupoEtnico", "FK_GrupoEtnico"),
new System.Data.Common.DataColumnMapping("DE_GrupoEtnico", "DE_GrupoEtnico"),
new System.Data.Common.DataColumnMapping("FK_Sesion", "FK_Sesion"),
new System.Data.Common.DataColumnMapping("TI_Edicion", "TI_Edicion"),
new System.Data.Common.DataColumnMapping("FE_Edicion", "FE_Edicion"),
new System.Data.Common.DataColumnMapping("NR_Expediente", "NR_Expediente")
}),
new System.Data.Common.DataTableMapping("Table1", "Table1", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FK_Raza", "FK_Raza"),
new System.Data.Common.DataColumnMapping("DE_Raza", "DE_Raza")
})
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "[SPR_PERSONA]";
this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand1.Connection = this.cnn;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PK_Persona", System.Data.SqlDbType.Int, 4));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PK_Programa", System.Data.SqlDbType.TinyInt, 1));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IN_Raza", System.Data.SqlDbType.Bit, 1));
//
// cnn
//
this.cnn.ConnectionString = NewSource.connectionString;
//
// dsPerfil
//
this.dsPerfil.DataSetName = "dsPerfil";
this.dsPerfil.Locale = new System.Globalization.CultureInfo("en-US");
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).EndInit();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
if (this.m_frmAction == frmAction.Create || this.m_frmAction == frmAction.Update)
{
if (this.m_frmAction == frmAction.Update)
{
this.ActualizarCampos();
}
}
else
{
LeerRegistro();
}
}
}
private void InitializeComponent()
{
this.dsPerfil = new ASSMCA.perfiles.dsPerfil();
this.dvwFuerzaLaboral = new System.Data.DataView();
this.dvwUltGrado = new System.Data.DataView();
this.dvwFreqAutoAyuda = new System.Data.DataView();
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFuerzaLaboral)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwUltGrado)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFreqAutoAyuda)).BeginInit();
//
// dsPerfil
//
this.dsPerfil.DataSetName = "dsPerfil";
this.dsPerfil.Locale = new System.Globalization.CultureInfo("en-US");
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFuerzaLaboral)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwUltGrado)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvwFreqAutoAyuda)).EndInit();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (this.Session["dsSeguridad"] == null)
{
this.Response.Redirect("~/Error.aspx?errMsg=sesion");
return;
}
if (!this.IsPostBack)
{
if (this.Request.QueryString["txtDescripcion"] != null && this.Request.QueryString["txtDescripcionHidden"] != null)
{
this.txtDescripcion.Value = this.Request.QueryString["txtDescripcion"].ToString();
this.txtDescripcionHidden.Value = this.Request.QueryString["txtDescripcionHidden"].ToString();
}
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.DataBind();
}
else
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.dvwRazonAlta.Table = this.dsPerfil.SA_LKP_ALTA;
//if (this.Session["pk_administracion"].ToString() == "1" && this.pk_programa != 75)//Niños y adolecentes
//{
// this.dvwRazonAlta.RowFilter = " PK_Alta <> 8 ";
//}
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.DataBind();
ListItem li = new ListItem("", "0");
this.ddlCategoriasDeCentrosPrivadosALL();
this.ddlCategoriasDeCentrosPrivados.Items.Insert(0, li);
this.ddlCentroReferido.Items.Insert(0, li);
this.RemoverRevocacionDeRazonDeAlta();
this.setValue();
switch (this.m_frmAction)
{
case (frmAction.Create):
this.ddlRazonAlta.Items.Insert(0, li);
this.EditarRegistro();
break;
case (frmAction.Update):
this.ActualizarCampos();
this.EditarRegistro();
break;
case (frmAction.Read):
this.LeerRegistro();
break;
default: break;
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.dvwFemina.Table = this.dsPerfil.SA_LKP_FEMINA;
this.dvwIngresoFamiliar.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
this.dvwIngresoIndividual.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
this.dvwFuerzaLaboral.Table = this.dsPerfil.SA_LKP_TEDS_NO_FUERZA_LABORAL;
this.dvwUltGrado.Table = this.dsPerfil.SA_LKP_TEDS_GRADO;
if (this.Session["pk_administracion"].ToString() == "1")//Niños y adolecentes
{
this.dvwFuerzaLaboral.RowFilter = "PK_NoFuerzaLaboral <> 9";
this.dvwUltGrado.RowFilter = "(PK_grado <> 22) AND (PK_grado <> 23) AND (PK_grado <> 24) AND (PK_grado <> 25)";
}
if (this.dsPerfil.SA_PERSONA[0]["FK_Sexo"].ToString() == "2" || this.dsPerfil.SA_PERSONA[0]["FK_Sexo"].ToString() == "4") //Femenino o transgenero m->f
{
this.dvwFemina.RowFilter = "PK_Femina <> 99";
}
this.DataBind();
load();
if (this.m_frmAction == frmAction.Create || this.m_frmAction == frmAction.Update)
{
this.EditarRegistro();
if (this.m_frmAction == frmAction.Update)
{
this.ActualizarCampos();
}
}
else
{
this.LeerRegistro();
}
}
}
private void InitializeComponent()
{
this.daLkpEpisodio = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.cnn = new System.Data.SqlClient.SqlConnection();
this.daLkpPerfil = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.dsPerfil = new ASSMCA.perfiles.dsPerfil();
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).BeginInit();
#region daLkpEpisodio
this.daLkpEpisodio.SelectCommand = this.sqlSelectCommand1;
this.daLkpEpisodio.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "SA_LKP_TEDS_SEGURO_SALUD", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_SeguroSalud", "PK_SeguroSalud"),
new System.Data.Common.DataColumnMapping("DE_SeguroSalud", "DE_SeguroSalud")
}),
new System.Data.Common.DataTableMapping("Table1", "SA_LKP_TEDS_PAGO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Pago", "PK_Pago"),
new System.Data.Common.DataColumnMapping("DE_Pago", "DE_Pago")
}),
new System.Data.Common.DataTableMapping("Table2", "SA_LKP_FEMINA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Femina", "PK_Femina"),
new System.Data.Common.DataColumnMapping("DE_Femina", "DE_Femina")
}),
new System.Data.Common.DataTableMapping("Table3", "SA_LKP_TEDS_FUENTE_INGRESO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_FuenteIngreso", "PK_FuenteIngreso"),
new System.Data.Common.DataColumnMapping("DE_FuenteIngreso", "DE_FuenteIngreso")
}),
new System.Data.Common.DataTableMapping("Table4", "SA_LKP_INGRESO_ANUAL", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_IngresoAnual", "PK_IngresoAnual"),
new System.Data.Common.DataColumnMapping("DE_IngresoAnual", "DE_IngresoAnual")
}),
new System.Data.Common.DataTableMapping("Table5", "SA_LKP_TIEMPO_RESIDENCIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_TiempoResidencia", "PK_TiempoResidencia"),
new System.Data.Common.DataColumnMapping("DE_TiempoResidencia", "DE_TiempoResidencia")
}),
new System.Data.Common.DataTableMapping("Table6", "SA_LKP_MUNICIPIO_RESIDENCIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Municipio", "PK_Municipio"),
new System.Data.Common.DataColumnMapping("DE_Municipio", "DE_Municipio")
}),
new System.Data.Common.DataTableMapping("Table7", "SA_LKP_TEDS_ETAPA_SERVICIO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_EtapaServicio", "PK_EtapaServicio"),
new System.Data.Common.DataColumnMapping("DE_EtapaServicio", "DE_EtapaServicio")
}),
new System.Data.Common.DataTableMapping("Table8", "SA_LKP_TEDS_REFERIDO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Referido", "PK_Referido"),
new System.Data.Common.DataColumnMapping("DE_Referido", "DE_Referido")
}),
new System.Data.Common.DataTableMapping("Table9", "SA_LKP_TEDS_ESTADO_LEGAL", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_EstadoLegal", "PK_EstadoLegal"),
new System.Data.Common.DataColumnMapping("DE_EstadoLegal", "DE_EstadoLegal")
}),
new System.Data.Common.DataTableMapping("Table10", "SA_LKP_PROBLEMA_JUSTICIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_ProbJusticia", "PK_ProbJusticia"),
new System.Data.Common.DataColumnMapping("DE_ProbJusticia", "DE_ProbJusticia")
}),
new System.Data.Common.DataTableMapping("Table11", "SA_LKP_TEDS_EPISODIO_PREVIO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_EpisodiosPrevios", "PK_EpisodiosPrevios"),
new System.Data.Common.DataColumnMapping("DE_EpisodiosPrevios", "DE_EpisodiosPrevios")
}),
new System.Data.Common.DataTableMapping("Table12", "SA_LKP_TIEMPO_ULT_TRAT", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_TiempoUltTrat", "PK_TiempoUltTrat"),
new System.Data.Common.DataColumnMapping("DE_TiempoUltTrat", "DE_TiempoUltTrat")
}),
new System.Data.Common.DataTableMapping("Table13", "SA_LKP_ABUSO_SUSTANCIAS_ANTERIOR", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_AbusoSustancias", "PK_AbusoSustancias"),
new System.Data.Common.DataColumnMapping("DE_AbusoSustancias", "DE_AbusoSustancias")
}),
new System.Data.Common.DataTableMapping("Table14", "SA_LKP_SALUD_MENTAL_ANTERIOR", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_SaludMental", "PK_SaludMental"),
new System.Data.Common.DataColumnMapping("DE_SaludMental", "DE_SaludMental")
})
});
#endregion
#region sqlSelectCommand1
this.sqlSelectCommand1.CommandText = "[SPR_LKP_EPISODIO]";
this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand1.Connection = this.cnn;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
#endregion
#region cnn
this.cnn.ConnectionString = NewSource.connectionString;
#endregion
#region daLkpPerfil
this.daLkpPerfil.SelectCommand = this.sqlSelectCommand2;
this.daLkpPerfil.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "SA_LKP_TEDS_ESTADO_MARITAL", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_EstadoMarital", "PK_EstadoMarital"),
new System.Data.Common.DataColumnMapping("DE_EstadoMarital", "DE_EstadoMarital")
}),
new System.Data.Common.DataTableMapping("Table1", "SA_LKP_TEDS_COND_LABORAL", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_CondLaboral", "PK_CondLaboral"),
new System.Data.Common.DataColumnMapping("DE_CondLaboral", "DE_CondLaboral")
}),
new System.Data.Common.DataTableMapping("Table2", "SA_LKP_TEDS_NO_FUERZA_LABORAL", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_NoFuerzaLaboral", "PK_NoFuerzaLaboral"),
new System.Data.Common.DataColumnMapping("DE_NoFuerzaLaboral", "DE_NoFuerzaLaboral")
}),
new System.Data.Common.DataTableMapping("Table3", "SA_LKP_TEDS_GRADO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Grado", "PK_Grado"),
new System.Data.Common.DataColumnMapping("DE_Grado", "DE_Grado")
}),
new System.Data.Common.DataTableMapping("Table4", "SA_LKP_COMPOSICION_FAMILIAR", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Familiar", "PK_Familiar"),
new System.Data.Common.DataColumnMapping("DE_Familiar", "DE_Familiar")
}),
new System.Data.Common.DataTableMapping("Table5", "SA_LKP_TEDS_RESIDENCIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Residencia", "PK_Residencia"),
new System.Data.Common.DataColumnMapping("DE_Residencia", "DE_Residencia")
}),
new System.Data.Common.DataTableMapping("Table6", "SA_LKP_DIAGNOSTICO", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Diagnostico", "PK_Diagnostico"),
new System.Data.Common.DataColumnMapping("DE_Diagnostico", "DE_Diagnostico")
}),
new System.Data.Common.DataTableMapping("Table7", "SA_LKP_DSMIV_CAT", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_DSMIVCat", "PK_DSMIVCat"),
new System.Data.Common.DataColumnMapping("DE_DSMIVCat", "DE_DSMIVCat")
}),
new System.Data.Common.DataTableMapping("Table8", "SA_LKP_DSMIV", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_DSMIV", "PK_DSMIV"),
new System.Data.Common.DataColumnMapping("DE_DSMIV", "DE_DSMIV"),
new System.Data.Common.DataColumnMapping("PK_DSMIV1", "PK_DSMIV1"),
new System.Data.Common.DataColumnMapping("FK_DSMIVCat", "FK_DSMIVCat")
}),
new System.Data.Common.DataTableMapping("Table9", "SA_LKP_DSMIV_IV", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_DSMIV_IV", "PK_DSMIV_IV"),
new System.Data.Common.DataColumnMapping("DE_DSMIV_IV", "DE_DSMIV_IV")
}),
new System.Data.Common.DataTableMapping("Table10", "SA_LKP_REFERIDOS_TX", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_ReferidosTX", "PK_ReferidosTX"),
new System.Data.Common.DataColumnMapping("DE_ReferidosTX", "DE_ReferidosTX")
}),
new System.Data.Common.DataTableMapping("Table11", "SA_LKP_TEDS_SUSTANCIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Sustancia", "PK_Sustancia"),
new System.Data.Common.DataColumnMapping("DE_Sustancia", "DE_Sustancia")
}),
new System.Data.Common.DataTableMapping("Table12", "SA_LKP_TEDS_VIA_UTILIZACION", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_ViaUtilizacion", "PK_ViaUtilizacion"),
new System.Data.Common.DataColumnMapping("DE_ViaUtilizacion", "DE_ViaUtilizacion")
}),
new System.Data.Common.DataTableMapping("Table13", "SA_LKP_TEDS_FRECUENCIA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Frecuencia", "PK_Frecuencia"),
new System.Data.Common.DataColumnMapping("DE_Frecuencia", "DE_Frecuencia")
}),
new System.Data.Common.DataTableMapping("Table14", "SA_LKP_MEDIDA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_Medida", "PK_Medida"),
new System.Data.Common.DataColumnMapping("DE_Medida", "DE_Medida")
}),
new System.Data.Common.DataTableMapping("Table15", "SA_LKP_TEDS_FRECUENCIA_AUTOAYUDA", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_FreqAutoAyuda", "PK_FreqAutoAyuda"),
new System.Data.Common.DataColumnMapping("DE_FreqAutoAyuda", "DE_FreqAutoAyuda")
}),
new System.Data.Common.DataTableMapping("Table16", "SA_LKP_TEDS_SITUACION_ESCOLAR", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_SituacionEscolar", "PK_SituacionEscolar"),
new System.Data.Common.DataColumnMapping("DE_SituacionEscolar", "DE_SituacionEscolar")
}),
new System.Data.Common.DataTableMapping("Table17", "SA_LKP_TEDS_TIPO_ADMISION", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_TipoAdmision", "PK_TipoAdmision"),
new System.Data.Common.DataColumnMapping("DE_TipoAdmision", "DE_TipoAdmision")
}),
new System.Data.Common.DataTableMapping("Table19", "SA_LKP_DSMV_ProblemasPsicosocialesAmbientales", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_DSMV_ProblemasPsicosocialesAmbientales", "PK_DSMV_ProblemasPsicosocialesAmbientales"),
new System.Data.Common.DataColumnMapping("DE_DSMV_ProblemasPsicosocialesAmbientales", "DE_DSMV_ProblemasPsicosocialesAmbientales")
}),
new System.Data.Common.DataTableMapping("Table20", "SA_LKP_DSMV", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PK_DSMV", "PK_DSMV"),
new System.Data.Common.DataColumnMapping("_PK_DSMV", "_PK_DSMV"),
new System.Data.Common.DataColumnMapping("CONCAT_DSMV", "CONCAT_DSMV"),
new System.Data.Common.DataColumnMapping("DE_DSMV", "DE_DSMV")
})
});
#endregion
#region sqlSelectCommand2
this.sqlSelectCommand2.CommandText = "[SPR_LKP_PERFIL]";
this.sqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand2.Connection = this.cnn;
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
#endregion
#region dsPerfil
this.dsPerfil.DataSetName = "dsPerfil";
this.dsPerfil.Locale = new System.Globalization.CultureInfo("en-US");
((System.ComponentModel.ISupportInitialize)(this.dsPerfil)).EndInit();
#endregion
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (this.Session["dsSeguridad"] == null)
{
this.Response.Redirect("~/Error.aspx?errMsg=sesion");
return;
}
if (!this.IsPostBack)
{
if (this.Request.QueryString["txtDescripcion"] != null && this.Request.QueryString["txtDescripcionHidden"] != null)
{
this.txtDescripcion.Value = this.Request.QueryString["txtDescripcion"].ToString();
this.txtDescripcionHidden.Value = this.Request.QueryString["txtDescripcionHidden"].ToString();
this.tipoDescripcion.Value = this.Request.QueryString["tipoDescripcion"].ToString();
ClinHD.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVClinPrim";
ClinTxt1.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_txtDSMVClinSec";
ClinHD1.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVClinSec";
ClinTxt2.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_txtDSMVClinTer";
ClinHD2.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVClinTer";
RMHD.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVRMPrim";
RMTxt1.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_txtDSMVRMSec";
RMHD1.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVRMSec";
RMTxt2.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_txtDSMVRMTer";
RMHD2.Value = "mainBodyContent_" + this.Request.QueryString["tipoDescripcion"].ToString() + "_hDSMVRMTer";
/*if(this.txtDescripcion.Value== "mainBodyContent_WucEpisodioAdmision_txtDSMVClinSec")
* {
* ClinHD.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVClinPrim";
* ClinTxt2.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVClinTer";
* ClinHD2.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVClinTer";
* }
* else if(this.txtDescripcion.Value == "mainBodyContent_WucEpisodioAdmision_txtDSMVClinPrim")
* {
* ClinTxt1.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVClinSec";
* ClinHD1.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVClinSec";
*
* ClinTxt2.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVClinTer";
* ClinHD2.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVClinTer";
* }
*
* if (this.txtDescripcion.Value == "mainBodyContent_WucEpisodioAdmision_txtDSMVRMSec")
* {
* RMTxt2.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVRMTer";
* RMHD2.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVRMTer";
* }
* else if (this.txtDescripcion.Value == "mainBodyContent_WucEpisodioAdmision_txtDSMVRMPrim")
* {
* RMTxt1.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVRMSec";
* RMHD1.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVClinSec";
*
* RMTxt2.Value = "mainBodyContent_WucEpisodioAdmision_txtDSMVRMTer";
* RMHD2.Value = "mainBodyContent_WucEpisodioAdmision_hDSMVRMTer";
* }*/
}
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.DataBind();
}
else
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
//ddlResidencia.DataBind();
if (!this.IsPostBack)
{
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.dvwFemina.Table = this.dsPerfil.SA_LKP_FEMINA;
this.dvwIngresoFamiliar.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
this.dvwIngresoIndividual.Table = this.dsPerfil.SA_LKP_INGRESO_ANUAL;
this.dvwFuerzaLaboral.Table = this.dsPerfil.SA_LKP_TEDS_NO_FUERZA_LABORAL;
this.dvwUltGrado.Table = this.dsPerfil.SA_LKP_TEDS_GRADO;
this.dvwResidencia.Table = this.dsPerfil.SA_LKP_TEDS_RESIDENCIA;
if (this.Session["pk_administracion"].ToString() == "1")//Niños y adolecentes
{
this.dvwFuerzaLaboral.RowFilter = "PK_NoFuerzaLaboral <> 9";
this.dvwUltGrado.RowFilter = "(PK_grado <> 22) AND (PK_grado <> 23) AND (PK_grado <> 24) AND (PK_grado <> 25)";
}
if (this.dsPerfil.SA_PERSONA[0]["FK_Sexo"].ToString() == "2" || this.dsPerfil.SA_PERSONA[0]["FK_Sexo"].ToString() == "4") //Femenino o transgenero m->f
{
this.dvwFemina.RowFilter = "PK_Femina <> 99";
}
//if (this.Session["co_tipo"].ToString() == "1")
//{
// this.dvwResidencia.RowFilter = "PK_Residencia IN (0,1,2,3,4,7,8,11,13,14,97)";
//}
this.DataBind();
load();
if (this.m_frmAction == frmAction.Create || this.m_frmAction == frmAction.Update)
{
this.EditarRegistro();
if (this.m_frmAction == frmAction.Update)
{
this.ActualizarCampos();
}
}
else
{
this.LeerRegistro();
}
}
//else
//{
// string CtrlID = string.Empty;
// if (Request.Form["__EVENTTARGET"] != null &&
// Request.Form["__EVENTTARGET"] != string.Empty)
// {
// CtrlID = Request.Form["__EVENTTARGET"];
// Response.Write("<script>alert('Post Demografico " + CtrlID + "');</script>");
// }
//}
}
protected void Page_Load(object sender, System.EventArgs e)
{
isAdmision = this.Session["Tipo_Perfil"].ToString() == "Admision";
isEvaluacion = this.Session["Tipo_Perfil"].ToString() == "Evaluacion";
isAlta = this.Session["Tipo_Perfil"].ToString() == "Alta";
tieneConvenio = TieneConvenio(m_PK_Programa);
this.dsPerfil = (ASSMCA.perfiles.dsPerfil) this.Session["dsPerfil"];
this.daPersona.SelectCommand.Parameters["@PK_Persona"].Value = this.m_pk_persona;
this.daPersona.SelectCommand.Parameters["@PK_Programa"].Value = this.m_PK_Programa;
this.daPersona.SelectCommand.Parameters["@IN_Raza"].Value = false;
this.dsPerfil.SA_PERSONA.Rows.Clear();
this.daPersona.Fill(this.dsPerfil, "SA_PERSONA");
if (!this.IsPostBack)
{
if (!tieneConvenio)
{
divFechaConvenio.Visible = false;
divFechaConvenio.Disabled = true;
}
string Min, Max;
//Defecto #62
// Min = DateTime.Now.AddYears(-1).Year.ToString();
// Max = DateTime.Now.Year.ToString();
Min = "1950";
Max = DateTime.Now.AddYears(1).Year.ToString();
//Fin defecto 62
this.rvAño.MinimumValue = Min;
this.rvAño.MaximumValue = Max;
this.rvAño.ToolTip = "Escriba un año entre el " + Min + " y el " + Max + ".";
#region meses desde admision
if ((isAdmision && !(this.m_frmAction == frmAction.Create) && this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"] != null) || ((isAlta || isEvaluacion) && this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"] != null))
{
this.lblMesesDesdeAdmision.Text = monthsSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())).ToString();
this.lblMesesDesdeAdmision.Text += (monthsSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())) == 0) || (monthsSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())) > 1) ? " meses" : " mes";
this.lblMesesDesdeAdmision.ToolTip = daysSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())).ToString();
this.lblMesesDesdeAdmision.ToolTip += (daysSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())) == 0) || (daysSinceDate(DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString())) > 1) ? " días" : " día";
}
else
{
this.divMesesDesdeAdmision.Visible = false;
}
#endregion
#region latest evaluation date
if (isAlta && this.dsPerfil.SA_EPISODIO.DefaultView[0]["PK_Episodio"] != null)
{
DateTime?latestEvaluationDate = GetLatestEvaluationDate((int)this.dsPerfil.SA_EPISODIO.DefaultView[0]["PK_Episodio"]);
if (latestEvaluationDate != null)
{
hiddenFechaUltimaEvaluacion.Value = ((DateTime)latestEvaluationDate).ToShortDateString();
}
}
#endregion
switch (m_frmAction)
{
case (frmAction.Create):
if (this.dsPerfil.SA_PERSONA[0]["NR_Expediente"] == System.DBNull.Value)
{
if (!isAdmision)
{
this.divTipoDeAdmision.Visible = false;
this.ddlDía.Visible = false;
this.ddlMes.Visible = false;
this.txtAño.Visible = false;
this.rfvFechaAdmision.Enabled = false;
}
if (!UsaTipoDeAdmision(m_PK_Programa))
{
divTipoDeAdmision.Visible = false;
}
this.dataReadOnly = false;
this.lblExpediente.Visible = false;
this.txtExpediente.Visible = true;
}
if (isAlta || isEvaluacion)
{
this.lblFechaAdmision.Text = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).ToShortDateString();
Session["FechaAdmision"] = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).ToShortDateString();
this.ddlMes.Visible = false;
this.ddlDía.Visible = false;
this.txtAño.Visible = false;
this.divTipoDeAdmision.Visible = false;
this.lblFechaAdmision.Visible = true;
this.txtExpediente.Visible = false;
this.ddlFechaConvenioDía.Visible = false;
this.ddlFechaConvenioMes.Visible = false;
this.txtFechaConvenioAño.Visible = false;
this.rfvFechaAdmision.Enabled = false;
this.divFamiliaMilitar.Visible = false;
this.divMilitar.Visible = false;
}
else if (isAdmision)
{
if (!UsaTipoDeAdmision(m_PK_Programa))
{
divTipoDeAdmision.Visible = false;
}
this.ddlMes.Visible = true;
this.ddlDía.Visible = true;
this.txtAño.Visible = true;
this.lblFechaAdmision.Visible = true;
if (!(this.dsPerfil.SA_PERSONA[0]["NR_Expediente"] == System.DBNull.Value))
{
this.lblExpediente.Visible = true;
this.txtExpediente.Text = this.dsPerfil.SA_PERSONA[0]["NR_Expediente"].ToString();
this.txtExpediente.Visible = false;
}
this.set_hProgramaAdultos();
}
this.dataReadOnly = false;
break;
case (frmAction.Read):
if (!isAdmision || !UsaTipoDeAdmision(m_PK_Programa))
{
divTipoDeAdmision.Visible = false;
}
if (!isAdmision)
{
this.divFamiliaMilitar.Visible = false;
this.divMilitar.Visible = false;
}
this.dataReadOnly = true;
this.lblFechaAdmision.Visible = true;
this.lblExpediente.Visible = true;
this.txtExpediente.Visible = false;
this.ddlTipoDeAdmision.Visible = false;
this.ddlMes.Visible = false;
this.ddlDía.Visible = false;
this.txtAño.Visible = false;
this.ddlFechaConvenioDía.Visible = false;
this.ddlFechaConvenioMes.Visible = false;
this.txtFechaConvenioAño.Visible = false;
this.lblFechaAdmision.Text = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).ToShortDateString();
break;
case (frmAction.Update):
this.dataReadOnly = false;
this.txtExpediente.Visible = false;
this.ddlMes.SelectedValue = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).Month.ToString();;
this.ddlDía.SelectedValue = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).Day.ToString();;
this.txtAño.Text = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).Year.ToString();
DateTime dtnow = new DateTime();
dtnow = DateTime.Now;
DateTime dt = FE_Episodio;
TimeSpan diffResult = dtnow.Date - dt.Date;
if (isAdmision)
{
this.txtExpediente.Visible = false;
if (!UsaTipoDeAdmision(m_PK_Programa))
{
divTipoDeAdmision.Visible = false;
}
this.set_hProgramaAdultos();
if ((int)diffResult.Days >= (365 * 2))
{
this.lblFechaError.Text = "La fecha de admisión fue hace más de dos años.";
this.lblFechaError.ForeColor = Color.Blue;
}
else
{
this.lblFechaError.Text = "";
}
}
else
{
this.rfvFechaAdmision.Enabled = false;
this.lblFechaAdmision.Text = DateTime.Parse(this.dsPerfil.SA_EPISODIO.DefaultView[0]["FE_Episodio"].ToString()).ToShortDateString();
this.divTipoDeAdmision.Visible = false;
this.ddlFechaConvenioDía.Visible = false;
this.ddlFechaConvenioMes.Visible = false;
this.txtFechaConvenioAño.Visible = false;
this.ddlDía.Visible = false;
this.ddlMes.Visible = false;
this.txtAño.Visible = false;
this.divFamiliaMilitar.Visible = false;
this.divMilitar.Visible = false;
}
break;
}
ListItem li = new ListItem("", "0");
this.ddlFamiliaMilitar.Items.Insert(0, li);
try
{
this.DataBind();
}
catch { }
if (isAdmision)
{
this.ddlTipoDeAdmision.Items.Insert(0, li);
}
if (dataReadOnly)
{
this.load();
dataRead();
}
else
{
dataEdit();
this.load();
this.ddlMilitar.Items.Insert(0, li);
this.ddlGenero.Items.Insert(0, li);
}
}
}
