public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = "WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( SELECT * " +
"from SIT_RED_NODOESTADO NOE ORDER BY nedclave ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = "WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
"SELECT * FROM TCP_ADM_AREAHIST ) a ) SELECT* from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = "WITH Resultado AS(select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from(" +
"SELECT * from SIT_SNT_SOLICITANTETIPO order by TSLclave) a) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT megclave, megdescripcion, megmostrar from SIT_sol_modoentrega order by megclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT agndescripcion, agnfecfin, agnfecini, agnclave from SIT_ADM_AREAGESTION "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT PRCCLAVE, PRCDESCRIPCION from SIT_SOL_PROCESO order by PRCCLAVE "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT diaclave, diatipo from SIT_ADM_DIANOLABORAL "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT OCUCLAVE, OCUDESCRIPCION, OCUFECBAJA from SIT_SNT_OCUPACION order by ocuClave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " select TSO_CLATIPOSOL, TSO_DESCRIPCION from SIT_SOL_SOLICITUDTIPO order by TSO_CLATIPOSOL "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
private DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT AFDCLAVE, AFD_DESCRIPCION, AFD_FECBAJA, AFD_PREFIJO from SIT_RED_AFD "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT cfgclave, cfgclave, cfgvalor, cfgfecbaja from SIT_ADM_CONFIGURACION "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
"SELECT * from SIT_ADM_AREA AREA, SIT_ADM_AREATIPO TAREA " +
"WHERE AREA.ARACLAVE = TAREA.ATPCLAVE order by ARACLAVE ) a ) SELECT* from Resultado WHERE recid between 1 and 100 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
"SELECT PAIS.PAICLAVE, PAIS.PAIDESCRIPCION, MUN.MUNDESCRIPCION, EDO.EDOCLAVE, EDO.EDODESCRIPCION, MUN.MUNCLAVE, MUN.MUNFECBAJA" +
" FROM SIT_SNT_MUNICIPIO MUN, SIT_SNT_PAIS PAIS, SIT_SNT_ESTADO EDO WHERE PAIS.PAICLAVE = MUN.PAICLAVE " +
" AND EDO.EDOCLAVE = MUN.EDOCLAVE ORDER BY MUN.MUNCLAVE, MUN.PAICLAVE ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
"SELECT EDO.edoclave, PAIS.paiclave, EDO.edodescripcion, PAIS.paidescripcion, EDO.edofecbaja" +
" FROM SIT_SNT_ESTADO EDO, SIT_SNT_PAIS PAIS" +
" WHERE EDO.PAICLAVE = PAIS.paiclave ORDER BY PAIS.paiclave, EDO.edoclave ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT docClave, docFecha, docFolio, docNombre, doctamaño, docruta, extClave, "
+ " docfilesystem, docurl, docMD5 "
+ " from SIT_DOC_DOCUMENTO order by docClave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT modclave, modpadre, modconsecutivo, modDescripcion, modcontrol, modmetodo, modfecbaja "
+ " from SIT_ADM_KMODULO "
+ " order by modclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
/*INICIO*/
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT metclave, METDESCRIPCION, METFECBAJA "
+ " from SIT_SOL_MEDIOENTRADA "
+ " order by metclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT extclave, extterminacion, extmimetype "
+ " from SIT_DOC_EXTENSION "
+ " order by extclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT perclave, perdescripcion, persigla, permultiple, perfecbaja "
+ " from SIT_ADM_PERFIL "
+ " order by perclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = "WITH Resultado AS(select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from(" +
" SELECT u.usrclave, u.usrNOMBRE, u.usrPATERNO, u.usrMATERNO, u.usrPUESTO, u.usrCONTRASEÑA, " +
" a.ARACLAVE, u.usrCORREO, u.usrEXTENSION, USUA.UARORIGEN, u.usrFECBAJA, " +
" u.usrINTENTOS, u.usrbloquearfin, u.usrTITULO, u.usrDESIGNACION, u.usrFECMOD, u.usrAUXCORREO " +
" from SIT_ADM_USUARIO u, SIT_ADM_AREA a, SIT_ADM_USUARIOAREA USUA where USUA.ARACLAVE = a.ARACLAVE " +
" order by usrPATERNO, usrMATERNO, usrNOMBRE) a) SELECT* from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(object oDatos)
{
BasePagMdl baseMdl = (BasePagMdl)oDatos;
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT solclave, segfecini, segdiassemaforo, segsemaforocolor, segfecamp, segfecfin, segmultiple, segdiasnolab, "
+ " segfeccalculo, rtpclave, SEG_RESP_EXTERIOR, prcclave, segedoproceso, AFDCLAVE, ariclave, segultimonodo, segfecestimada "
+ " from SIT_SOL_SEGUIMIENTO order by solclave, segedoproceso "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
" SELECT UPA.USRCLAVE, UPA.araClave, usrCorreo, araDescripcion " +
" from SIT_ADM_USER_AREA UPA, SIT_ADM_USUARIO US, SIT_ADM_KAREA AR " +
" WHERE US.USRCLAVE = UPA.USRCLAVE " +
" AND AR.araClave = UPA.araClave " +
" order by usrCorreo, UPA.araClave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT PLZ.prcclave,krp_descripcion, PLZ.sotclave, tso_descripcion, pczclave, pczplazo, pczverde, pczamarillo "
+ " FROM SIT_SOL_PROCESOPLAZOS PLZ, SIT_SOL_PROCESO PRC, SIT_SOL_SOLICITUDTIPO TSOL "
+ " WHERE PRC.prcclave = PLZ.prcclave "
+ " AND TSOL.sotclave = PLZ.sotclave "
+ " ORDER BY prcclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));;
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT UP.PERCLAVE, UP.USRCLAVE, USRNOMBRE, USRPATERNO, USRMATERNO "
+ " FROM SIT_ADM_USRPERFIL UP, SIT_ADM_USUARIO U, SIT_ADM_PERFIL P "
+ " WHERE U.USRCLAVE = UP.USRCLAVE AND P.PERCLAVE = UP.PERCLAVE "
+ " AND usrfecbaja is null "
+ " ORDER BY USRCLAVE, PERCLAVE "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ "SELECT solclave, solclave, solfecrec, solotromod, solarcdes, "
+ " soldes, soldat, solfecsol, solfecent, solfecenv, "
+ " solfecresp, afdDataMdl.solicitud.solotroderacc = regArchivoSol.us_otroderechoacceso;, metclave, solrespclave, solmotdesecha, "
+ " solnotificado, sotclave, sntclave, US_UNIENL, IDFORMAENTREGA, megclave, "
+ " KRT_CLATEMA, solfecacl, prcclave, solfecrecrev "
+ " from SIT_SOL_SOLICITUD ORDER BY prcclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT solclave, NOD.prcclave, KRP_DESCRIPCION, NOD.KA_CLAAREA, KA_DESCRIPCION, nodclave, nodfeccreacion, "
+ " NOE.nedclave, KNE_DESCRIPCION, nodatendido, nodcapa, nod_holgura, nod_tip, nod_til, nod_ttp, nod_ttl "
+ " from SIT_RED_NODO NOD, SIT_ADM_KAREA AREA, SIT_RED_NODOESTADO NOE, SIT_SOL_PROCESO PRC "
+ " WHERE AREA.KA_CLAAREA = NOD.KA_CLAAREA "
+ " AND NOE.nedclave = NOD.nedclave "
+ " AND PRC.prcclave = NOD.prcclave "
+ " ORDER BY solclave, nodclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT sntRFC, sntApePat, sntApeMat, sntNombre, sntcurp, sntCalle, "
+ " sntNumExt, sntNumInt, sntCol, sntCodPos, sntTel, sntCorEle, sntedoext, sntciudadext, "
+ " sntSexo, sntfecnac, sntusuario, PAIS.paiclave, paiDescripcion, "
+ " SNT.edoclave, edodescripcion, SNT.munclave, mundescripcion, sntrepleg, "
+ " sntniveduc, sntotraocup, sntotroniveledu, SNT.tslclave, tsldescripcion, SNT.ocuClave, ocudescripcion "
+ " FROM SIT_SNT_SOLICITANTE SNT, SIT_SNT_MUNICIPIO MUN, SIT_SNT_PAIS PAIS, SIT_SNT_ESTADO EDO, "
+ " SIT_SNT_OCUPACION OCU, SIT_SNT_SOLICITANTETIPO TSNT "
+ " WHERE PAIS.paiclave = SNT.paiclave AND EDO.edoclave = SNT.edoclave"
+ " AND MUN.munclave = SNT.munclave AND OCU.ocuClave = SNT.ocuClave"
+ " AND TSNT.tslclave = SNT.tslclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( " +
" select ARI.solclave, ARI.ariclave, USU.usrClave, USU.usrNOMBRE || ' ' || USU.usrpaterno || ' ' || USU.usrmaterno as KU_USUARIO, " +
" ARI.nodorigen, AORI.ARHDESCRIPCION as ORIGEN, ARI.rtpclave, TARI.rtpdescripcion, ARI.noddestino, ADES.ARHDESCRIPCION as DESTINO, " +
"AORI.ARHFECINI, AORI.ARHFECFIN, ARI.aridiaslab, DES.NODFECLECTURA, ARI.aridiasnat, ARI.arihito " +
"from SIT_RED_ARISTA ARI, SIT_RESP_TIPO TARI, SIT_RED_NODO ORI, SIT_RED_NODO DES, SIT_adm_areahist AORI, SIT_adm_areahist ADES, SIT_ADM_USUARIO USU " +
"WHERE TARI.rtpclave = ARI.rtpclave " +
"AND ORI.nodclave = nodorigen " +
"AND DES.nodclave = noddestino " +
"AND AORI.ARACLAVE = ORI.ARACLAVE " +
"AND ADES.ARACLAVE = Des.ARACLAVE " +
"AND USU.usrClave = ORI.usrClave " +
"ORDER BY ARI.solclave, ARI.ariclave " +
") a ) SELECT* from Resultado WHERE recid between :P0 and :P1 ";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}
public DataTable dmlSelectGrid(BasePagMdl baseMdl)
{
String sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.* from ( "
+ " SELECT AFDCLAVE, AFFORIGEN, PORI.KP_DESCRIPCION AS ORIGENAREA, ORI.KNE_DESCRIPCION AS ORIGENACCION, ARI.rtpclave, rtpdescripcion, "
+ " affdestino, PDES.KP_DESCRIPCION as DESTAREA, DES.KNE_DESCRIPCION as DESTACCION, affplazo "
+ " FROM SIT_RED_AFDFLUJO FLU, SIT_RESP_TIPO ARI, SIT_RED_NODOESTADO ORI, SIT_RED_NODOESTADO DES, "
+ " SIT_ADM_PERFIL PORI, SIT_ADM_PERFIL PDES "
+ " WHERE ARI.rtpclave = FLU.rtpclave "
+ " AND ORI.nedclave = AFFORIGEN "
+ " AND DES.nedclave = affdestino "
+ " AND PORI.KP_CLAPERFIL = ORI.KP_CLAPERFIL "
+ " AND PDES.KP_CLAPERFIL = DES.KP_CLAPERFIL "
+ " ORDER BY ORI.KP_CLAPERFIL, ORI.KNE_DESCRIPCION, rtpclave "
+ " ) a ) SELECT * from Resultado WHERE recid between :P0 and :P1 ";
sqlQuery = " WITH Resultado AS( select COUNT(*) OVER() RESULT_COUNT, rownum recid, a.*from( SELECT AFDCLAVE, AFFORIGEN, PORI.PERDESCRIPCION AS ORIGENAREA, ORI.NEDDESCRIPCION AS ORIGENACCION, ARI.rtpclave, rtpdescripcion, affdestino, PDES.PERDESCRIPCION as DESTAREA, DES.NEDDESCRIPCION as DESTACCION, RTPPLAZO FROM SIT_RED_AFDFLUJO FLU, SIT_RESP_TIPO ARI, SIT_RED_NODOESTADO ORI, SIT_RED_NODOESTADO DES, SIT_ADM_PERFIL PORI, SIT_ADM_PERFIL PDES WHERE ARI.rtpclave = FLU.rtpclave AND ORI.nedclave = AFFORIGEN AND DES.nedclave = affdestino AND PDES.PERCLAVE = DES.NEDCLAVE ORDER BY PDES.PERCLAVE, ORI.NEDDESCRIPCION, rtpclave) a ) SELECT* from Resultado WHERE recid between :P0 and :P1";
return((DataTable)ConsultaDML(sqlQuery, baseMdl.LimInf, baseMdl.LimSup));
}