public SIT_SNT_SOLICITANTE dmlSelectID(SIT_SNT_SOLICITANTE oDatos)
{
String sSQL = " SELECT * FROM SIT_SNT_SOLICITANTE WHERE sntclave = :P0 ";
return(CrearListaMDL <SIT_SNT_SOLICITANTE>(ConsultaDML(sSQL, oDatos.sntclave) as DataTable)[0]);
}
public int dmlEditar(SIT_SNT_SOLICITANTE oDatos)
{
String sSQL = " UPDATE SIT_SNT_SOLICITANTE SET paiclave = :P0, ocuclave = :P1, tslclave = :P2, sntotroniveledu = :P3, sntotraocup = :P4, sntniveduc = :P5, sntrepleg = :P6, munclave = :P7, edoclave = :P8, sntusuario = :P9, sntfecnac = :P10, sntsexo = :P11, sntciudadext = :P12, sntedoext = :P13, sntcorele = :P14, snttel = :P15, sntcodpos = :P16, sntcol = :P17, sntnumint = :P18, sntnumext = :P19, sntcalle = :P20, sntcurp = :P21, sntnombre = :P22, sntapemat = :P23, sntapepat = :P24, sntrfc = :P25 WHERE sntclave = :P26 ";
return((int)EjecutaDML(sSQL, oDatos.paiclave, oDatos.ocuclave, oDatos.tslclave, oDatos.sntotroniveledu, oDatos.sntotraocup, oDatos.sntniveduc, oDatos.sntrepleg, oDatos.munclave, oDatos.edoclave, oDatos.sntusuario, oDatos.sntfecnac, oDatos.sntsexo, oDatos.sntciudadext, oDatos.sntedoext, oDatos.sntcorele, oDatos.snttel, oDatos.sntcodpos, oDatos.sntcol, oDatos.sntnumint, oDatos.sntnumext, oDatos.sntcalle, oDatos.sntcurp, oDatos.sntnombre, oDatos.sntapemat, oDatos.sntapepat, oDatos.sntrfc, oDatos.sntclave));
}
public int dmlBorrar(SIT_SNT_SOLICITANTE oDatos)
{
String sSQL = " DELETE FROM SIT_SNT_SOLICITANTE WHERE sntclave = :P0 ";
return((int)EjecutaDML(sSQL, oDatos.sntclave));
}
public Object dmlAgregar(SIT_SNT_SOLICITANTE oDatos)
{
String sSQL = " INSERT INTO SIT_SNT_SOLICITANTE( paiclave, ocuclave, tslclave, sntotroniveledu, sntotraocup, sntniveduc, sntrepleg, munclave, edoclave, sntusuario, sntfecnac, sntsexo, sntciudadext, sntedoext, sntcorele, snttel, sntcodpos, sntcol, sntnumint, sntnumext, sntcalle, sntcurp, sntnombre, sntapemat, sntapepat, sntrfc, sntclave) VALUES ( :P0, :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19, :P20, :P21, :P22, :P23, :P24, :P25, :P26) ";
return(EjecutaDML(sSQL, oDatos.paiclave, oDatos.ocuclave, oDatos.tslclave, oDatos.sntotroniveledu, oDatos.sntotraocup, oDatos.sntniveduc, oDatos.sntrepleg, oDatos.munclave, oDatos.edoclave, oDatos.sntusuario, oDatos.sntfecnac, oDatos.sntsexo, oDatos.sntciudadext, oDatos.sntedoext, oDatos.sntcorele, oDatos.snttel, oDatos.sntcodpos, oDatos.sntcol, oDatos.sntnumint, oDatos.sntnumext, oDatos.sntcalle, oDatos.sntcurp, oDatos.sntnombre, oDatos.sntapemat, oDatos.sntapepat, oDatos.sntrfc, oDatos.sntclave));
}
