コード例 #1
0
ファイル: ReplyDao.cs プロジェクト: ZhangVic/asp1110git
 private bool UpdateNewsReply(NewsReplyInfo reply)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("update vshop_Reply set ");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected],");
     builder.Append("[email protected]");
     builder.Append(" where [email protected];delete from vshop_Message ");
     builder.Append(" where [email protected] ");
     DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
     this.database.AddInParameter(sqlStringCommand, "Keys", DbType.String, reply.Keys);
     this.database.AddInParameter(sqlStringCommand, "MatchType", DbType.Int32, (int) reply.MatchType);
     this.database.AddInParameter(sqlStringCommand, "ReplyType", DbType.Int32, (int) reply.ReplyType);
     this.database.AddInParameter(sqlStringCommand, "MessageType", DbType.Int32, (int) reply.MessageType);
     this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, reply.IsDisable);
     this.database.AddInParameter(sqlStringCommand, "LastEditDate", DbType.DateTime, reply.LastEditDate);
     this.database.AddInParameter(sqlStringCommand, "LastEditor", DbType.String, reply.LastEditor);
     this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, "");
     this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, 2);
     this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, reply.Id);
     this.database.ExecuteNonQuery(sqlStringCommand);
     foreach (NewsMsgInfo info in reply.NewsMsg)
     {
         builder = new StringBuilder();
         builder.Append("insert into vshop_Message(");
         builder.Append("ReplyId,Title,ImageUrl,Url,Description,Content)");
         builder.Append(" values (");
         builder.Append("@ReplyId,@Title,@ImageUrl,@Url,@Description,@Content)");
         sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
         this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, reply.Id);
         this.database.AddInParameter(sqlStringCommand, "Title", DbType.String, info.Title);
         this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.PicUrl);
         this.database.AddInParameter(sqlStringCommand, "Url", DbType.String, info.Url);
         this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, info.Description);
         this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, info.Content);
         this.database.ExecuteNonQuery(sqlStringCommand);
     }
     return true;
 }
コード例 #2
0
ファイル: ReplyDao.cs プロジェクト: ZhangVic/asp1110git
 private bool SaveNewsReply(NewsReplyInfo model)
 {
     int num;
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into vshop_Reply(");
     builder.Append("Keys,MatchType,ReplyType,MessageType,IsDisable,LastEditDate,LastEditor,Content,Type)");
     builder.Append(" values (");
     builder.Append("@Keys,@MatchType,@ReplyType,@MessageType,@IsDisable,@LastEditDate,@LastEditor,@Content,@Type)");
     builder.Append(";select @@IDENTITY");
     DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
     this.database.AddInParameter(sqlStringCommand, "Keys", DbType.String, model.Keys);
     this.database.AddInParameter(sqlStringCommand, "MatchType", DbType.Int32, (int) model.MatchType);
     this.database.AddInParameter(sqlStringCommand, "ReplyType", DbType.Int32, (int) model.ReplyType);
     this.database.AddInParameter(sqlStringCommand, "MessageType", DbType.Int32, (int) model.MessageType);
     this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, model.IsDisable);
     this.database.AddInParameter(sqlStringCommand, "LastEditDate", DbType.DateTime, model.LastEditDate);
     this.database.AddInParameter(sqlStringCommand, "LastEditor", DbType.String, model.LastEditor);
     this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, "");
     this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, 2);
     if (int.TryParse(this.database.ExecuteScalar(sqlStringCommand).ToString(), out num))
     {
         foreach (NewsMsgInfo info in model.NewsMsg)
         {
             builder = new StringBuilder();
             builder.Append("insert into vshop_Message(");
             builder.Append("ReplyId,Title,ImageUrl,Url,Description,Content)");
             builder.Append(" values (");
             builder.Append("@ReplyId,@Title,@ImageUrl,@Url,@Description,@Content)");
             sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
             this.database.AddInParameter(sqlStringCommand, "ReplyId", DbType.Int32, num);
             this.database.AddInParameter(sqlStringCommand, "Title", DbType.String, info.Title);
             this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.PicUrl);
             this.database.AddInParameter(sqlStringCommand, "Url", DbType.String, info.Url);
             this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, info.Description);
             this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, info.Content);
             this.database.ExecuteNonQuery(sqlStringCommand);
         }
     }
     return true;
 }
