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 ImpController(ImpRepository repository)
{
_repository = repository;
}
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"));
}
