//
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);
}
