DAL/DALUser.cs

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

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

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

namespace DAL
{
   public class DALUser
    {

        /*绑定数据*/
       public DataSet UserBind(int a, int b, string c)
        {
            String sql = "select * from tb_Menber";
            return SQLHelper.PagedataSet(sql, a, b, c);
            
        }
       
       
       //删除用户
       public int DeleUser(CMenber menber)
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("delete from tb_Menber where MenberID = @id");
           SqlParameter[] par ={
                                    new SqlParameter ("@id",SqlDbType.Int,4)
                                };
           par[0].Value = menber.MenberId;
           return DBHelperSQL.ExecuteSql(sql.ToString(), par);
       }

       //通过昵称查询用户
       public DataSet SelMNa(int a, int b, string c,CMenber menber)
       {
           string sql = "select * from tb_Menber where UserName like '%" + menber.MRealName + "%' ";
           DataSet ds = SQLHelper.PagedataSet(sql, a, b, c);
           return ds;
       }

       //通过用户名查询用户
       public DataSet SelMID(int a, int b, string c, CMenber menber)
       {
           string sql = "select * from tb_Menber where MenberID =" + menber.MenberId;
           DataSet ds = SQLHelper.PagedataSet(sql, a, b, c);
           return ds;
       }

       //通过昵称查询是否有用户
       public int CountNa(CMenber menber)
       {
           string sql = "select count(*) from tb_Menber where UserName like '%" + menber.MRealName + "%' ";
           int result = Convert.ToInt32(DBHelperSQL.ExecuteSqlCell(sql));
           return result;
       }


       //通过用户名查询是否有用户