public JsonResult GetPosMachineList(Models.Biz.PosMachine.PosMachineSearchCondition condition)
{
string[] arrNoInDeviceId = condition.NoInDeviceIds == null ? new string[1] {
""
} : condition.NoInDeviceIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
string deviceId = condition.DeviceId.ToSearchString();
string userName = condition.UserName.ToSearchString();
var list = (from mp in CurrentDb.MerchantPosMachine
join m in CurrentDb.Merchant on mp.MerchantId equals m.Id
join p in CurrentDb.PosMachine on mp.PosMachineId equals p.Id
where (deviceId.Length == 0 || p.DeviceId.Contains(deviceId)) &&
(userName.Length == 0 || m.ClientCode.Contains(userName)) &&
m.SalesmanId == null &&
!arrNoInDeviceId.Contains(p.DeviceId)
select new { mp.Id, m.ClientCode, p.FuselageNumber, p.TerminalNumber, p.CreateTime, p.Version, p.DeviceId, p.Deposit, p.Rent });
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 GetPosMachineList(Models.Biz.PosMachine.PosMachineSearchCondition condition)
{
string fuselageNumber = condition.FuselageNumber.ToSearchString();
string terminalNumber = condition.TerminalNumber.ToSearchString();
var list = (from p in CurrentDb.PosMachine
where (fuselageNumber.Length == 0 || p.FuselageNumber.Contains(fuselageNumber)) &&
(terminalNumber.Length == 0 || p.TerminalNumber.Contains(terminalNumber)) &&
p.IsUse == false
select new { p.Id, p.FuselageNumber, p.TerminalNumber, p.CreateTime, p.Version, p.DeviceId, p.Deposit, p.Rent });
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, ""));
}
