BLL/BLLMemberGrade.cs

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

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

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


namespace BLL
{
    /// <summary>
    ///ＢＬＬ　　 会员类型表
    /// </summary>
   public static class BLLMemberGrade
    {
        /// <summary>
        ///DB   查询所有会员等级的方法
        /// </summary>
        /// <returns></returns>
        public static  List<CMemberGrade> BLLMemberGradeQuery()
        {
            using (DBMemberGrade dbmg = new DBMemberGrade())
            {
                return dbmg.DBMemberGradeQuery();
            }
        }

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

            using (DBMemberGrade dbmg = new DBMemberGrade())
            {
                return dbmg.DBMemberGradePoint (mgName );
            }
        }
        /// <summary>
        /// 根据会员等级查询相应的编号的方法
        /// </summary>
        /// <param name="mgName">会员等级</param>
        /// <returns></returns>
       public static int BLLMemberGradeID(string mgName)
        {

            using (DBMemberGrade dbmg = new DBMemberGrade())
            {
                return dbmg.DBMemberGradeID (mgName );
            }
        }

        /// <summary>
        /// 插入会员等级信息的方法
        /// </summary>
        /// <param name="mg"></param>
       public static void BLLMemberGradeInsert(CMemberGrade mg)