protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; var col = grid.CreateColumn("Code", "Code", 80, Alignment.MiddleCenter); col.GroupBoxEffects = GroupBoxEffects.None; grid.CreateColumn("Description", "Description", 200); //col = grid.CreateColumn("Mandatory", "Mandatory", 80, Alignment.MiddleCenter); //col.EditorType = typeof(GridCheckBoxXEditControl); col = grid.CreateColumn("Priority", "Priority", 80, Alignment.MiddleCenter); col.EditorType = typeof(GridCheckBoxXEditControl); col = grid.CreateColumn("Active", "Active", 80, Alignment.MiddleCenter); col.EditorType = typeof(GridCheckBoxXEditControl); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Lastname"]); }
public ActionResult RTL(string gridState = "") { //string returnUrl = Request.Path; string returnUrl = "/Home/RTL"; ViewData["returnUrl"] = returnUrl; var shipperList = _shippersRepository.GetAll() .Select(s => new SelectItem(s.ShipperID.ToString(), s.CompanyName)) .ToList(); ViewData["shipperList"] = shipperList; IQueryCollection query = Request.Query; if (!string.IsNullOrWhiteSpace(gridState)) { try { query = new QueryCollection(StringExtensions.GetQuery(gridState)); } catch (Exception) { // do nothing, gridState was not a valid state } } var model = new SGrid <Order>(_orderRepository.GetAll(), query, false, GridPager.DefaultAjaxPagerViewName); ViewBag.ActiveMenuTitle = "RTL"; return(View(model)); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; var col = new GridColumn(); col = grid.CreateColumn("TaxId", "Tax Id", 80); col.DataType = typeof(int); grid.CreateColumn("Description", "Description", 200); grid.CreateColumn("Short", "Short Description", 100); grid.CreateColumn("Dependent", "Dependent", 80, Alignment.MiddleCenter); grid.CreateColumn("Exemption", "Exemption", 80, Alignment.MiddleRight); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["TaxId"]); }
public GridHtmlOptions(SGrid <T> source, ViewContext viewContext, string viewName, IViewEngine viewEngine) { _viewEngine = viewEngine; _source = source; _viewContext = viewContext; GridViewName = viewName; }
public ActionResult GetOrdersGridRows() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); return(PartialView("_OrdersGrid", model)); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; // grid.CreateColumn("CameraCounter", "Image File", 85); grid.CreateColumn("Id", "Id"); grid.CreateColumn("SubjectCode", "Subject Code", 100); grid.CreateColumn("Subject", "Subject", 150); grid.CreateColumn("SectionId", "Section Id"); grid.CreateColumn("Section", "Section", 80); grid.CreateColumn("Teacher", "Teacher", 180); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Lastname"]); }
private void del_Click(object sender, EventArgs e) { string id = sId.Text; Regex regexId = new Regex(@"^[1-9]\d*$"); if (regexId.IsMatch(id)) { string searchId = "Id = " + id; DataRow[] rowId = virusesDBDataSet2.Scientist.Select(searchId); SqlDataAdapter adapter = new SqlDataAdapter(); String vCheck = "Select Id from VirusScientist where ScientistId = '" + id + "'"; adapter.SelectCommand = new SqlCommand(vCheck, cnn); Object check = adapter.SelectCommand.ExecuteScalar(); if (rowId.Length == 1 && check == null) { String sql = "DELETE from Scientist Where Id = " + id; adapter.DeleteCommand = new SqlCommand(sql, cnn); adapter.DeleteCommand.ExecuteNonQuery(); this.scientistTableAdapter.Fill(this.virusesDBDataSet2.Scientist); SGrid.Refresh(); SGrid.Update(); } else { MessageBox.Show("Element with this ID is not in table!"); } } else { MessageBox.Show("Id is not correct!"); } }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.CreateColumn("Id", "Id", 60, Alignment.MiddleCenter); grid.CreateColumn("Username", "Username", 80); grid.CreateColumn("Role", "Role", 150); grid.CreateColumn("LinkedAccount", "Linked Employee", 200); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Username"]); }
private void upd_Click(object sender, EventArgs e) { string id = sId.Text; Regex regexId = new Regex(@"^[1-9]\d*$"); if (regexId.IsMatch(id)) { string name = sName.Text; string country = sCou.Text; string searchId = "Id = " + id; string searchName = "Name = '" + name + "'"; DataRow[] rowId = virusesDBDataSet2.Scientist.Select(searchId); DataRow[] rowName = virusesDBDataSet2.Scientist.Select(searchName); Regex regex = new Regex("^([a-zA-Z]{2,}\\s[a-zA-z]{1,}'?-?[a-zA-Z]{2,}\\s?([a-zA-Z]{1,})?)"); if (rowId.Length == 1 && rowName.Length == 0 && regex.IsMatch(name) && CountryValidator(country)) { SqlDataAdapter adapter = new SqlDataAdapter(); String sql = "UPDATE Scientist SET Name = '" + name + "', Country ='" + country + "' Where Id = " + id; adapter.UpdateCommand = new SqlCommand(sql, cnn); adapter.UpdateCommand.ExecuteNonQuery(); this.scientistTableAdapter.Fill(this.virusesDBDataSet2.Scientist); SGrid.Refresh(); SGrid.Update(); } else { MessageBox.Show("Name is not correct or element with this ID or Name is not in table!"); } } else { MessageBox.Show("Id is not correct!"); } }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; var col = grid.CreateColumn("BiometricId", "Biometric Id", 80, Alignment.MiddleCenter); grid.CreateColumn("Lastname", "Lastname", 90); grid.CreateColumn("Firstname", "Firstname", 100); grid.CreateColumn("Middlename", "Middlename", 80); grid.CreateColumn("NameExtension", "Ext", 40); grid.CreateColumn("Gender", "Gender"); grid.CreateColumn("Category", "Category", 90); grid.CreateColumn("PhoneNumber", "Phone No.", 100); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Lastname"]); }
public ActionResult Subgrid(string gridState = "") { //string returnUrl = Request.Path; string returnUrl = "/Home/Subgrid"; ViewData["returnUrl"] = returnUrl; IQueryCollection query = Request.Query; if (!string.IsNullOrWhiteSpace(gridState)) { try { query = new QueryCollection(StringExtensions.GetQuery(gridState)); } catch (Exception) { // do nothing, gridState was not a valid state } } var model = new SGrid <Order>(_orderRepository.GetAll(), query, false, GridPager.DefaultAjaxPagerViewName); ViewBag.ActiveMenuTitle = "Subgrid"; return(View(model)); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; var col = grid.CreateColumn("Effectivity", "Effectivity", 180); //col.EditorType = typeof(GridDateTimeInputEditControl); //col.RenderType = typeof(GridTextBoxXEditControl); grid.CreateColumn("Remarks", "Remarks", 200); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort //grid.SetSort(SGrid.PrimaryGrid.Columns["Effectivity"], SortDirection.Descending); //SGrid.Update(); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.CreateColumn("Id", "Id", 50, Alignment.MiddleCenter); grid.CreateColumn("Lastname", "Lastname", 90); grid.CreateColumn("Firstname", "Firstname", 100); grid.CreateColumn("Middlename", "Middlename", 80); grid.CreateColumn("NameExtension", "Ext", 40); grid.CreateColumn("Gender", "Gender"); grid.CreateColumn("Birthdate", "Birthdate", 80, Alignment.MiddleCenter); grid.CreateColumn("BirthTown", "Town", 120); grid.CreateColumn("BirthProvince", "Province", 85); grid.CreateColumn("BirthCountry", "Country", 70); grid.CreateColumn("CameraCounter", "Image File", 85); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Lastname"]); }
public ActionResult AjaxPaging() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); ViewBag.ActiveMenuTitle = "AjaxPaging"; return(View(model)); }
public async Task <IViewComponentResult> InvokeAsync() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), HttpContext.Request.Query, false, GridPager.DefaultAjaxPagerViewName); var factory = Task <IViewComponentResult> .Factory; return(await factory.StartNew(() => View(model))); }
protected void InitializeGrid() { SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; var col = new GridColumn(); SGrid.RowDoubleClick += (s, e) => { btnPayViewProfile.RaiseClick(); }; SGrid.ColumnHeaderMouseUp += SGrid_ColumnHeaderMouseUp; grid.GroupByRow.Visible = false; grid.Filter.Visible = true; grid.EnableFiltering = true; grid.EnableColumnFiltering = true; grid.FilterMatchType = FilterMatchType.RegularExpressions; grid.CheckBoxes = true; grid.CreateColumn("Empnum", "Employee No.", 100, Alignment.MiddleCenter); grid.CreateColumn("Name", "Name", 200); grid.CreateColumn("Gender", "Gender", 50, Alignment.MiddleCenter).Visible = false; grid.CreateColumn("Position", "Position", 90); grid.CreateColumn("Department", "Department", 90); grid.CreateColumn("TaxCode", "Tax Code", 80); grid.CreateColumn("SG", "SG", 40, Alignment.MiddleCenter); grid.CreateColumn("Step", "Step", 40, Alignment.MiddleCenter); col = grid.CreateColumn("Exemption", "Tax Exemption", 80, Alignment.MiddleRight); col.RenderType = typeof(GridDoubleInputEditControl); col = grid.CreateColumn("BasicSalary", "Salary", 80, Alignment.MiddleRight); col.RenderType = typeof(GridDoubleInputEditControl); col = grid.CreateColumn("Active", "Active", 40, Alignment.MiddleCenter); col.RenderType = typeof(GridCheckBoxXEditControl); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Name"]); }
public ActionResult GetOrdersGridRows() { //string returnUrl = Request.Path; string returnUrl = "/Home/Subgrid"; ViewData["returnUrl"] = returnUrl; var model = new SGrid <Order>(_orderRepository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); return(PartialView("_OrdersGrid", model)); }
public GridServer(IEnumerable <T> items, IQueryCollection query, bool renderOnlyRows, string viewName, Action <IGridColumnCollection <T> > columns = null, int?pageSize = null, string language = "") { _source = new SGrid <T>(items, query, renderOnlyRows); GridViewName = viewName; columns?.Invoke(_source.Columns); if (!string.IsNullOrWhiteSpace(language)) { _source.Language = language; } if (pageSize.HasValue) { WithPaging(pageSize.Value); } }
public frmRolePrivileges() { InitializeComponent(); InitializeGrid(); Shown += (s, e) => { LoadItems(); SGrid.PrimaryGrid.ExpandAll(3); SGrid.Refresh(); }; }
public GridServer(IEnumerable <T> items, IQueryCollection query, bool renderOnlyRows, string gridName, Action <IGridColumnCollection <T> > columns = null, int?pageSize = null, string language = "", string pagerViewName = GridPager.DefaultPagerViewName, IColumnBuilder <T> columnBuilder = null) { _source = new SGrid <T>(items, query, renderOnlyRows, pagerViewName, columnBuilder); _source.RenderOptions.GridName = gridName; columns?.Invoke(_source.Columns); if (!string.IsNullOrWhiteSpace(language)) { _source.Language = language; } if (pageSize.HasValue) { WithPaging(pageSize.Value); } }
public ActionResult GetOrdersGridRows() { //string returnUrl = Request.Path; string returnUrl = "/Home/Subgrid"; ViewData["returnUrl"] = returnUrl; var shipperList = _shippersRepository.GetAll() .Select(s => new SelectItem(s.ShipperID.ToString(), s.CompanyName)) .ToList(); ViewData["shipperList"] = shipperList; var model = new SGrid <Order>(_orderRepository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); return(PartialView("_OrdersGrid", model)); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; grid.CreateColumn("Code", "Code", 120); grid.CreateColumn("Description", "Description", 200); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Lastname"]); }
protected override void InitializeGrid() { base.InitializeGrid(); SGrid.InitializeGrid(); var grid = SGrid.PrimaryGrid; grid.GroupByRow.Visible = false; grid.CreateColumn("Batch", "Batch", 90); grid.CreateColumn("Semester", "Semester", 100); grid.CreateRecordInfoColumns(); // Create COntext Menu; CreateGridContextMenu(); //Define Sort grid.SetSort(SGrid.PrimaryGrid.Columns["Batch"]); }
public void SetGrid(SGrid grid) { _grid = grid; }
public HtmlGrid(IHtmlHelper helper, SGrid <T> source, string viewName) : base(helper, source, viewName) { }
public GridHtmlOptions(IHtmlHelper helper, SGrid <T> source, string viewName) { _helper = helper; _source = source; GridViewName = viewName; }
/// <summary> /// 创建一个格子 /// </summary> /// <returns></returns> public SGrid CreateGrid() { SGrid grid = new SGrid(); GameObject Upper = CreateCube(); GameObject Downer = CreateCube(); Upper.layer = LayerMask.NameToLayer("UpperCube"); Downer.layer = LayerMask.NameToLayer("FloorCube"); CCube UpperCube = Upper.AddComponent <CCube>(); CCube DownerCube = Downer.AddComponent <CCube>(); int xpos = _nowGridIndex * 2; float zpos = 0f; int ypos; int SafeOffset; if (_nowGridIndex < SAFE_GRID_COUNT) { //前10个Y轴固定为10 ypos = 9; SafeOffset = 2; UpperCube.IsSafe = true; } else { //后面的依照前面的进行偏移 int offset = CMath.Rand(-2, 3); ypos = _lastYPos + offset; bool isSafe = CheckIsSafe(); if (isSafe) { _lastSafeIndex = _nowGridIndex; } UpperCube.IsSafe = isSafe; SafeOffset = isSafe ? CMath.Rand(1, 3) : 0; } _lastYPos = ypos; //下方 目标坐标 int downTargetPosY = ypos - 10; //上方 目标坐标 int upTargetPosY = ypos + 10 + SafeOffset; //下方 开始坐标 int downStartPosY = downTargetPosY - 3; //上方开始坐标 int upStartPosY = upTargetPosY + 3; Upper.transform.position = new Vector3(xpos, upStartPosY, zpos); Downer.transform.position = new Vector3(xpos, downStartPosY, zpos); Upper.transform.SetParent(Root_Upper); Downer.transform.SetParent(Root_Downer); UpperCube.SetInfo(upStartPosY, upTargetPosY); DownerCube.SetInfo(downStartPosY, downTargetPosY); grid._UpperCube = Upper; grid._DownerCube = Downer; _nowGridIndex++; return(grid); }
public HtmlGrid(SGrid <T> source, ViewContext viewContext, string viewName, IViewEngine viewEngine) : base(source, viewContext, viewName, viewEngine) { _source = source; }
public void SetGrid(SGrid sGrid) { }
public IActionResult OnGet(string gridState = "") { string returnUrl = "/GridPage"; IQueryCollection query = Request.Query; if (!string.IsNullOrWhiteSpace(gridState)) { try { query = new QueryCollection(StringExtensions.GetQuery(gridState)); } catch (Exception) { // do nothing, gridState was not a valid state } } var requestCulture = HttpContext.Features.Get <IRequestCultureFeature>(); var locale = requestCulture.RequestCulture.UICulture.TwoLetterISOLanguageName; SharedResource.Culture = requestCulture.RequestCulture.UICulture; var shipperList = _shippersRepository.GetAll() .Select(s => new SelectItem(s.ShipperID.ToString(), s.CompanyName)) .ToList(); Action <IGridColumnCollection <Order> > columns = c => { /* Adding not mapped column, that renders body, using inline Razor html helper */ c.Add() .Encoded(false) .Sanitized(false) .SetWidth(60) .Css("hidden-xs") //hide on phones .RenderComponentAs <ButtonCellViewComponent>(returnUrl); /* Adding "OrderID" column: */ c.Add(o => o.OrderID) .Titled(SharedResource.Number) .SetWidth(100); /* Adding "OrderDate" column: */ c.Add(o => o.OrderDate, "OrderCustomDate") .Titled(SharedResource.OrderCustomDate) .SortInitialDirection(GridSortDirection.Descending) .ThenSortByDescending(o => o.OrderID) .SetCellCssClassesContraint(o => o.OrderDate.HasValue && o.OrderDate.Value >= DateTime.Parse("1997-01-01") ? "red" : "") .Format("{0:yyyy-MM-dd}") .SetWidth(110) .Max(true).Min(true); c.Add(o => o.ShipVia) .Titled("Via") .SetWidth(250) .RenderValueAs(o => o.Shipper?.CompanyName) .SetListFilter(shipperList); /* Adding "CompanyName" column: */ c.Add(o => o.Customer.CompanyName) .Titled(SharedResource.CompanyName) .ThenSortByDescending(o => o.ShipVia) .ThenSortByDescending(o => o.Freight) .SetWidth(250) .SetInitialFilter(GridFilterType.StartsWith, "a") .SetFilterWidgetType("CustomCompanyNameFilterWidget") .Max(true).Min(true); /* Adding "ContactName" column: */ c.Add(o => o.Customer.ContactName).Titled(SharedResource.ContactName).SetWidth(250) .Max(true).Min(true); /* Adding "Customer.Country" hidden column: */ c.Add(o => o.Customer.Country, true); /* Adding "Freight" column: */ c.Add(o => o.Freight) .Titled(SharedResource.Freight) .SetWidth(100) .Format("{0:F}") .Sum(true).Average(true).Max(true).Min(true); /* Adding "Vip customer" column: */ c.Add(o => o.Customer.IsVip) .Titled(SharedResource.IsVip) .SetWidth(80) .Css("hidden-xs") //hide on phones .RenderValueAs(o => o.Customer.IsVip ? Strings.BoolTrueLabel : Strings.BoolFalseLabel); }; var server = new GridServer <Order>(_orderRepository.GetAll(), query, false, "ordersGrid", columns, 10, locale) .SetRowCssClasses(item => item.Customer.IsVip ? "success" : string.Empty) .Sortable() .Filterable() .WithMultipleFilters() .Searchable(true, false) .Groupable(true) .ClearFiltersButton(true) .Selectable(true) .SetStriped(true) .ChangePageSize(true) .WithGridItemsCount() .SetTableLayout(TableLayout.Fixed, "1000px", "400px"); Grid = server.Grid; return(Page()); }