public void GetNewData(HttpContext context) { HttpRequest request = context.Request; PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); try { HashtableCustom ht = new HashtableCustom(); ht.Add_Key(PageIndex, request); ht.Add_Key(PageSize, request); ht.Add_Key(isPush, request); ht.Add_Key(IsDelete, request); jsonModel = BllAdvert.GetAdvertData(ht); } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, retData = "", status = "no" }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
public void SetAdvertisingTop(HttpContext context) { HttpRequest request = context.Request; PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); try { HashtableCustom ht = new HashtableCustom(); ht.Add_Key(MenuId, request); ht.Add_Key(Id, request); jsonModel = BllAdvert.SetAdvertisingTop(ht); } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
private PMSModel.JsonModel GetDataHelper(HttpRequest request, HashtableCustom ht) { PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); try { ht.Add_Key(MenuIds, request); ht.Add_Key(IsDelete, request); ht.Add_Key(isPush, request); ht.Add_Key(PageIndex, request); ht.Add_Key(PageSize, request); ht.Add_Key(ImageUrl, request); ht.Add_Key(NotItem, request); ht.Add_Key(ChildId, request); ht.Add_Key(isAll, request); jsonModel = BllAdvert.GetDataInfo(ht); } catch (Exception ex) { LogHelper.Error(ex); } return(jsonModel); }
/// <summary> /// 根据菜单子节点或父节点获得 菜单下的分类信息。 /// </summary> /// <param name="context"></param> public void GetPageListForMenuId(HttpContext context) { HttpRequest request = context.Request; PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); try { HashtableCustom ht = new HashtableCustom(); ht.Add_Key(PageIndex, request); ht.Add_Key(PageSize, request); ht.Add_Key(isPush, request); if (!Null_Check(request, isAll)) { ht.Add(isAll, Convert.ToBoolean(request[isAll])); } if (!Null_Check(request, MenuId)) { int mid = Convert.ToInt32(request[MenuId]); string pids = GetMenuChild(mid); if (!string.IsNullOrWhiteSpace(pids)) { ht.Add(MenuId, pids); jsonModel = BllAdvert.GetAdvertData(ht); } } else { jsonModel = BllAdvert.GetAdvertData(ht); } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, retData = "", status = "no" }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 统计文章访问率 /// </summary> /// <param name="context"></param> public void GetStatistics(HttpContext context) { PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); HttpRequest request = context.Request; try { HashtableCustom ht = new HashtableCustom(); ht.Add_Key(PageIndex, request); ht.Add_Key(PageSize, request); string where = string.Empty; ht.Add(TableName, Advertising); where += " and IsDelete =" + (int)PMSUtility.SysStatus.正常; string notIn = string.Empty; string _NotItem = Convert.ToString(request["NotItem"]); if (!string.IsNullOrEmpty(_NotItem)) { notIn = string.Format(" and MenuId not in ({0})", _NotItem); } if (!Null_Check(request, isPush)) { where += " and isPush=" + request[isPush].SafeToString() + notIn; } ht.Add(Order, "ClickNum desc "); jsonModel = BllAdvert.GetPage(ht, true, where); } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, retData = "", status = "no" }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 新闻导读上移、下移 /// </summary> /// <param name="context"></param> public void UpOrDownAdvert(HttpContext context) { HttpRequest request = context.Request; PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); try { HashtableCustom ht = new HashtableCustom(); ht.Add_Key(upOrdown, request); if (!Null_Check(request, MenuId)) { ht.Add(MenuId, GetMenuChild(Convert.ToInt32(request[MenuId]))); } else { ht.Add_Key(MenuId, request); } ht.Add_Key(isPush, request); ht.Add_Key(Id, request); ht.Add_Key(SortId, request); jsonModel = BllAdvert.UpdateAdertSort(ht); } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
public DataTable GetDataLevelInfo(HashtableCustom ht) { try { StringBuilder sbSql4org = new StringBuilder(); List <SqlParameter> List = new List <SqlParameter>(); if (ht.ContainsKey("isAll") && Convert.ToBoolean(ht["isAll"]) == true) { sbSql4org.Append(@"select [Id] ,[Description] ,[MenuId] ,[IsDelete] ,[CreateTime] ,[Creator] ,[ClickNum] ,[ImageUrl] ,[ModelType] ,[FileName] ,[FilePath] ,[SortId] ,[isPush] FROM [dbo].[Advertising] where 1=1 "); } else { sbSql4org.Append("select * from Advertising where 1=1 "); } if (ht.Add_Key("MenuIds")) { string ids = string.Empty; if (ht.Add_Key("ChildId")) { ids = ht["MenuIds"].ToString(); sbSql4org.Append(" and [MenuId] in (" + ids + ")"); } else { ids = GetMenuInfoByParentMoreLevelID(Convert.ToInt32(ht["MenuIds"])); if (string.IsNullOrEmpty(ids)) { ids = GetMenuInfoByParentID(Convert.ToInt32(ht["MenuIds"])); } sbSql4org.Append(" and [MenuId] in (" + ids + ")"); } } if (ht.Add_Key("isPush")) { sbSql4org.Append(" and isPush=" + ht["isPush"].SafeToString()); } if (ht.Add_Key("IsDelete")) { sbSql4org.Append(" and IsDelete=@IsDelete"); List.Add(new SqlParameter("@IsDelete", ht["IsDelete"].ToString())); } if (ht.Add_Key("ImgUrl")) { sbSql4org.Append(" and (ImageUrl is not null and ImageUrl!='')"); } if (ht.Add_Key("NotItem")) { sbSql4org.Append(" and ([MenuId] not in (" + ht["NotItem"].ToString() + "))"); } DataTable dt = SQLHelp.ExecuteDataTable(sbSql4org.ToString(), CommandType.Text, List.ToArray()); return(dt); } catch (Exception ex) { LogHelper.Error(ex); return(null); } }
public void GetMenuOwnLevel(HttpContext context) { PMSModel.JsonModel jsonModel = null; PMSModel.JsonModel Model = null; HttpRequest request = context.Request; try { if (menu == null) { HashtableCustom ht1 = new HashtableCustom(); ht1.Add(TableName, PortalTreeData); string where = string.Empty; bool isPage = false; if (!string.IsNullOrWhiteSpace(request["MenuLevelIndex"])) { where += " and MenuLevelIndex=" + request["MenuLevelIndex"]; } if (!string.IsNullOrWhiteSpace(request[Display])) { where += " and Display=" + request[Display]; } if (!string.IsNullOrWhiteSpace(request[IsDelete])) { where += " and IsDelete=" + request[IsDelete]; } ht1.Add(Order, " SortId desc ,CreateTime desc,ShowIndexSort desc "); //获取菜单数据 Model = BllPTDS.GetPage(ht1, isPage, where); List <Dictionary <string, object> > dic = Model.retData as List <Dictionary <string, object> >; List <MenuLevelModel> menuLevelModelList = new List <MenuLevelModel>(); foreach (var item in dic) { #region 获取数据或IDs HashtableCustom ht2 = new HashtableCustom(); ht2.Add_Key(Display, request); ht2.Add_Key(IsDelete, request); ht2.Add(TableName, PortalTreeData); ht2.Add(Order, " SortId asc ,CreateTime desc "); string where2 = string.Empty; if (!string.IsNullOrWhiteSpace(request[Display])) { where2 += " and Display=" + request[Display]; } if (!string.IsNullOrWhiteSpace(request[IsDelete])) { where2 += " and IsDelete=" + request[IsDelete]; } //跳级获取,listChild 如果为null 说明只有两级(获取三级数据) where2 = string.Format(" and Id in(select pid from PortalTreeData where pid in(select id from PortalTreeData where PId ={0}) group by PId)", item[Id]); ht2.Add(MenuIds, item[Id]); var moder = BllPTDS.GetPage(ht2, isPage, where2); string ids = BllAdvert.GetIDS(ht2); #endregion //菜单级别数据(携带跳级数据) MenuLevelModel menLevelModel = null; if (Convert.ToString(moder.retData) != string.Empty) { menLevelModel = new MenuLevelModel() { ChildList = moder.retData, IsMore2Level = true }; } else { menLevelModel = new MenuLevelModel() { IsMore2Level = false }; } menLevelModel.Id_Bottom_List = ids; #region 实体属性 menLevelModel.Id = Convert.ToInt32(item[Id]); menLevelModel.Name = Convert.ToString(item[Name]); menLevelModel.CreateTime = Convert.ToDateTime(item[CreateTime]); menLevelModel.Creator = Convert.ToString(item["Creator"]); menLevelModel.PId = Convert.ToInt32(item["PId"]); menLevelModel.BeforeUrl = Convert.ToString(item["BeforeUrl"]); menLevelModel.BeforeAfter = Convert.ToInt32(item["BeforeAfter"]); menLevelModel.AfterUrl = Convert.ToString(item["AfterUrl"]); menLevelModel.SortId = Convert.ToInt32(item[SortId]); menLevelModel.DisplayCount = Convert.ToInt32(item["DisplayCount"]); menLevelModel.DisplayType = Convert.ToString(item["DisplayType"]); menLevelModel.MenuLevelIndex = Convert.ToInt32(item["MenuLevelIndex"]); menLevelModel.ShowIndexSort = Convert.ToInt32(item["ShowIndexSort"]); #endregion menuLevelModelList.Add(menLevelModel); } jsonModel = new PMSModel.JsonModel() { retData = menuLevelModelList, errMsg = "success" }; menu = jsonModel; } else { jsonModel = menu; } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, retData = "", status = "no" }; } finally { if (jsonModel == null) { jsonModel = new JsonModel(); } context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 不需要传IDS和PageSize(根据菜单获取所有数据) /// </summary> /// <param name="context"></param> public void GetMenusItemsData(HttpContext context) { HttpRequest request = context.Request; HashtableCustom ht1 = new HashtableCustom(); List <IndexModelEntity> IndexModelEntityList = new List <IndexModelEntity>(); PMSModel.JsonModel jsonModel = new PMSModel.JsonModel(); PMSModel.JsonModel Model = new PMSModel.JsonModel(); try { #region 获取首页导读的一级菜单(包括了三级的菜单)||获取指定菜单ID的二级菜单(通过一级菜单的ID去获取) ht1.Add(TableName, PortalTreeData); string where = string.Empty; bool isPage = false; if (!string.IsNullOrWhiteSpace(request[Display])) { where += " and Display=" + request[Display]; } if (!string.IsNullOrWhiteSpace(request[IsDelete])) { where += " and IsDelete=" + request[IsDelete]; } if (!string.IsNullOrWhiteSpace(request[IsShowIndex])) { where += " and IsShowIndex=" + request[IsShowIndex]; } else if (!string.IsNullOrWhiteSpace(request[MenuIds])) { where += string.Format(" and PId in({0}) ", request[MenuIds]); } //获取显示在首页导读工作区域的菜单 ht1.Add(Order, " ShowIndexSort asc, SortId desc ,CreateTime desc "); Model = BllPTDS.GetPage(ht1, isPage, where); #endregion List <Dictionary <string, object> > dic = Model.retData as List <Dictionary <string, object> >; foreach (var item in dic) { IndexModelEntity indexModielEntity = new IndexModelEntity(); #region 实体属性 indexModielEntity.Id = Convert.ToInt32(item[Id]); indexModielEntity.Name = Convert.ToString(item[Name]); indexModielEntity.CreateTime = Convert.ToDateTime(item[CreateTime]); indexModielEntity.Creator = Convert.ToString(item["Creator"]); indexModielEntity.PId = Convert.ToInt32(item["PId"]); indexModielEntity.BeforeUrl = Convert.ToString(item["BeforeUrl"]); indexModielEntity.BeforeAfter = Convert.ToInt32(item["BeforeAfter"]); indexModielEntity.AfterUrl = Convert.ToString(item["AfterUrl"]); indexModielEntity.SortId = Convert.ToInt32(item[SortId]); indexModielEntity.DisplayCount = Convert.ToInt32(item["DisplayCount"]); indexModielEntity.DisplayType = Convert.ToString(item["DisplayType"]); indexModielEntity.MenuLevelIndex = Convert.ToInt32(item["MenuLevelIndex"]); indexModielEntity.ShowIndexSort = Convert.ToInt32(item["ShowIndexSort"]); #endregion #region 获取导读数据(后台获取限制数据的条数) int displayCount = 0; if (request["DisplayCount"] != null) { displayCount = Convert.ToInt32(request["DisplayCount"]); } else { displayCount = Convert.ToInt32(item["DisplayCount"]); } HashtableCustom ht2 = new HashtableCustom(); ht2.Add(MenuIds, item[Id]); ht2.Add(MenuId, item[Id]); ht2.Add(PageSize, displayCount); ht2.Add_Key(IsDelete, request); ht2.Add_Key(isPush, request); ht2.Add(PageIndex, 1); if (!string.IsNullOrWhiteSpace(request[IsShowIndex])) { //获取三级数据,没有则获取二级数据 var moder = BllAdvert.GetDataMore_LevelInfo(ht2); indexModielEntity.ListData = moder.retData; } else if (!string.IsNullOrWhiteSpace(request[MenuIds])) { //获取直接二级数据,没有则获取二级数据 var moder = BllAdvert.GetAdvertData(ht2); indexModielEntity.ListData = moder.retData; } #endregion IndexModelEntityList.Add(indexModielEntity); } jsonModel = new PMSModel.JsonModel() { retData = IndexModelEntityList, errMsg = "success" }; } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, }; } finally { context.Response.Write("{\"result\":" + Hander_C.jss.Serialize(jsonModel) + "}"); } }
/// <summary> /// 获得新闻或菜单下的分类信息。 /// </summary> /// <param name="context"></param> public void GetPageList(HttpContext context) { HttpRequest request = context.Request; PMSModel.JsonModel jsonModel = null; HashtableCustom ht = new HashtableCustom(); try { bool is_Page = true; bool is_All = false; ht.Add_Key(PageIndex, request); ht.Add_Key(PageSize, request); if (!Null_Check(request, isPage)) { is_Page = Convert.ToBoolean(request[isPage]); } if (!Null_Check(request, isAll)) { is_All = Convert.ToBoolean(request[isAll]); } if (is_All) { ht.Add_Key(MenuId, request); ht.Add(IsDelete, (int)PMSUtility.SysStatus.正常); ht.Add_Key(isPush, request); jsonModel = BllAdvert.GetAdvertPageList(ht); } else { ht.Add(TableName, Advertising); string where = string.Empty; if (!Null_Check(request, MenuId)) { where += " and [MenuId]=" + request[MenuId]; } where += " and IsDelete =" + (int)PMSUtility.SysStatus.正常; if (!Null_Check(request, isPush)) { where += " and isPush=" + request[isPush].SafeToString(); } if (!Null_Check(request, MenuIds)) { where += " and [MenuId] in (" + request[MenuIds].SafeToString() + ")"; } if (!Null_Check(request, ImageUrl)) { where += " and(ImageUrl is not null and ImageUrl != '')"; } ht.Add(Order, " MenuId asc,SortId desc ,CreateTime desc "); jsonModel = BllAdvert.GetPage(ht, is_Page, where); } } catch (Exception ex) { LogHelper.Error(ex); jsonModel = new PMSModel.JsonModel() { errMsg = ex.Message, retData = "", status = "no" }; } finally { if (jsonModel == null) { jsonModel = new PMSModel.JsonModel(); } ht.Clear(); string js = Hander_C.jss.Serialize(jsonModel); context.Response.Write("{\"result\":" + js + "}"); } }