/// <summary>
/// 根据查询条件过滤数据
/// </summary>
/// <param name="dailyQuery"></param>
/// <returns></returns>
private List <DailyRecord> FilterRecordInfo(DailyQueryMod dailyQuery, int pageIndex)
{
List <DailyRecord> records = DailyRecordHelper.DailyRecordList();
IEnumerable <DailyRecord> temRecords = records.Where(item => item.StaffId != "");
if (!string.IsNullOrEmpty(dailyQuery.StaffId))
{
temRecords = temRecords.Where(item => item.StaffId == dailyQuery.StaffId);
}
if (!string.IsNullOrEmpty(dailyQuery.CustomerId))
{
temRecords = temRecords.Where(item => item.CustomerId == dailyQuery.CustomerId);
}
if (dailyQuery.DateBegin > Convert.ToDateTime("2017-01-01"))
{
temRecords = temRecords.Where(item => item.VisitDate >= dailyQuery.DateBegin);
}
if (dailyQuery.DateBegin > Convert.ToDateTime("2017-01-01"))
{
temRecords = temRecords.Where(item => item.VisitDate <= dailyQuery.DateEnd.AddHours(8));
}
temRecords = temRecords.Where(item => item.SendBucketAmount > 0 || item.ReceiveEmptyBucketAmount > 0);
//获取页条数
int pageSize = PageSize();
var currentRecords = temRecords
.OrderByDescending(item => item.VisitDate)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize);
TempData["currentPage"] = pageIndex;
TempData["DailyRecord"] = temRecords.ToList();
return(currentRecords.ToList <DailyRecord>());
}
/// <summary>
/// 查询日常记录
/// </summary>
/// <param name="dailyQuery"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult QueryDailyRecord(DailyQueryMod dailyQuery, int pageIndex, int flag)
{
int pageSize = PageSize();
//获取当页信息
var records = FilterRecordInfo(dailyQuery, pageIndex);
TempData["currentRecords"] = records;
TempData["dailyQuery"] = dailyQuery;
switch (flag)
{
case 0:
return(RedirectToAction("DailyRecord"));
case 1: //附属产品交易
TempData["currentRecords"] = ((List <DailyRecord>)TempData["DailyRecord"]).Where(
item =>
item.WaterHolder != 0 || item.WaterDispenser != 0 || item.PushPump != 0 ||
item.WaterHolderBack != 0 || item.WaterDispenserBack != 0 || item.PushPumpBack != 0)
.GroupBy(item => new { item.VisitDate, item.CustomerId, item.StaffId })
.Select(item => new AccessoryProducts()
{
StaffId = item.First().StaffId,
CustomerId = item.First().CustomerId,
WaterDispenser = MakeAccessoryInfo(item.First().WaterDispenser, item.First().WaterDispenserBack),
PushPump = MakeAccessoryInfo(item.First().PushPump, item.First().PushPumpBack),
WaterHolder = MakeAccessoryInfo(item.First().WaterHolder, item.First().WaterHolderBack),
VisitDate = item.First().VisitDate
})
.OrderByDescending(item => item.VisitDate)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize).ToList();
return(RedirectToAction("AccessRecord"));
case 2: //公司资金交易
TempData["currentRecords"] = ((List <DailyRecord>)TempData["DailyRecord"]).Where(
item =>
item.PayDeposit > 0 || item.EarnDeposit > 0 || item.EarnMonthEndPrice > 0 ||
item.EarnWaterCardPrice > 0)
.OrderByDescending(item => item.VisitDate)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize).ToList();
return(RedirectToAction("FundRecord"));
default:
return(RedirectToAction("DailyRecord"));
}
}
