BLL/BLLMembers.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
using DA;
namespace BLL
{
    /// <summary>
    /// 会员表
    /// </summary>
    public static class BLLMembers
    {
        /// <summary>
        /// 自动产生会员编号
        /// </summary>
        /// <returns></returns>
        public static string BLLGetNewHY()
        {
            using (DBMembers m = new DBMembers())
            {
                return m.DBGetNewHY();
            }
        }
        /// <summary>
        /// BLL   查询所有会员信息
        /// </summary>
        /// <returns></returns>
        public static DataSet BLLMembersQueryWithTitle()
        {
            using (DBMembers dm = new DBMembers())
            {
                return dm.DBMembersQueryWithTitle();
            }
        }
        /// <summary>
        /// BLL   查询所有会员信息
        /// </summary>
        /// <returns></returns>

        /// <summary>
        /// BLL   查询所有会员信息
        /// </summary>
        /// <returns></returns>
        public static DataSet BLLMembersQuery()
        {
            using (DBMembers dm = new DBMembers())
            {
                return dm.DBMembersQuery();
            }
        }

        
       /// <summary>
       /// BLL   根据拼音缩写查询会员的业务
       /// </summary>
       /// <param name="spell">拼音缩写</param>
       /// <returns></returns>
        public static List<CMembers> BLLMembersQueryMsSpell(string spell)