// GET: QLNews
public ActionResult GetAccountByPage(int? index, int page, int pageSize)
{
var roleManager = new RoleManager<Microsoft.AspNet.Identity.EntityFramework.IdentityRole>(new RoleStore<IdentityRole>(new ApplicationDbContext()));
var idAdminRole = roleManager.FindByName("Admin").Id;
ApplicationUserManager userManager = HttpContext.GetOwinContext().GetUserManager<ApplicationUserManager>();
GridViewModel<ApplicationUser> viewModel = new GridViewModel<ApplicationUser>();
int totalItems = userManager.Users.Where(x => x.Roles.Where(o => o.RoleId == idAdminRole).ToList().Count == 0).Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<ApplicationUser> data = userManager.Users.Where(x => x.Roles.Where(o => o.RoleId == idAdminRole).ToList().Count == 0).OrderBy(x => x.UserName).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<ApplicationUser> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<ApplicationUser> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
// GET: QLMaterialArea
public ActionResult GetMaterialAreaPage(int? index, int page, int pageSize)
{
GridViewModel<MaterialArea> viewModel = new GridViewModel<MaterialArea>();
int totalItems = dbContext.MaterialAreas.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<MaterialArea> data = dbContext.MaterialAreas.OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).ToList();
//foreach (var item in data)
//{
// if (item.MenuItem.MenuItems != null)
// {
// item.MenuItem.MenuItems = null;
// }
//}
if (index != null)
{
viewModel = new GridViewModel<MaterialArea> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<MaterialArea> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
public virtual ActionResult Index()
{
IList<GridColumnViewModel> columns = new List<GridColumnViewModel>
{
new GridColumnViewModel {Name = Translate(".Model.UserGroup.Name"), Index = "Name"},
new GridColumnViewModel
{
Name = Translate(".Model.UserGroup.RolesList"),
Width = 150,
Sortable = false
},
new GridColumnViewModel
{
Name = Translate(".Model.UserGroup.UsersList"),
Sortable = false
},
new GridColumnViewModel
{
Width = 10,
Sortable = false
},
new GridColumnViewModel
{Name = "Id", Sortable = false, Hidden = true}
};
var model = new GridViewModel
{
DataUrl = Url.Action(MVC.Admin.UserGroup.DynamicGridData()),
DetailsUrl = String.Format("{0}/", Url.Action(MVC.Admin.UserGroup.Edit())),
DefaultOrderColumn = "Name",
GridTitle = ".UserGroups",
Columns = columns
};
return View(model);
}
public ActionResult GetSubCatagoryPage(int? index, int page, int pageSize)
{
GridViewModel<SubCatagorySolution> viewModel = new GridViewModel<SubCatagorySolution>();
int totalItems = dbContext.SubCatagorySolutions.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<SubCatagorySolution> data = dbContext.SubCatagorySolutions.Include(x => x.CatagorySolution).OrderBy(x => x.SubCatagorySolutionName).Skip((page - 1) * pageSize).Take(pageSize).ToList();
foreach (var item in data)
{
if (item.CatagorySolution.SubCatagorySolutions != null)
{
item.CatagorySolution.SubCatagorySolutions = null;
}
}
if (index != null)
{
viewModel = new GridViewModel<SubCatagorySolution> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<SubCatagorySolution> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
public virtual ActionResult Index()
{
IList<GridColumnViewModel> columns = new List<GridColumnViewModel>
{
new GridColumnViewModel
{
Name = Translate(".Model.Widget.Title"), Index = "Title"
},
new GridColumnViewModel
{
Name = Translate(".Model.Widget.Module"), Sortable = false
},
new GridColumnViewModel
{
Name = Translate(".Model.Widget.Status"), Index = "widget.Status"
},
new GridColumnViewModel
{
Name = Translate("Actions.Actions"), Sortable = false
}
,
new GridColumnViewModel
{
Name = Translate("Actions.Edit"), Sortable = false
}
};
var model = new GridViewModel
{
DataUrl = Url.Action(MVC.Admin.Widget.DynamicGridData()),
DefaultOrderColumn = "Id",
GridTitle = Translate(".Widgets"),
Columns = columns
};
return View(model);
}
protected override void OnInitialized()
{
GridViewModel = GetViewModel<GridViewModel<ListItemModel>>();
for (int i = 0; i < 20; i++)
{
GridViewModel.ItemsSource.Add(new ListItemModel { IsValid = true });
GridViewModel.ItemsSource.Add(new ListItemModel { IsValid = false });
}
}
public JsonResult ProductQuery(ProductQueryRequest request)
{
var totalNumber = 0;
var dt = GetProductQuery(request, ref totalNumber);
var data = BuildProductQueryModel(dt);
GridViewModel <ProductQueryViewModel> result = new GridViewModel <ProductQueryViewModel>(totalNumber, data, request.sEcho);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static GridViewModel TimeLogGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "EmployeeId";
viewModel.Columns.Add("FirstName");
viewModel.Columns.Add("SurName");
viewModel.Columns.Add("EmployeeRole");
viewModel.Columns.Add("PayrollEmployeeNo");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
public GridViewModel <T> ConvertGridViewModel <T>(T[] data, RequestGrid model) where T : class
{
var result = new GridViewModel <T>
{
data = data,
draw = model.draw,
recordsTotal = model.Total,
recordsFiltered = model.Total
};
return(result);
}
public ActionResult AdvancedCustomBindingCore(GridViewModel viewModel)
{
try
{
viewModel.ProcessCustomBinding(GridViewCustomBindingHandlers.GetDataRowCountAdvanced, GridViewCustomBindingHandlers.GetDataAdvanced);
return(PartialView("_GridView", viewModel));;
}
catch (System.Exception)
{
throw;
}
}
public GridView()
{
InitializeComponent();
viewModel = new GridViewModel(12, 12);
DataContext = viewModel;
content.Content = new TextBlock()
{
Text = "pOUET"
};
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Name");
viewModel.Columns.Add("DisplayName");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("Measurement");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
public IActionResult GetOrdersGridData(int pageNum)
{
var data = _unitOfWork.ProductOrderRepository.GetProductOrdersWithPaging(pageNum, 10);
var culture = Request.Cookies[".AspNetCore.Culture"];
var orderRowViewModel = data.Select(a => new ProductOrdersRowViewModel(a, culture)).ToList();
var totalCount = _unitOfWork.ProductOrderRepository.All.Count();
var pagesCount = Math.Ceiling(totalCount / 10d);
var isLastPage = pageNum * 10 >= totalCount && (pageNum - 1) * 10 < totalCount;
var gridViewModel = new GridViewModel <ProductOrdersRowViewModel>(orderRowViewModel, pageNum, pageNum == 1, isLastPage, pagesCount);
return(new JsonResult(gridViewModel));
}
private static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Name");
viewModel.Columns.Add("Order");
viewModel.Columns.Add("Remark");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
/// <summary>
/// Apply changes for specific grid
/// </summary>
/// <param name="source">Item to change</param>
/// <param name="target">Target item</param>
private void ApplyChanges(GridViewModel source, GridViewModel target)
{
for (var i = 0; i < source.ChoiceBoxes.Count; i++)
{
this.ApplyChanges(source.ChoiceBoxes[i], target.ChoiceBoxes[i]);
}
source.Top = target.Top;
source.Left = target.Left;
source.Width = target.Width;
source.Height = target.Height;
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("PeriodeType");
viewModel.Columns.Add("Type");
viewModel.Columns.Add("Title");
viewModel.Columns.Add("Date");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return viewModel;
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("KpiName");
viewModel.Columns.Add("PeriodeType");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
private PartialViewResult AdvancedCustomBindingCore(string listPartial, GridViewModel viewModel)
{
viewModel.ProcessCustomBinding(GetDataRowCountAdvanced, GetDataAdvanced, null, GetGroupingInfoAdvanced, GetUniqueHeaderFilterValuesAdvanced);
var where = GetFilterExpressionState(viewModel.FilterExpression);
ListState.FilterExpression = viewModel.FilterExpression;
ListState.SortExpression = viewModel.SortedColumns;
LoadListHeaderFilters(where);
return(PartialView(listPartial, viewModel));
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "ID";
viewModel.Columns.Add("From");
viewModel.Columns.Add("Subject");
viewModel.Columns.Add("Sent");
viewModel.Columns.Add("Size");
viewModel.Columns.Add("HasAttachment");
return(viewModel);
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Username");
viewModel.Columns.Add("Email");
viewModel.Columns.Add("IsActive");
viewModel.Columns.Add("RoleName");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
/// <summary>
/// Converts template data model to template view model
/// </summary>
/// <param name="template">OmrTemplate to convert</param>
/// <returns>Resulting TemplateViewModel</returns>
public static TemplateViewModel ConvertModelToViewModel(OmrTemplate template)
{
TemplateViewModel templateViewModel = new TemplateViewModel(template.FinalizationComplete, template.TemplateId);
templateViewModel.TemplateName = template.Name;
templateViewModel.IsGeneratedTemplate = template.IsGenerated;
OmrPage page = template.Pages[0];
templateViewModel.TemplateImageName = page.ImageName;
templateViewModel.ImageFileFormat = page.ImageFormat;
templateViewModel.PageWidth = page.Width;
templateViewModel.PageHeight = page.Height;
List <BaseQuestionViewModel> elements = new List <BaseQuestionViewModel>();
List <ReferencePointElement> refPoints = new List <ReferencePointElement>();
foreach (OmrElement modelElement in page.Elements)
{
if (modelElement is ChoiceBoxElement)
{
ChoiceBoxViewModel choiceBoxViewModel = CreateChoiceBoxViewModel((ChoiceBoxElement)modelElement, templateViewModel);
elements.Add(choiceBoxViewModel);
}
else if (modelElement is GridElement)
{
GridViewModel gridViewModel = CreateGridViewModel((GridElement)modelElement, templateViewModel);
elements.Add(gridViewModel);
}
else if (modelElement is BarcodeElement)
{
BarcodeViewModel barcodeViewModel = CreateBarcodeViewModel((BarcodeElement)modelElement, templateViewModel);
elements.Add(barcodeViewModel);
}
else if (modelElement is ClipAreaElement)
{
ClipAreaViewModel clipViewModel = CreateClipAreaViewModel((ClipAreaElement)modelElement, templateViewModel);
elements.Add(clipViewModel);
}
else if (modelElement is ReferencePointElement)
{
refPoints.Add((ReferencePointElement)modelElement);
}
}
templateViewModel.AddQuestions(elements);
templateViewModel.ReferencePointsModels = refPoints.ToArray();
templateViewModel.IsDirty = false;
return(templateViewModel);
}
/// <summary>
/// 查询用户的待阅任务
/// </summary>
/// <param name="pagerInfo"></param>
/// <param name="keyWord"></param>
/// <returns></returns>
public JsonResult GetUnReadWorkItems(PagerInfo pagerInfo, string keyWord)
{
return(this.ExecuteFunctionRun(() =>
{
string[] conditions = Engine.PortalQuery.GetWorkItemConditions(this.UserValidator.UserID, DateTime.MinValue, DateTime.MaxValue, WorkItem.WorkItemState.Unfinished, keyWord, OThinker.Data.BoolMatchValue.Unspecified, string.Empty, false, WorkItem.CirculateItem.TableName);
DataTable dtWorkitem = Engine.PortalQuery.QueryWorkItem(conditions, pagerInfo.StartIndex, pagerInfo.EndIndex, string.Empty, WorkItem.CirculateItem.TableName);
int total = Engine.PortalQuery.CountWorkItem(conditions, WorkItem.CirculateItem.TableName); // 记录总数
string[] columns = new string[] { WorkItem.CirculateItem.PropertyName_OrgUnit };
List <CirculateItemViewModel> griddata = this.Getgriddata(dtWorkitem, columns, false);
GridViewModel <CirculateItemViewModel> result = new GridViewModel <CirculateItemViewModel>(total, griddata, pagerInfo.sEcho);
return Json(result, JsonRequestBehavior.AllowGet);
}));
}
protected override void OnInitialized()
{
GridViewModel = GetViewModel <GridViewModel <TableItemModel> >();
GridViewModel.Filter = Filter;
for (int i = 0; i < 100; i++)
{
GridViewModel.ItemsSource.Add(new TableItemModel
{
Id = i,
Name = "Item " + i.ToString(CultureInfo.InvariantCulture)
});
}
}
protected override void OnInitialized()
{
GridViewModel = GetViewModel <GridViewModel <ListItemModel> >();
for (var i = 0; i < 20; i++)
{
GridViewModel.ItemsSource.Add(new ListItemModel {
IsValid = true
});
GridViewModel.ItemsSource.Add(new ListItemModel {
IsValid = false
});
}
}
public System.Web.Mvc.JsonResult GetFinalBondList(PagerInfo pagerInfo, string keyWord, string startDate, string endDate, string state, string distributorCode, string Status)
{
return(this.ExecuteFunctionRun(() =>
{
int total = 0;
DataTable dtWorkitem = QueryFinalBondList(pagerInfo, keyWord, startDate, endDate, state, distributorCode, Status, ref total);
// string[] columns = new string[] { WorkItem.WorkItem.PropertyName_OrgUnit, Query.ColumnName_OriginateUnit };
List <BondViewModel> griddata = this.Getgriddata(dtWorkitem);
GridViewModel <BondViewModel> result = new GridViewModel <BondViewModel>(total, griddata, pagerInfo.sEcho);
return Json(result, JsonRequestBehavior.AllowGet);
}));
}
public ActionResult CreateGrid(int?id, int?rpId)
{
if (id != null && rpId != null)
{
GridViewModel grid = new GridViewModel()
{
BNR = id.Value,
RegPId = rpId.Value
};
return(View(grid));
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public async Task <JsonResult> GetAll(GridViewModel model)
{
var total = DbContext.Tenants.Count();
var results = DbContext.Tenants.Skip((model.Page - 1) * model.Length).Take(model.Length).ToList().ToModel();
return(await Task.FromResult(new JsonResult(new GridDataViewModel <TenantViewModel>
{
draw = model.Draw,
data = results,
recordsFiltered = total,
recordsTotal = total
})));
}
public static GridViewModel MarketRouteProgressGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "RouteProgressId";
viewModel.Columns.Add("MarketName");
viewModel.Columns.Add("MarketRoute");
viewModel.Columns.Add("AccountName");
viewModel.Columns.Add("Comment");
viewModel.Columns.Add("DateCreated");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
public static GridViewModel CreateRoleGridViewModel()
{
var gridModel = new GridViewModel
{
GridName = "GridServiceResult",
PagingRoute = "User",
PagingAction = "SearchRole"
};
gridModel.AddColumn("Name", true);
gridModel.AddColumn("Actions");
return(gridModel);
}
private PartialViewResult AdvancedCustomBindingCore(GridViewModel viewModel)
{
viewModel.ProcessCustomBinding(
gridViewHanders.GetDataRowCountAdvanced,
gridViewHanders.GetDataAdvanced,
gridViewHanders.GetSummaryValuesAdvanced,
gridViewHanders.GetGroupingInfoAdvanced,
gridViewHanders.GetUniqueHeaderFilterValuesAdvanced
);
var list = (IQueryable <LogSystem>)gridViewHanders.Model.ApplyFilter(viewModel.FilterExpression).AsQueryable();
return(PartialView("LogPartial", viewModel));
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Vessel");
viewModel.Columns.Add("ETA");
viewModel.Columns.Add("ETD");
viewModel.Columns.Add("Remark");
viewModel.Columns.Add("CreatedAt");
viewModel.Pager.PageSize = 10;
return(viewModel);
}
static void ProcessCustomBinding(int userId, GridViewModel viewModel)
{
viewModel.ProcessCustomBinding(
new GridViewCustomBindingGetDataRowCountHandler(args =>
{
Alert_Model.GetDataRowCount(args, userId);
}),
new GridViewCustomBindingGetDataHandler(args =>
{
Alert_Model.GetData(args, userId);
})
);
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "CustomerID";
viewModel.Columns.Add("ContactName");
viewModel.Columns.Add("CompanyName");
viewModel.Columns.Add("ContactTitle");
viewModel.Columns.Add("City");
viewModel.Columns.Add("Phone");
viewModel.Pager.PageSize = 20;
return(viewModel);
}
public PageControl()
{
InitializeComponent();
var pageControlViewModel = new PageControlViewModel();
DataContext = pageControlViewModel;
pageControlViewModel.NumInPageControlDataContext = 3;
var gridViewModel = new GridViewModel();
SubGrid.DataContext = gridViewModel;
gridViewModel.NumInGridDataContext = 10;
}
/// <summary>
/// 分组模式-待办
/// </summary>
/// <param name="pagerInfo"></param>
/// <param name="keyWord">流程模板名称</param>
/// <returns></returns>
public JsonResult MyUnfinishedWorkItemByGroup()
{
return(this.ExecuteFunctionRun(() =>
{
string orderBy = "ORDER BY " +
WorkItem.WorkItem.TableName + "." + WorkItem.WorkItem.PropertyName_Priority + " DESC," +
WorkItem.WorkItem.TableName + "." + WorkItem.WorkItem.PropertyName_ReceiveTime + " DESC";
string[] conditions = Engine.PortalQuery.GetWorkItemConditions(this.UserValidator.UserID, DateTime.MinValue, DateTime.MaxValue, WorkItem.WorkItemState.Unfinished, string.Empty, OThinker.Data.BoolMatchValue.Unspecified, string.Empty, false, WorkItem.WorkItem.TableName);
DataTable dtWorkitem = Engine.PortalQuery.QueryWorkItem(conditions, -1, -1, orderBy, WorkItem.WorkItem.TableName);
string[] columns = new string[] { WorkItem.WorkItem.PropertyName_OrgUnit };
Dictionary <string, string> unitNames = this.GetUnitNamesFromTable(dtWorkitem, columns);
Dictionary <string, string> workflowNames = this.GetWorkflowNamesFromTable(dtWorkitem);
Dictionary <string, WorkItemGroup> workflowGroups = new Dictionary <string, WorkItemGroup>();
// 获取分组集合
foreach (DataRow row in dtWorkitem.Rows)
{
string workflowCode = row[WorkItem.WorkItem.PropertyName_WorkflowCode] + string.Empty;
if (!workflowGroups.ContainsKey(workflowCode))
{
string workflowName = workflowNames[workflowCode] + string.Empty;
workflowGroups.Add(workflowCode, new WorkItemGroup(workflowCode, workflowName));
}
var workItem = new WorkItemViewModel()
{
Priority = row[WorkItem.WorkItem.PropertyName_Priority] + string.Empty,
Urged = this.GetColumnsValue(row, WorkItem.WorkItem.PropertyName_Urged).ToString() == "1" ? true : false,
ObjectID = row[WorkItem.WorkItem.PropertyName_ObjectID] + string.Empty,
InstanceId = row[WorkItem.WorkItem.PropertyName_InstanceId] + string.Empty,
WorkflowCode = workflowCode,
InstanceName = row[Instance.InstanceContext.PropertyName_InstanceName] + string.Empty,
ActivityCode = row[WorkItem.WorkItem.PropertyName_ActivityCode] + string.Empty,
DisplayName = row[WorkItem.WorkItem.PropertyName_DisplayName] + string.Empty,
ReceiveTime = this.GetValueFromDate(row[WorkItem.WorkItem.PropertyName_ReceiveTime], WorkItemTimeFormat),
Originator = row[WorkItem.WorkItem.PropertyName_Originator] + string.Empty,
OriginatorName = row[Instance.InstanceContext.PropertyName_OriginatorName] + string.Empty,
OriginatorOUName = this.GetValueFromDictionary(unitNames, row[Instance.InstanceContext.PropertyName_OrgUnit] + string.Empty)
};
workflowGroups[workflowCode].WorkItems.Add(workItem);
}
List <WorkItemGroup> gridDatas = new List <WorkItemGroup>();
foreach (string key in workflowGroups.Keys)
{
gridDatas.Add(workflowGroups[key]);
}
GridViewModel <WorkItemGroup> result = new GridViewModel <WorkItemGroup>(workflowGroups.Count, gridDatas);
return Json(result, JsonRequestBehavior.AllowGet);
}, FunctionNode.Workspace_MyUnfinishedWorkItem_Code));
}
public static GridViewModel CreateGridViewModel()
{
var gridModel = new GridViewModel
{
GridName = "GridServiceResult",
PagingRoute = "Sites",
PagingAction = "search"
};
gridModel.AddColumn("Site Name", true, "Abbriviation");
gridModel.AddColumn("Actions");
return(gridModel);
}
public HtmlTag FilterTemplatesFor(GridViewModel model)
{
var tag = new HtmlTag("div");
var containerNameForGrid = model.GridType.ContainerNameForGrid();
tag.Id("filters_" + containerNameForGrid);
tag.AddClass("smart-grid-filter");
tag.Append(new TableTag());
var metadata = new Dictionary<string, object>{
{"gridId", "grid_" + model.GridName},
{"initialCriteria", model.InitialCriteria()}
};
tag.MetaData("filters", metadata);
var properties = model.FilteredProperties;
var templates = _sources.Distinct().SelectMany(x => x.TagsFor(properties));
var operators = properties.Select(prop =>
{
return new SelectTag(select =>
{
prop.Operators.Each(oper => select.Option(oper.ToString(), oper.Key));
}).AddClass(prop.Accessor.Name);
});
tag.Add("div", div =>
{
div.Hide();
div.AddClass("templates");
div.Add("div").AddClass("smart-grid-editors").Append(templates);
div.Add("div").AddClass("smart-grid-operators").Append(operators);
div.Append(new SelectTag(select =>
{
select.AddClass("smart-grid-properties");
properties.Each(prop => select.Option(prop.Header, prop.Accessor.Name));
}));
});
return tag;
}
// GET: QLMenuItem
public ActionResult GetMenuPage(int? index, int page, int pageSize)
{
GridViewModel<MenuItem> viewModel = new GridViewModel<MenuItem>();
int totalItems = dbContext.MenuItems.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<MenuItem> data = dbContext.MenuItems.OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).Include(x => x.ParentMenu).ToList();
foreach (var item in data)
{
if (item.MenuItems != null)
{
foreach (var i in item.MenuItems)
{
if (i.ParentMenu != null) {
i.ParentMenu.MenuItems = null;
}
}
}
if (item.ParentMenu != null)
{
item.ParentMenu.MenuItems = null;
item.ParentMenu.ParentMenu = null;
}
}
if (index != null)
{
viewModel = new GridViewModel<MenuItem> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<MenuItem> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
// GET: QLLinkHeader
public ActionResult GetLinkHeaderPage(int? index, int page, int pageSize)
{
GridViewModel<LinkHeader> viewModel = new GridViewModel<LinkHeader>();
int totalItems = dbContext.LinkHeaders.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<LinkHeader> data = dbContext.LinkHeaders.Where(x => x.Type == TypeLink.Link).OrderBy(y => y.Id).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<LinkHeader> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<LinkHeader> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
// GET: QLNews
public ActionResult GetAllNews(int? index, int page, int pageSize)
{
GridViewModel<News> viewModel = new GridViewModel<News>();
int totalItems = dbContext.Newss.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<News> data = dbContext.Newss.Include(x => x.CatagoryNews).OrderBy(x => x.Date).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<News> { GridData = data, CurrentPage = page, TotalItems = totalItems};
}
else
{
viewModel = new GridViewModel<News> { GridData = data, TotalItems = totalItems};
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
public ActionResult GetSlideShowPage(int? index, int page, int pageSize)
{
GridViewModel<SlideShow> viewModel = new GridViewModel<SlideShow>();
int totalItems = dbContext.SlideShows.Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<SlideShow> data = dbContext.SlideShows.OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<SlideShow> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<SlideShow> { GridData = data, TotalItems = totalItems };
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
protected override void OnInitialized()
{
GridViewModel = GetViewModel<GridViewModel<ProductModel>>();
GridViewModel.Filter = FilterProduct;
_initializedTask = _repository
.GetProductsAsync(DisposeCancellationToken)
.TryExecuteSynchronously(task => GridViewModel.UpdateItemsSource(task.Result))
.WithBusyIndicator(this);
}
public ViewModel()
{
listViewModel = new ListViewModel();
ListViewModel.AddItem();
gridViewModel = new GridViewModel();
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Name");
viewModel.Columns.Add("DisplayName");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("Measurement");
viewModel.Pager.PageSize = 10;
return viewModel;
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("PeriodeType");
viewModel.Columns.Add("Date");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("Temperature");
viewModel.Pager.PageSize = 10;
return viewModel;
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("PeriodeType");
viewModel.Columns.Add("Type");
viewModel.Columns.Add("Title");
viewModel.Columns.Add("Date");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return viewModel;
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("FromName");
viewModel.Columns.Add("ToName");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("Name");
viewModel.Columns.Add("IsReverse");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return viewModel;
}
public virtual ActionResult UserGroups(long id)
{
var role = roleService.Find(id);
if (role == null)
{
throw new HttpException((int)HttpStatusCode.NotFound, Translate("Messages.CouldNotFoundEntity"));
}
IList<GridColumnViewModel> columns = new List<GridColumnViewModel>
{
new GridColumnViewModel
{
Name = Translate(".Model.Role.UserGroupName"),
Index = "Name",
Width = 1100
},
new GridColumnViewModel
{
Name = "Id",
Sortable = false,
Hidden = true
}
};
var model = new GridViewModel
{
DataUrl = Url.Action(MVC.Admin.Role.UserGroupsDynamicGridData()),
DefaultOrderColumn = "Name",
GridTitle = Translate(".Model.UserGroups"),
Columns = columns,
MultiSelect = true,
IsRowNotClickable = true,
SelectedIds = role.UserGroups.Select(t => t.Id),
Title = String.Format(Translate("Titles.Role_UserGroups"), role.Name)
};
return View(model);
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Name");
viewModel.Columns.Add("Remark");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return viewModel;
}
public void ItemsSourceShouldBeEmptyWhenVmCreated()
{
var gridViewModel = new GridViewModel<object>();
gridViewModel.ItemsSource.ShouldBeEmpty();
}
// GET: QLVideo
public ActionResult GetVideoPage(int? index, int page, int pageSize, int Id, string type)
{
GridViewModel<Video> viewModel = new GridViewModel<Video>();
if (type == "News")
{
int totalItems = dbContext.Videos.Where(x => x.NewsId == Id).Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<Video> data = dbContext.Videos.Where(x => x.NewsId == Id).OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<Video> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<Video> { GridData = data, TotalItems = totalItems };
}
}
else if (type == "Provider")
{
int totalItems = dbContext.Videos.Where(x => x.ProviderId == Id).Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<Video> data = dbContext.Videos.Where(x => x.ProviderId == Id).OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<Video> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<Video> { GridData = data, TotalItems = totalItems };
}
}
else if (type == "Area")
{
int totalItems = dbContext.Videos.Where(x => x.MaterialAreaId == Id).Count();
if (index != null && index != 0)
{
page = (int)Math.Ceiling((decimal)(index + 1) / (decimal)pageSize);
}
if (index == 0)
{
page = 1;
}
IEnumerable<Video> data = dbContext.Videos.Where(x => x.MaterialAreaId == Id).OrderBy(x => x.Name).Skip((page - 1) * pageSize).Take(pageSize).ToList();
if (index != null)
{
viewModel = new GridViewModel<Video> { GridData = data, CurrentPage = page, TotalItems = totalItems };
}
else
{
viewModel = new GridViewModel<Video> { GridData = data, TotalItems = totalItems };
}
}
return Json(viewModel, JsonRequestBehavior.AllowGet);
}
PartialViewResult YearlyBindingCore(GridViewModel gridViewModel)
{
gridViewModel.ProcessCustomBinding(
YearlyGetDataRowCount,
YearlyGetData
);
return PartialView("_YearlyGridPartial", gridViewModel);
}
public virtual ActionResult Users(long id)
{
var userGroup = userGroupService.Find(id);
if (userGroup == null)
{
throw new HttpException((int)HttpStatusCode.NotFound, Translate("Messages.CouldNotFoundEntity"));
}
IList<GridColumnViewModel> columns = new List<GridColumnViewModel>
{
new GridColumnViewModel
{
Name = "Name",
Index = "Username",
Width = 1100
},
new GridColumnViewModel
{
Name = "Id",
Sortable = false,
Hidden = true
}
};
var model = new GridViewModel
{
DataUrl = Url.Action(MVC.Admin.UserGroup.UsersDynamicGridData()),
DefaultOrderColumn = "Username",
GridTitle = "Users",
Columns = columns,
MultiSelect = true,
IsRowNotClickable = true,
SelectedIds = userGroup.Users.Select(t => t.Id),
Title = String.Format(Translate("Titles.UserGroup_Users"), userGroup.Name)
};
return View(model);//View(UserGroupHelper.BuildAssignmentModel(userGroup));
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("Name");
viewModel.Columns.Add("Capacity");
viewModel.Columns.Add("Type");
viewModel.Columns.Add("Measurement");
viewModel.Pager.PageSize = 10;
return viewModel;
}
public virtual ActionResult Index()
{
IList<GridColumnViewModel> columns = new List<GridColumnViewModel>
{
new GridColumnViewModel {
Name = Translate("Models.PageLocale.Title"),
Index = "Title"
},
new GridColumnViewModel
{
Name = Translate("Models.PageLocale.Url"),
Index = "page.Url"
},
new GridColumnViewModel
{
Name = Translate("Models.PageLocale.InMainMenu"),
Index = "page.InMainMenu"
},
new GridColumnViewModel
{
Name = Translate("Actions.Actions"),
Sortable = false
},
new GridColumnViewModel
{
Width = 10,
Sortable = false
},
new GridColumnViewModel
{Name = "Id", Sortable = false, Hidden = true}
};
var model = new GridViewModel
{
DataUrl = Url.Action(MVC.Admin.PageTemplate.DynamicGridData()),
DetailsUrl = String.Format("{0}/", Url.Action(MVC.Admin.PageTemplate.Edit())),
DefaultOrderColumn = "Title",
GridTitle = Translate(".Pages"),
Columns = columns
};
return View(model);
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel();
viewModel.KeyFieldName = "Id";
viewModel.Columns.Add("GraphicName");
viewModel.Columns.Add("GraphicType");
viewModel.Pager.PageSize = 10;
return viewModel;
}
protected override void OnInitialized()
{
GridViewModel = GetViewModel<GridViewModel<TableItemModel>>();
GridViewModel.Filter = Filter;
for (int i = 0; i < 100; i++)
{
GridViewModel.ItemsSource.Add(new TableItemModel
{
Id = i,
Name = "Item " + i.ToString(CultureInfo.InvariantCulture)
});
}
}
protected override void OnInitialized()
{
UserGridViewModel = GetViewModel<GridViewModel<UserModel>>();
UserEditorViewModel = GetViewModel<UserEditorViewModel>();
UserGridViewModel.UpdateItemsSource(_userRepository.GetUsers());
InitializeNewUser();
}
PartialViewResult BindingCore(GridViewModel gridViewModel)
{
gridViewModel.ProcessCustomBinding(
GetDataRowCount,
GetData
);
return PartialView("_GridViewPartial", gridViewModel);
}
static GridViewModel CreateGridViewModel()
{
var viewModel = new GridViewModel() { KeyFieldName = "Id" };
viewModel.Columns.Add("KpiName");
viewModel.Columns.Add("PeriodeType");
viewModel.Columns.Add("Value");
viewModel.Columns.Add("IsActive");
viewModel.Pager.PageSize = 10;
return viewModel;
}
