AccessDAL/GuestBook.cs

（开头部分） 10KB

这里只显示每个文件的开头 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 GuestBook : IGuestBook
    {
        private ConfigInfo configInfo = new ConfigInfo();
        private string tableName = "Ljh_GuestBook";

        public GuestBook()
        {
            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
                tableName = configInfo.TablePrefix + "GuestBook";
        }
        #region IGuestBook member


        /// <summary>
        /// add 
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回ID, 如果发生错误则返回-1</returns>
        public int Add(GuestBookInfo model)
        {
            if (model == null)
            {
                return -1;
            }
            string commandText = "insert into " + this.tableName + "(GuestName,content,QQ,Email,HomePage,LeaveTime,Reply,Gender,IsPassed,Face) values(@GuestName,@content,@QQ,@Email,@HomePage,@LeaveTime,@Reply,@Gender,@IsPassed,@Face)   ";
             OleDbParameter[] commandParameters ={
                Database.MakeInParam("@GuestName", OleDbType.VarWChar	,	20	,model.GuestName	),
                Database.MakeInParam("@content", OleDbType.VarWChar	,	0	,model.content	),
                Database.MakeInParam("@QQ", OleDbType.VarWChar	,	50	,model.QQ	),
                Database.MakeInParam("@Email", OleDbType.VarWChar	,	50	,model.Email	),
                Database.MakeInParam("@HomePage", OleDbType.VarWChar	,	50	,model.HomePage	),
                Database.MakeInParam("@LeaveTime", OleDbType.Date	,	8	,model.LeaveTime	),
                Database.MakeInParam("@Reply", OleDbType.VarWChar	,	0	,model.Reply	),
                Database.MakeInParam("@Gender", OleDbType.UnsignedTinyInt	,	1	,model.Gender	),
                Database.MakeInParam("@IsPassed", OleDbType.UnsignedTinyInt	,	1	,model.IsPassed	),
                Database.MakeInParam("@Face", OleDbType.Integer	,	4	,model.Face)
            };           
            int intIdentity = -1;
            try
            {
                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return intIdentity;
        }

        /// <summary>
后面还有 255 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。