/// <summary>
/// 获取历史数据列表
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public string GetHisData(HisReq req)
{
var user = JsonConvert.DeserializeObject <AllInOne_UserInfo>(Session["user"].ToString());
req.lastName = req.lastName ?? user.name;
var r = AllFunc.Instance.GetFMList(req, user);
if (r.HttpCode == 200)
{
Session["HisReq"] = JsonConvert.SerializeObject(req);
}
return(JsonConvert.SerializeObject(r));
}
public Respbase <List <MySvchisDto> > GetMySvchis(HisReq req)
{
// tblc_centcard_his
PXinContext db = HttpContext.Current.GetDbContext <PXinContext>();
var query = from tc in db.TblcCentcardSet
join th in db.TblcCentcardHisSet on tc.Idno equals th.Idno
join tr in db.TnetReginfoSet on th.Nodeid equals tr.Nodeid into trdata
from trf in trdata.DefaultIfEmpty()
where tc.Usenodeid == req.Nodeid || th.Opnodeid == req.Nodeid
orderby th.Createtime descending
select new MySvchisDto
{
Amount = (decimal)tc.Amount,
Typeid = th.Typeid == 1 && th.Nodeid == req.Nodeid ? 4 : th.Typeid,
Note = th.Note,
CreateTime = th.Createtime,
Cardno = tc.Cardno,
AmountType = "SV",
NodeCode = trf.Nodecode
};
List <MySvchisDto> result = null;
if (req.TypeId != -1)
{
if (req.TypeId == 0)
{
result = query.Where(c => c.Typeid == 0 || c.Typeid == 2 || c.Typeid == 3 || c.Typeid == 4 || c.Typeid == 7 || c.Typeid == 8 || c.Typeid == 9 || c.Typeid == 10 || c.Typeid == 11).Skip((req.PageNum - 1) * req.PageSize).Take(req.PageSize).ToList();
}
else
{
result = query.Where(c => c.Typeid == req.TypeId).Skip((req.PageNum - 1) * req.PageSize).Take(req.PageSize).ToList();
}
}
else
{
result = query.Skip((req.PageNum - 1) * req.PageSize).Take(req.PageSize).ToList();
}
if (result != null)
{
return(new Respbase <List <MySvchisDto> > {
Data = result, Result = 1, Message = "成功"
});
}
return(new Respbase <List <MySvchisDto> > {
Result = -1, Message = "未找到数据"
});
}