public JsonResult List(string shopName, int type, int page, int rows)
{
CashDepositQuery cashDepositQuery = new CashDepositQuery()
{
ShopName = shopName,
PageNo = page,
PageSize = rows
};
CashDepositQuery nullable = cashDepositQuery;
if (type == 1)
{
nullable.Type = new bool?(true);
}
if (type == 2)
{
nullable.Type = new bool?(false);
}
ICashDepositsService cashDepositsService = ServiceHelper.Create <ICashDepositsService>();
PageModel <CashDepositInfo> cashDeposits = cashDepositsService.GetCashDeposits(nullable);
var collection = cashDeposits.Models.ToArray().Select((CashDepositInfo item) => {
decimal needPayCashDepositByShopId = cashDepositsService.GetNeedPayCashDepositByShopId(item.ShopId);
return(new { Id = item.Id, ShopName = item.ChemCloud_Shops.ShopName, Type = (needPayCashDepositByShopId > new decimal(0) ? "欠费" : "正常"), TotalBalance = item.TotalBalance, CurrentBalance = item.CurrentBalance, Date = item.Date.ToString("yyyy-MM-dd HH:mm"), NeedPay = needPayCashDepositByShopId, EnableLabels = item.EnableLabels });
});
return(Json(new { rows = collection, total = cashDeposits.Total }));
}
/// <summary>
/// 获取保证金列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <CashDeposit> GetCashDeposits(CashDepositQuery query)
{
var data = _iCashDepositsService.GetCashDeposits(query);
var shops = GetService <IShopService>().GetShops(data.Models.Select(p => p.ShopId).ToList());
var result = data.Models.Select(item =>
{
var needPay = _iCashDepositsService.GetNeedPayCashDepositByShopId(item.ShopId);
var shop = shops.FirstOrDefault(p => p.Id == item.ShopId);
return(new CashDeposit
{
Id = item.Id,
ShopName = shop.ShopName,
Type = needPay > 0 ? "欠费" : "正常",
TotalBalance = item.TotalBalance,
CurrentBalance = item.CurrentBalance,
Date = item.Date,
NeedPay = needPay,
EnableLabels = item.EnableLabels,
});
}).ToList();
return(new QueryPageModel <CashDeposit>
{
Models = result,
Total = data.Total
});
}
public PageModel <CashDepositInfo> GetCashDeposits(CashDepositQuery query)
{
int num;
IQueryable <CashDepositInfo> page = context.CashDepositInfo.AsQueryable <CashDepositInfo>();
if (!string.IsNullOrWhiteSpace(query.ShopName))
{
page =
from item in page
where item.ChemCloud_Shops.ShopName.Contains(query.ShopName)
select item;
}
List <CashDepositInfo> list = page.ToList();
List <long> nums = new List <long>();
foreach (CashDepositInfo cashDepositInfo in list)
{
if (GetNeedPayCashDepositByShopId(cashDepositInfo.ShopId) <= new decimal(0))
{
continue;
}
nums.Add(cashDepositInfo.ShopId);
}
if (query.Type.HasValue)
{
page = (query.Type.Value ?
from item in page
where !nums.Contains(item.ShopId)
select item :
from item in page
where nums.Contains(item.ShopId)
select item);
}
page = page.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <CashDepositInfo> d) =>
from o in d
orderby o.Date descending
select o);
return(new PageModel <CashDepositInfo>()
{
Models = page,
Total = num
});
}
public ObsoletePageModel <CashDepositInfo> GetCashDeposits(CashDepositQuery query)
{
IQueryable <CashDepositInfo> cashDeposits = Context.CashDepositInfo.AsQueryable();
if (!string.IsNullOrWhiteSpace(query.ShopName))
{
cashDeposits = cashDeposits.Where(item => item.Himall_Shops.ShopName.Contains(query.ShopName));
}
var c = cashDeposits.ToList();
List <long> shopIds = new List <long>();
foreach (var cashDeposit in c)
{
var needPayShop = GetNeedPayCashDepositByShopId(cashDeposit.ShopId);
if (needPayShop > 0)
{
shopIds.Add(cashDeposit.ShopId);
}
}
if (query.Type.HasValue)
{
if (query.Type.Value == false)
{
cashDeposits = cashDeposits.Where(item => shopIds.Contains(item.ShopId));
}
else
{
cashDeposits = cashDeposits.Where(item => !shopIds.Contains(item.ShopId));
}
}
int total;
cashDeposits = cashDeposits.GetPage(out total, query.PageNo, query.PageSize, d => d.OrderByDescending(o => o.Date));
ObsoletePageModel <CashDepositInfo> pageModel = new ObsoletePageModel <CashDepositInfo>()
{
Models = cashDeposits, Total = total
};
return(pageModel);
}
public JsonResult List(string shopName, int type, int page, int rows)
{
var queryModel = new CashDepositQuery()
{
ShopName = shopName,
PageNo = page,
PageSize = rows
};
if (type == 1)
{
queryModel.Type = true;
}
if (type == 2)
{
queryModel.Type = false;
}
var cashDepositsService = _iCashDepositsService;
ObsoletePageModel <CashDepositInfo> cashDeposits = cashDepositsService.GetCashDeposits(queryModel);
var cashDepositModel = cashDeposits.Models.ToArray().Select(item =>
{
var needPay = cashDepositsService.GetNeedPayCashDepositByShopId(item.ShopId);
return(new
{
Id = item.Id,
ShopName = item.Himall_Shops.ShopName,
Type = needPay > 0 ? "欠费" : "正常",
TotalBalance = item.TotalBalance,
CurrentBalance = item.CurrentBalance,
Date = item.Date.ToString("yyyy-MM-dd HH:mm"),
NeedPay = needPay,
EnableLabels = item.EnableLabels,
});
});
return(Json(new { rows = cashDepositModel, total = cashDeposits.Total }));
}
/// <summary>
/// 获取保证金列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static ObsoletePageModel <CashDepositInfo> GetCashDeposits(CashDepositQuery query)
{
return(_iCashDepositsService.GetCashDeposits(query));
}
public JsonResult List(CashDepositQuery query)
{
var data = CashDepositsApplication.GetCashDeposits(query);
return(Json(data, true));
}
public QueryPageModel <CashDepositInfo> GetCashDeposits(CashDepositQuery query)
{
var db = DbFactory.Default.Get <CashDepositInfo>().LeftJoin <ShopInfo>((ci, si) => ci.ShopId == si.Id);
var scd = DbFactory.Default.Get <CashDepositInfo>().LeftJoin <ShopInfo>((ci, si) => ci.ShopId == si.Id);
if (!string.IsNullOrWhiteSpace(query.ShopName))
{
db.Where <ShopInfo>(item => item.ShopName.Contains(query.ShopName));
scd.Where <ShopInfo>(item => item.ShopName.Contains(query.ShopName));
}
var c = scd.ToList();
List <long> shopIds = new List <long>();
foreach (var cashDeposit in c)
{
var needPayShop = GetNeedPayCashDepositByShopId(cashDeposit.ShopId);
if (needPayShop > 0)
{
shopIds.Add(cashDeposit.ShopId);
}
}
if (query.Type.HasValue)
{
if (query.Type.Value == false)
{
db.Where(item => item.ShopId.ExIn(shopIds));
}
else
{
db.Where(item => item.ShopId.ExNotIn(shopIds));
}
}
switch (query.Sort.ToLower())
{
case "totalbalance":
if (query.IsAsc)
{
db.OrderBy(p => p.TotalBalance);
}
else
{
db.OrderByDescending(p => p.TotalBalance);
}
break;
case "currentbalance":
if (query.IsAsc)
{
db.OrderBy(p => p.CurrentBalance);
}
else
{
db.OrderByDescending(p => p.CurrentBalance);
}
break;
case "date":
if (query.IsAsc)
{
db.OrderBy(p => p.Date);
}
else
{
db.OrderByDescending(p => p.Date);
}
break;
//case "needPay":
//需业务计算未实现
default:
db.OrderByDescending(o => o.Date);
break;
}
var models = db.Select().ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <CashDepositInfo> pageModel = new QueryPageModel <CashDepositInfo>()
{
Models = models, Total = models.TotalRecordCount
};
return(pageModel);
}
public PageModel <CashDepositInfo> GetCashDeposits(CashDepositQuery query)
{
throw new NotImplementedException();
}
