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