AccessDAL/Article.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using MyShop.IDAL;
using MyShop.Model;

namespace MyShop.AccessDAL
{
    public class Article : IArticle
    {

        private ConfigInfo configInfo = new ConfigInfo();
        private string tableName = "Ljh_Article";

        public Article()
        {
            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
                tableName = configInfo.TablePrefix + "Article";
        }

        #region IArticle member


        /// <summary>
        /// add  
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回ID, 如果发生错误则返回-1</returns>
        public int Add(ArticleInfo model)
        {
            if (model == null)
            {
                return -1;
            }
            string commandText = "insert into " + this.tableName + "(ChannelID,ClassID,Title,Author,CopyFrom,Inputer,Editor,Keyword,Hits,CommentCount,CreateTime,OnTop,Elite,Content,DefaultPicUrl,IncludePic,Stars,Deleted,Status,IsHot)  values(@ChannelID,@ClassID,@Title,@Author,@CopyFrom,@Inputer,@Editor,@Keyword,@Hits,@CommentCount,@CreateTime,@OnTop,@Elite,@Content,@DefaultPicUrl,@IncludePic,@Stars,@Deleted,@Status,@IsHot)  ";
            OleDbParameter[] commandParameters = 
             { 
                    Database.MakeInParam("@ChannelID", OleDbType.Integer, 4, model.ChannelID), 
                 Database.MakeInParam("@ClassID", OleDbType.Integer, 4, model.ClassID), 
                 Database.MakeInParam("@Title", OleDbType.VarWChar, 0xff, model.Title),
                 Database.MakeInParam("@Author", OleDbType.VarWChar, 0xff, model.Author), 
                 Database.MakeInParam("@CopyFrom", OleDbType.VarWChar, 0xff, model.CopyFrom),
                 Database.MakeInParam("@Inputer", OleDbType.VarWChar, 20, model.Inputer), 
                 Database.MakeInParam("@Editor", OleDbType.VarWChar, 20, model.Editor), 
                 Database.MakeInParam("@Keyword", OleDbType.VarWChar, 0xff, model.Keyword), 
                 Database.MakeInParam("@Hits", OleDbType.Integer, 4, model.Hits), 
                 Database.MakeInParam("@CommentCount", OleDbType.Integer, 4, model.CommentCount), 
                 Database.MakeInParam("@CreateTime", OleDbType.DBTimeStamp, 8, model.CreateTime),
                 Database.MakeInParam("@OnTop", OleDbType.Integer, 4, model.OnTop),
                 Database.MakeInParam("@Elite", OleDbType.UnsignedTinyInt, 4, model.IsElite), 
                 Database.MakeInParam("@Content", OleDbType.VarWChar, 0, model.Content),
                 Database.MakeInParam("@DefaultPicUrl", OleDbType.VarWChar, 0xff, model.DefaultPicUrl), 
                 Database.MakeInParam("@IncludePic", OleDbType.Integer, 4, model.IncludePic), 
                    Database.MakeInParam("@Stars", OleDbType.Integer, 4, model.Stars), 
                 Database.MakeInParam("@Deleted", OleDbType.UnsignedTinyInt, 1, model.Deleted),
                 Database.MakeInParam("@Status", OleDbType.UnsignedTinyInt, 1, model.Status), 
                 Database.MakeInParam("@Ishot", OleDbType.UnsignedTinyInt, 1, model.IsHot)
                 };
            int intIdentity = -1;