BookShop/DAL/BookShop_Book.cs

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

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

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

using BookShop.Model;
using CTL.Common;
using CTL.Data;

namespace BookShop.Data
{
    /// <summary>
    ///	图书信息表
    ///	数据层实例化接口类 BookShop_Book
    /// 主要完成对数据库的基本操作
    ///	2013-08-06 21:04:36
    /// </summary>
    public partial class BookProvider : SqlDB<BookProvider>
    {
        #region Method
        /// <summary>
        /// 数据库表名
        /// </summary>
        private static string tableName = "BookShop_Book";
        /// <summary>
        /// 数据库视图名
        /// </summary>
        private static string viewName = "BookShop_View_Book";
        /// <summary>
        /// 数据查询语句(查询全部数据)
        /// </summary>
        private string select_strsql = "Select * from " + viewName;


        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string insert_strsql = "Insert into " + tableName + " (PrintTime,PrintTimes,Pages,WordCount,MarketPrice,CostPrice,Price,OnSale,OnSaleTime,Remark,Name,RateTotal,GradeTotal,CreateTime,Photo,Stock,SaleTotal,IsHot,IsNew,IsRecommend,Visits,BookNo,ForSerach,Point,ISBN,Author,CateID,PressID,PublishTime,Revision)values(@PrintTime,@PrintTimes,@Pages,@WordCount,@MarketPrice,@CostPrice,@Price,@OnSale,@OnSaleTime,@Remark,@Name,@RateTotal,@GradeTotal,@CreateTime,@Photo,@Stock,@SaleTotal,@IsHot,@IsNew,@IsRecommend,@Visits,@BookNo,@ForSerach,@Point,@ISBN,@Author,@CateID,@PressID,@PublishTime,@Revision)";
        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string count_strsql = "Select Count(*) From " + viewName;
        /// <summary>
        /// 数据更新语句
        /// </summary>
        private string update_strsql = "Update  " + tableName + " Set PrintTime= @PrintTime ,PrintTimes= @PrintTimes ,Pages= @Pages ,WordCount= @WordCount ,MarketPrice= @MarketPrice ,CostPrice= @CostPrice ,Price= @Price ,OnSale= @OnSale ,OnSaleTime= @OnSaleTime ,Remark= @Remark ,Name= @Name ,RateTotal= @RateTotal ,GradeTotal= @GradeTotal ,CreateTime= @CreateTime ,Photo= @Photo ,Stock= @Stock ,SaleTotal= @SaleTotal ,IsHot= @IsHot ,IsNew= @IsNew ,IsRecommend= @IsRecommend ,Visits= @Visits ,BookNo= @BookNo ,ForSerach= @ForSerach ,Point= @Point ,ISBN= @ISBN ,Author= @Author ,CateID= @CateID ,PressID= @PressID ,PublishTime= @PublishTime ,Revision= @Revision   where BookID=@BookID  ";
        /// <summary>
        /// 数据删除语句(根据主键删除)
        /// </summary>
        private string delete_strsql = "Delete  From " + tableName + "  where BookID=@BookID";


        #region  判断是否存在
        /// <summary>
        /// 根据条件判断是否存在
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>