private void UpdateAll(Plat_util_CodeDetail entity, DbTransaction transaction) { ArgumentValidator.CheckForNullArgument(entity, "entity"); ArgumentValidator.CheckForNullArgument(transaction, "transaction"); PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail; try { Database db = GetDatabaseInstance(); DbCommand dbCommand = db.GetSqlStringCommand(Plat_util_CodeDetailDAO.SqlUpdate); db.AddInParameter(dbCommand, "@CodeDetailGuid", DbType.Guid, Plat_util_CodeDetailEntity.CodeDetailGuid); db.AddInParameter(dbCommand, "@CodeBaseCode", DbType.String, Plat_util_CodeDetailEntity.CodeBaseCode); db.AddInParameter(dbCommand, "@CodeDetailCode", DbType.String, Plat_util_CodeDetailEntity.CodeDetailCode); db.AddInParameter(dbCommand, "@CodeDetailName", DbType.String, Plat_util_CodeDetailEntity.CodeDetailName); db.AddInParameter(dbCommand, "@CodeDetailDesc", DbType.String, Plat_util_CodeDetailEntity.CodeDetailDesc); db.AddInParameter(dbCommand, "@CodeDetailValue", DbType.String, Plat_util_CodeDetailEntity.CodeDetailValue); db.AddInParameter(dbCommand, "@MySequence", DbType.Int32, Plat_util_CodeDetailEntity.MySequence); db.AddInParameter(dbCommand, "@IsDefault", DbType.Boolean, Plat_util_CodeDetailEntity.IsDefault); db.AddInParameter(dbCommand, "@IsDisplay", DbType.Boolean, Plat_util_CodeDetailEntity.IsDisplay); db.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, Plat_util_CodeDetailEntity.IsActive); int result = db.ExecuteNonQuery(dbCommand, transaction); if (result == 0) { throw new EntityNotFoundException(); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy); } }
/// <summary> /// Insert /// </summary> public Plat_util_CodeDetail Insert(Plat_util_CodeDetail entity) { ArgumentValidator.CheckForNullArgument(entity, "entity"); PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail; try { Database db = GetDatabaseInstance(); DbCommand dbCommand = db.GetSqlStringCommand(Plat_util_CodeDetailDAO.SqlInsert); db.AddInParameter(dbCommand, "@CodeDetailGuid", DbType.Guid, Plat_util_CodeDetailEntity.CodeDetailGuid); db.AddInParameter(dbCommand, "@CodeBaseCode", DbType.String, Plat_util_CodeDetailEntity.CodeBaseCode); db.AddInParameter(dbCommand, "@CodeDetailCode", DbType.String, Plat_util_CodeDetailEntity.CodeDetailCode); db.AddInParameter(dbCommand, "@CodeDetailName", DbType.String, Plat_util_CodeDetailEntity.CodeDetailName); db.AddInParameter(dbCommand, "@CodeDetailDesc", DbType.String, Plat_util_CodeDetailEntity.CodeDetailDesc); db.AddInParameter(dbCommand, "@CodeDetailValue", DbType.String, Plat_util_CodeDetailEntity.CodeDetailValue); db.AddInParameter(dbCommand, "@MySequence", DbType.Int32, Plat_util_CodeDetailEntity.MySequence); db.AddInParameter(dbCommand, "@IsDefault", DbType.Boolean, Plat_util_CodeDetailEntity.IsDefault); db.AddInParameter(dbCommand, "@IsDisplay", DbType.Boolean, Plat_util_CodeDetailEntity.IsDisplay); db.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, Plat_util_CodeDetailEntity.IsActive); int result = db.ExecuteNonQuery(dbCommand); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy); } return(Plat_util_CodeDetailEntity as Plat_util_CodeDetail); }
private void UpdateSome(Plat_util_CodeDetail entity, DbTransaction transaction) { ArgumentValidator.CheckForNullArgument(entity, "entity"); ArgumentValidator.CheckForNullArgument(transaction, "transaction"); PersistentPlat_util_CodeDetail Plat_util_CodeDetailEntity = entity as PersistentPlat_util_CodeDetail; StringBuilder sqlUpdateSome = new StringBuilder(); sqlUpdateSome.Append("UPDATE dbo.Plat_util_CodeDetail SET "); PropertyInfo[] propertyInfos = Plat_util_CodeDetailEntity.GetType().GetProperties(); Hashtable propertyValues = new System.Collections.Hashtable(); int columnCountForUpdate = 0; foreach (PropertyInfo propertyInfo in propertyInfos) { if (EntityMapping.ContainsProperty(propertyInfo.Name)) { object propertyValue = propertyInfo.GetValue(Plat_util_CodeDetailEntity, null); ORProperty property = EntityMapping[propertyInfo.Name]; if (!property.IsPrimaryKey) { if (!Plat_util_CodeDetailEntity.IsDefaultValue(propertyInfo.Name)) { propertyValues[propertyInfo.Name] = propertyValue; sqlUpdateSome.Append(" " + property.ColumnName + " = @" + property.ColumnName + ","); columnCountForUpdate++; } } else { propertyValues[propertyInfo.Name] = propertyValue; } } } if (columnCountForUpdate == 0) { return; } sqlUpdateSome.Remove(sqlUpdateSome.Length - 1, 1); sqlUpdateSome.Append(" WHERE 1 = 1 "); sqlUpdateSome.Append(" AND CodeDetailGuid = @CodeDetailGuid "); try { Database db = GetDatabaseInstance(); DbCommand dbCommand = db.GetSqlStringCommand(sqlUpdateSome.ToString()); foreach (DictionaryEntry de in propertyValues) { ORProperty property = EntityMapping[de.Key.ToString()]; db.AddInParameter(dbCommand, "@" + property.ColumnName, property.DatabaseType, de.Value); } int result = db.ExecuteNonQuery(dbCommand, transaction); if (result == 0) { throw new EntityNotFoundException(); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy); } }