public ActionResult PersonalRankList(int pageIndex)
{
int pageCount = 0;
using (MyDbContext dbc = new MyDbContext())
{
SqlParameter[] parameters =
{
new SqlParameter("@pageIndex", SqlDbType.Int, 4),
new SqlParameter("@pageSize", SqlDbType.Int, 4),
new SqlParameter("@pageCount", SqlDbType.Int, 4),
new SqlParameter("@totalCount", SqlDbType.Int, 4)
};
parameters[0].Value = pageIndex;
parameters[1].Value = pageSize;
parameters[2].Direction = ParameterDirection.Output;
parameters[3].Direction = ParameterDirection.Output;
var list = dbc.Database.SqlQuery <PersonalRankModel>("exec proc_PersonalRankList @pageIndex = @pageIndex,@pageSize =@pageSize,@pageCount = @pageCount output, @totalCount = @totalCount output", parameters).ToList();
pageIndex -= 1;
int i = pageIndex * pageSize;
list.ForEach(s => s.rankNo = ++i);
int.TryParse(parameters[2].Value.ToString(), out pageCount);
PersonalResultModel teamRank = new PersonalResultModel();
teamRank.List = list.ToArray();
teamRank.PageCount = pageCount;
return(Json(new AjaxResult {
Status = 1, Data = teamRank
}));
}
}
public APIResponse Personal(int userId, int merchantId, string deviceId)
{
PersonalResultModel model = new PersonalResultModel();
var posMachine = CurrentDb.PosMachine.Where(m => m.DeviceId == deviceId).FirstOrDefault();
if (posMachine == null)
{
model.PosMachineStatus = Enumeration.MerchantPosMachineStatus.NotMatch;
return(ResponseResult(ResultType.Failure, ResultCode.Failure, "设备ID不存在"));
}
var merchant = CurrentDb.Merchant.Where(m => m.Id == merchantId).FirstOrDefault();
var userAccount = CurrentDb.SysClientUser.Where(m => m.Id == userId).FirstOrDefault();
var merchantFund = CurrentDb.Fund.Where(m => m.UserId == merchant.UserId && m.MerchantId == merchant.Id).FirstOrDefault();
var merchantPosMachine = CurrentDb.MerchantPosMachine.Where(m => m.MerchantId == merchantId && m.PosMachineId == posMachine.Id).FirstOrDefault();
var merchantOrder = CurrentDb.Order.Where(m => m.UserId == merchant.UserId && m.MerchantId == merchant.Id && (m.Status == Enumeration.OrderStatus.Follow || m.Status == Enumeration.OrderStatus.WaitPay && ((int)m.ProductType).ToString().StartsWith("201"))).ToList();
//var
Log.Info("测试通过1");
model.PosMachineStatus = merchantPosMachine.Status;
PersonalInfo personalInfo = new PersonalInfo();
personalInfo.PhoneNumber = userAccount.PhoneNumber.NullToEmpty();
personalInfo.FullName = userAccount.FullName.NullToEmpty();
personalInfo.MerchantName = merchant.YYZZ_Name.NullToEmpty();
personalInfo.MerchantAddress = merchant.YYZZ_Address.NullToEmpty();
model.PersonalInfo = personalInfo;
model.WithdrawRuleUrl = BizFactory.Withdraw.GetWithrawRuleUrl();
if (merchant != null)
{
//资金详细
if (merchantFund != null)
{
FundDetails fundDetails = new FundDetails();
fundDetails.Balance = merchantFund.Balance;
fundDetails.Arrearage = merchantFund.Arrearage;
model.Fund = fundDetails;
}
//订单数据
if (merchantOrder != null)
{
OrderStatusCount orderStatusCount = new OrderStatusCount();
orderStatusCount.Follow = merchantOrder.Where(m => m.Status == Enumeration.OrderStatus.Follow).Count();
orderStatusCount.WaitPay = merchantOrder.Where(m => m.Status == Enumeration.OrderStatus.WaitPay).Count();
model.OrderStatusCount = orderStatusCount;
}
Log.Info("测试通过2");
//租金
if (merchantPosMachine != null)
{
model.RentDue = BizFactory.Merchant.GetRentOrder(merchant.Id, posMachine.Id);
}
Log.Info("测试通过3");
//续保数量
DateTime periodEndMax = DateTime.Now.AddDays(-7);
model.RenewalCount = CurrentDb.OrderToCarInsure.Where(m => m.MerchantId == merchant.Id && m.Status == Enumeration.OrderStatus.Completed && m.PeriodEnd >= periodEndMax).Count();
}
model.CustomerPhone = "020-88888888";
APIResult result = new APIResult()
{
Result = ResultType.Success, Code = ResultCode.Success, Message = "获取成功", Data = model
};
return(new APIResponse(result));
}