积分计算方法（带过期时间）

-- 获取用户积分信息 procedure SS_UserIntegral_List( v_9YOUACCOUNT varchar2, cur_Result out rc_class ) is begin open cur_Result for select d.intergral, d.collectdate, d.expdate from tgs_userintergral_detail d where lower(d.user_id)=lower(v_9YOUACCOUNT) order by d.expdate; end SS_UserIntegral_List; -- 获取用户兑换消费积分 procedure SS_UserIntergralExchange_List( v_9YOUACCOUNT varchar2, cur_Result out rc_class ) is begin open cur_Result for select * from( select v.costintegral, v.exchangetime from tgs_exchangeitem v where lower(v.you9id)=lower(v_9YOUACCOUNT) and v.status=1 union all select r.costintegral, r.exchangetime from tgs_exchangerealitem r where lower(r.you9id)=lower(v_9YOUACCOUNT) ) order by exchangetime; end SS_UserIntergralExchange_List;end SS_SITE_POINT_PACK;

 

程序代码：

// 计算积分// TGS_SITE_POINT_PACK.TGS_UserIntegral_List// TGS_SITE_POINT_PACK.TGS_UserIntergralExchange_Listprivate UserIntegral UserIntegralDS(string you9Account){decimal all = 0;List<PointChange> plist = ScoreDAL.SS_UserIntegral_List(you9Account);List<ExchangeDetails> exlist = ScoreDAL.SS_UserIntergralExchange_List(you9Account);foreach (var pc in plist){decimal lst = pc.INTERGRAL;foreach (var el in exlist){if (el.EXCHANGETIME >= pc.COLLECTDATE && el.EXCHANGETIME <= pc.EXPDATE && lst >=0){lst -= el.COSTINTEGRAL;if (lst < 0){pc.INTERGRAL = 0;el.COSTINTEGRAL = -lst;}else if (lst == 0){pc.INTERGRAL = 0;el.COSTINTEGRAL = 0;}else{pc.INTERGRAL = lst;el.COSTINTEGRAL = 0;}}}}DateTime now = DateTime.Now;foreach (var pc in plist){if (pc.EXPDATE >= now){all += pc.INTERGRAL;}}return new UserIntegral(){INTERGRAL_NOW = all,INTERGRAL_TOTAL = 0,TYPENAME = "普通用户",UKEY = 0,}; }// 获得积分日志// TGS_SITE_POINT_PACK.TGS_UserIntegralDetail_QUERY// 兑换记录// 虚拟 TGS_SITE_ITEM_PACK.TGS_ExchangeItem_Query// 实物 TGS_SITE_ITEM_PACK.TGS_ExchangeRealItem_Query