AccessDAL/FriendSite.cs

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

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

using System;
using System.Text;

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




namespace MyShop.AccessDAL
{
    public class FriendSite : IFriendSite
    {
        
        private string tableName = "Ljh_FriendSite";

        public FriendSite()
        {
            if (!string.IsNullOrEmpty(BaseConfig.GetBaseConfig().TablePrefix.Trim()))
                tableName = BaseConfig.GetBaseConfig().TablePrefix + "FriendSite";
        }
        #region IFriendSite member


        /// <summary>
        /// add 
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回ID, 如果发生错误则返回-1</returns>
        public int Add(FriendSiteInfo model)
        {

            if (model == null)
            {
                return 0;
            }
            string commandText = "insert into " + tableName + "(LinkType,SiteName,SiteUrl,LogoUrl,SiteIntro,Hits,AddTime,EndTime,Passed,OrderID) values(@LinkType,@SiteName,@SiteUrl,@LogoUrl,@SiteIntro,@Hits,@AddTime,@EndTime,@Passed,@OrderID) ";
            OleDbParameter[] commandParameters = 	
                {
                Database.MakeInParam("@LinkType", OleDbType.Integer	,	4	,model.LinkType	),
                Database.MakeInParam("@SiteName", OleDbType.VarWChar	,	100	,model.SiteName	),
                Database.MakeInParam("@SiteUrl", OleDbType.VarWChar	,	255	,model.SiteUrl	),
                Database.MakeInParam("@LogoUrl", OleDbType.VarWChar	,	255	,model.LogoUrl	),
                Database.MakeInParam("@SiteIntro", OleDbType.VarWChar	,	255	,model.SiteIntro	),
                Database.MakeInParam("@Hits", OleDbType.Integer	,	4	,model.Hits	),
                Database.MakeInParam("@AddTime", OleDbType.DBDate	,	8	,model.AddTime	),
                Database.MakeInParam("@EndTime", OleDbType.DBDate	,	8	,model.EndTime	),
                Database.MakeInParam("@Passed", OleDbType.Integer	,	4	,model.Passed	),
                Database.MakeInParam("@OrderId", OleDbType.Integer	,	4	,model.OrderId	)

                                                            };

            int intIdentity = -1;
            try
            {
                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);