/// <summary>
/// 获取明细列表
/// </summary>
/// <param name="IcpGoodsSysNo">系统编号</param>
/// <returns>明细列表</returns>
/// <remarks>2016-03-24 王耀发 创建</remarks>
public override Pager <CBIcpGoodsItem> IcpGoodsItemQuery(ParaIcpGoodsFilter filter)
{
const string sql = @"(select gi.SysNo,gi.IcpType, pd.ErpCode,pd.ProductName,i.MessageType,gi.MessageID,gi.CreatedDate,
case isnull(i.PlatStatus,'') when '' then '待审核' when 10 then '通过' when 20 then '不通过' END as PlatStatus,case isnull(i.CiqStatus,'') when '' then '待审核' when 10 then '通过' when 20 then '不通过' END as CiqStatus
from
(
select * from IcpGoodsItem where IcpGoodsSysNo in (select SysNo from Icp where [Status] <> -1 and MessageType = '661105')
) gi left join Icp i on gi.IcpGoodsSysNo = i.SysNo
left join PdProduct pd on gi.ProductSysNo = pd.SysNo
where
(@0 is null or gi.IcpType = @0) and
(@1 is null or pd.ErpCode = @1)
) tb";
var paras = new object[]
{
filter.IcpType,
filter.Condition
};
var dataList = Context.Select <CBIcpGoodsItem>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBIcpGoodsItem>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.Id, filter.PageSize).QueryMany()
};
return(pager);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public override Pager <CIcp> OrderQuery(ParaIcpGoodsFilter filter)
{
const string sql = @"(select * from Icp
where
(@0 is null or IcpType = @0) and
(@1 is null or MessageType = @1) and
SourceSysNo <> 0 and
(@2 is null or convert(nvarchar(50),SysNo) = @2 or convert(nvarchar(50),SourceSysNo) = @2 or MessageID = @2)
) tb";
var paras = new object[]
{
filter.IcpType,
filter.MessageType,
filter.Condition
};
var dataList = Context.Select <CIcp>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CIcp>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.Id, filter.PageSize).QueryMany()
};
return(pager);
}
public ActionResult DoIcpOrderPaging(ParaIcpGoodsFilter filter)
{
filter.PageSize = 10;
var pager = new Pager <CIcp>();
if (filter.IcpType == null)
{
pager = IcpBo.Instance.GetOrderPagerList(filter);
}
else
{
pager = BLL.ApiFactory.ApiProviderFactory.GetIcqInstance((int)filter.IcpType).GetOrderPagerList(filter);
}
var list = new PagedList <CIcp>
{
PageSize = filter.PageSize,
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows
};
return(PartialView("_IcpOrderPager", list));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public override Pager <CIcp> GetOrderPagerList(ParaIcpGoodsFilter filter)
{
filter.MessageType = "KJ881111";
return(IcpDao.Instance.OrderQuery(filter));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public virtual Pager <CBIcpGoodsItem> IcpGoodsItemQuery(ParaIcpGoodsFilter filter)
{
return(new Pager <CBIcpGoodsItem>());
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public virtual Pager <CIcp> GetOrderPagerList(ParaIcpGoodsFilter filter)
{
return(new Pager <CIcp>());
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public Pager <CBIcpGoodsItem> IcpGoodsItemQuery(ParaIcpGoodsFilter filter)
{
return(IcpDao.Instance.IcpGoodsItemQuery(filter));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public Pager <CIcp> GetOrderPagerList(ParaIcpGoodsFilter filter)
{
return(IcpDao.Instance.OrderQuery(filter));
}
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2016-3-23 王耀发 创建</remarks> public abstract Pager <CBIcpGoodsItem> IcpGoodsItemQuery(ParaIcpGoodsFilter filter);
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2016-3-23 王耀发 创建</remarks> public abstract Pager <CIcp> OrderQuery(ParaIcpGoodsFilter filter);
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public override Pager <CBIcpGoodsItem> IcpGoodsItemQuery(ParaIcpGoodsFilter filter)
{
filter.MessageType = "661101";
return(IcpDao.Instance.IcpGoodsItemQuery(filter));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public override Pager <CIcp> GetGoodsPagerList(ParaIcpGoodsFilter filter)
{
filter.MessageType = "661105";
return(IcpDao.Instance.GoodsQuery(filter));
}
