public void OnEnable()
{
int quant = 0;
BDClass.LerRanking(referencia1, referencia2, ref quant);
Debug.Log(quant.ToString());
switch (quant)
{
case 1:
PreencheRanking(quant);
break;
case 2:
PreencheRanking(quant);
break;
case 3:
PreencheRanking(quant);
break;
case 4:
PreencheRanking(quant);
break;
case 5:
PreencheRanking(quant);
break;
}
}
public static void FillDataGrid(DataGridView grid, BDClass bdc, string query, string filters, string orderby, bool saveOrder)
{
string sortedColumn = string.Empty;
ListSortDirection order = ListSortDirection.Ascending;
bool sorted = false;
int index = 0;
if (saveOrder && grid.SortOrder != SortOrder.None)
{
sorted = true;
sortedColumn = grid.SortedColumn.Name;
order = grid.SortOrder == SortOrder.Ascending ? ListSortDirection.Ascending : ListSortDirection.Descending;
index = grid.CurrentRow == null ? -1 : grid.CurrentRow.Index;
}
DataSet ds;
DataTable dt;
try
{
if (query != "")
{
ds = bdc.GetDataSet(query + " " + filters + " " + orderby);
dt = ds.Tables[0];
}
else
{
dt = new DataTable();
dt.Columns.Add("Id");
}
DataView dv = new DataView(dt);
dv.AllowNew = false;
grid.DataSource = dv;
grid.Columns["Id"].Visible = false;
grid.Update();
if (saveOrder && grid.Rows.Count > 0)
{
if (sorted && grid.Columns.Contains(sortedColumn))
{
grid.Sort(grid.Columns[sortedColumn], order);
}
if (index >= 0 && index <= grid.Rows.Count)
{
grid.CurrentCell = grid[1, index];
}
}
}
catch (Exception ex)
{
WinFormsServ.Error("Ошибка сервера: " + ex.Message);
}
}
void LerSom()
{
BDClass.LerSom(ref opt);
if (opt == 0)
{
checkSom.GetComponent <Toggle>().isOn = true;
}
else if (opt == 1)
{
checkSom.GetComponent <Toggle>().isOn = false;
}
AtivaOuDesativaSom();
}
public static void FillDataGrid(DataGridView grid, BDClass bdc, string query, string filters, string orderby)
{
FillDataGrid(grid, bdc, query, filters, orderby, false);
}
// заполнение DataGrid
public static void FillDataGrid(DataGridView grid, BDClass bdc, string query, string filters)
{
FillDataGrid(grid, bdc, query, filters, "");
}
public void MudaSom()
{
BDClass.AlteraSom();
AtivaOuDesativaSom();
}
public void GravarInsert()
{
nome = GameObject.Find("TextColocarNome").GetComponent <Text> ().text;
score = GameObject.Find("ScoreFinal").GetComponent <Text> ().text;
BDClass.InsertBD(nome, score);
}
