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