Hidistro.SqlDal/VShop/ReplyDao.cs

（开头部分） 27KB

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

namespace Hidistro.SqlDal.VShop
{
    using Hidistro.Core;
    using Hidistro.Entities;
    using Hidistro.Entities.VShop;
    using Hidistro.Entities.Weibo;
    using Hidistro.SqlDal.Weibo;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class ReplyDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public void DeleteNewsMsg(int id)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(new StringBuilder(" delete from vshop_Message where MsgID=@MsgID").ToString());
            this.database.AddInParameter(sqlStringCommand, "MsgID", DbType.Int32, id);
            this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public bool DeleteReply(int id)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE vshop_Reply WHERE ReplyId = @ReplyId;DELETE vshop_Message WHERE ReplyId = @ReplyId");
            this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, id);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public IList<Hidistro.Entities.VShop.ReplyInfo> GetAllReply()
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select ReplyId,Keys,MatchType,ReplyType,MessageType,IsDisable,LastEditDate,LastEditor,Content,Type,ActivityId,ArticleID");
            builder.Append(" FROM vshop_Reply order by Replyid desc ");
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            List<Hidistro.Entities.VShop.ReplyInfo> list = new List<Hidistro.Entities.VShop.ReplyInfo>();
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                while (reader.Read())
                {
                    object obj2;
                    Hidistro.Entities.VShop.ReplyInfo info = this.ReaderBind(reader);
                    switch (info.MessageType)
                    {
                        case MessageType.Text:
                        {
                            TextReplyInfo info3 = info as TextReplyInfo;
                            obj2 = reader["Content"];
                            if ((obj2 != null) && (obj2 != DBNull.Value))
                            {
                                info3.Text = obj2.ToString();
                            }
                            list.Add(info3);
                            continue;
                        }
                        case MessageType.News:
                        case MessageType.List:
后面还有 524 行代码，购买后查看完整代码

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

AI 解读 AI

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

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