Пример #1
0
        public JsonResult GetCustomer(DataTableParameters dataTableParameters)
        {
            CUSTOMER cus = new CUSTOMER();

            var resultSet = new DataTableResultSet();

            resultSet.draw = dataTableParameters.Draw;
            var lst = cus.SelectPaging(dataTableParameters.Start + 1,
                                       dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value);

            resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value);

            foreach (var i in lst)
            {
                var columns = new List <string>();
                columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' />");
                columns.Add(i.ID);
                columns.Add(i.NAME);
                columns.Add(i.LOCATION == null ? "" : i.LOCATION.Trim());
                columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME);
                columns.Add(i.TYPE == null ? "": i.TYPE);
                columns.Add("<a href='#' class='end' title='End User' id='" + i.ID + "'><span class='badge badge-pill badge-primary'>" + i.NUM_END + "</span></a>");
                resultSet.data.Add(columns);
            }
            return(Json(resultSet));
        }