DAL/userhandle.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using BasketBallShop.Model;
using System.Data;
using System.Data.SqlClient;
using mybook.DAL;

namespace BasketBallShop.DAL
{
    public class userhandle
    {
        public DataSet GetUsers(string username, string truename, int freeze, int pageindex, int pagesize, ref int recordcount)
        {
            SQLHelper sh = new SQLHelper();
            SqlParameter[] prams = {new SqlParameter("@username",SqlDbType .VarChar ,20),
                                       new SqlParameter ("@truename",SqlDbType .VarChar,20),
                                       new SqlParameter ("@freeze",SqlDbType .Int ,4),
                                       new SqlParameter ("@pageindex",SqlDbType .Int ,4),
                                       new SqlParameter ("@pagesize",SqlDbType .Int ,4),
                                       new SqlParameter ("@recordcount",SqlDbType .Int ,4)
                                   };
            
            prams[0].Value = username;
            prams[1].Value = truename;
            prams[2].Value = freeze;
            prams[3].Value = pageindex;
            prams[4].Value = pagesize;
            prams[5].Direction = ParameterDirection.Output;
            DataSet ds = sh.ExecuteDataSet("uspGetUsers", prams);
            recordcount = int.Parse(prams[5].Value.ToString());
            return ds;
        }

        public bool FreezeUser(int cid, int freeze)
        {
            SQLHelper sh = new SQLHelper();
            SqlParameter[] prams = {new SqlParameter ("@cid",SqlDbType .Int,4),
                                   new SqlParameter ("@freeze",SqlDbType .Int ,4)};
            prams[0].Value = cid;
            prams[1].Value = freeze;
            return sh.ExecuteNonQuery("uspFreezeUser", prams) == 0 ? true : false;
        }

        public Users GetUser(string cid)
        {
            SQLHelper sh = new SQLHelper();
            SqlParameter[] prams = { new SqlParameter("cid", SqlDbType.Int, 4) };
            prams[0].Value = cid;
            SqlDataReader dr = sh.ExecuteDataReader("uspGetUser", prams);
            Users u = new Users();
            if (dr.Read())
            {
                u.UserName = dr.GetString(dr.GetOrdinal("username"));
                u.Password = dr.GetString(dr.GetOrdinal("password"));
                u.TrueName = dr.GetString(dr.GetOrdinal("truename"));
                u.City = dr.GetString(dr.GetOrdinal("city"));
                u.Cardtype = dr.GetString(dr.GetOrdinal("cardtype"));
                u.Cardno = dr.GetString(dr.GetOrdinal("cardno"));