/// <summary>
/// 通过条件获取联盟网站列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>联盟网站列表</returns>
/// <remarks>2013-10-16 周唐炬 创建</remarks>
public override Pager <UnUnionSite> GetUnionSiteList(ParaUnUnionSiteFilter filter)
{
// const string sql = @"(SELECT A.*
// FROM UnUnionSite A
// WHERE (@p0p0 IS NULL OR A.STATUS = @p0p0)
// AND (@p0p1 IS NULL OR REGEXP_charindex(A.SiteName, @p0p1, 1, 1, 1, 'i') > 0)
// ) tb";
const string sql = @"(SELECT A.*
FROM UnUnionSite A
WHERE (@0 IS NULL OR A.STATUS = @0)
AND (@1 IS NULL OR CHARINDEX(','+A.SiteName+',',','+CAST(@1 as VARCHAR(255))+',') > 0)
) tb";
var dataList = Context.Select <UnUnionSite>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.Status,
filter.SiteName
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <UnUnionSite>
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
/// <summary>
/// 通过条件获取联盟网站列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>联盟网站列表</returns>
/// <remarks>2013-10-16 周唐炬 创建</remarks>
public PagedList <UnUnionSite> GetUnionSiteList(ParaUnUnionSiteFilter filter)
{
if (filter != null)
{
var model = new PagedList <UnUnionSite>();
filter.PageSize = model.PageSize;
var pager = IUnUnionSiteDao.Instance.GetUnionSiteList(filter);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = filter.CurrentPage;
}
return(model);
}
return(null);
}
public ActionResult UnionSiteManage(int?id, ParaUnUnionSiteFilter filter)
{
try
{
if (Request.IsAjaxRequest())
{
filter.CurrentPage = id ?? 1;
var list = UnUnionSiteBo.Instance.GetUnionSiteList(filter);
return(PartialView("_UnionSiteList", list));
}
InitUnionSitePageViewData(true, null);
}
catch (Exception ex)
{
SysLog.Instance.Error(LogStatus.系统日志来源.后台, "联盟网站管理" + ex.Message, LogStatus.系统日志目标类型.联盟网站, CurrentUser.Base.SysNo, ex);
}
return(View());
}
/// <summary> /// 通过条件获取联盟网站列表 /// </summary> /// <param name="filter">过滤条件</param> /// <returns>联盟网站列表</returns> /// <remarks>2013-10-16 周唐炬 创建</remarks> public abstract Pager <UnUnionSite> GetUnionSiteList(ParaUnUnionSiteFilter filter);
