/// <summary> /// Page分页(DataTable.js) /// </summary> /// <param name="search">search</param> /// <returns></returns> public TablePage <T> GetQueryPage(Search search) { try { Page <T> pageModel; object[] args; string strWhere = search.GetConditonByDapper(out args); pageModel = ReadDataBase.Page <T>(search.CurrentPageIndex, search.PageSize, Sql.Builder.Select(search.SelectedColums).From(search.TableName).Where(strWhere, args).OrderBy(search.SortField)); TablePage <T> tablePage = new TablePage <T>(); if (pageModel != null) { tablePage.draw = search.sEcho; tablePage.recordsTotal = pageModel.TotalItems; tablePage.recordsFiltered = pageModel.TotalItems; tablePage.aaData = pageModel.Items; } return(tablePage); } catch (Exception ex) { LogHelper.Error(ex); ReadDataBase.CloseSharedConnection(); return(null); } finally { ReadDataBase.CloseSharedConnection(); } }
/// <summary> /// Page分页(DataTable.js) /// </summary> /// <param name="search">search</param> /// <returns></returns> public TablePage <T> jsonDataTable(List <T> jsonlist) { try { TablePage <T> tablePage = new TablePage <T>(); if (jsonlist != null) { tablePage.draw = 0; tablePage.recordsTotal = jsonlist.Count; tablePage.recordsFiltered = jsonlist.Count; tablePage.aaData = jsonlist; } return(tablePage); } catch (Exception ex) { LogHelper.Error(ex); ReadDataBase.CloseSharedConnection(); return(null); } finally { ReadDataBase.CloseSharedConnection(); } }
private void MenuButtonClick(object sender, RoutedEventArgs e) { TablePage page = new TablePage(); switch (((Button)e.Source).Name) { case "Firmy": page.MyInit(_db, _db.Firmy.ToList().Cast <TableBase>().ToList(), TableCategory.Firma, this); SetPage(page); break; case "Divizie": page.MyInit(_db, _db.Divizie.ToList().Cast <TableBase>().ToList(), TableCategory.Divizia, this); SetPage(page); break; case "Projekty": page.MyInit(_db, _db.Projekty.ToList().Cast <TableBase>().ToList(), TableCategory.Projekt, this); SetPage(page); break; case "Oddelenia": page.MyInit(_db, _db.Oddelenia.ToList().Cast <TableBase>().ToList(), TableCategory.Oddelenie, this); SetPage(page); break; case "Zatvorit": this.Close(); break; default: throw new ArgumentOutOfRangeException(); } }
public void Initialize() { InitBrowser(BrowserType.Firefox); driver.Navigate().GoToUrl(TablePage.BaseUrl); Methods.Methods.ImplicitWaitForSeconds(driver, 3); TablePage = new TablePage(driver); }
public void DictionaryToListTest() { // Arrange var tablePage = new TablePage(); // Act // Assert }
public virtual void testTablePageQueryAsCamundaAdmin() { // given identityService.setAuthentication(userId, Collections.singletonList(org.camunda.bpm.engine.authorization.Groups_Fields.CAMUNDA_ADMIN)); string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; // when TablePage page = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RE_PROCDEF").listPage(0, int.MaxValue); // then assertNotNull(page); }
public virtual TablePage GetTablePage(ITablePageQuery tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); TablePageQueryImpl tablePageQueryImpl = tablePageQuery as TablePageQueryImpl; IList <Dictionary <string, object> > tableData = DbSqlSession.SelectList <PropertyEntityImpl, Dictionary <string, object> >("selectTableData", null, firstResult, maxResults); tablePage.TableName = tablePageQueryImpl.TableName; tablePage.Total = GetTableCount(tablePageQueryImpl.TableName); tablePage.Rows = (IList <IDictionary <string, object> >)tableData; tablePage.FirstResult = firstResult; return(tablePage); }
public void OpenTable(IFeatureLayer featureLayer) { if (TableViews.ContainsKey(featureLayer.Name)) { ActivatePage(featureLayer.Name); return; } ITableView pTableView = new TablePage(_context, this, featureLayer); xtraTabControl.TabPages.Add(pTableView as XtraTabPage); xtraTabControl.SelectedTabPage = pTableView as XtraTabPage; TableViews.Add(featureLayer.Name, pTableView); }
//JAVA TO C# CONVERTER TODO TASK: Most Java annotations will not have direct .NET equivalent attributes: //ORIGINAL LINE: @SuppressWarnings("unchecked") public org.camunda.bpm.engine.management.TablePage getTablePage(org.camunda.bpm.engine.impl.TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) public virtual TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); //JAVA TO C# CONVERTER TODO TASK: Most Java annotations will not have direct .NET equivalent attributes: //ORIGINAL LINE: @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession().selectList("selectTableData", tablePageQuery, new org.apache.ibatis.session.RowBounds(firstResult, maxResults)); System.Collections.IList tableData = DbSqlSession.SqlSession.selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.TableName = tablePageQuery.TableName; tablePage.Total = getTableCount(tablePageQuery.TableName); tablePage.Rows = tableData; tablePage.FirstResult = firstResult; return(tablePage); }
public virtual void testGetSortedTablePage() { string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; IList <string> taskIds = generateDummyTasks(15); // With an ascending sort TablePage tablePage = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RU_TASK").orderAsc("NAME_").listPage(1, 7); string[] expectedTaskNames = new string[] { "B", "C", "D", "E", "F", "G", "H" }; verifyTaskNames(expectedTaskNames, tablePage.Rows); // With a descending sort tablePage = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RU_TASK").orderDesc("NAME_").listPage(6, 8); expectedTaskNames = new string[] { "I", "H", "G", "F", "E", "D", "C", "B" }; verifyTaskNames(expectedTaskNames, tablePage.Rows); taskService.deleteTasks(taskIds, true); }
public virtual void testGetTablePage() { string tablePrefix = processEngineConfiguration.DatabaseTablePrefix; IList <string> taskIds = generateDummyTasks(20); TablePage tablePage = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RU_TASK").listPage(0, 5); assertEquals(0, tablePage.FirstResult); assertEquals(5, tablePage.Size); assertEquals(5, tablePage.Rows.Count); assertEquals(20, tablePage.Total); tablePage = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RU_TASK").listPage(14, 10); assertEquals(14, tablePage.FirstResult); assertEquals(6, tablePage.Size); assertEquals(6, tablePage.Rows.Count); assertEquals(20, tablePage.Total); taskService.deleteTasks(taskIds, true); }
//public Program() //{ // Driver = new ChromeDriver(); // Driver.Navigate().GoToUrl("file:///C:/Users/anuradha/Desktop/Selenium/ComplexTable.html"); //} static void Main(string[] args) { //Program p = new Program(); Driver = new ChromeDriver(); Driver.Navigate().GoToUrl("file:///C:/Users/anuradha/Desktop/Selenium/ComplexTable.html"); //instantiate a new TablePage TablePage page = new TablePage(); //reads the Html table Utilities.ReadTable(page.table); /* * //get the cell value from the table * Console.WriteLine(Utilities.ReadCellValue("Firstname", 1)); */ Console.WriteLine("****************************************************************"); //string formatting for the cell values outputted in the console Console.WriteLine("Firstname {0} LastName {1} Age {2} Gender {3}", Utilities.ReadCellValue("Firstname", 2), Utilities.ReadCellValue("Lastname", 2), Utilities.ReadCellValue("Age", 2), Utilities.ReadCellValue("Gender", 2)); Console.WriteLine("****************************************************************"); //Delete John //Console.WriteLine("Calling PerformActionOnCell"); //Utilities.PerformActionOnCell("5", "Firstname", "John","Delete"); //Save John //Utilities.PerformActionOnCell("5", "Firstname", "John", "Save"); //Click the CheckBox of John by passing the column name Utilities.PerformActionOnCell("Option", "Lastname", "Doe"); Console.Read(); }
public void Setup() { DriverContent.driverInstance = BrowserFactory.browserSelection("firefox", "website"); tablepage = new TablePage(); DriverContent.driverInstance.Manage().Window.Maximize(); }
public void SetUp() { _mainPage = new MainPage(Driver).GoToMainPage(); _tablePage = _mainPage.GoToTablePage(); }
/// <summary> /// Page分页 /// </summary> /// <param name="search">search</param> /// <returns></returns> public TablePage <T> jsonDataTable(List <T> jsonlist) { TablePage <T> pageModel = CurrentRepository.jsonDataTable(jsonlist); return(pageModel); }
protected override void OnSetUp() { page = Go.To<TablePage>(); }
/// <summary> /// Page分页 /// </summary> /// <param name="search">search</param> /// <returns></returns> public TablePage <T> GetQueryPage(Search search) { TablePage <T> pageModel = CurrentRepository.GetQueryPage(search); return(pageModel); }
/// <summary> /// La méthode retourne le numéro de page ayant le compteur le plus petit /// </summary> /// <returns></returns> public override int PageAReplacer() { return(TablePage.CalculPagePetitCompteur()); }