AccessDAL/Trademark.cs

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

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

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




namespace MyShop.AccessDAL
{
     public  class Trademark:ITrademark
    {
        
        private string tableName = "Ljh_Trademark";

         public Trademark()
         {
             if (!string.IsNullOrEmpty(BaseConfig.GetBaseConfig().TablePrefix.Trim()))
                 tableName = BaseConfig.GetBaseConfig().TablePrefix + "Trademark";

         }

         #region ITrademark member


         /// <summary>
         /// add  
         /// </summary>
         /// <param name="model"></param>
         /// <returns>返回ID, 如果发生错误则返回-1</returns>
         public int Add(TrademarkInfo model)
         {
             if (model == null)
             {
                 return -1;
             }
             string commandText = "insert into " + this.tableName + "(ChannelID,ProducerID,TrademarkName,TrademarkPhoto,TrademarkIntro,TrademarkType,Passed,OnTop,IsElite,Hits)  values(@ChannelID,@ProducerID,@TrademarkName,@TrademarkPhoto,@TrademarkIntro,@TrademarkType,@Passed,@OnTop,@IsElite,@Hits)  ";
             OleDbParameter[] commandParameters = {
				Database.MakeInParam("@ChannelID",OleDbType.Integer,4,model.ChannelID),
				Database.MakeInParam("@ProducerID",OleDbType.Integer,4,model.ProducerID),
				Database.MakeInParam("@TrademarkName",OleDbType.VarWChar,50,model.TrademarkName),
				Database.MakeInParam("@TrademarkPhoto",OleDbType.VarWChar,50,model.TrademarkPhoto),
				Database.MakeInParam("@TrademarkIntro",OleDbType.VarWChar,0,model.TrademarkIntro),
				Database.MakeInParam("@TrademarkType",OleDbType.Integer,4,model.TrademarkType),
				Database.MakeInParam("@Passed",OleDbType.UnsignedTinyInt,1,model.Passed),
				Database.MakeInParam("@onTop",OleDbType.UnsignedTinyInt,1,model.OnTop),
				Database.MakeInParam("@IsElite",OleDbType.UnsignedTinyInt,1,model.IsElite),
				Database.MakeInParam("@Hits",OleDbType.Integer,4,model.Hits)
         };
             int intIdentity = -1;
             try
             {
                 Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
             }
             catch (Exception exception)
             {