com.eshop.www.DAL/MessageDAO.cs

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

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

//
// 
// 网址：http://.taobao.com
// QQ：



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using com.eshop.www.Model;
using System.Data;

namespace com.eshop.www.DAL
{
    public class MessageDAO
    {
        public bool Add(Message message)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "insert into message (member_id,title,[content],is_show,create_date) values (@member_id,@title,@content,@is_show,default)";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@member_id", DbType.Int32, message.MemberId);
            database.AddInParameter(cmd, "@title", DbType.String, message.Title);
            database.AddInParameter(cmd, "@content", DbType.String, message.Content);
            database.AddInParameter(cmd, "@is_show", DbType.Boolean, message.IsShow);
            return database.ExecuteNonQuery(cmd) > 0;
        }

        public bool Delete(int Id)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "delete from message where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@Id", DbType.Int32, Id);
            return database.ExecuteNonQuery(cmd) > 0;
        }

        public bool Update(Message message)
        {
            Database database = DatabaseFactory.CreateDatabase();
            string sql = "update message set member_id=@member_id,title=@title,[content]=@content,is_show=@is_show where Id=@Id";
            DbCommand cmd = database.GetSqlStringCommand(sql);
            database.AddInParameter(cmd, "@member_id", DbType.Int32, message.MemberId);
            database.AddInParameter(cmd, "@title", DbType.String, message.Title);
            database.AddInParameter(cmd, "@content", DbType.String, message.Content);
            database.AddInParameter(cmd, "@is_show", DbType.Boolean, message.IsShow);
            database.AddInParameter(cmd, "@Id", DbType.Int32, message.Id);
            int row = database.ExecuteNonQuery(cmd);
            return row > 0;
        }

        public bool Reply(Message message)