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());
}
