public async Task <IActionResult> GetT_Singlerows(int page, int limit, int Auditstate, string Requisition = "", string Tuneout = "", string Transferred = "") { List <Singlerows> list = await GetWMSS.GetT_Singlerows(); if (Auditstate != 0) { list = list.Where(x => x.Auditstate == Auditstate).ToList(); } if (!string.IsNullOrEmpty(Requisition)) { list = list.Where(x => x.Requisition == Requisition).ToList(); } if (!string.IsNullOrEmpty(Tuneout)) { list = list.Where(x => x.Tuneout.Contains(Tuneout)).ToList(); } if (!string.IsNullOrEmpty(Transferred)) { list = list.Where(x => x.Tuneout.Contains(Transferred)).ToList(); } //list = list.Skip((page - 1) * limit).Take(limit).ToList(); JsonData jsons = new JsonData { code = 0, msg = "", count = list.Count(), data = list }; string json = JsonConvert.SerializeObject(jsons); return(Ok(json)); }