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, "")); }