/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSubmit_Click(object sender, EventArgs e) { #region validation if (string.IsNullOrEmpty(PostTitle.Text.Trim())) { WriteBackScript("alert('交流主题不能为空!')"); return; } else if (PostTitle.Text.Trim().Length > 100) { WriteBackScript("alert('交流主题长度不能超过100字符!')"); return; } if (string.IsNullOrEmpty(PostContent.Text.Trim())) { WriteBackScript("alert('交流内容不能为空!')"); return; } else if (PostContent.Text.Length > 1000) { WriteBackScript("alert('交流内容长度不能超过1000!')"); return; } #endregion LabMS.BLL.Post post = new LabMS.BLL.Post(); LabMS.Model.Post postInfo = new LabMS.Model.Post(); postInfo.PostTitle = PostTitle.Text.Trim(); postInfo.PostContent = Server.HtmlEncode(PostContent.Text); postInfo.PostRecordTime = DateTime.Now; postInfo.ViewTimes = 0; postInfo.PostPlateID = int.Parse(Request.QueryString["plateID"]); postInfo.PosterType = Base.PrivilegeManager.GetUserTypeCode(); postInfo.PosterID = int.Parse(UserID); postInfo.ID = post.Add(postInfo); WriteBackScript("alert('发贴成功!');window.returnValue=true;window.opener.location.replace(window.opener.location);window.close();"); }
/// <summary> /// 获取帖子信息 /// </summary> protected void GetPost() { int postID = int.Parse(Request.QueryString["postID"]); ExtendBLL.Post p = new ExtendBLL.Post(); post = p.GetModel(postID); if (post == null) { WriteBackScript("alert('当前主题已经被删除!');window.location.href='Index.aspx';"); } }
public List<LabMS.Model.Post> GetLatest(int counts) { List<LabMS.Model.Post> results = new List<LabMS.Model.Post>(); StringBuilder sb = new StringBuilder(); sb.Append("select top "); sb.Append(counts); sb.Append(" [ID],PostTitle,PosterID,PostContent,PostRecordTime,PosterType,PostPlateID,ViewTimes from Post "); sb.Append(" order by [id] desc "); LabMS.Model.Post model; System.Data.DataSet ds = Maticsoft.DBUtility.DbHelperSQL.Query(sb.ToString()); foreach (System.Data.DataRow row in ds.Tables[0].Rows) { model = new LabMS.Model.Post(); if (row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } model.PostTitle = row["PostTitle"].ToString(); if (row["PosterID"].ToString() != "") { model.PosterID = int.Parse(row["PosterID"].ToString()); } model.PostContent = row["PostContent"].ToString(); if (row["PostRecordTime"].ToString() != "") { model.PostRecordTime = DateTime.Parse(row["PostRecordTime"].ToString()); } if (row["PosterType"].ToString() != "") { model.PosterType = int.Parse(row["PosterType"].ToString()); } if (row["PostPlateID"].ToString() != "") { model.PostPlateID = int.Parse(row["PostPlateID"].ToString()); } if (row["ViewTimes"].ToString() != "") { model.ViewTimes = int.Parse(row["ViewTimes"].ToString()); } results.Add(model); } return results; }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.Post GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 [ID],PostTitle,PosterID,PostContent,PostRecordTime,PosterType,PostPlateID,ViewTimes from Post "); strSql.Append(" where [ID]=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.Post model=new LabMS.Model.Post(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.PostTitle=ds.Tables[0].Rows[0]["PostTitle"].ToString(); if(ds.Tables[0].Rows[0]["PosterID"].ToString()!="") { model.PosterID=int.Parse(ds.Tables[0].Rows[0]["PosterID"].ToString()); } model.PostContent=ds.Tables[0].Rows[0]["PostContent"].ToString(); if(ds.Tables[0].Rows[0]["PostRecordTime"].ToString()!="") { model.PostRecordTime=DateTime.Parse(ds.Tables[0].Rows[0]["PostRecordTime"].ToString()); } if(ds.Tables[0].Rows[0]["PosterType"].ToString()!="") { model.PosterType=int.Parse(ds.Tables[0].Rows[0]["PosterType"].ToString()); } if(ds.Tables[0].Rows[0]["PostPlateID"].ToString()!="") { model.PostPlateID=int.Parse(ds.Tables[0].Rows[0]["PostPlateID"].ToString()); } if(ds.Tables[0].Rows[0]["ViewTimes"].ToString()!="") { model.ViewTimes=int.Parse(ds.Tables[0].Rows[0]["ViewTimes"].ToString()); } return model; } else { return null; } }