示例#1
0
        /// <summary>更新会员余额。</summary>
        /// <param name="memberid">会员卡号</param>
        public void UpdateBalance(string memberid)
        {
            decimal dSumDeposit = Deposit.GetTotalMoneyForMember(memberid);
            decimal dSumPays    = Pays.GetTotalPayForMember(memberid, 1, 0, 0, 0);
            decimal dResult     = dSumDeposit - dSumPays;
            string  strSql      = "update member set mbalance=" + dResult + " where mid='" + memberid + "'";

            new SQLHelper().ExecuteSql(strSql);
        }