/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
public override Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter)
{
var where = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
where += " and dea.SysNo = " + filter.DealerSysNo;
}
else
{
where += " and dea.CreatedBy = " + filter.DealerCreatedBy;
}
}
if (filter.SelectedAgentSysNo != -1)
{
if (filter.SelectedDealerSysNo != -1)
{
where += " and dea.SysNo = " + filter.SelectedDealerSysNo;
}
else
{
where += " and dea.CreatedBy = " + filter.SelectedAgentSysNo;
}
}
string sql = @"(select a.*,(select SysNo from fnreceiptvoucher where Source = 20 and SourceSysNo = a.SysNo) as FnReceiptVoucherSysNo,dea.DealerName
from DsDealerBailOrder a
left join CrCustomer c on a.CustomerSysNo = c.SysNo
left join DsDealer dea on c.DealerSysNo = dea.SysNo
where " + where + " and ((@0 is null or charindex(a.ContactName,@1)>0) or (@2 is null or charindex(a.ContactWay,@3)>0) )) tb";
var dataList = Context.Select <CBDsDealerBailOrder>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.ContactName, filter.ContactName,
filter.ContactWay, filter.ContactWay
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBDsDealerBailOrder>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.CreateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
public ActionResult DoDsDealerBailOrderQuery(ParaDsDealerBailOrderFilter filter)
{
//当前用户对应分销商，2015-12-19 王耀发 创建
if (CurrentUser.IsBindDealer)
{
int DealerSysNo = CurrentUser.Dealer.SysNo;
filter.DealerSysNo = DealerSysNo;
filter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
filter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
filter.DealerCreatedBy = CurrentUser.Base.SysNo;
filter.PageSize = 10;
var pager = DsDealerBailOrderBo.Instance.Query(filter);
var list = new PagedList <CBDsDealerBailOrder>
{
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows
};
return(PartialView("_DsDealerBailOrderPager", list));
}
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> public abstract Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter);
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
public Pager <CBDsDealerBailOrder> Query(ParaDsDealerBailOrderFilter filter)
{
return(IDsDealerBailOrderDao.Instance.Query(filter));
}
