/// <summary>
/// 获取PID栏目
/// </summary>
/// <param name="Pid"></param>
/// <returns></returns>
protected string GetChannelJson(int Pid)
{
string json = "";
List <ModeChannel> list1 = ModeChannelProvider.GetMyID(Pid);
List <ModeChannel> list = ModeChannelProvider.SelectByParentID(Pid);
for (int i = 0; i < list1.Count; i++)
{
json += "{\"ID\":" + list1[i].ID + ", \"Name\":\"" + list1[i].Name + "\", \"Brief\":\"" + Null(list1[i].Brief) + "\", \"OrderID\":\"" + list1[i].OrderID + "\", \"IsChild\":\"" + list1[i].Child.ToString() + "\", \"ParentID\":\"" + list1[i].ParentID + "\", \"Depth\":\"" + list1[i].Depth + "\", \"RootID\":\"" + list1[i].RootID + "\",\"News\":" + GetNews(list1[i].ID) + "},";
}
for (int i = 0; i < list.Count; i++)
{
json += "{\"ID\":" + list[i].ID + ", \"Name\":\"" + list[i].Name + "\", \"Brief\":\"" + Null(list[i].Brief) + "\", \"OrderID\":\"" + list[i].OrderID + "\", \"IsChild\":\"" + list[i].Child.ToString() + "\", \"ParentID\":\"" + list[i].ParentID + "\", \"Depth\":\"" + list[i].Depth + "\", \"RootID\":\"" + list[i].RootID + "\",\"News\":" + GetNews(list[i].ID) + "},";
}
json = json.Trim(',');
return(json);
}
protected void Page_Load(object sender, EventArgs e)
{
m_ExhibitionList = ModeChannelProvider.SelectAll();
ChannelNews condition = new ChannelNews();
ChannelNews value = new ChannelNews();
string title = GetstringKey("name");
PCID = GetIntKey("pcid");
if (title != "")
{
condition.Title = "%" + title + "%";
condition.AddAttach("Title", "like");
}
if (PCID != 0)
{
condition.ChannelID = PCID;
}
condition.ExhibitionID = AdminMethod.ExhibitionID;
m_tableManageList = TableOperate <ChannelNews> .SelectByPage(value, condition, "order by OrderID asc", PageSize, PageIndex, ref Count);
DataBind();
name.Value = title;
}
protected void Page_Load(object sender, EventArgs e)
{
Result result = new Result();
JavaScriptSerializer js = new JavaScriptSerializer();
try
{
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
int iD = Convert.ToInt32(this.Request["iD"]);
if (TableOperate <ModeChannel> .Delete(iD) > 0)
{
List <ModeChannel> channelList = ModeChannelProvider.SelectAll();
foreach (var item in channelList)
{
if (item.Path.IndexOf(this.Request["iD"]) > -1)
{
TableOperate <ModeChannel> .Delete(item.ID);
}
}
result.isOk = true;
}
else
{
result.msg = "删除失败";
}
}
else if (!string.IsNullOrEmpty(this.Request["checkshop"]))
{
string checkshop = Convert.ToString(this.Request["checkshop"]);
checkshop = RequestString.NoHTML(checkshop);
int id = TableOperate <ModeChannel> .MultiDelete(checkshop);
if (id > 0)
{
result.isOk = true;
}
else
{
result.msg = "删除失败";
}
}
else if (!string.IsNullOrEmpty(this.Request["all"]))
{
ModeChannel condition = new ModeChannel();
condition.ExhibitionID = AdminMethod.ExhibitionID;
int id = TableOperate <ModeChannel> .Delete(condition);
if (id > 0)
{
result.isOk = true;
}
else
{
result.msg = "删除失败";
}
}
}
catch (Exception ex)
{
result.isOk = false;
result.msg = ex.ToString();
}
Response.ContentType = "text/json";
Response.Write(js.Serialize(result));
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
m_ExhibitionList = ModeChannelProvider.SelectAll();
string action = GetstringKey("action");
pid = GetIntKey("pid");
if (action != "save")
{
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
int _iD = Convert.ToInt32(this.Request["iD"]);
ModeChannel condition = new ModeChannel();
condition.ID = _iD;
news = TableOperate <ModeChannel> .GetRowData(condition);
m_nowChild = Convert.ToString(news.Child).ToLower();
iD.Value = Convert.ToString(news.ID);
}
DataBind();
}
else
{
Result result = new Result();
string logbrief = "";
ModeChannel newChannelNews = new ModeChannel();
newChannelNews.ID = 0;
newChannelNews.AutoForm(this.Page);
string Title = newChannelNews.Name;
int _iD;
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
_iD = Convert.ToInt32(this.Request["iD"]);
ModeChannelProvider.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;
_iD = ModeChannelProvider.Insert(newChannelNews);
result.msg = "添加成功，等待返回列表";
logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "添加了为【" + Title + "】的场景模式";
}
if (_iD > 0)
{
result.isOk = true;
Lognet.AddLogin(logbrief);
}
else
{
result.msg = "操作失败";
}
Response.ContentType = "text/json";
Response.Write(new JavaScriptSerializer().Serialize(result));
Response.End();
}
DataBind();
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
// [{
// "text": "父节点 1",
// "nodes": [{
// "text": "子节点 1",
// "nodes": [{
// "text": "孙子节点 1"
// }, {
// "text": "孙子节点 2"
// }]
// }, {
// "text": "子节点 2"
// }]
//}, {
// "text": "父节点 2"
//}, {
// "text": "父节点 3"
//}, {
// "text": "父节点 4"
//}, {
// "text": "父节点 5"
//}]
channelList = ModeChannelProvider.SelectAll();
string arrstr = "";
for (int i = 0; i < channelList.Count; i++)
{
arrstr += channelList[i].ID + ",";
}
string[] arry = arrstr.TrimEnd(',').Split(',');
string TreeJson = "[";
string JsonData = "";
for (int i = 0; i < channelList.Count; i++)
{
if (channelList[i].Depth == 0)
{
JsonData += "{";
JsonData += "\"text\":\"" + channelList[i].Name + "\"";
JsonData += ",\"id\":\"" + channelList[i].ID + "\"";
JsonData += ",\"itemid\":\"" + i + "\"";
if (channelList[i].Child)
{
JsonData += GetChild(channelList[i].ID);
}
JsonData += "},";
}
else
{
if (!((IList)arry).Contains(channelList[i].ParentID + ""))
{
JsonData += "{";
JsonData += "\"text\":\"" + channelList[i].Name + "\"";
JsonData += ",\"id\":\"" + channelList[i].ID + "\"";
JsonData += "},";
}
}
}
JsonData = JsonData.TrimEnd(',');
TreeJson += JsonData + "]";
Response.Write(TreeJson);
}
