categoryservice.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 CategoryService
	{

		
        public static Category GetCategoryById(int id)
        {
            string sql = "SELECT * FROM Categories WHERE Id = @Id";

            using(SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id)))
            {
                if (reader.Read())
                {
                    Category category = new Category();

					category.Id = (int)reader["Id"];
					category.Name = (string)reader["Name"];

                    reader.Close();
					
                    return category;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
        }
		
	}
}