///描述:获取其它收支信息
///作者:许
///时间:2018-04-27
/// </summary>
private void GetOtherInoutList()
{
BLL_T_CW_OTHERINOUT bll = new BLL_T_CW_OTHERINOUT(this.ol);
bll.GetOtherInoutList(pi);
Value = pi.ToJson();
}
/// <summary>
///描述:获取其它收支信息
///作者:许
///时间:2018-04-27
/// </summary>
public void GetOtherInoutList(PagerInfo pi)
{
dal.GetOtherInoutList(pi);
}
/// <summary>
/// 描述:获取其它收支信息
/// 作者:许
/// 时间:2018-04-27
/// </summary>
/// <param name="pi"></param>
public void GetOtherInoutList(PagerInfo pi)
{
var query = from a in db.T_CW_OTHERINOUT
join b in db.T_BASE_SUPPLY on a.I_ID_SUPPLY equals b.ID
orderby a.VC_NO descending
select new GRID_OTHERINOUT
{
ID=a.ID,
I_ID_SUPPLY=b.ID,
I_STATE=a.I_STATE,
VC_NO=a.VC_NO,
NVC_NAME = b.NVC_NAME,
N_MONEY=a.N_MONEY,
DT_MONEY=a.DT_MONEY,
VC_REMARK=a.VC_REMARK
};
query = query.Filter(pi, ol, "ID");
pi.totalCount = query.Count();
var list = query.Skip(pi.start).Take(pi.limit).ToList();
pi.data = list;
}