public List <USU_V034FAD> ListarUSU_V034FAD(int cargo, int area, int setor) { using (db = new RubiContext()) { return(db.Database.SqlQuery <USU_V034FAD>(string.Format("SELECT ROWNUM USU_V034FADID, NUMEMP,NUMCAD,NOMFUN,EMACOM,CODCAR,TITRED,USU_CODDIR,CODCCU,NOMCCU,NUMLOC,NOMLOC,USU_LD1EMP,USU_LD1TIP,USU_LD1CAD,LD1NOM,DATADM,FOTEMP,DATCAR FROM {3}.USU_V034FAD WHERE CODCAR = {0} AND CODCCU = {1} AND NUMLOC = {2}", cargo, area, setor, ConfigurationManager.AppSettings["schemaRubi"].ToString())).ToList()); } }
public List <USU_V092EST> ListarUSU_V092EST() { using (db = new RubiContext()) { //return db.Database.SqlQuery<USU_V092EST>("SELECT CAST(ROW_NUMBER() OVER (ORDER BY CODCAR,CODCCU,NUMLOC) AS INT) USU_V092ESTID,CODCAR,TITRED,CODCCU,NOMCCU,NUMLOC,NOMLOC FROM USU_V092EST").ToList(); return(db.Database.SqlQuery <USU_V092EST>(string.Format("SELECT ROWNUM USU_V092ESTID,CODCAR,TITRED,CODCCU,NOMCCU,NUMLOC,NOMLOC FROM {0}.USU_V092EST ORDER BY NOMLOC, NOMCCU, TITRED ", ConfigurationManager.AppSettings["schemaRubi"].ToString())).ToList()); } }
public USU_V034FAD ObterUSU_V034FAD(int numEmp, int numCad) { using (db = new RubiContext()) { //return db.Database.SqlQuery<USU_V034FAD>(string.Format("SELECT CAST(ROW_NUMBER() OVER (ORDER BY NUMEMP, NUMCAD) AS INT) USU_V034FADID, NUMEMP,NUMCAD,NOMFUN,EMACOM,CODCAR,TITRED,USU_CODDIR,CODCCU,NOMCCU,NUMLOC,NOMLOC,USU_LD1EMP,USU_LD1TIP,USU_LD1CAD,LD1NOM,DATADM,FOTEMP FROM USU_V034FAD WHERE NUMEMP = {0} AND NUMCAD = {1}", numEmp, numCad)).FirstOrDefault(); return(db.Database.SqlQuery <USU_V034FAD>(string.Format("SELECT ROWNUM USU_V034FADID, NUMEMP,NUMCAD,NOMFUN,EMACOM,CODCAR,TITRED,USU_CODDIR,CODCCU,NOMCCU,NUMLOC,NOMLOC,USU_LD1EMP,USU_LD1TIP,USU_LD1CAD,LD1NOM,DATADM,FOTEMP,DATCAR,DATCAR FROM {2}.USU_V034FAD WHERE NUMEMP = {0} AND NUMCAD = {1}", numEmp, numCad, ConfigurationManager.AppSettings["schemaRubi"].ToString())).FirstOrDefault()); } }
public List <USU_V034FAD> ListarUSU_V034FAD() { using (db = new RubiContext()) { //return db.Database.SqlQuery<USU_V034FAD>("SELECT CAST(ROW_NUMBER() OVER (ORDER BY NUMEMP, NUMCAD) AS INT) USU_V034FADID, NUMEMP,NUMCAD,NOMFUN,EMACOM,CODCAR,TITRED,USU_CODDIR,CODCCU,NOMCCU,NUMLOC,NOMLOC,USU_LD1EMP,USU_LD1TIP,USU_LD1CAD,LD1NOM,DATADM,FOTEMP FROM USU_V034FAD").ToList(); return(db.Database.SqlQuery <USU_V034FAD>(string.Format("SELECT ROWNUM USU_V034FADID, NUMEMP,NUMCAD,NOMFUN,EMACOM,CODCAR,TITRED,USU_CODDIR,CODCCU,NOMCCU,NUMLOC,NOMLOC,USU_LD1EMP,USU_LD1TIP,USU_LD1CAD,LD1NOM,DATADM,FOTEMP,DATCAR FROM {0}.USU_V034FAD", ConfigurationManager.AppSettings["schemaRubi"].ToString())).ToList()); } }