// public bool UpdateById(User model, Int32 userId) { model.UserId = userId; StringBuilder strSql = new StringBuilder(); strSql.Append("update [User] set "); if (model.@Username != null) { strSql.Append("Username=@Username,"); } if (model.@PasswordHash != null) { strSql.Append("PasswordHash=@PasswordHash,"); } if (model.@Email != null) { strSql.Append("Email=@Email,"); } if (model.@PhoneNumber != null) { strSql.Append("PhoneNumber=@PhoneNumber,"); } if (model.@IsFirstTimeLogin != null) { strSql.Append("IsFirstTimeLogin=@IsFirstTimeLogin,"); } if (model.@AccessFailedCount != null) { strSql.Append("AccessFailedCount=@AccessFailedCount,"); } if (model.@CreationDate != null) { strSql.Append("CreationDate=@CreationDate,"); } if (model.@IsActive != null) { strSql.Append("IsActive=@IsActive,"); } int n = strSql.ToString().LastIndexOf(",", StringComparison.Ordinal); if (n > 0) { strSql.Remove(n, 1); } strSql.Append(" where UserId=@userId "); var flag = DbHelperSql.Update(strSql.ToString(), model); return(flag); }
// public bool UpdateById(Person model, Int32 id) { model.Id = id; StringBuilder strSql = new StringBuilder(); strSql.Append("update [Person] set "); if (model.@Username != null) { strSql.Append("username=@Username,"); } if (model.@Password != null) { strSql.Append("password=@Password,"); } if (model.@Age != null) { strSql.Append("age=@Age,"); } if (model.@RegisterDate != null) { strSql.Append("registerDate=@RegisterDate,"); } if (model.@Address != null) { strSql.Append("address=@Address,"); } int n = strSql.ToString().LastIndexOf(",", StringComparison.Ordinal); if (n > 0) { strSql.Remove(n, 1); } strSql.Append(" where id=@id "); var flag = DbHelperSql.Update(strSql.ToString(), model); return(flag); }