public IList <SiteChannelEntity> GetList(SiteChannelQuery query) { ISiteChannelService service = ServiceContainer.Instance.Container.Resolve <ISiteChannelService>(); IList <SiteChannelEntity> list = service.GetSiteChannelList(query); return(list); }
public SiteChannelEntity GetModel(SiteChannelQuery query) { ISiteChannelService service = ServiceContainer.Instance.Container.Resolve <ISiteChannelService>(); SiteChannelEntity model = service.GetSiteChannel(query); return(model); }
public List <SiteChannelEntity> GetSiteChannelList(SiteChannelQuery query) { List <SiteChannelEntity> list = new List <SiteChannelEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT ChannelID,JournalID,PChannelID,ContentType,IsNav,Keywords,Description,ChannelUrl,SortID,Status,AddDate FROM dbo.SiteChannel WITH(NOLOCK)"); string whereSQL = SiteChannelQueryToSQLWhere(query); string orderBy = SiteChannelQueryToSQLOrder(query); if (!string.IsNullOrEmpty(whereSQL)) { sqlCommandText.Append(" WHERE " + whereSQL); } if (!string.IsNullOrEmpty(orderBy)) { sqlCommandText.Append(" ORDER BY " + orderBy); } DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using (IDataReader dr = db.ExecuteReader(cmd)) { list = MakeSiteChannelList(dr); } return(list); }
public ActionResult GetTree() { SiteChannelQuery query = new SiteChannelQuery(); query.JournalID = JournalID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); return(Content(JsonConvert.SerializeObject(service.GetSiteChannelTreeList(query)))); }
public ActionResult Delete(Int64 ChannelID) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); SiteChannelQuery query = new SiteChannelQuery(); query.JournalID = CurAuthor.JournalID; query.ChannelID = ChannelID; ExecResult result = service.DelSiteChannel(query); return(Json(new { result = result.result, msg = result.msg })); }
public SiteChannelEntity GetSiteChannel(SiteChannelQuery query) { SiteChannelEntity siteChannelEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 ChannelID,JournalID,PChannelID,ContentType,IsNav,Keywords,Description,ChannelUrl,SortID,Status,AddDate FROM dbo.SiteChannel WITH(NOLOCK)"); sqlCommandText.Append(" WHERE " + SiteChannelQueryToSQLWhere(query)); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using (IDataReader dr = db.ExecuteReader(cmd)) { siteChannelEntity = MakeSiteChannel(dr); } return(siteChannelEntity); }
public Pager <SiteChannelEntity> GetSiteChannelPageList(SiteChannelQuery query) { int recordCount = 0; string whereSQL = SiteChannelQueryToSQLWhere(query); string orderBy = SiteChannelQueryToSQLOrder(query); DataSet ds = db.GetPagingData("SiteChannel", "ChannelID,JournalID,PChannelID,ContentType,IsNav,Keywords,Description,ChannelUrl,SortID,Status,AddDate", orderBy, whereSQL, query.CurrentPage, query.PageSize, out recordCount); Pager <SiteChannelEntity> pager = new Pager <SiteChannelEntity>(); if (ds != null && ds.Tables.Count > 0) { pager.ItemList = MakeSiteChannelList(ds.Tables[0]); } pager.CurrentPage = query.CurrentPage; pager.PageSize = query.PageSize; pager.TotalRecords = recordCount; return(pager); }
private SiteChannelEntity GetModel(Int64 ChannelID) { SiteChannelEntity model = null; if (ChannelID > 0) { SiteChannelQuery query = new SiteChannelQuery(); query.JournalID = CurAuthor.JournalID; query.ChannelID = ChannelID; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetSiteChannelModel(query); } if (model == null) { model = new SiteChannelEntity(); } return(model); }
public ExecResult Del(SiteChannelQuery query) { ExecResult execResult = new ExecResult(); ISiteChannelService service = ServiceContainer.Instance.Container.Resolve <ISiteChannelService>(); bool result = service.DeleteSiteChannel(query.ChannelID.Value); if (result) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "删除栏目成功!"; } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "删除栏目失败!"; } return(execResult); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string SiteChannelQueryToSQLWhere(SiteChannelQuery query) { StringBuilder sbWhere = new StringBuilder(" JournalID=" + query.JournalID); if (query.ChannelID != null && query.ChannelID > 0) { sbWhere.Append(" AND ChannelID = ").Append(query.ChannelID.Value); } if (query.Status != null) { sbWhere.Append(" AND Status = ").Append(query.Status.Value); } if (query.IsNav != null) { sbWhere.Append(" AND IsNav = ").Append(query.IsNav.Value); } if (!string.IsNullOrEmpty(query.ChannelUrl)) { sbWhere.Append(" AND ChannelUrl = '").Append(WKT.Common.Security.SecurityUtils.SafeSqlString(query.ChannelUrl)).Append("'"); } return(sbWhere.ToString()); }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="siteChannelQuery">SiteChannelQuery查询实体对象</param> /// <returns>List<SiteChannelEntity></returns> public List <SiteChannelEntity> GetSiteChannelList(SiteChannelQuery siteChannelQuery) { return(SiteChannelBusProvider.GetSiteChannelList(siteChannelQuery)); }
/// <summary> /// 获取一个实体对象 /// </summary> /// <param name="channelID"></param> /// <returns>获取一个实体,如果数据不存在返回Null</returns> public SiteChannelEntity GetSiteChannel(SiteChannelQuery query) { return(SiteChannelBusProvider.GetSiteChannel(query)); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="siteChannelQuery">SiteChannelQuery查询实体对象</param> /// <returns>Pager<SiteChannelEntity></returns> public Pager <SiteChannelEntity> GetSiteChannelPageList(SiteChannelQuery siteChannelQuery) { return(SiteChannelDataAccess.Instance.GetSiteChannelPageList(siteChannelQuery)); }
/// <summary> /// 获取一个实体对象 /// </summary> /// <param name="channelID"></param> /// <returns>获取一个实体,如果数据不存在返回Null</returns> public SiteChannelEntity GetSiteChannel(SiteChannelQuery query) { return(SiteChannelDataAccess.Instance.GetSiteChannel(query)); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string SiteChannelQueryToSQLOrder(SiteChannelQuery query) { return(" SortID ASC,ChannelID DESC"); }