DA/DBMembers.cs

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

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

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

namespace DA
{
    public class DBMembers : IDisposable
    {

        string sql;
        SqlHelpers sqlh;
        DataSet ds;
        SqlDataReader dr;
        public DBMembers()
        {
            sqlh = new SqlHelpers();
        }
        public DBMembers(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }

        /// <summary>
        /// 自动产生会员 编号的方法
        /// </summary>
        /// <returns></returns>
        public string DBGetNewHY()
        {
            List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@id", SqlDbType.VarChar, 20));
            pars[0].Direction = ParameterDirection.Output;
            sql = "pro_getNewHYZD";//执行存储过程
            sqlh.NonQuery(sql, pars, CommandType.StoredProcedure);
            return pars[0].Value.ToString();//返回参数的值
        }
        /// <summary>
        ///DB   查询所有会员信息的方法
        /// </summary>
        /// <returns></returns>
          public DataSet DBMembersQueryWithTitle()
        {
            sql = "select m.mId as '会员编号' ,m.mCardNum as '会员卡号' ,m.mName as '姓名' ,m.mSex as '性别' ,mg.mgName as '会员类型' ,m.mMoney as '会员余额' ,m.mPoint as '会员积分' ,m.mLinkphone as '电话' ,m.mStartDate as '开卡日期',m.mState as '会员状态' from Members m inner join MemberGrade mg on m.mgId=mg.mgId";
            ds = sqlh.ExcuteSelect(sql, "MMG", null);
            return ds;
        }
        /// <summary>
        ///DB   查询所有会员信息的方法
        ///
        /// </summary>
        /// <returns></returns>
        public DataSet DBMembersQuery()
        {
            sql = "select m.mId,m.mCardNum,m.mName,m.mSex,mg.mgName,m.mMoney,m.mPoint,m.mBirthday,m.mLinkphone,m.mStartDate,m.mState,m.mRemark,m.mAddress1,m.mAddress2,m.mAddress3 from Members m inner join MemberGrade mg on m.mgId=mg.mgId";