public PageModel <CapitalInfo> GetCapitals(CapitalQuery query)
{
IQueryable <CapitalInfo> capitalInfo =
from e in context.CapitalInfo
where true
select e;
if (query.memberId.HasValue)
{
capitalInfo =
from e in context.CapitalInfo
where e.MemId == query.memberId
select e;
}
int num = 0;
IQueryable <CapitalInfo> page = capitalInfo.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <CapitalInfo> o) =>
from e in o
orderby e.Id descending
select e);
return(new PageModel <CapitalInfo>()
{
Models = page,
Total = num
});
}
public ObsoletePageModel <CapitalInfo> GetCapitals(CapitalQuery query)
{
var capital = Context.CapitalInfo.Where(e => true);
if (query.memberId.HasValue)
{
capital = Context.CapitalInfo.Where(e => e.MemId == query.memberId);
}
int total = 0;
var page = capital.GetPage(out total, query.PageNo, query.PageSize, o => o.OrderByDescending(e => e.Id));
ObsoletePageModel <CapitalInfo> result = new ObsoletePageModel <CapitalInfo> {
Models = page, Total = total
};
return(result);
}
public JsonResult GetMemberCapitals(string user, int page, int rows)
{
var capitalService = _iMemberCapitalService;
var memberService = _iMemberService;
long?membid = null;
if (!string.IsNullOrWhiteSpace(user))
{
var memberInfo = memberService.GetMemberByName(user) ?? new UserMemberInfo()
{
Id = 0
};
membid = memberInfo.Id;
}
var query = new CapitalQuery
{
PageNo = page,
PageSize = rows,
Sort = "Balance",
memberId = membid
};
var pagemodel = capitalService.GetCapitals(query);
var model = pagemodel.Models.ToList().Select(e =>
{
var member = memberService.GetMember(e.MemId);
return(new CapitalModel
{
Balance = e.Balance.Value,
ChargeAmount = e.ChargeAmount.HasValue ? e.ChargeAmount.Value : 0.00M,
FreezeAmount = e.FreezeAmount.HasValue ? e.FreezeAmount.Value : 0.00M,
Id = e.Id,
UserId = e.MemId,
UserCode = member.UserName,
UserName = string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName
});
});
var models = new DataGridModel <CapitalModel>
{
rows = model,
total = pagemodel.Total
};
return(Json(models));
}
public JsonResult GetMemberCapitals(string user, int page, int rows)
{
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
IMemberService memberService = ServiceHelper.Create <IMemberService>();
long?nullable = null;
if (!string.IsNullOrWhiteSpace(user))
{
nullable = new long?((memberService.GetMemberByName(user) ?? new UserMemberInfo()
{
Id = 0
}).Id);
}
CapitalQuery capitalQuery = new CapitalQuery()
{
PageNo = page,
PageSize = rows,
Sort = "Balance",
memberId = nullable
};
PageModel <CapitalInfo> capitals = memberCapitalService.GetCapitals(capitalQuery);
IEnumerable <CapitalModel> capitalModels = capitals.Models.ToList().Select <CapitalInfo, CapitalModel>((CapitalInfo e) =>
{
UserMemberInfo member = memberService.GetMember(e.MemId);
return(new CapitalModel()
{
Balance = e.Balance.Value,
ChargeAmount = (e.ChargeAmount.HasValue ? e.ChargeAmount.Value : new decimal(0, 0, 0, false, 2)),
FreezeAmount = (e.FreezeAmount.HasValue ? e.FreezeAmount.Value : new decimal(0, 0, 0, false, 2)),
Id = e.Id,
UserId = e.MemId,
UserCode = member.UserName,
UserName = (string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName)
});
});
DataGridModel <CapitalModel> dataGridModel = new DataGridModel <CapitalModel>()
{
rows = capitalModels,
total = capitals.Total
};
return(Json(dataGridModel));
}
public JsonResult GetMemberCapitals(string user, int page, int rows)
{
IMemberCapitalService memberCapitalService = this._iMemberCapitalService;
IMemberService memberService = this._iMemberService;
long?nullable1 = new long?();
if (!string.IsNullOrWhiteSpace(user))
{
UserMemberInfo userMemberInfo = memberService.GetMemberByName(user);
if (userMemberInfo == null)
{
userMemberInfo = new UserMemberInfo()
{
Id = 0L
}
}
;
nullable1 = new long?(userMemberInfo.Id);
}
CapitalQuery capitalQuery = new CapitalQuery();
capitalQuery.PageNo = page;
capitalQuery.PageSize = rows;
capitalQuery.Sort = "Balance";
capitalQuery.memberId = nullable1;
CapitalQuery query = capitalQuery;
ObsoletePageModel <CapitalInfo> capitals = memberCapitalService.GetCapitals(query);
IEnumerable <CapitalModel> enumerable = Enumerable.Select <CapitalInfo, CapitalModel>((IEnumerable <CapitalInfo>)Enumerable.ToList <CapitalInfo>((IEnumerable <CapitalInfo>)capitals.Models), (Func <CapitalInfo, CapitalModel>)(e =>
{
UserMemberInfo member = memberService.GetMember(e.MemId);
CapitalModel capitalModel1 = new CapitalModel();
capitalModel1.Balance = e.Balance.Value;
CapitalModel capitalModel2 = capitalModel1;
Decimal?nullable2;
Decimal num1;
if (!e.ChargeAmount.HasValue)
{
num1 = new Decimal(0, 0, 0, false, (byte)2);
}
else
{
nullable2 = e.ChargeAmount;
num1 = nullable2.Value;
}
capitalModel2.ChargeAmount = num1;
CapitalModel capitalModel3 = capitalModel1;
nullable2 = e.FreezeAmount;
Decimal num2;
if (!nullable2.HasValue)
{
num2 = new Decimal(0, 0, 0, false, (byte)2);
}
else
{
nullable2 = e.FreezeAmount;
num2 = nullable2.Value;
}
capitalModel3.FreezeAmount = num2;
capitalModel1.Id = e.Id;
capitalModel1.UserId = e.MemId;
capitalModel1.UserCode = member.UserName;
capitalModel1.UserName = string.IsNullOrWhiteSpace(member.RealName) ? member.UserName : member.RealName;
return(capitalModel1);
}));
return(this.Json((object)new DataGridModel <CapitalModel>()
{
rows = enumerable,
total = capitals.Total
}));
}
/// <summary>
/// 取多个会员资产信息
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public static ObsoletePageModel <CapitalInfo> GetCapitals(CapitalQuery query)
{
return(_iMemberCapitalService.GetCapitals(query));
}
/// <summary>
/// 取多个会员资产信息
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public static QueryPageModel <MemberCapital> GetCapitals(CapitalQuery query)
{
return(Service.GetCapitals(query));
}
public QueryPageModel <MemberCapital> GetCapitals(CapitalQuery query)
{
var db = DbFactory.Default.Get <MemberInfo>().LeftJoin <CapitalInfo>((mi, ci) => ci.MemId == mi.Id);
if (query.MemberId > 0)
{
db.Where(e => e.Id == query.MemberId);
}
if (!string.IsNullOrEmpty(query.UserName))
{
//var members = DbFactory.Default.Get<MemberInfo>().Where(p => p.UserName.Contains(query.UserName)).Select(p => p.Id).ToList<long>();
//db.Where(p => p.MemId.ExIn(members));
db.Where(p => p.UserName.Contains(query.UserName));
}
switch (query.Sort.ToLower())
{
case "balance":
if (query.IsAsc)
{
db.OrderBy <CapitalInfo>(p => p.Balance);
}
else
{
db.OrderByDescending <CapitalInfo>(p => p.Balance);
}
break;
case "freezeamount":
if (query.IsAsc)
{
db.OrderBy <CapitalInfo>(p => p.FreezeAmount);
}
else
{
db.OrderByDescending <CapitalInfo>(p => p.FreezeAmount);
}
break;
case "chargeamount":
if (query.IsAsc)
{
db.OrderBy <CapitalInfo>(p => p.ChargeAmount);
}
else
{
db.OrderByDescending <CapitalInfo>(p => p.ChargeAmount);
}
break;
case "presentamount":
if (query.IsAsc)
{
db.OrderBy <CapitalInfo>(p => p.PresentAmount);
}
else
{
db.OrderByDescending <CapitalInfo>(p => p.PresentAmount);
}
break;
default:
db.OrderByDescending <CapitalInfo>(e => e.Balance);
break;
}
db.Select <CapitalInfo>(p => new { Id = p.Id, Balance = p.Balance.ExIfNull(0), ChargeAmount = p.ChargeAmount.ExIfNull(0), FreezeAmount = p.FreezeAmount.ExIfNull(0), PresentAmount = p.PresentAmount.ExIfNull(0) });
db.Select(p => new { UserName = p.UserName, RealName = p.RealName, UserId = p.Id });
var page = db.ToPagedList <MemberCapital>(query.PageNo, query.PageSize);
return(new QueryPageModel <MemberCapital>
{
Models = page,
Total = page.TotalRecordCount
});
}
public JsonResult GetMemberCapitals(CapitalQuery query)
{
var result = MemberCapitalApplication.GetCapitals(query);
return(Json(result, true));
}
