userpoint.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

namespace PowerEasy.SqlServerDal.UserManage
{
    using PowerEasy.IDal.UserManage;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Data;

    public class UserPoint : IUserPoint
    {
        private static bool AddPoint(string strSql, int userPoint)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@UserPoint", DbType.Int32, userPoint);
            return (DBHelper.ExecuteNonQuerySql(strSql, cmdParams) > 0);
        }

        public bool AddPointForAll(int userPoint)
        {
            string strSql = "UPDATE PE_Users SET UserPoint = UserPoint + @UserPoint";
            return AddPoint(strSql, userPoint);
        }

        public bool AddPointForGroups(string groupId, int userPoint)
        {
            return AddPoint(string.Format("UPDATE PE_Users SET UserPoint = UserPoint + @UserPoint WHERE GroupId IN({0})", groupId), userPoint);
        }

        public bool AddPointForUsers(string toUserList, int userPoint)
        {
            return AddPoint(string.Format("UPDATE PE_Users SET UserPoint=UserPoint+@UserPoint  WHERE UserId in({0})", toUserList), userPoint);
        }
    }
}