userstateservice.cs

一个网上书店的源码

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

namespace MyBookShop.DAL
{
	public static partial class UserStateService
	{

        public static UserState GetNormalUserState()
        {
            return GetUserStateById(1);
        }

        public static UserState GetUserStateById(int id)
        {
            string sql = "SELECT * FROM UserStates WHERE Id = @Id";
            SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id));

            if (reader.Read())
            {
                UserState userState = new UserState();
                userState.Id = (int)reader["Id"];
                userState.Name = (string)reader["Name"];
                reader.Close();
                return userState;
            }
            else
            {
                reader.Close();
                return null;
            }
        }

        public static UserState GetDefaultUserState()
        {
            return GetUserStateById(1);
        }
	

	}
}