public JsonResult GetReturnList(PosMachineSearchCondition condition)
{
string fuselageNumber = condition.FuselageNumber.ToSearchString();
string deviceId = condition.DeviceId.ToSearchString();
var list = (from mp in CurrentDb.MerchantPosMachine
join p in CurrentDb.PosMachine on mp.PosMachineId equals p.Id
join m in CurrentDb.Merchant on mp.MerchantId equals m.Id
where (fuselageNumber.Length == 0 || p.FuselageNumber.Contains(fuselageNumber)) &&
(deviceId.Length == 0 || p.DeviceId.Contains(deviceId)) &&
mp.Status == Enumeration.MerchantPosMachineStatus.Return
select new { m.ClientCode, m.YYZZ_Name, p.Id, p.DeviceId, mp.Deposit, mp.ReturnDeposit, mp.DepositPayTime, mp.ReturnTime, });
int total = list.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
list = list.OrderByDescending(r => r.ReturnTime).Skip(pageSize * (pageIndex)).Take(pageSize);
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
public CustomJsonResult GetList(PosMachineSearchCondition condition)
{
string fuselageNumber = condition.FuselageNumber.ToSearchString();
string deviceId = condition.DeviceId.ToSearchString();
string terminalNumber = condition.TerminalNumber.ToSearchString();
var list = (from p in CurrentDb.PosMachine
where (fuselageNumber.Length == 0 || p.FuselageNumber.Contains(fuselageNumber)) &&
(deviceId.Length == 0 || p.DeviceId.Contains(deviceId)) &&
(terminalNumber.Length == 0 || p.TerminalNumber.Contains(terminalNumber)) &&
p.AgentId == this.CurrentUserId
select new { p.Id, p.DeviceId, p.FuselageNumber, p.TerminalNumber, p.AgentName, IsUse = (p.IsUse == true ? "是" : "否"), p.CreateTime, p.Version });
int total = list.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
list = list.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize);
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
public JsonResult GetMerchantPosMachineList(PosMachineSearchCondition condition)
{
string fuselageNumber = condition.FuselageNumber.ToSearchString();
string deviceId = condition.DeviceId.ToSearchString();
var query = (from mp in CurrentDb.MerchantPosMachine
join p in CurrentDb.PosMachine on mp.PosMachineId equals p.Id
join m in CurrentDb.Merchant on mp.MerchantId equals m.Id
where (fuselageNumber.Length == 0 || p.FuselageNumber.Contains(fuselageNumber)) &&
(deviceId.Length == 0 || p.DeviceId.Contains(deviceId)) &&
(mp.Status == Enumeration.MerchantPosMachineStatus.Normal ||
mp.Status == Enumeration.MerchantPosMachineStatus.NoActive ||
mp.Status == Enumeration.MerchantPosMachineStatus.Rentdue
)
select new { m.ClientCode, m.YYZZ_Name, m.ContactName, m.ContactPhoneNumber, mp.Deposit, mp.DepositPayTime, p.DeviceId, p.FuselageNumber, p.TerminalNumber, p.Version, m.CreateTime, mp.Status });
int total = query.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
query = query.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize);
List <object> list = new List <object>();
foreach (var item in query)
{
list.Add(new
{
item.ClientCode,
item.YYZZ_Name,
item.ContactName,
item.ContactPhoneNumber,
Deposit = item.Deposit.ToPrice(),
item.DepositPayTime,
item.DeviceId,
item.FuselageNumber,
item.TerminalNumber,
item.Version,
item.CreateTime,
StatusName = item.Status.GetCnName(),
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
