private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE CenCosId = " + SysData.NumberToField(VM.CenCosId);
break;
case WhereFilters.CenCosDes:
break;
case WhereFilters.Grid:
strSQL = " LEFT JOIN ctbCenCosGrupo ON ctbCenCos.CenCosGrupoId = ctbCenCosGrupo.CenCosGrupoId " +
" LEFT JOIN parEstado ON ctbCenCos.EstadoId = parEstado.EstadoId ";
break;
case WhereFilters.CenCosCod:
strSQL = " WHERE CenCosCod = " + SysData.StringToField(VM.CenCosCod);
break;
case WhereFilters.GridCheck:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE CapituloId = " + SysData.NumberToField(VM.CapituloId);
break;
case WhereFilters.CapituloDes:
break;
case WhereFilters.Grid:
break;
case WhereFilters.CapituloCod:
strSQL = " WHERE CapituloCod = " + SysData.StringToField(VM.CapituloCod);
break;
case WhereFilters.GridCheck:
break;
case WhereFilters.Grid_EstadoId:
strSQL = " WHERE ctbCapitulo.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE CenCosId = " + SysData.NumberToField(VM.CenCosId);
break;
case WhereFilters.CenCosDes:
break;
case WhereFilters.Grid:
break;
case WhereFilters.CenCosCod:
strSQL = " WHERE CenCosCod = " + SysData.StringToField(VM.CenCosCod);
break;
case WhereFilters.GridCheck:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.None:
break;
case WhereFilters.PrimaryKey:
strSQL = " WHERE ctbPlanGrupoTipoDet.PlanGrupoTipoDetId = " + SysData.NumberToField(VM.PlanGrupoTipoDetId);
break;
case WhereFilters.PlanGrupoTipoDetDes:
strSQL = " WHERE ctbPlanGrupoTipoDet.PlanGrupoTipoDetDes = " + SysData.StringToField(VM.PlanGrupoTipoDetDes);
break;
case WhereFilters.Grid:
break;
case WhereFilters.PlanGrupoTipoDetCod:
strSQL = " WHERE ctbPlanGrupoTipoDet.PlanGrupoTipoDetCod = " + SysData.StringToField(VM.PlanGrupoTipoDetCod);
break;
case WhereFilters.GridCheck:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE ModuloId = " + SysData.NumberToField(VM.ModuloId);
break;
case WhereFilters.ModuloDes:
strSQL = " WHERE segModulo.ModuloDes = " + SysData.StringToField(VM.ModuloDes);
break;
case WhereFilters.None:
strSQL = " WHERE segModulo.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.EstadoId:
strSQL = " WHERE segModulo.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.Grid:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE ctbTipoPlan.TipoPlanId = " + SysData.NumberToField(VM.TipoPlanId);
break;
case WhereFilters.TipoPlanDes:
strSQL = " WHERE ctbTipoPlan.TipoPlanDes = " + SysData.StringToField(VM.TipoPlanDes);
break;
case WhereFilters.Grid:
break;
case WhereFilters.GridCheck:
break;
case WhereFilters.EstadoId:
strSQL = " WHERE ctbTipoPlan.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.None:
break;
case WhereFilters.PrimaryKey:
strSQL = " WHERE ctbSucursal.SucursalId = " + SysData.NumberToField(VM.SucursalId);
break;
case WhereFilters.SucursalDes:
strSQL = " WHERE ctbSucursal.SucursalDes = " + SysData.StringToField(VM.SucursalDes);
break;
case WhereFilters.Grid:
break;
case WhereFilters.SucursalCod:
strSQL = " WHERE ctbSucursal.SucursalCod = " + SysData.StringToField(VM.SucursalCod);
break;
case WhereFilters.GridCheck:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE ctbPlan.PlanId = " + SysData.NumberToField(VM.PlanId);
break;
case WhereFilters.PlanDes:
strSQL = " WHERE ctbPlan.PlanDes = " + SysData.StringToField(VM.PlanDes);
break;
case WhereFilters.Grid:
break;
case WhereFilters.PlanCod:
strSQL = " WHERE ctbPlan.PlanCod = " + SysData.StringToField(VM.PlanCod);
break;
case WhereFilters.GridCheck:
break;
case WhereFilters.PlanPadreId:
strSQL = " WHERE ctbPlan.PlanPadreId = " + SysData.NumberToField(VM.PlanPadreId);
break;
case WhereFilters.EstadoId:
strSQL = " WHERE ctbPlan.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.TipoPlanId:
strSQL = " WHERE ctbPlan.TipoPlanId = " + SysData.NumberToField(VM.TipoPlanId);
break;
case WhereFilters.PlanHijoMAXorden:
strSQL = " WHERE ctbPlan.PlanPadreId = " + SysData.NumberToField(VM.PlanPadreId) +
" AND ctbPlan.EstadoId = " + SysData.NumberToField(VM.EstadoId) +
" AND ctbPlan.Orden = " +
" ( SELECT MAX(Orden) FROM ctbPlan " +
" WHERE PlanPadreId = "+ SysData.NumberToField(VM.PlanPadreId) + ")";
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE segAplicacion.AplicacionId = " + SysData.NumberToField(VM.AplicacionId);
break;
case WhereFilters.AplicacionCod:
strSQL = " WHERE AplicacionCod = " + SysData.StringToField(VM.AplicacionCod);
break;
case WhereFilters.Grid:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE parTipoPersona.TipoPersonaId = " + SysData.NumberToField(VM.TipoPersonaId);
break;
case WhereFilters.TipoPersonaCod:
strSQL = " WHERE parTipoPersona.TipoPersonaCod = " + SysData.StringToField(VM.TipoPersonaCod);
break;
case WhereFilters.EstadoId:
strSQL = " WHERE parTipoPersona.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.Grid:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE UsuarioId = " + SysData.NumberToField(VM.UsuarioId);
break;
case WhereFilters.TipoUsuarioId:
strSQL = " WHERE segUsuario.TipoUsuarioId = " + SysData.NumberToField(VM.TipoUsuarioId);
break;
case WhereFilters.UsuarioCod:
strSQL = " WHERE segUsuario.UsuarioCod = " + SysData.StringToField(VM.UsuarioCod);
break;
case WhereFilters.Grid:
break;
}
return(strSQL);
}