日期:2014-05-20 浏览次数:20814 次
aList = aObj.GetListInfo(condition, "");
uList = uObj.GetListInfo("", "");
mList = mObj.GetListInfo("", "");
var result = from p in aList
join q in uList on p.i_client_id equals q.UserId
join m in mList on q.UserId equals m.BeatedUserID
select new
{
p.i_datetime,
p.i_client_id,
money = p.i_op_id == "客户入金" ? p.e_post_bala.ToString() : "",
money2 = p.i_op_id == "客户入金" ? p.e_post_bala.ToString() : "",
money3 = p.i_op_id == "申请出金" ? p.e_post_bala.ToString() : "",
money4 = p.i_op_id == "客户出金" ? p.e_post_bala.ToString() : "",