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