DA/DBMemberPayBills.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Common;

namespace DA
{
    public class DBMemberPayBills:IDisposable
    {
        private string sql;
        private SqlHelpers sqlh;
        private DataSet ds;
        private SqlDataReader dr;

        public DBMemberPayBills()
        {
            sqlh = new SqlHelpers();
        }

        public DBMemberPayBills(SqlHelpers helper)
        {
            sqlh = helper;
        }

        public void Dispose()
        {
            sqlh.Dispose();
        }
        /// <summary>
        /// 根据id获取单条数据
        /// </summary>
        /// <param name="id">主键id</param>
        /// <returns></returns>
        public CMemberPayBills GetById(int id)
        {
            sql = "select * from MemberPayBills where Id=" + id;
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            dr.Read();
            CMemberPayBills payBills = new CMemberPayBills();
            payBills.Id = Convert.ToInt32(dr["Id"]);
            payBills.Money = Convert.ToDecimal(dr["Money"]);
            payBills.Giving = Convert.ToDecimal(dr["Giving"]);
            payBills.CardNum = dr["CardNum"].ToString();
            payBills.UserId = Convert.ToInt32(dr["UserId"]);
            payBills.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
            return payBills;
        }
        /// <summary>
        /// 获取一个会员所有的充值信息
        /// </summary>
        /// <param name="memberId"></param>
        /// <returns></returns>
        public List<CMemberPayBills> GetListByMemberId(string memberId)
        {
            sql = "select * from MemberPayBills where CardNum="+memberId;
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            List<CMemberPayBills> res = new List<CMemberPayBills>();