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));
}
