public int setCtpropo(int emp_codi, int rev_cont, string state) { StringBuilder sql = new StringBuilder(); DateTime date = DateTime.Now; sql.Append(" UPDATE CT_REVPR"); sql.Append(" SET REV_ESTA = @REV_ESTA,"); sql.Append(" AUD_ESTA = @AUD_ESTA, "); sql.Append(" AUD_UFAC = @AUD_UFAC, "); sql.Append(" AUD_USUA = @AUD_USUA "); sql.Append(" WHERE EMP_CODI = @EMP_CODI"); sql.Append(" AND REV_CONT = @REV_CONT"); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@REV_CONT", rev_cont)); parametros.Add(new Parameter("@AUD_ESTA", "M")); parametros.Add(new Parameter("@AUD_UFAC", date)); parametros.Add(new Parameter("@AUD_USUA", "SEVEN")); parametros.Add(new Parameter("@REV_ESTA", state)); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray())); }
public int insertCtAcxpr(int rev_cont, int pro_cont, int emp_codi) { StringBuilder sql = new StringBuilder(); DateTime date = DateTime.Now; sql.Append(" INSERT INTO CT_ACXPR(AUD_ESTA, AUD_UFAC, AUD_USUA, EMP_CODI, ARB_CONT, PRO_CONT) "); sql.Append(" SELECT @AUD_ESTA, @AUD_UFAC, @AUD_USUA, EMP_CODI, ARB_CONT, @PRO_CONT "); sql.Append(" FROM CT_REVAC "); sql.Append(" WHERE EMP_CODI = @EMP_CODI "); sql.Append(" AND REV_CONT = @REV_CONT "); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@REV_CONT", rev_cont)); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@PRO_CONT", pro_cont)); parametros.Add(new Parameter("@AUD_USUA", "SEVEN")); parametros.Add(new Parameter("@AUD_UFAC", date)); parametros.Add(new Parameter("@AUD_ESTA", "A")); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray())); }
public int UpdSoSocip(TOSoSocio toSoSocio) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE SO_SBENE "); sql.Append(" SET SBE_PASS = @P_SBE_PASS "); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI "); sql.Append(" AND SOC_CONT = @P_SOC_CONT "); sql.Append(" AND SBE_CONT = @P_SBE_CONT "); listAux.Add(new Parameter("@P_SBE_PASS", toSoSocio.Soc_pass)); listAux.Add(new Parameter("@P_EMP_CODI", toSoSocio.Emp_codi)); listAux.Add(new Parameter("@P_SOC_CONT", toSoSocio.Soc_cont)); listAux.Add(new Parameter("@P_SBE_CONT", toSoSocio.Sbe_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.Update(pTOContext, sql.ToString(), oParameter); return(objeto.AsInt()); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(-1); } }
public int setCtRevdo(int emp_codi, int rev_cont, int doc_cont, bool chkApro) { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE CT_REVDO"); sql.Append(" SET REV_APRO = @REV_APRO"); sql.Append(" WHERE EMP_CODI = @EMP_CODI"); sql.Append(" AND REV_CONT = @REV_CONT"); sql.Append(" AND DOC_CONT = @DOC_CONT"); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@REV_CONT", rev_cont)); parametros.Add(new Parameter("@DOC_CONT", doc_cont)); if (chkApro) { parametros.Add(new Parameter("@REV_APRO", "S")); } else { parametros.Add(new Parameter("@REV_APRO", "N")); } OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray())); }
public List <PqInpqr> getPqInPqrEncuestas(int inp_cont, int emp_codi = 0) { StringBuilder sql = new StringBuilder(); List <Parameter> parameters = new List <Parameter>(); sql.Append(" SELECT case when ISNUMERIC(PQ_INPQR.INP_TIDO) = 1 then GN_TIPDO.TIP_NOMB else GN_TIPDO2.TIP_NOMB end INP_TIDO, "); sql.Append(" PQ_INPQR.*, '' DIG_VALO "); sql.Append(" FROM PQ_INPQR "); sql.Append(" left join GN_TIPDO on convert(varchar, GN_TIPDO.TIP_CODI) = PQ_INPQR.INP_TIDO "); sql.Append(" left join GN_TIPDO GN_TIPDO2 on convert(varchar, GN_TIPDO2.TIP_ABRE) = PQ_INPQR.INP_TIDO "); sql.Append(" WHERE INP_CONT = @INP_CONT "); if (emp_codi > 0) { sql.Append(" AND EMP_CODI=@EMP_CODI"); parameters.Add(new Parameter("@EMP_CODI", emp_codi)); } parameters.Add(new Parameter("@INP_CONT", inp_cont)); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var data = conection.ReadList(pTOContext, sql.ToString(), Make, parameters.ToArray()); return(data); }
public int GetInfoValidEnc(string cli_coda, int ite_serv, int emp_codi, string redEnc) { StringBuilder sql = new StringBuilder(); List <Parameter> parametros = new List <Parameter>(); sql.Append(" SELECT REM_CONT "); sql.Append(" FROM EE_REMES "); sql.Append(" WHERE CLI_CODA = @CLI_CODA "); sql.Append(" AND ITE_SERV = @ITE_SERV "); sql.Append(" AND EMP_CODI = @EMP_CODI "); sql.Append(" AND REM_CONT "); sql.Append(" IN ( "); sql.Append(" SELECT REM_CONT FROM EE_RESEN WHERE EMP_CODI = @EMP_CODI "); sql.Append(" UNION "); sql.Append(" SELECT REM_CONT FROM EE_RESEM WHERE EMP_CODI = @EMP_CODI "); sql.Append(" ) "); if (redEnc == "N") { sql.Append(" AND CONVERT(VARCHAR,REM_FECH,103) = CONVERT(VARCHAR,GETDATE(),103) "); } parametros.Add(new Parameter("@CLI_CODA", cli_coda)); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@ITE_SERV", ite_serv)); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var result = conection.GetScalar(pTOContext, sql.ToString(), parametros.ToArray()); if (result == null) { return(0); } return(result.AsInt()); }
public List <TOPqInpqr> GetPqInpqr(short emp_codi, int soc_cont, int sbe_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT INP_CONT, INP_ESTA, INP_MPQR, INP_FEVE "); sql.Append(" FROM PQ_INPQR "); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI "); sql.Append(" AND SOC_CONT = @P_SOC_CONT "); sql.Append(" AND SBE_CONT = @P_SBE_CONT "); sql.Append(" AND SBE_CONT = @P_SBE_CONT "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); listAux.Add(new Parameter("@P_SOC_CONT", soc_cont)); listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
internal List <Models.TOAeOsApp> GetAeOsApp(short emp_codi) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine(" SELECT CONVERT(VARBINARY (MAX), AE_OSAPP.OSA_BMPR) AS OSA_IMAGE, * FROM AE_OSAPP"); sql.AppendLine(" WHERE EMP_CODI = @P_EMP_CODI "); //sql.AppendLine(" AND AUD_ESTA = 'A' "); sql.AppendLine(" AND OSA_MAPP = 'S' "); Parameter[] oParameter = new Parameter[] { new Parameter("P_EMP_CODI", emp_codi) }; OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); return(conection.ReadList(pTOContext, sql.ToString(), Make, oParameter)); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public bool SEBOEsVendedorCmVende(string pUsuario) { try { StringBuilder builder = new StringBuilder(); builder.AppendLine("SELECT * FROM CA_VENDE WHERE VEN_ESTA = 'A' AND USU_CODI = @Usuario "); Parameter[] oParameter = new Parameter[] { new Parameter("Usuario", pUsuario) }; OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); DataSet objeto = conection.GetDataSet(pTOContext, builder.ToString(), oParameter); if (objeto == null || objeto.Tables.Count == 0) { return(false); } return(true); } catch (Exception) { return(false); } }
public TOGnTerce GetGnTerce(short emp_codi, int ter_codi) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT CONVERT(VARBINARY(MAX), GN_TERCE.TER_FOTO) TER_FOTO,TER_NOCO,TER_CODI "); sql.Append(" FROM GN_TERCE WHERE TER_CODI = @TER_CODI AND EMP_CODI = @EMP_CODI "); listAux.Add(new Parameter("@EMP_CODI", emp_codi)); listAux.Add(new Parameter("@TER_CODI", ter_codi)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.Read(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
internal TOAeClase GetAeClaseByClaCont(int emp_codi, int cla_cont) { try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT EMP_CODI,CLA_CONT,CLA_CODI,CLA_NOMB,CLA_CLTI,AUD_ESTA,AUD_UFAC,CLA_TICA,CLA_DESC, "); sql.Append(" AUD_USUA, LIP_CONT, LIP_CONB, CLA_FOTO, CLA_FCHR "); sql.Append(" FROM AE_CLASE"); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI"); sql.Append(" AND CLA_CONT = @P_CLA_CONT"); Parameter[] listAux = { new Parameter("@P_EMP_CODI", emp_codi), new Parameter("@P_CLA_CONT", cla_cont), }; OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.Read(pTOContext, sql.ToString(), Make, listAux); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public int insertDAOPqEncue(PQEncue encue) { StringBuilder sql = new StringBuilder(); sql.Append("INSERT INTO PQ_ENCUE "); sql.Append("(EMP_CODI,AUD_ESTA, AUD_UFAC,AUD_USUA,ENC_CONT,INP_CONT,TIP_CODI,ENC_DOCU,ENC_NOMB,ENC_APEL,ENC_PREG, "); sql.Append("ENC_RESP,ENC_FECH )VALUES "); sql.Append("(@EMP_CODI,@AUD_ESTA,@AUD_UFAC, @AUD_USUA, @ENC_CONT,@INP_CONT,@TIP_CODI,@ENC_DOCU,@ENC_NOMB, @ENC_APEL, "); sql.Append(" @ENC_PREG,@ENC_RESP, @ENC_FECH) "); OTOContext ptoContext = new OTOContext(); List <Parameter> parameters = new List <Parameter>(); parameters.Add(new Parameter("@EMP_CODI", encue.emp_codi)); parameters.Add(new Parameter("@AUD_ESTA", "A")); parameters.Add(new Parameter("@AUD_UFAC", DateTime.Now)); parameters.Add(new Parameter("@AUD_USUA", "seven")); parameters.Add(new Parameter("@ENC_CONT", encue.enc_cont)); parameters.Add(new Parameter("@INP_CONT", encue.inp_cont)); parameters.Add(new Parameter("@TIP_CODI", encue.tip_codi)); parameters.Add(new Parameter("@ENC_DOCU", encue.enc_docu)); parameters.Add(new Parameter("@ENC_NOMB", encue.enc_nomb)); parameters.Add(new Parameter("@ENC_APEL", encue.enc_apel)); parameters.Add(new Parameter("@ENC_PREG", encue.enc_preg)); parameters.Add(new Parameter("@ENC_RESP", encue.enc_resp)); parameters.Add(new Parameter("@ENC_FECH", encue.enc_fech)); var connection = DBFactory.GetDB(ptoContext); int result = connection.Insert(ptoContext, sql.ToString(), parameters.ToArray()); return(result); }
public List <TOGnArbol> GetGnArbol(short emp_codi, short tar_codi) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT EMP_CODI, ARB_CONT, ARB_CODI, ARB_NOMB "); sql.Append(" FROM GN_ARBOL "); sql.Append(" WHERE TAR_CODI = @P_TAR_CODI "); sql.Append(" AND ARB_MOVI = 'S' "); sql.Append(" AND ARB_ACTI = 'A' "); sql.Append(" AND EMP_CODI = @P_EMP_CODI "); listAux.Add(new Parameter("@P_TAR_CODI", tar_codi)); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public string DAOSEConsultarAdicionales(short pEMP_CODI, int pCAS_CONT, string pSQL) { try { StringBuilder builder = new StringBuilder(); pSQL = pSQL.ToUpper().Replace(":P_EMP_CODI", pEMP_CODI.AsString()); pSQL = pSQL.ToUpper().Replace(":P_CAS_CONT", "'" + pCAS_CONT + "'"); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.GetDataSet(pTOContext, pSQL.ToString(), null); List <string> lData = new List <string>(); for (int j = 0; j < objeto.Tables[0].Rows.Count; j++) { for (int k = 0; k < objeto.Tables[0].Columns.Count; k++) { DataColumn col = objeto.Tables[0].Columns[k]; lData.Add(string.Format("{0}: {1}", col.ColumnName, objeto.Tables[0].Rows[j][k].ToString())); } } return(string.Join("<br />", lData)); } catch (Exception) { //this.BOException.Throw("KDAOGeneral", "DAOSEListaFlujos", exception); return(""); } }
internal List <WF_ACCIO> DAOSEListaAccionesdeUnaEtapa(short emp_codi, int flu_cont, short eta_cont) { try { StringBuilder builder = new StringBuilder(); builder.AppendLine(" SELECT WF_ACCIO.ACC_CONT,WF_ACCIO.ACC_NOMB,WF_ACCIO.ACC_ESTT "); builder.AppendLine(" FROM WF_ACCIO,WF_RUTAS "); builder.AppendLine(" WHERE WF_ACCIO.EMP_CODI=WF_RUTAS.EMP_CODI "); builder.AppendLine(" AND WF_ACCIO.FLU_CONT=WF_RUTAS.FLU_CONT "); builder.AppendLine(" AND WF_ACCIO.ETA_CONT=WF_RUTAS.ETA_CONT "); builder.AppendLine(" AND WF_ACCIO.ACC_CONT=WF_RUTAS.ACC_CONT "); builder.AppendLine(" AND WF_ACCIO.EMP_CODI= " + emp_codi + " "); builder.AppendLine(" AND WF_ACCIO.FLU_CONT= " + flu_cont + " "); builder.AppendLine(" AND WF_ACCIO.ETA_CONT= " + eta_cont + " "); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, builder.ToString(), MkAcc, null); return(objeto); } catch (Exception exception) { //this.BOException.Throw("KDAOGeneral", "DAOSEListaAccionesdeUnaEtapa", exception); return(null); } }
public List <TOPqDinpq> GetPqDinpqDetail(short emp_codi, int inp_cont, int din_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT DIN_CONT, DIN_SEGT, DIN_FESE "); sql.Append(" FROM PQ_DINPQ "); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI "); sql.Append(" AND INP_CONT = @P_INP_CONT "); sql.Append(" AND DIN_CONT = @P_DIN_CONT "); sql.Append(" ORDER BY DIN_CONT DESC "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); listAux.Add(new Parameter("@P_INP_CONT", inp_cont)); listAux.Add(new Parameter("@P_DIN_CONT", din_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <TOAeEspac> GetAeEspac(short emp_codi, int cla_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT EMP_CODI, ESP_CONT, ESP_CODI, ESP_NOMB, CLA_CONT, TIP_CONT, ESP_DESC, BOD_CODI, ESP_ESTA, AUD_ESTA,"); sql.Append(" AUD_UFAC, AUD_USUA, ESP_AREA, ESP_CAPA, ESP_PADR, ESP_IMAG, BOD_CONT, CAS_CONT, ESP_MDIT,ESP_IMAG FROM AE_ESPAC"); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI"); sql.Append(" AND AE_ESPAC.CLA_CONT = @P_CLA_CONT"); sql.Append(" AND AE_ESPAC.ESP_CONT > 0"); sql.Append(" AND AE_ESPAC.ESP_ESTA = 'A' "); sql.Append(" AND AE_ESPAC.ESP_MAPP = 'S' "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); listAux.Add(new Parameter("@P_CLA_CONT", cla_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <TOAeClase> GetAeClase(short emp_codi) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT EMP_CODI,CLA_CONT,CLA_CODI,CLA_NOMB,CLA_CLTI,AUD_ESTA,AUD_UFAC,CLA_TICA,"); sql.Append(" AUD_USUA, LIP_CONT, LIP_CONB, CLA_FOTO, CLA_FCHR, CLA_DESC "); sql.Append(" FROM AE_CLASE"); sql.Append(" WHERE EMP_CODI = @P_EMP_CODI"); sql.Append(" AND AE_CLASE.CLA_CODI > '0' "); sql.Append(" AND AE_CLASE.CLA_MAPP = 'S'"); sql.Append(" AND EXISTS(SELECT 1 FROM AE_ESPAC "); sql.Append(" WHERE AE_ESPAC.EMP_CODI = AE_CLASE.EMP_CODI "); sql.Append(" AND AE_ESPAC.CLA_CONT = AE_CLASE.CLA_CONT "); sql.Append(" AND AE_ESPAC.ESP_ESTA = 'A') "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <GnBarri> GetGnBarri(int pai_codi, int reg_codi, int dep_codi, int mun_codi, int loc_codi) { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT BAR_NOMB, BAR_CODI"); sql.Append(" FROM GN_BARRI WHERE PAI_CODI=@PAI_CODI "); sql.Append(" AND REG_CODI=@REG_CODI "); sql.Append(" AND DEP_CODI=@DEP_CODI "); sql.Append(" AND MUN_CODI=@MUN_CODI "); sql.Append(" AND LOC_CODI=@LOC_CODI "); sql.Append(" ORDER BY BAR_NOMB "); List <Parameter> sqlParams = new List <Parameter>(); sqlParams.Add(new Parameter("PAI_CODI", pai_codi)); sqlParams.Add(new Parameter("REG_CODI", reg_codi)); sqlParams.Add(new Parameter("DEP_CODI", dep_codi)); sqlParams.Add(new Parameter("MUN_CODI", mun_codi)); sqlParams.Add(new Parameter("LOC_CODI", loc_codi)); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); List <GnBarri> data = conection.ReadList(pTOContext, sql.ToString(), Make, sqlParams.ToArray()); return(data); }
public int updateTratamiento(Rnradtd radtd, int emp_codi, int rad_cont) { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE RN_TRARD"); sql.Append(" SET TRA_ACEP = @TRA_ACEP"); sql.Append(" WHERE EMP_CODI = @EMP_CODI"); sql.Append(" AND RAD_CONT = @RAD_CONT"); sql.Append(" AND ITE_CONT = @ITE_CONT"); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@RAD_CONT", rad_cont)); parametros.Add(new Parameter("@ITE_CONT", radtd.ite_cont)); if (radtd.ite_chkd) { parametros.Add(new Parameter("@TRA_ACEP", "S")); } else { parametros.Add(new Parameter("@TRA_ACEP", "N")); } OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); return(conection.Update(pTOContext, sql.ToString(), parametros.ToArray())); }
public List <TOGnItems> GetGnItems(int tit_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT ITE_CONT, TIT_CONT, ITE_CODI, ITE_NOMB "); sql.Append(" FROM GN_ITEMS "); sql.Append(" WHERE ITE_ACTI = 'S' "); sql.Append(" AND TIT_CONT = @P_TIT_CONT "); sql.Append(" AND ITE_CODI > '0' "); listAux.Add(new Parameter("@P_TIT_CONT", tit_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public int InseCTREVTD(myObject revtd) { DateTime date = DateTime.Now; foreach (CtRevtd item in revtd.detail) { StringBuilder sql = new StringBuilder(); sql.Append(" INSERT INTO CT_REVTD(EMP_CODI, AUD_USUA, AUD_ESTA, AUD_UFAC, ITE_CONT, REV_CONT, DTR_ACEP) "); sql.Append(" VALUES(@EMP_CODI, @AUD_USUA, @AUD_ESTA, @AUD_UFAC, @ITE_CONT, @REV_CONT, @DTR_ACEP) "); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@EMP_CODI", revtd.emp_codi)); parametros.Add(new Parameter("@AUD_USUA", "SEVEN")); parametros.Add(new Parameter("@AUD_ESTA", "A")); parametros.Add(new Parameter("@AUD_UFAC", date)); parametros.Add(new Parameter("@ITE_CONT", item.ite_cont)); parametros.Add(new Parameter("@REV_CONT", revtd.rev_cont)); if (item.ite_chkd) { parametros.Add(new Parameter("@DTR_ACEP", "S")); } else { parametros.Add(new Parameter("@DTR_ACEP", "N")); } OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); conection.Insert(pTOContext, sql.ToString(), parametros.ToArray()); } return(0); }
internal TOProducto GetProducto(short emp_codi, int pro_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT PRO_CONT, PRO_CODI, PRO_NOMB,PRO_DMIN FROM IN_PRODU"); sql.Append(" WHERE IN_PRODU.PRO_CONT = @P_PRO_CONT"); sql.Append(" AND IN_PRODU.EMP_CODI = @P_EMP_CODI"); listAux.Add(new Parameter("@P_PRO_CONT", pro_cont)); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.Read(pTOContext, sql.ToString(), MakeProducto, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <GnTipdo> getListGnTipdo() { StringBuilder sql = new StringBuilder(); sql.AppendLine(" SELECT * FROM GN_TIPDO WHERE TIP_CODI <> 0 "); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); List <GnTipdo> data = conection.ReadList(pTOContext, sql.ToString(), Make); return(data); }
public List <TOInfReser> GetInfoReservas(short emp_codi, int soc_cont, int sbe_cont) { List <Parameter> listAux = new List <Parameter>(); DateTime ahora = DateTime.Now.AddDays(-2); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT AE_CLASE.CLA_NOMB, AE_ESPAC.ESP_NOMB, AE_CLASE.CLA_TICA, "); sql.Append(" IN_PRODU.PRO_NOMB, AE_CLASE.CLA_CONT, AE_CLASE.CLA_FOTO, "); sql.Append(" AE_RESER.RES_FINI, AE_RESER.RES_FINA,"); sql.Append(" AE_RESER.RES_CONT, AE_RESER.RES_NUME, AE_RESER.RES_ESTA,AE_ESPAC.ESP_MDIT, AE_ESPAC.ESP_IMAG,AE_RESER.TER_CODI "); sql.Append(" FROM AE_ESPAC, AE_RESER, AE_CLASE, AE_DPROD, IN_PRODU"); sql.Append(" WHERE AE_ESPAC.EMP_CODI = AE_RESER.EMP_CODI"); sql.Append(" AND AE_ESPAC.ESP_CONT = AE_RESER.ESP_CONT"); sql.Append(" AND AE_ESPAC.EMP_CODI = @P_EMP_CODI"); sql.Append(" AND AE_RESER.SOC_CONT = @P_SOC_CONT"); sql.Append(" AND AE_RESER.SBE_CONT = @P_SBE_CONT"); sql.Append(" AND AE_RESER.RES_FINI > @P_RES_FINI"); //sql.Append(" AND AE_RESER.RES_ESTA IN('R', 'C', 'U', 'E')"); sql.Append(" AND AE_RESER.RES_ESTA = 'C'"); sql.Append(" AND AE_RESER.RES_TIPO = 'U'"); sql.Append(" AND AE_RESER.EMP_CODI = AE_DPROD.EMP_CODI"); sql.Append(" AND AE_RESER.RES_CONT = AE_DPROD.RES_CONT"); sql.Append(" AND AE_ESPAC.EMP_CODI = AE_CLASE.EMP_CODI"); sql.Append(" AND AE_ESPAC.CLA_CONT = AE_CLASE.CLA_CONT"); sql.Append(" AND AE_DPROD.EMP_CODI = IN_PRODU.EMP_CODI"); sql.Append(" AND AE_DPROD.PRO_CONT = IN_PRODU.PRO_CONT"); //sql.Append(" ORDER BY 7 DESC "); sql.Append(" ORDER BY AE_RESER.RES_NUME DESC "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); listAux.Add(new Parameter("@P_SOC_CONT", soc_cont)); listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont)); listAux.Add(new Parameter("@P_RES_FINI", ahora)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <TOEcEvent> GetEcEvent(short emp_codi, int soc_cont, int sbe_cont) { List <Parameter> listAux = new List <Parameter>(); try { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT EVE_ESTA, EVE_FEIN, EVE_FESA, GN_TOPER.TOP_NOMB, "); sql.Append(" EVE_VATO, EVE_NOMB, 'N' INVITADO "); sql.Append(" FROM EC_EVENT, GN_TOPER "); sql.Append(" WHERE EC_EVENT.EMP_CODI = GN_TOPER.EMP_CODI "); sql.Append(" AND EC_EVENT.TOP_CODI = GN_TOPER.TOP_CODI "); sql.Append(" AND EC_EVENT.EVE_ESTA IN('C', 'P') "); sql.Append(" AND EC_EVENT.EVE_CONT > 0 "); sql.Append(" AND EC_EVENT.EMP_CODI = @P_EMP_CODI "); sql.Append(" AND EC_EVENT.SOC_CONT = @P_SOC_CONT "); sql.Append(" AND EC_EVENT.SBE_CONT = @P_SBE_CONT "); sql.Append(" UNION ALL "); sql.Append(" SELECT EVE_ESTA, EVE_FEIN, EVE_FESA, GN_TOPER.TOP_NOMB, "); sql.Append(" EVE_VATO, EVE_NOMB, 'S' INVITADO "); sql.Append(" FROM EC_EVENT, GN_TOPER, EC_LISEV,SO_SBENE "); sql.Append(" WHERE EC_EVENT.EMP_CODI = GN_TOPER.EMP_CODI "); sql.Append(" AND EC_EVENT.TOP_CODI = GN_TOPER.TOP_CODI "); sql.Append(" AND EC_EVENT.EMP_CODI = EC_LISEV.EMP_CODI "); sql.Append(" AND EC_EVENT.EVE_CONT = EC_LISEV.EVE_CONT "); sql.Append(" AND EC_LISEV.EMP_CODI = SO_SBENE.EMP_CODI "); sql.Append(" AND EC_LISEV.DLI_IDIN = SO_SBENE.SBE_CODI "); sql.Append(" AND EC_EVENT.EVE_ESTA IN('C', 'P') "); sql.Append(" AND EC_EVENT.EVE_CONT > 0 "); sql.Append(" AND EC_EVENT.EMP_CODI = @P_EMP_CODI "); sql.Append(" AND SO_SBENE.SOC_CONT = @P_SOC_CONT "); sql.Append(" AND SO_SBENE.SBE_CONT = @P_SBE_CONT "); listAux.Add(new Parameter("@P_EMP_CODI", emp_codi)); listAux.Add(new Parameter("@P_SOC_CONT", soc_cont)); listAux.Add(new Parameter("@P_SBE_CONT", sbe_cont)); Parameter[] oParameter = listAux.ToArray(); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, oParameter); return(objeto); } catch (Exception ex) { BOException.Throw(this.GetType().ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(null); } }
public List <TOGnEmpre> ConsultarEmpresas() { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT * FROM GN_EMPRE "); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.ReadList(pTOContext, sql.ToString(), Make, null); return(objeto); }
public GnInsta GetGnInsta() { List <Parameter> parametros = new List <Parameter>(); StringBuilder sql = new StringBuilder(); sql.Append(" SELECT PAR_NMIN,PAR_NMAX,PAR_CCLN,PAR_CCLG,PAR_HOST,PAR_MAIL,PAR_PCOR,PAR_USMT,PAR_USSL,PAR_UTLS,PAR_CLMA,PAR_INFA ,PAR_ADJU"); sql.Append(" FROM GN_INSTA "); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var data = conection.Read(pTOContext, sql.ToString(), Make); return(data); }
internal FA_CLIEN DAOSEGetNombreSolicitante(short emp_codi, int cas_cont) { try { StringBuilder builder = new StringBuilder(); builder.AppendLine("SELECT FA_CLIEN.CLI_NOCO AS CLI_NOCO, FA_DCLIE.DCL_NOMB AS DCL_NOMB FROM TS_ANTIC, FA_CLIEN, FA_DCLIE "); builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = FA_CLIEN.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.CLI_CODI = FA_CLIEN.CLI_CODI "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = FA_DCLIE.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.CLI_CODI = FA_DCLIE.CLI_CODI "); builder.AppendLine(" AND TS_ANTIC.DCL_CODD = FA_DCLIE.DCL_CODD "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT "); builder.AppendLine(" AND TS_ANTIC.ANT_TIPO = 'C' "); builder.AppendLine("UNION ALL "); builder.AppendLine("SELECT PO_PVDOR.PVR_NOCO AS CLI_NOCO, PO_DEPRO.DEP_NOMB AS DCL_NOMB FROM TS_ANTIC, PO_PVDOR, PO_DEPRO "); builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = PO_PVDOR.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.PVD_CODI = PO_PVDOR.PVD_CODI "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = PO_DEPRO.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.PVD_CODI = PO_DEPRO.PVD_CODI "); builder.AppendLine(" AND TS_ANTIC.DEP_CODD = PO_DEPRO.DEP_CODD "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT "); builder.AppendLine(" AND TS_ANTIC.ANT_TIPO = 'P' "); builder.AppendLine("UNION ALL "); builder.AppendLine("SELECT CR_PROSP.PRO_NOCO collate Latin1_General_Bin AS CLI_NOCO, CR_DPROS.DPR_NOMB AS DCL_NOMB FROM TS_ANTIC, CR_PROSP, CR_DPROS "); builder.AppendLine("WHERE TS_ANTIC.EMP_CODI = CR_PROSP.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.PRO_CONT = CR_PROSP.PRO_CONT "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = CR_DPROS.EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.PRO_CONT = CR_DPROS.PRO_CONT "); builder.AppendLine(" AND TS_ANTIC.DPR_CODI = CR_DPROS.DPR_CODI "); builder.AppendLine(" AND TS_ANTIC.EMP_CODI = @EMP_CODI "); builder.AppendLine(" AND TS_ANTIC.CAS_CONT = @CAS_CONT "); builder.AppendLine(" AND TS_ANTIC.ANT_TIPO <> 'C' "); builder.AppendLine(" AND TS_ANTIC.ANT_TIPO <> 'P' "); Parameter[] param = new Parameter[] { new Parameter("EMP_CODI", emp_codi), new Parameter("CAS_CONT", cas_cont) }; OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); var objeto = conection.Read(pTOContext, builder.ToString(), MkFaClien, param); return(objeto); } catch (Exception) { return(null); } }
public void deleteDocumentos(int emp_codi, int rev_cont, string tabla) { StringBuilder sql = new StringBuilder(); sql.Append("DELETE FROM " + tabla + " WHERE EMP_CODI = @EMP_CODI AND REV_CONT= @REV_CONT "); List <Parameter> parametros = new List <Parameter>(); parametros.Add(new Parameter("@EMP_CODI", emp_codi)); parametros.Add(new Parameter("@REV_CONT", rev_cont)); OTOContext pTOContext = new OTOContext(); var conection = DBFactory.GetDB(pTOContext); conection.Delete(pTOContext, sql.ToString(), parametros.ToArray()); }