SQLServer/User.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using Model;
using IDAL;
using DBUnititly;

/// <summary>
/// SQLUser 的摘要说明
/// </summary>
namespace SQLServer
{
    public class User : IUser
    {
        public IList<UserInfo> GetUser()
        {

            IList<UserInfo> userInfo = new List<UserInfo>();
            using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.txtConnecttionString, CommandType.StoredProcedure, "SelectUser", null))
            {

                while (dr.Read())
                {

                    UserInfo user = new UserInfo(dr.GetInt32(0), dr.GetString(1), dr.GetString(2), dr.GetBoolean(3));
                    userInfo.Add(user);

                }

            }
            return userInfo;
        }
        public IList<UserInfo> GetUserById(int nId)
        {

            IList<UserInfo> userInfo = new List<UserInfo>();
            SqlParameter[] paras = { new SqlParameter("@Id", SqlDbType.Int, 4) };
            paras[0].Value = nId;
            using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.txtConnecttionString, CommandType.StoredProcedure, "SelectUserById", paras))
            {
                while (dr.Read())
                {
                    if (dr["Phone"] == null)
                    {
                        UserInfo user = new UserInfo(dr.GetInt32(0), dr.GetString(1), dr.GetString(2), dr.GetString(3), null, dr.GetInt64(5), dr.GetString(6), dr.GetString(7), dr.GetBoolean(8));
                        userInfo.Add(user);
                    }
                    else
                    {

                        UserInfo user = new UserInfo(dr.GetInt32(0), dr.GetString(1), dr.GetString(2), dr.GetString(3), dr.GetString(4), dr.GetInt64(5), dr.GetString(6), dr.GetString(7),dr.GetBoolean(8));
                        userInfo.Add(user);

                    }
                }

            }
            return userInfo;