public FileTypeDST Fill() { StringBuilder sql = new StringBuilder(); sql.Append("SELECT "); sql.Append("FILETYPE_ID Filetype_Id, "); sql.Append("FILETYPE_NAME Filetype_Name, "); sql.Append("FILETYPE_DESCRIPTION Filetype_Description, "); sql.Append("FILETYPE_TYPES Filetype_Type, "); sql.Append("FILETYPE_FLOW Filetype_Flow, "); sql.Append("FILETYPE_CATEGORY Filetype_Category "); sql.Append(" FROM "); sql.Append("EF_FILETYPE "); sql.Append(" ORDER BY FILETYPE_ID ASC "); DBCommandWrapper dbCommandWrapper = BaseDatos.GetSqlStringCommandWrapper(sql.ToString()); FileTypeDST dsFileType = new FileTypeDST(); BaseDatos.LoadDataSet(dbCommandWrapper, dsFileType, "EF_FILETYPE"); return(dsFileType); }
public int Update(FileTypeDST dsFileType, IDbTransaction trans) { #region comando insert string sql = "INSERT INTO "; sql += "EF_FILETYPE "; sql += "("; sql += BaseDatos.ConfigurationName == Constantes.BDDORACLE ? "FILETYPE_ID, " : ""; //SOLO ORACLE sql += "FILETYPE_NAME, FILETYPE_DESCRIPTION, FILETYPE_TYPES, " + "FILETYPE_FLOW, FILETYPE_CATEGORY ) " + " VALUES( "; sql += BaseDatos.ConfigurationName == Constantes.BDDORACLE ? "FILETYPE_ID.NEXTVAL, " : ""; //SOLO ORACLE sql += " @Nombre, @Cedula, " + "@Telefono, @Edad )"; DBCommandWrapper insertCommand = BaseDatos.GetSqlStringCommandWrapper(sql); insertCommand.AddInParameter( "@Filetype_Name", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_NAMEColumn, DataRowVersion.Current); insertCommand.AddInParameter( "@Filetype_Description", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_DESCRIPTIONColumn, DataRowVersion.Current); insertCommand.AddInParameter( "@Filetype_Types", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_TYPESColumn, DataRowVersion.Current); insertCommand.AddInParameter( "@Filetype_Flow", DbType.Int32, dsFileType.EF_FILETYPE.FILETYPE_FLOWColumn, DataRowVersion.Current); insertCommand.AddInParameter( "@Filetype_Category", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_CATEGORYColumn, DataRowVersion.Current); #endregion #region sentencia update sql = "UPDATE "; sql += "EF_FILETYPE "; sql += "SET "; sql += " FILETYPE_NAME = @Filetype_Name," + " FILETYPE_DESCRIPTION = @Filetype_Description, " + " FILETYPE_TYPES = @Filetype_Types, " + " FILETYPE_FLOW = @Filetype_Flow, " + " FILETYPE_CATEGORY = @Filetype_Category " + " WHERE " + " FILETYPE_ID = @Filetype_idOriginal "; DBCommandWrapper updateCommand = BaseDatos.GetSqlStringCommandWrapper(sql); #endregion #region parametros del update updateCommand.AddInParameter( "@Filetype_idOriginal ", DbType.Int32, dsFileType.EF_FILETYPE.FILETYPE_IDColumn, DataRowVersion.Original); updateCommand.AddInParameter( "@Filetype_Name", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_NAMEColumn, DataRowVersion.Current); updateCommand.AddInParameter( "@Filetype_Description", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_DESCRIPTIONColumn, DataRowVersion.Current); updateCommand.AddInParameter( "@Filetype_Types", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_TYPESColumn, DataRowVersion.Current); updateCommand.AddInParameter( "@Filetype_Flow", DbType.Int32, dsFileType.EF_FILETYPE.FILETYPE_FLOWColumn, DataRowVersion.Current); updateCommand.AddInParameter( "@Filetype_Category", DbType.AnsiStringFixedLength, dsFileType.EF_FILETYPE.FILETYPE_CATEGORYColumn, DataRowVersion.Current); DBCommandWrapper deleteCommand = null; #endregion #region sql del Delete sql = "DELETE FROM "; sql += "EF_FILETYPE "; sql += "WHERE "; sql += " FILETYPE_ID = @Filetype_idOriginal "; deleteCommand = BaseDatos.GetSqlStringCommandWrapper(sql); #endregion #region parametros del delete deleteCommand.AddInParameter("@Filetype_idOriginal", DbType.Int32, dsFileType.EF_FILETYPE.FILETYPE_IDColumn, DataRowVersion.Original); #endregion if (trans == null) { return(BaseDatos.UpdateDataSet(dsFileType, "EF_FILETYPE", insertCommand, updateCommand, deleteCommand, UpdateBehavior.Standard)); } else { return(BaseDatos.UpdateDataSet(dsFileType, dsFileType.EF_FILETYPE.TableName, insertCommand, updateCommand, deleteCommand, trans)); } }