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