コード例 #3
0
 protected void btnCreate_Click(object sender, EventArgs e)
 {
     if ((!string.IsNullOrEmpty(this.Tbtitle.Text) && !string.IsNullOrEmpty(this.Tbdescription.Text)) && !string.IsNullOrEmpty(this.hdpic.Value))
     {
         if (!string.IsNullOrEmpty(this.txtKeys.Text) && ReplyHelper.HasReplyKey(this.txtKeys.Text.Trim()))
         {
             this.ShowMsg("关键字重复!", false);
         }
         else
         {
             NewsReplyInfo reply = new NewsReplyInfo {
                 IsDisable = !this.radDisable.SelectedValue
             };
             if (this.chkKeys.Checked && !string.IsNullOrWhiteSpace(this.txtKeys.Text))
             {
                 reply.Keys = this.txtKeys.Text.Trim();
             }
             if (this.chkKeys.Checked && string.IsNullOrWhiteSpace(this.txtKeys.Text))
             {
                 this.ShowMsg("你选择了关键字回复,必须填写关键字!", false);
             }
             else
             {
                 reply.MatchType = this.radMatch.SelectedValue ? MatchType.Like : MatchType.Equal;
                 reply.MessageType = MessageType.News;
                 if (this.chkKeys.Checked)
                 {
                     reply.ReplyType |= ReplyType.Keys;
                 }
                 if (this.chkSub.Checked)
                 {
                     reply.ReplyType |= ReplyType.Subscribe;
                 }
                 if (this.chkNo.Checked)
                 {
                     reply.ReplyType |= ReplyType.NoMatch;
                 }
                 if (reply.ReplyType == ReplyType.None)
                 {
                     this.ShowMsg("请选择回复类型", false);
                 }
                 else if (string.IsNullOrEmpty(this.Tbtitle.Text))
                 {
                     this.ShowMsg("请输入标题", false);
                 }
                 else if (string.IsNullOrEmpty(this.hdpic.Value))
                 {
                     this.ShowMsg("请上传封面图", false);
                 }
                 else if (string.IsNullOrEmpty(this.Tbdescription.Text))
                 {
                     this.ShowMsg("请输入摘要", false);
                 }
                 else if (string.IsNullOrEmpty(this.fkContent.Text) && string.IsNullOrEmpty(this.TbUrl.Text))
                 {
                     this.ShowMsg("请输入内容或自定义链接", false);
                 }
                 else
                 {
                     NewsMsgInfo item = new NewsMsgInfo {
                         Reply = reply,
                         Content = this.fkContent.Text,
                         Description = HttpUtility.HtmlEncode(this.Tbdescription.Text),
                         PicUrl = this.hdpic.Value,
                         Title = HttpUtility.HtmlEncode(this.Tbtitle.Text),
                         Url = this.TbUrl.Text.Trim()
                     };
                     reply.NewsMsg = new List<NewsMsgInfo>();
                     reply.NewsMsg.Add(item);
                     if (ReplyHelper.SaveReply(reply))
                     {
                         this.ShowMsg("添加成功", true);
                     }
                     else
                     {
                         this.ShowMsg("添加失败", false);
                     }
                 }
             }
         }
     }
     else
     {
         this.ShowMsg("您填写的信息不完整!", false);
     }
 }
コード例 #4
0
ファイル: ReplyDao.cs プロジェクト: ZhangVic/asp1110git
 public ReplyInfo ReaderBind(IDataReader dataReader)
 {
     ReplyInfo info = null;
     object obj2 = dataReader["MessageType"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         if (((MessageType) obj2) == MessageType.Text)
         {
             info = new TextReplyInfo();
         }
         else
         {
             info = new NewsReplyInfo();
         }
     }
     obj2 = dataReader["ReplyId"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.Id = (int) obj2;
     }
     info.Keys = dataReader["Keys"].ToString();
     obj2 = dataReader["MatchType"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.MatchType = (MatchType) obj2;
     }
     obj2 = dataReader["ReplyType"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.ReplyType = (ReplyType) obj2;
     }
     obj2 = dataReader["MessageType"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.MessageType = (MessageType) obj2;
     }
     obj2 = dataReader["IsDisable"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.IsDisable = (bool) obj2;
     }
     obj2 = dataReader["LastEditDate"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.LastEditDate = (DateTime) obj2;
     }
     info.LastEditor = dataReader["LastEditor"].ToString();
     obj2 = dataReader["ActivityId"];
     if ((obj2 != null) && (obj2 != DBNull.Value))
     {
         info.ActivityId = (int) obj2;
     }
     return info;
 }
コード例 #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     this.radMatch.Items[0].Text = "模糊匹配";
     this.radMatch.Items[1].Text = "精确匹配";
     this.radDisable.Items[0].Text = "启用";
     this.radDisable.Items[1].Text = "禁用";
     this.chkNo.Enabled = ReplyHelper.GetMismatchReply() == null;
     this.chkSub.Enabled = ReplyHelper.GetSubscribeReply() == null;
     if (!this.chkNo.Enabled)
     {
         this.chkNo.ToolTip = "该类型已被使用";
     }
     if (!this.chkSub.Enabled)
     {
         this.chkSub.ToolTip = "该类型已被使用";
     }
     if (!string.IsNullOrEmpty(base.Request.QueryString["cmd"]) && !string.IsNullOrEmpty(base.Request.Form["MultiArticle"]))
     {
         string str = base.Request.Form["MultiArticle"];
         List<ArticleList> list = JsonConvert.DeserializeObject<List<ArticleList>>(str);
         if ((list != null) && (list.Count > 0))
         {
             NewsReplyInfo reply = new NewsReplyInfo {
                 MessageType = MessageType.List,
                 IsDisable = base.Request.Form["radDisable"] != "true"
             };
             if (base.Request.Form["chkKeys"] == "true")
             {
                 reply.Keys = base.Request.Form.Get("Keys");
             }
             if (!string.IsNullOrWhiteSpace(reply.Keys) && ReplyHelper.HasReplyKey(reply.Keys))
             {
                 base.Response.Write("key");
                 base.Response.End();
             }
             reply.MatchType = (base.Request.Form["radMatch"] == "true") ? MatchType.Like : MatchType.Equal;
             reply.ReplyType = ReplyType.None;
             if (base.Request.Form["chkKeys"] == "true")
             {
                 reply.ReplyType |= ReplyType.Keys;
             }
             if (base.Request.Form["chkSub"] == "true")
             {
                 reply.ReplyType |= ReplyType.Subscribe;
             }
             if (base.Request.Form["chkNo"] == "true")
             {
                 reply.ReplyType |= ReplyType.NoMatch;
             }
             List<NewsMsgInfo> list2 = new List<NewsMsgInfo>();
             foreach (ArticleList list3 in list)
             {
                 if (list3.Status != "del")
                 {
                     NewsMsgInfo item = list3;
                     if (item != null)
                     {
                         item.Reply = reply;
                         list2.Add(item);
                     }
                 }
             }
             reply.NewsMsg = list2;
             if (ReplyHelper.SaveReply(reply))
             {
                 base.Response.Write("true");
                 base.Response.End();
             }
         }
     }
 }