/// <summary>
/// 修改密码
/// </summary>
/// <returns>返回影响行数</returns>
public int ModifyPassword(VM_SysModifyPassword model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Declare @ID int; ");
strSql.Append("Set @ID =0; ");
strSql.Append("SELECT @ID=UserID From SysUser where LoginName =@LoginName and LoginPassword =@LoginPassword ;");
strSql.Append("if @ID >0 Begin ");
strSql.Append("Update SysUser Set LoginPassword =@NewPassword Where UserID=@ID end ;");
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.NVarChar, 50),
new SqlParameter("@LoginPassword", SqlDbType.NVarChar, 50),
new SqlParameter("@NewPassword", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = DBUtility.DESEncrypt.Encrypt(model.LoginPassword);
parameters[2].Value = DBUtility.DESEncrypt.Encrypt(model.NewPassword);
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 修改密码
/// </summary>
/// <returns>返回影响行数</returns>
public int ModifyPassword(VM_SysModifyPassword model)
{
return(dal.ModifyPassword(model));
}
