public ActionResult Index(int id) { SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db(); ViewBag._101资讯 = bll.ExecuteTableForCache("SELECT TOP 10 Id,Title,Channel FROM dbo.yxs_article WHERE State=1 AND Channel LIKE('102%')"); string sql = "SELECT Title,SubTitle,KeyWord,Content,Introduction, (SELECT TOP (1) Name FROM yxs_articlechannel WHERE Id = a.Channel) AS Channel FROM dbo.yxs_article a WHERE State=1 AND Id=" + id; return(View(bll.ExecuteTableForCache(sql).Rows)); }
public ActionResult Index(int id) { SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db(); ViewBag._101资讯 = bll.ExecuteTableForCache("SELECT TOP 10 id,Title FROM dbo.yxs_article WHERE Channel LIKE('100%') and id<>" + id + " ORDER BY id DESC"); string sql = "SELECT Title,SubTitle,KeyWord,Content,Introduction,CopyFrom,updateTime FROM dbo.yxs_article WHERE id=" + id; return(View(bll.ExecuteTableForCache(sql).Rows)); }
public static string Get_Json(int value) { string js = ""; //查询数据库 try { SOSOshop.BLL.Db db = new SOSOshop.BLL.Db(); StringBuilder json = new StringBuilder(); string ParentPath = ""; string sql = "SELECT ParentPath FROM Region WHERE (ParentPath <> '') GROUP BY ParentPath ORDER BY ParentPath"; DataTable dt = db.ExecuteTableForCache(sql); if (dt != null) { foreach (DataRow dr in dt.Rows) { ParentPath += dr[0] + ":"; } if (ParentPath != "") { ParentPath = ParentPath.Substring(0, ParentPath.Length - 1); } string[] Paths = ParentPath.Split(":".ToCharArray()); foreach (string Path in Paths) { sql = "select Id,Name,ParentPath from Region where ParentPath='" + Path + "' ORDER BY OrderID"; dt = db.ExecuteTableForCache(sql); if (dt != null) { json.Append("'" + Path + "':{"); string option = ""; foreach (DataRow dr in dt.Rows) { option += dr["Id"].ToString() + ":'" + dr["Name"].ToString().Trim("\r\n '".ToCharArray()) + "',"; } if (option != "") { json.Append(option.Substring(0, option.Length - 1) + "},"); } } } } js = json.ToString(); if (js != "") { js = js.Substring(0, js.Length - 1); } } catch { } return("{" + js + "}"); }
/// <summary> /// 取网站配置信息 /// </summary> /// <returns></returns> public static WebSiteInfo GetNetSiteInfo() { //WebSiteInfo wsi = new WebSiteInfo(); string sql = @"SELECT TOP 1 [id] ,[websitetitle] ,[tel] ,[fax] ,[email] ,[metekey] ,[meteinfo] ,[websitename] ,[usersagreement] ,[websitedomain] FROM [yxs_websetting]"; SOSOshop.BLL.Db db = new SOSOshop.BLL.Db(); DataTable dt = db.ExecuteTableForCache(sql, DateTime.Now.AddDays(1)); IList <WebSiteInfo> list = dt.AsEnumerable().Select(x => new WebSiteInfo { NetName = x.Field <string>("websitename"), Domain = System.Configuration.ConfigurationManager.AppSettings["CompanyDomainName"], NetTitle = x.Field <string>("websitetitle"), Phone = x.Field <string>("tel"), Fax = x.Field <string>("fax"), Email = x.Field <string>("email"), Keys = x.Field <string>("metekey"), NetInfo = x.Field <string>("meteinfo"), NetProtocol = x.Field <string>("usersagreement") }).ToList(); return(list[0]); }
/// <summary> /// 资讯列表 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult list(string id = "100") { //记录总数 int recordCount = 0; //页总数 int pageCount = 0; //页大小 int pageSize = 12; //当前页 int pageIndex = 1; if (!string.IsNullOrEmpty(Request["pageindex"])) { pageIndex = int.Parse(Request["pageindex"]); } ViewBag.id = id; var bll = new SOSOshop.BLL.Db(); DataTable key = bll.ExecuteTableForCache("SELECT Name,Description,MeteKey,MeteDescription FROM dbo.yxs_articlechannel where id=" + Library.Lang.Input.Filter(id)); if (key.Rows.Count > 0) { ViewBag.Name = key.Rows[0]["Name"]; ViewBag.MeteKey = key.Rows[0]["MeteKey"]; ViewBag.MeteDescription = key.Rows[0]["MeteDescription"]; } string where = string.Format(" AND Channel LIKE('{0}%')", Library.Lang.Input.Filter(id)); DataTable dt = bll.GetListByPage("yxs_article", "id,Title,CreateTime", pageSize, pageIndex, " id desc ", where, out recordCount, out pageCount); //定义页面 PagedList <DataRow> pl = new PagedList <DataRow>(dt.Select(), pageIndex, pageSize, recordCount); return(View(pl)); }
/// <summary> /// 取热门搜索列表 /// </summary> /// <returns></returns> public static Dictionary <string, string> GetHotSearch() { string sql = "select top 5 name,linkad from yxs_topsearches where isshow=1 order by [sort]"; SOSOshop.BLL.Db db = new SOSOshop.BLL.Db(); DataTable dt = db.ExecuteTableForCache(sql, DateTime.Now.AddHours(1)); Dictionary <string, string> dic = new Dictionary <string, string>(); dic = dt.AsEnumerable().ToDictionary(x => x.Field <string>("name"), x => x.Field <string>("linkad")); return(dic); }