DA/DBMemberGrade.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DA
{
    /// <summary>
    /// DB　　 会员类型表
    /// </summary>
   public class DBMemberGrade: IDisposable 
    {
         string sql;
        SqlHelpers sqlh;
      
        SqlDataReader dr;
        public DBMemberGrade()
        {
            sqlh = new SqlHelpers();
        }
       public DBMemberGrade(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }

       /// <summary>
        ///DB   查询所有会员等级的方法
       /// </summary>
       /// <returns></returns>
        public List<CMemberGrade> DBMemberGradeQuery()
        {
            List<CMemberGrade> lmg = new List<CMemberGrade>();
            sql = "select * from MemberGrade";
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            while (dr.Read())
            {
                CMemberGrade mg = new CMemberGrade();
                mg.CmgId1  = Convert.ToInt32(dr["mgId"]);
                mg.CmgName1  = dr["mgName"].ToString();
                mg.CmgStartPoint1  = Convert.ToInt32(dr["mgStartPoint"]);
                mg.CmgDiscount1  = Convert.ToSingle(dr["mgDiscount"]);
                lmg.Add(mg);
            }
            dr.Close();
            return lmg;
        }

        /// <summary>
        ///DB   根据会员的等级查询相应的初始积分的方法
        /// </summary>
        /// <param name="mgName">会员等级</param>
        /// <returns></returns>
       public int DBMemberGradePoint(string mgName)
        {
            List<SqlParameter> pars = new List<SqlParameter>();