DAL/DalBonusPoints.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using MODEL;
namespace DAL
{
    public class DalBonusPoints
    {
        /// <summary>
        /// 增加积分
        /// </summary>
        /// <returns></returns>
        public static Boolean AddBonusPoints(ModelBonusPoints model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "insert into mis_bp(MID,BP,FLAG,CREATER) values('"+model.MID+"','"+model.BP+"','"+model.FLAG+"','"+model.CREATER+"')");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 回去积分信息
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static IList<ModelBonusPoints> GetList(ModelBonusPoints model)
        {
            IList<ModelBonusPoints> list = new List<ModelBonusPoints>();
            DataTable dt = Dal.SqlHelpers.ExecuteGetDataTable(CommandType.Text,"select * from mis_bp where mid='"+model.MID+"'");
            foreach (DataRow dr in dt.Rows)
            {
                ModelBonusPoints models = new ModelBonusPoints();
                models.BID=int.Parse(dr["BID"].ToString());
                models.BP = int.Parse(dr["BP"].ToString());
                models.MID =int.Parse(dr["MID"].ToString());
                model.CREATE_DATE = DateTime.Parse(dr["CREATE_DATE"].ToString());
                list.Add(models);
            }
            return list;
        }
        /// <summary>
        /// 剩余积分
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static int GetBp(ModelBonusPoints model)
        {
            int bp=0;
            SqlDataReader reader = Dal.SqlHelpers.ExecuteGetReader(CommandType.Text,"select sum(bp) bp from mis_bp where mid='"+model.MID+"'");
            if (reader.Read())
            {
                bp = int.Parse(reader["BP"].ToString());
                return bp;