protected void AddLog(string ids)
{
News condition = new News();
News value = new News();
condition.AddConditon(" and id in(" + ids + ")");
List <News> list = TableOperate <News> .Select(value, condition);
if (list.Count > 0)
{
CloudSQL.UpdataVesion(list[0].PcID);
string deltitle = "";
for (int i = 0; i < list.Count; i++)
{
CloudSQL.DeleteOldFile(list[i]);
deltitle += list[i].Title + ",";
}
deltitle = deltitle.TrimEnd(',');
if (deltitle != "")
{
string logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "删除了资源【" + deltitle + "】";
Lognet.AddLogin(logbrief);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int ID = 0;
string action = GetstringKey("action");
if (action == "save")
{
Result result = new Result();
string logbrief = "";
News newChannelNews = new News();
int _ModeID = GetIntKey("ModeID");
int _PCID = GetIntKey("PCID");
ID = GetIntKey("iD");
if (_ModeID != 0 && _PCID != 0 && ID != 0)
{
newChannelNews = GetShare(ID);
newChannelNews.NoID();
newChannelNews.AddTime = DateTime.Now;
newChannelNews.AddID = AdminMethod.AdminID;
newChannelNews.ExhibitionID = AdminMethod.ExhibitionID;
newChannelNews.TypeID = 0;
newChannelNews.IsShare = 0;
newChannelNews.OldID = 0;
newChannelNews.ModeID = _ModeID;
newChannelNews.PcID = _PCID;
newChannelNews.OrderID = CloudSQL.GetNowTime();
int Sid = TableOperate <News> .InsertReturnID(newChannelNews);
if (Sid > 0)
{
CloudSQL.UpdataVesion(_PCID);
result.isOk = true;
result.msg = "资源调用成功！";
logbrief = "管理员:【" + AdminMethod.AdminFullName + "】,在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "调用了【" + newChannelNews.Title + "】资源";
Lognet.AddLogin(logbrief);
AddUsing(Sid);
}
else
{
result.msg = "资源调用失败！";
}
}
Response.ContentType = "text/json";
Response.Write(new JavaScriptSerializer().Serialize(result));
Response.End();
}
else
{
ID = GetIntKey("iD");
iD.Value = ID + "";
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
m_ExhibitionList = ChannelProvider.SelectAll();
m_ExhibitionList1 = ModeChannelProvider.SelectAll();
string action = GetstringKey("action");
PCID = GetIntKey("pcid");
if (action != "save")
{
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
int _iD = Convert.ToInt32(this.Request["iD"]);
News condition = new News();
condition.ID = _iD;
news = TableOperate <News> .GetRowData(condition);
iD.Value = Convert.ToString(news.ID);
state.Value = Convert.ToString(news.State);
}
DataBind();
}
else
{
Result result = new Result();
string logbrief = "";
try
{
News newChannelNews = new News();
newChannelNews.ID = 0;
newChannelNews.AutoForm(this.Page);
newChannelNews.FileType = SysConfig.CheckPlayType(newChannelNews.Files);
if (newChannelNews.JsonStr == "" || newChannelNews.JsonStr == null)
{
newChannelNews.JsonStr = "{\"type\": \"google\",\"data\": \"\"}";
}
string oldFiles = GetstringKey("oldFiles");
if (oldFiles != newChannelNews.Files && newChannelNews.FileType == 4)
{
string piczip = CloudSQL.GetPicZip(newChannelNews.Files, news.Files1);
newChannelNews.Files1 = piczip;
}
string Title = newChannelNews.Title;
int _iD;
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
_iD = Convert.ToInt32(this.Request["iD"]);
newChannelNews.AddTime = DateTime.Now;
TableOperate <News> .Update(newChannelNews);
result.msg = "编辑成功，等待返回列表";
logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "编辑了资源【" + Title + "】";
}
else
{
newChannelNews.AddTime = DateTime.Now;
newChannelNews.AddID = AdminMethod.AdminID;
newChannelNews.ExhibitionID = AdminMethod.ExhibitionID;
newChannelNews.TypeID = 0;
newChannelNews.IsShare = 0;
newChannelNews.OldID = 0;
newChannelNews.OrderID = CloudSQL.GetNowTime();
_iD = TableOperate <News> .InsertReturnID(newChannelNews);
result.msg = "添加成功，等待返回列表";
logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "添加了资源【" + Title + "】";
}
if (_iD > 0)
{
result.isOk = true;
Lognet.AddLogin(logbrief);
if (newChannelNews.State == 1)
{
CloudSQL.UpdataVesion(newChannelNews.PcID);
}
}
else
{
result.msg = "操作失败";
}
}
catch (Exception ex)
{
result.isOk = false;
result.msg = "操作失败";
}
Response.ContentType = "text/json";
Response.Write(new JavaScriptSerializer().Serialize(result));
Response.End();
}
DataBind();
}