protected void Page_Load(object sender, EventArgs e) { View_News condition = new View_News(); View_News value = new View_News(); string title = GetstringKey("name"); PCID = GetIntKey("pcid"); if (title != "") { condition.Title = "%" + title + "%"; condition.AddAttach("Title", "like"); } if (PCID != 0) { condition.PcID = PCID; } condition.ExhibitionID = AdminMethod.ExhibitionID; condition.TypeID = 0; m_tableManageList = TableOperate <View_News> .SelectByPage(value, condition, "order by OrderID asc", PageSize, PageIndex, ref Count); Counts = TableOperate <View_News> .GetCountValue(condition); DataBind(); name.Value = title; }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.Request["ip"])) { string ip = this.Request["ip"]; int version = Convert.ToInt32(this.Request["v"]);//文件版本控制 Pclist condition = new Pclist(); condition.IP = ip; Pclist channel = TableOperate <Pclist> .GetRowData(condition); if ((channel.Version == version || channel.ID == 0)) { Response.Write("false"); return; } else { Response.Write("<?xml version=\"1.0\"?>\r\n<Config xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">\r\n"); View_News conditionNews = new View_News(); View_News vNews = new View_News(); conditionNews.PcID = channel.ID; conditionNews.State = 1; List <View_News> m_newsList = TableOperate <View_News> .Select(vNews, conditionNews, 0, " order by OrderID asc "); string str = "<FileList>\r\n"; for (int i = 0; i < m_newsList.Count; i++) { string files = m_newsList[i].Files; string item = "<NetFile>\r\n"; item += "<ID>" + m_newsList[i].ID + "</ID>\r\n"; item += "<Title>" + Del(m_newsList[i].Title) + "</Title>\r\n"; item += "<File>" + Del(files) + "</File>\r\n"; item += "<Word>" + Del(m_newsList[i].PicWord) + "</Word>\r\n"; item += "<Tag>" + m_newsList[i].ModeID + "</Tag>\r\n"; item += "<FileType>" + m_newsList[i].FileType + "</FileType>\r\n"; item += "<ISrh>false</ISrh>\r\n"; item += "<IsJz>false</IsJz>\r\n"; item += "<Bejson>" + Del(m_newsList[i].JsonStr) + "</Bejson>\r\n"; item += "</NetFile>\r\n"; str += item; } str += "</FileList>\r\n"; Response.Write("<NeedUpdate>true</NeedUpdate>\r\n"); Response.Write("<NowVersion>" + channel.Version + "</NowVersion>\r\n"); Response.Write(str); Response.Write("</Config>"); } } else { Response.Write("false"); } }
/// <summary> /// 获取展厅最新更新的5条资源 /// </summary> /// <returns></returns> public static List <View_News> NewsList() { View_News condition = new View_News(); View_News value = new View_News(); condition.ExhibitionID = AdminMethod.ExhibitionID; condition.TypeID = 0; List <View_News> list = TableOperate <View_News> .Select(value, condition, 5, "order by id desc"); return(list); }
protected void Page_Load(object sender, EventArgs e) { DateTime dtNow = DateTime.Now; days = DateTime.DaysInMonth(dtNow.Year, dtNow.Month); View_News condition = new View_News(); View_News value = new View_News(); condition.ExhibitionID = AdminMethod.ExhibitionID; condition.TypeID = 0; MyList = TableOperate <View_News> .Select(value, condition); ExhibitionOpen exhibition = new ExhibitionOpen(); ExhibitionOpen exhibitionvalue = new ExhibitionOpen(); exhibition.ExhibitionID = AdminMethod.ExhibitionID; OpenList = TableOperate <ExhibitionOpen> .Select(exhibitionvalue, exhibition); Count = OpenList.Count; DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string action = GetstringKey("action"); bool isUp = false; string ID = Request["ID"]; View_News condition = new View_News(); View_News v = new View_News(); if (string.IsNullOrEmpty(ID)) { Response.Write(""); return; } condition.ID = Convert.ToInt32(ID); View_News myView = TableOperate <View_News> .GetRowData(v, condition); if (myView.ID == 0) { Response.Write(""); return; } View_News condition2 = new View_News(); View_News V2 = new View_News(); condition2.AddConditon(" and ID<>'" + condition.ID + "'"); condition2.PcID = myView.PcID; string strOrder = string.Empty; condition2.OrderID = myView.OrderID; if (action == "up") { //向上,现在是时间越早越在上面 condition2.AddAttach("OrderID", "<"); strOrder = " order by OrderID DESC"; //时间从大到小 } else { condition2.AddAttach("OrderID", ">"); strOrder = " order by OrderID ASC"; } List <View_News> desOrderMdl = TableOperate <View_News> .Select(V2, condition2, 1, strOrder); if (desOrderMdl.Count != 1) { Response.Write(""); return; } News conditionU = new News(); conditionU.ID = myView.ID; conditionU.OrderID = desOrderMdl[0].OrderID; TableOperate <News> .Update(conditionU); News conditionU2 = new News(); conditionU2.ID = desOrderMdl[0].ID; conditionU2.OrderID = myView.OrderID; TableOperate <News> .Update(conditionU2); CloudSQL.UpdataVesion(myView.PcID); Response.StatusCode = 200; Response.Write(conditionU2.ID); }
public static View_NewsView EntityMap(this View_News model) { return(Mapper.Map <View_News, View_NewsView>(model)); }