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.None:
Array.Resize(ref moParameters, moParameters.Length + 4);
break;
case WhereFilters.PrimaryKey:
strSQL = " WHERE ctbRegTipoPersona.RegTipoPersonaId = " + SysData.NumberToField(VM.RegTipoPersonaId);
break;
case WhereFilters.Grid:
break;
case WhereFilters.TipoPersonaId:
strSQL = " WHERE ctbRegTipoPersona.TipoPersonaId = " + SysData.NumberToField(VM.TipoPersonaId);
break;
case WhereFilters.GridCheck:
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE AutorizaId = " + SysData.NumberToField(VM.AutorizaId);
break;
case WhereFilters.TipoUsuarioIdAppId:
strSQL = " WHERE segAutoriza.TipoUsuarioId = " + SysData.NumberToField(VM.TipoUsuarioId) +
" AND segAutoriza.AutorizaItemId = " + SysData.NumberToField(VM.AutorizaItemId) +
" AND segAutoriza.RegistroId = " + SysData.NumberToField(VM.RegistroId);
break;
case WhereFilters.Grid:
break;
case WhereFilters.AutorizaItemSel:
strSQL = " WHERE segAutoriza.TipoUsuarioId = " + SysData.NumberToField(VM.TipoUsuarioId) +
" AND segAutoriza.AutorizaItemId = " + SysData.NumberToField(VM.AutorizaItemId);
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.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.None:
break;
case WhereFilters.PrimaryKey:
strSQL = " WHERE parMoneda.MonedaId = " + SysData.NumberToField(VM.MonedaId);
break;
case WhereFilters.MonedaDes:
strSQL = " WHERE parMoneda.MonedaDes = " + SysData.NumberToField(VM.MonedaDes);
break;
case WhereFilters.Grid:
break;
case WhereFilters.MonedaCod:
strSQL = " WHERE parMoneda.MonedaCod = " + SysData.NumberToField(VM.MonedaCod);
break;
case WhereFilters.GridCheck:
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.None:
break;
case WhereFilters.Grid:
break;
case WhereFilters.PrimaryKey:
strSQL = " WHERE parGestion.GestionId = " + SysData.NumberToField(VM.GestionId);
break;
}
return(strSQL);
}
private string WhereFilterGet()
{
string strSQL = null;
switch (mintWhereFilter)
{
case WhereFilters.PrimaryKey:
strSQL = " WHERE EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.AplicacionId:
strSQL = " WHERE parEstado.AplicacionId = " + SysData.NumberToField(VM.AplicacionId);
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 TipoUsuarioId = " + SysData.NumberToField(VM.TipoUsuarioId);
break;
case WhereFilters.EstadoId:
strSQL = " WHERE segTipoUsuario.EstadoId = " + SysData.NumberToField(VM.EstadoId);
break;
case WhereFilters.Grid:
break;
case WhereFilters.Estado:
strSQL = " WHERE TipoUsuarioId = " + SysData.NumberToField(VM.TipoUsuarioId);
break;
}
return(strSQL);
}