/// <summary>
/// 查询采购单
/// </summary>
/// <param name="para">查询参数</param>
/// <returns></returns>
/// <remarks>2016-6-21 杨浩 增加查询条件</remarks>
public override Pager <CBPrPurchaseReturn> QueryPrPurchaseReturn(ParaPrPurchaseReturnFilter para)
{
var paras = new List <object>();
string whereStr = " where 1=1 ";
if (para.WarehouseSysNo > 0)
{
whereStr += " and phr.WarehouseSysNo=@" + paras.Count;
paras.Add(para.WarehouseSysNo);
}
if (!string.IsNullOrEmpty(para.PurchaseCode) && para.PurchaseCode != "")
{
whereStr += " and ph.PurchaseCode=@" + paras.Count;
paras.Add(para.PurchaseCode);
}
if (para.Status != 0)
{
whereStr += " and phr.Status=@" + paras.Count;
paras.Add(para.Status);
}
//if (para.CreatedDate.HasValue)
//{
// whereStr += " and phr.CreatedDate=@" + paras.Count;
// paras.Add(para.CreatedDate);
//}
string sql = @"
(
select phr.*,wh.BackWarehouseName,ph.PurchaseCode from PrPurchaseReturn as phr
left join WhWarehouse as wh on wh.SysNo=phr.WarehouseSysNo
left join PrPurchase ph on phr.PurchaseSysNo = ph.SysNo " + whereStr + ") tb";
var dataList = Context.Select <CBPrPurchaseReturn>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras.ToArray());
dataCount.Parameters(paras.ToArray());
var pager = new Pager <CBPrPurchaseReturn>
{
PageSize = para.PageSize,
CurrentPage = para.Id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.sysNo desc").Paging(para.Id, para.PageSize).QueryMany()
};
return(pager);
}
/// <summary>
/// 查询采购退货单
/// </summary>
/// <param name="para">查询参数</param>
/// <returns></returns>
public PagedList <CBPrPurchaseReturn> QueryPrPurchaseReturn(ParaPrPurchaseReturnFilter para)
{
PagedList <CBPrPurchaseReturn> model = null;
if (para != null)
{
model = new PagedList <CBPrPurchaseReturn>();
var pager = IPrPurchaseReturnDao.Instance.QueryPrPurchaseReturn(para);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = para.Id;
}
}
return(model);
}
public ActionResult PurchaseReturnList(ParaPrPurchaseReturnFilter para)
{
if (Request.IsAjaxRequest())
{
para.Id = para.Id > 0 ? para.Id : 1;
var pageList = BLL.Purchase.PrPurchaseReturnBo.Instance.QueryPrPurchaseReturn(para);
return(PartialView("_AjaxPagerPurchaseReturnList", pageList));
}
else
{
//采购单状态下拉绑定数据
var statustList = new List <SelectListItem>()
{
new SelectListItem()
{
Text = @"全部", Value = "0", Selected = true
}
};
EnumUtil.ToListItem <PurchaseStatus.采购退货单状态>(ref statustList);
ViewData["Status"] = new SelectList(statustList, "Value", "Text");
}
return(View());
}
/// <summary> /// 查询采购单 /// </summary> /// <param name="para">查询参数</param> /// <returns></returns> public abstract Pager <CBPrPurchaseReturn> QueryPrPurchaseReturn(ParaPrPurchaseReturnFilter para);
