/// <summary> /// 获取一条 /// </summary> /// <param name="id"></param> /// <returns></returns> public Memos GetMemos(int id) { Memos me = new Memos(); string sql = "select * from Memos where id=@id"; SqlParameter[] para = { new SqlParameter("@id", id) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); if (ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; me.UserName = dr["UserName"].ToString(); me.TelPhone = dr["TelPhone"].ToString(); me.Cop = dr["Cop"].ToString(); me.Zhiwei = dr["Zhiwei"].ToString(); me.MemosContent = dr["MemosContent"].ToString(); me.SubTime = dr["SubTime"].ToString(); me.Hanye = dr["Hanye"].ToString(); me.BrandName = dr["BrandName"].ToString(); me.BrandWeb = dr["BrandWeb"].ToString(); me.Email = dr["Email"].ToString(); } return(me); }
/// <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); }
/// <summary> /// 获取案例分类列表 /// </summary> /// <returns></returns> public List <BoCaseType> GetBoCaseType() { List <BoCaseType> list = new List <BoCaseType>(); string sql = "select ID,TypeName from BoCaseType"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { BoCaseType tp = new BoCaseType(); tp.ID = Convert.ToInt32(dr["ID"]); tp.TypeName = dr["TypeName"].ToString(); list.Add(tp); } return(list); }
/// <summary> /// 获取观点列表 /// </summary> /// <returns></returns> public List <PointType> GetPointTypeList() { List <PointType> list = new List <PointType>(); string sql = "select ID,TypeName from PointType"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { PointType pt = new PointType(); pt.ID = Convert.ToInt32(dr["ID"]); pt.TypeName = dr["TypeName"].ToString(); list.Add(pt); } return(list); }
/// <summary> /// 获取所有链接 /// </summary> /// <param name="txts"></param> /// <returns></returns> public List <FriendShip> GetLinkList_all() { List <FriendShip> list = new List <FriendShip>(); string sql = "select ID,Fword,FUrl from FriendShip"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { FriendShip fri = new FriendShip(); fri.Fword = dr["Fword"].ToString(); fri.FUrl = "http://" + dr["FUrl"].ToString(); fri.ID = Convert.ToInt32(dr["ID"]); list.Add(fri); } return(list); }
/// <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); }
/// <summary> /// 获取前6条数据 /// </summary> /// <param name="p">id</param> /// <returns></returns> public List <ViewPoint> GetViewPointListById_top6() { List <ViewPoint> list = new List <ViewPoint>(); string sql = "select top 6 ID,Title,AddTime from ViewPoint order by AddTime desc"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { ViewPoint vp = new ViewPoint(); vp.ID = Convert.ToInt32(dr["ID"]); vp.Title = dr["Title"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); list.Add(vp); } return(list); }
/// <summary> /// 获取9条数据 /// </summary> /// <returns></returns> public List <BoutiqueCase> GetBoutiqueList_Top6() { List <BoutiqueCase> list = new List <BoutiqueCase>(); string sql = "select ID,Logo,Client,Hanye,item from BoutiqueCase order by Addtime desc"; DataSet ds = DbHelper.GetDataSetBySql(sql); foreach (DataRow dr in ds.Tables[0].Rows) { BoutiqueCase BCase = new BoutiqueCase(); BCase.ID = Convert.ToInt32(dr["ID"]); BCase.Logo = dr["Logo"].ToString(); BCase.Client = dr["Client"].ToString(); BCase.Hanye = dr["Hanye"].ToString(); BCase.item = dr["item"].ToString(); list.Add(BCase); } return(list); }
/// <summary> /// 下一页 /// </summary> /// <returns></returns> public ViewPoint GetViewPointUp(int id) { string sql = "select top 1 * from ViewPoint where @id>ID order by ID asc"; ViewPoint vp = new ViewPoint(); 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.ID = Convert.ToInt32(dr["ID"]); } return(vp); }
/// <summary> /// 获取前十个案例图 /// </summary> /// <param name="p">id</param> /// <returns></returns> public List <Cases> GetCasesListById_top10() { List <Cases> list = new List <Cases>(); string sql = "select top 10 ID,CName,IsTop,AddTime,ImgSrc from Cases where 1=1 order by IsTop desc, AddTime desc"; SqlParameter[] para = { }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { Cases vp = new Cases(); vp.ID = Convert.ToInt32(dr["ID"]); vp.ImgSrc = dr["ImgSrc"].ToString(); vp.CName = dr["CName"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); list.Add(vp); } return(list); }
/// <summary> /// 获取一个 /// </summary> /// <param name="d"></param> /// <returns></returns> public NsyNews GetNsyNews(int d) { NsyNews news = new NsyNews(); string sql = "select * from NsyNews where ID=@id"; SqlParameter[] para = { new SqlParameter("@id", d) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { news.ID = Convert.ToInt32(dr["ID"]); news.Title = dr["Title"].ToString(); news.Contents = dr["Contents"].ToString(); news.AddTime = Convert.ToDateTime(dr["AddTime"]); } return(news); }
/// <summary> /// 获取前6条数据 /// </summary> /// <param name="p">id</param> /// <returns></returns> public List <ViewPoint> GetViewPointListById_top6(int p) { List <ViewPoint> list = new List <ViewPoint>(); string sql = "select top 6 ID,Title,Istop,AddTime from ViewPoint where TpId=@tpid order by Istop desc, AddTime desc"; SqlParameter[] para = { new SqlParameter("@tpid", p) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { ViewPoint vp = new ViewPoint(); vp.ID = Convert.ToInt32(dr["ID"]); vp.Title = dr["Title"].ToString(); vp.AddTime = Convert.ToDateTime(dr["AddTime"]); list.Add(vp); } return(list); }
/// <summary> /// 得到一条案例 /// </summary> /// <param name="d"></param> /// <returns></returns> public BoutiqueCase GetBCase(int d) { BoutiqueCase BCase = new BoutiqueCase(); string sql = "select * from BoutiqueCase where ID=@id"; SqlParameter[] para = { new SqlParameter("@id", d) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { BCase.Logo = dr["Logo"].ToString(); BCase.Background = dr["background"].ToString(); BCase.Challenge = dr["Challenge"].ToString(); BCase.Client = dr["Client"].ToString(); BCase.gain = dr["gain"].ToString(); BCase.Hanye = dr["Hanye"].ToString(); BCase.item = dr["item"].ToString(); } return(BCase); }
/// <summary> /// 获得一个观点 /// </summary> /// <param name="d">id</param> /// <returns></returns> public ViewPoint GetViewPoint(int d) { ViewPoint vp = new ViewPoint(); string sql = "select Title,Article,TpId,Istop,MetaKey,MetaDesc,vtag,CShortDes from ViewPoint where ID=@id"; SqlParameter[] para = { new SqlParameter("@id", d) }; DataSet ds = DbHelper.GetDataSetBySql(sql, para); foreach (DataRow dr in ds.Tables[0].Rows) { vp.Title = dr["Title"].ToString(); vp.Article = dr["Article"].ToString(); vp.TpId = Convert.ToInt32(dr["TpId"]); vp.Istop = Convert.ToInt32(dr["Istop"]); vp.MetaKey = (Convert.IsDBNull(dr["MetaKey"]) ? "" : Convert.ToString(dr["MetaKey"])); vp.MetaDesc = (Convert.IsDBNull(dr["MetaDesc"]) ? "" : Convert.ToString(dr["MetaDesc"])); vp.vtag = (Convert.IsDBNull(dr["vtag"]) ? "" : Convert.ToString(dr["vtag"])); vp.CShortDes = (Convert.IsDBNull(dr["CShortDes"]) ? "" : Convert.ToString(dr["CShortDes"])); } return(vp); }