public ExecResult Del(SiteResourceQuery query)
{
ExecResult execResult = new ExecResult();
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
Int64[] ResourceIDs = query.ResourceIDs;
if (ResourceIDs == null)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "没有删除任何数据！";
return(execResult);
}
string msg = string.Empty;
bool result = service.BatchDeleteSiteResource(ResourceIDs);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "删除资源文件成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "删除资源文件失败！";
}
return(execResult);
}
public IList <SiteResourceEntity> GetList(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
IList <SiteResourceEntity> list = service.GetSiteResourceList(query);
return(list);
}
public SiteResourceEntity GetModel(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
SiteResourceEntity model = service.GetSiteResourceModel(query);
return(model);
}
public Pager <SiteResourceEntity> GetPageList(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
Pager <SiteResourceEntity> pager = service.GetSiteResourcePageList(query);
return(pager);
}
public ActionResult GetList(SiteResourceQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList <SiteResourceEntity> list = service.GetSiteResourceList(query);
return(Json(new { list }));
}
/// <summary>
/// 获取条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetSiteResourceFilter(SiteResourceQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID=" + query.JournalID);
if (query.ChannelID > 0)
{
strFilter.AppendFormat(" and ChannelID={0}", query.ChannelID);
}
return(strFilter.ToString());
}
public ActionResult Delete(Int64[] ResourceIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
SiteResourceQuery query = new SiteResourceQuery();
query.JournalID = CurAuthor.JournalID;
query.ResourceIDs = ResourceIDs;
ExecResult result = service.DelSiteResource(query);
return(Json(new { result = result.result, msg = result.msg }));
}
public ActionResult GetPageList(SiteResourceQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager <SiteResourceEntity> pager = service.GetSiteResourcePageList(query);
return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }));
}
/// <summary>
/// 获取资源数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
string strSql = "SELECT * FROM dbo.SiteResource with(nolock)";
string whereSQL = GetSiteResourceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by ResourceID";
return(db.GetList <SiteResourceEntity>(strSql, MakeSiteResourceList));
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
SiteResourceEntity item = null;
string strSql = string.Format("SELECT TOP 1 * FROM dbo.SiteResource with(nolock) WHERE ResourceID=@ResourceID AND JournalID=@JournalID");
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
db.AddInParameter(cmd, "@ResourceID", DbType.Int64, query.ResourceID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
{
item = MakeSiteResourceModel(dr);
}
}
return(item);
}
private SiteResourceEntity GetModel(Int64 ResourceID)
{
SiteResourceEntity model = null;
if (ResourceID > 0)
{
SiteResourceQuery query = new SiteResourceQuery();
query.JournalID = CurAuthor.JournalID;
query.ResourceID = ResourceID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetSiteResourceModel(query);
}
if (model == null)
{
model = new SiteResourceEntity();
}
return(model);
}
/// <summary>
/// 获取资源分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <SiteResourceEntity> GetSiteResourcePageList(SiteResourceQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY ResourceID DESC) AS ROW_ID FROM dbo.SiteResource with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.SiteResource with(nolock)";
string whereSQL = GetSiteResourceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return(db.GetPageList <SiteResourceEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeSiteResourceList));
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
return(SiteResourceBusProvider.GetSiteResourceModel(query));
}
/// <summary>
/// 获取资源数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
return(SiteResourceBusProvider.GetSiteResourceList(query));
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
return(SiteResourceDataAccess.Instance.GetSiteResourceModel(query));
}
/// <summary>
/// 获取资源数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
return(SiteResourceDataAccess.Instance.GetSiteResourceList(query));
}
