usermoney.cs

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

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

    public class UserMoney : IUserMoney
    {
        private static bool AddMoney(string strSql, decimal balance)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@Balance", DbType.Currency, balance);
            return (DBHelper.ExecuteNonQuerySql(strSql, cmdParams) > 0);
        }

        public bool AddMoneyForAll(decimal balance)
        {
            string strSql = "UPDATE PE_Users SET Balance = Balance + @Balance";
            return AddMoney(strSql, balance);
        }

        public bool AddMoneyForGroups(string groupId, decimal balance)
        {
            return AddMoney(string.Format("UPDATE PE_Users SET Balance = Balance + @Balance WHERE GroupId IN({0})", groupId), balance);
        }

        public bool AddMoneyForUsers(string toUserList, decimal balance)
        {
            return AddMoney(string.Format("UPDATE PE_Users SET Balance = Balance + @Balance  WHERE UserId in({0})", toUserList), balance);
        }
    }
}