/// <summary> /// 获得观点列表 /// </summary> /// <param name="pg"></param> /// <returns></returns> public List <ViewPointExtend> GetViewPointList(Pages pg) { List <ViewPointExtend> list = new List <ViewPointExtend>(); string sql = "proc_ViewPoint_fenye"; SqlParameter[] para = { new SqlParameter("@pageIndex", pg.PageIndex), new SqlParameter("@pageSize", pg.PagesSize), new SqlParameter("@ListName", pg.types), new SqlParameter("@require", pg.Tiaojian), new SqlParameter("@id", pg.id) }; DataSet ds = DbHelper.GetDataSetByProc(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { ViewPointExtend vp = new ViewPointExtend(); vp.ID = Convert.ToInt32(dr["ID"]); vp.Title = dr["Title"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); vp.TypeName = dr["TpName"].ToString(); vp.Istop = Convert.ToInt32(dr["Istop"]); list.Add(vp); } return(list); }
public IList <ViewPointExtend> GetViewPointList(int topN, int tid) { IList <ViewPointExtend> list = new List <ViewPointExtend>(); string sql = "select top ( @topN ) vp.ID,vp.Title,vp.AddTime from ViewPoint vp inner join PointType pt on pt.ID = vp.TpId where pt.ID = @Tid order by vp.AddTime desc"; SqlParameter[] paras = { new SqlParameter("@TopN", topN), new SqlParameter("@Tid", tid) }; using (SqlDataReader dr = SqlHelper.ExecuteReader(sql, paras, CommandType.Text)) { while (dr.Read()) { ViewPointExtend vp = new ViewPointExtend(); vp.ID = Convert.IsDBNull(dr["ID"]) ? 0 : Convert.ToInt32(dr["ID"]); vp.Title = Convert.IsDBNull(dr["Title"]) ? "" : dr["Title"].ToString(); vp.AddTime = Convert.IsDBNull(dr["AddTime"]) ? DateTime.Now : Convert.ToDateTime(dr["AddTime"]); list.Add(vp); } dr.Close(); } return(list); }
/// <summary> /// 根据id去获取ViewPoint /// </summary> /// <param name="id">id</param> /// <returns></returns> public ViewPointExtend GetViewPointTpName(int id) { ViewPointExtend vp = new ViewPointExtend(); string sql = "select b.ID, a.AddTime, Title,TypeName,tag,Article,MetaKey,MetaDesc,vtag from ViewPoint a inner join PointType b on a.TpId=b.ID where a.ID=@id"; SqlParameter[] para = { new SqlParameter("@id", id) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; vp.Title = dr["Title"].ToString(); vp.TypeName = dr["TypeName"].ToString(); vp.Tag = dr["tag"].ToString(); vp.Article = dr["Article"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); vp.ID = Convert.ToInt32(dr["ID"]); vp.MetaKey = dr["MetaKey"].ToString(); vp.MetaDesc = dr["MetaDesc"].ToString(); vp.vtag = dr["vtag"].ToString(); } return(vp); }
public ViewPointExtend GetViewPointExtendByID(int id) { ViewPointExtend vp = new ViewPointExtend(); SqlParameter[] para = { new SqlParameter("@ID", id) }; using (SqlDataReader dr = SqlHelper.ExecuteReader("proc_GetViewPointByID", para, CommandType.StoredProcedure)) { if (dr.Read()) { vp.ID = id; vp.Article = dr["Article"].ToString(); vp.TpId = Convert.ToInt32(dr["TpId"]); vp.TypeName = Convert.IsDBNull(dr["TypeName"]) ? "" : dr["TypeName"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); vp.Title = dr["Title"].ToString(); vp.Istop = Convert.ToInt32(dr["Istop"]); } dr.Close(); } return(vp); }
void InitNewsInfoByID() { int id = Convert.ToInt32(Request.QueryString["id"]); vp = vpManager.GetViewPointExtendByID(id); this.Page.Title = vp.Title + "-隆恩特"; }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// ~/FirstPage/new/ndetail_id.html protected void btnOK_Click(object sender, EventArgs e) { ViewPointExtend point = new ViewPointExtend(); point.Title = this.txtTitle.Value; string vName = this.ddlFLInfoclass.SelectedItem.Text; point.Article = this.UEditor1.Value; point.TpId = Convert.ToInt32(this.ddlFLInfoclass.SelectedItem.Value); point.TypeName = vName.Substring(0, 2); if (chkIsTop.Checked == true) { point.Istop = 1; } else { point.Istop = 0; } point.MetaDesc = txt_metadesc.Text; point.MetaKey = txt_metakey.Text; point.vtag = txt_tag.Text; point.CShortDes = txt_shortdes.Text; if (ViewState["isNUlls"] == null) { int id = 0; if (vpMang.AddViewPoint(point, out id)) { point.ID = id;//id //ViewPoint vpnext = new ViewPointManager().GetViewPointNext(point.ID); //ViewPoint vpUp = new ViewPointManager().GetViewPointUp(point.ID); //WirteFile(point,vpnext,vpUp); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('添加成功!');window.location.href='ViewPointMsg.aspx'</script>"); } } else { point.ID = Convert.ToInt32(ViewState["isNUlls"]); if (vpMang.EditViewPoint(point)) { //string path = HttpContext.Current.Server.MapPath("~/FirstPage/viewpoint/"); //string hurl = "vdetail_" + point.ID.ToString() + ".html"; //ViewPoint vpnext = new ViewPointManager().GetViewPointNext(point.ID); //ViewPoint vpUp = new ViewPointManager().GetViewPointUp(point.ID); //File.Delete(path + hurl); //WirteFile(point,vpnext,vpUp); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('修改成功!');</script>"); } } }
/// <summary> /// 写入页面 /// </summary> public void WirteFile(ViewPointExtend news, ViewPoint NextText, ViewPoint UpText) { string path = HttpContext.Current.Server.MapPath("~/FirstPage/viewpoint/"); Encoding code = Encoding.GetEncoding("gb2312"); string temp = HttpContext.Current.Server.MapPath("viewdetail.html"); StreamReader sr = null; StreamWriter sw = null; string str = ""; try { sr = new StreamReader(temp, code); str = sr.ReadToEnd(); } catch (Exception ex) { HttpContext.Current.Response.Write(ex.Message); HttpContext.Current.Response.End(); sr.Close(); } string NextStr = "<span>下一篇: <a href='vdetail_" + NextText.ID + ".html'>" + NextText.Title + "</a></span>"; string UpStr = "<span>下一篇: <a href='vdetail_" + UpText.ID + ".html'>" + UpText.Title + "</a></span>"; str = str.Replace("[title]", news.Title) .Replace("[Content]", news.Article) .Replace("[TypeName]", news.TypeName) .Replace("[UpText]", UpStr) .Replace("[NextText]", NextStr); string hurl = "vdetail_" + news.ID.ToString() + ".html"; try { sw = new StreamWriter(path + hurl, false, code); sw.Write(str); sw.Flush(); } catch (Exception ex) { HttpContext.Current.Response.Write(ex.Message); HttpContext.Current.Response.End(); throw; } finally { sw.Close(); } }
/// <summary> /// 推荐观点6条(按时间排序) /// </summary> /// <returns></returns> public List <ViewPointExtend> GetViewPointList() { List <ViewPointExtend> list = new List <ViewPointExtend>(); string sql = "select top 4 a.ID,Title,TypeName from ViewPoint a inner join PointType b on a.TpId=b.ID"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { ViewPointExtend vpe = new ViewPointExtend(); vpe.ID = Convert.ToInt32(dr["ID"]); vpe.Title = dr["Title"].ToString(); vpe.TypeName = dr["TypeName"].ToString(); list.Add(vpe); } return(list); }