publisherservice.cs

来自「一个网上书店的源码」· CS 代码 · 共 41 行

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 PublisherService
	{
	
        public static Publisher GetPublisherById(int id)
        {
            string sql = "SELECT * FROM Publishers WHERE Id = @Id";

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

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

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