public ActionResult Items_getItems() { var parameters = AjaxModel.GetParameters(HttpContext); var mng = new ImpManager(); var name = ""; if (parameters.filter != null && parameters.filter.Count > 0) { name = parameters.filter.ContainsKey("name") ? parameters.filter["name"].ToString() : ""; } var sorts = parameters.sort.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var directions = parameters.direction.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var sort1 = sorts.Length > 0 ? sorts[0] : ""; var direction1 = directions.Length > 0 ? directions[0] : ""; var rep = new ImpRepository(); var p = new DynamicParameters(); p.Add("name", name); p.Add("sort1", sort1); p.Add("direction1", direction1); p.Add("page", parameters.page); p.Add("pageSize", parameters.pageSize); p.Add("total", dbType: DbType.Int32, direction: ParameterDirection.Output); var items = rep.GetSQLData <dynamic>("GetItems", p, CommandType.StoredProcedure); var total = p.Get <int>("total"); var json = JsonConvert.SerializeObject(new { items, total = total }); return(Content(json, "application/json")); }
public ActionResult StatisticImportExport_getItems() { var parameters = AjaxModel.GetParameters(HttpContext); var mng = new ImpManager(); DateTime createdMin = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue; DateTime createdMax = (DateTime)System.Data.SqlTypes.SqlDateTime.MaxValue; var user = ""; var operationId = 0; var datatable = ""; var checkError = false; //--------------обработка фильтров-------------- if (parameters.filter != null && parameters.filter.Count > 0) { if (parameters.filter.ContainsKey("creat") && parameters.filter["creat"] != null) { var dates = parameters.filter["creat"].ToString() .Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); if (dates.Length > 0) { createdMin = RDL.Convert.StrToDateTime(dates[0].Trim(), (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue); } if (dates.Length > 1) { createdMax = RDL.Convert.StrToDateTime(dates[1].Trim(), (DateTime)System.Data.SqlTypes.SqlDateTime.MaxValue); } } if (parameters.filter.ContainsKey("user") && parameters.filter["user"] != null) { var userId = RDL.Convert.StrToGuid(parameters.filter["user"].ToString(), Guid.Empty); var users = new CoreManager(); user = userId == Guid.Empty ? "" : users.GetUsers().First(i => i.UserId == userId).UserName; } if (parameters.filter.ContainsKey("oper") && parameters.filter["oper"] != null) { operationId = RDL.Convert.StrToInt(parameters.filter["oper"].ToString(), 0); } if (parameters.filter.ContainsKey("object") && parameters.filter["object"] != null) { datatable = parameters.filter["object"].ToString(); } if (parameters.filter.ContainsKey("checked") && parameters.filter["checked"] != null) { checkError = Convert.ToBoolean(parameters.filter["checked"].ToString()); } } var sorts = parameters.sort.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var directions = parameters.direction.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries); var sort1 = sorts.Length > 0 ? sorts[0] : ""; var direction1 = directions.Length > 0 ? directions[0] : ""; var rep = new ImpRepository(); var p = new DynamicParameters(); p.Add("user", user); p.Add("operationId", operationId); p.Add("datatable", datatable); p.Add("checkError", checkError); p.Add("createdMin", createdMin); p.Add("createdMax", createdMax); p.Add("sort1", sort1); p.Add("direction1", direction1); p.Add("page", parameters.page); p.Add("pageSize", parameters.pageSize); p.Add("total", dbType: DbType.Int32, direction: ParameterDirection.Output); var items = rep.GetSQLData <dynamic>("GetStatisticImportExport", p, CommandType.StoredProcedure); var total = p.Get <int>("total"); var json = JsonConvert.SerializeObject(new { items, total = total }); return(Content(json, "application/json")); }