ZSJ_BCY_Web_DAL/MemberService.cs

（开头部分） 8KB

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

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

namespace ZSJ_BCY_Web_DAL
{
    public class MemberService
    {
        /// <summary>
        /// 带条件查询
        /// </summary>
        /// <param name="ic"></param>
        /// <returns></returns>
        public static List<Member> Select(InquireCondition ic)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(@"select m.Id,m.MemberName, 
            case m.MemberSex
            when 0 then '女'
            else '男' end as MemberSex
            ,m.MemberIntegral,m.MemberTelePhone,m.MemberTime,g.GradingName
            from Grading as g inner join  Member as m on g.Id = m.MemberLevel
            ");
            List<string> listString = new List<string>();
            List<SqlParameter> listpame = new List<SqlParameter>();

            if (!string.IsNullOrWhiteSpace(ic.MemberName))
            {
                listString.Add("m.MemberName like @MemberName ");
                listpame.Add(new SqlParameter("@MemberName", "%" + ic.MemberName + "%"));
            }
            if (!string.IsNullOrWhiteSpace(ic.MemberTelePhone))
            {
                listString.Add("m.MemberTelePhone like @MemberTelePhone ");
                listpame.Add(new SqlParameter("@MemberTelePhone", "%" + ic.MemberTelePhone + "%"));
            }


            if (ic.MemberSex > -1)
            {
                listString.Add("m.MemberSex=@MemberSex ");
                listpame.Add(new SqlParameter("@MemberSex", ic.MemberSex));
            }
            if (ic.MemberLevel > 0)
            {
                listString.Add("m.MemberLevel=@MemberLevel ");
                listpame.Add(new SqlParameter("@MemberLevel", ic.MemberLevel));
            }
            if (listpame.Count > 0)
            {
                sb.Append(" where " + string.Join(" and ", listString.ToArray()));
            }

            SqlDataReader reader = DBHelper.ExecuteReader(sb.ToString(), listpame.ToArray());
            List<Member> listmember = new List<Member>();

            while (reader.Read())
后面还有 184 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。