private void radGridView1_UserAddedRow(object sender, GridViewRowEventArgs e)
{
var commandServer = new CommandServer();
_bindingSource = new BindingSource {
DataSource = commandServer.DataGridSet(@"select key_typeHelp, typeHelp as [Тип помощи] from typeHelp order by typeHelp").Tables[0]
};
radGridView1.Invoke(new MethodInvoker(delegate()
{
radGridView1.DataSource = _bindingSource.DataSource;
}));
}
//обновление таблицы
private void radGridViewSoc_UserAddedRow(object sender, GridViewRowEventArgs e)
{
var commandServer = new CommandServer();
_bindingSource_soc = new BindingSource {
DataSource = commandServer.DataGridSet(@"select *
from socPersonelViewColor() order by [ФИО]").Tables[0]
};
radGridViewSoc.Invoke(new MethodInvoker(delegate()
{
radGridViewSoc.DataSource = _bindingSource_soc;
}));
}
private void radGridView5_UserAddedRow(object sender, GridViewRowEventArgs e)
{
var commandServer = new CommandServer();
_bindingSource_personel = new BindingSource {
DataSource = commandServer.DataGridSet(@"select *
from spezialistView(0, 0)
order by [ФИО]").Tables[0]
};
radGridView5.Invoke(new MethodInvoker(delegate()
{
radGridView5.DataSource = _bindingSource_personel;
}));
}
private void LoadGridInspector(object sender, DoWorkEventArgs e)
{
var commandServer = new CommandServer();
_binding = new BindingSource {
DataSource = commandServer.DataGridSet(@"select*
from spezialistView(1, 0)
order by[ФИО]").Tables[0]
};
radGridView1.DataSource = _binding;
if (radGridView1.Columns.Count > 0)
{
radGridView1.Columns[0].IsVisible = false;
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
}
private void LoadGridInspector()
{
var commandServer = new CommandServer();
_binding = new BindingSource {
DataSource = commandServer.DataGridSet(@"select*
from spezialistViewColor('1')
where date_end is null
order by[ФИО]").Tables[0]
};
radGridView1.DataSource = _binding;
if (radGridView1.Columns.Count > 0)
{
radGridView1.Columns[0].IsVisible = false;
radGridView1.Columns[2].IsVisible = false;
radGridView1.Columns[3].IsVisible = false;
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
}
private void UpdateGridView()
{
var commandServer = new CommandServer();
_bindingSource = new BindingSource {
DataSource = commandServer.DataGridSet(@"select key_typeHelp, typeHelp as [Тип помощи] from typeHelp order by typeHelp").Tables[0]
};
radGridView1.Invoke(new MethodInvoker(delegate()
{
radGridView1.DataSource = _bindingSource;
radGridView1.Columns[0].IsVisible = false;
using (radGridView1.DeferRefresh())
{
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
foreach (GridViewDataColumn column in radGridView1.Columns)
{
column.BestFit();
}
}
radGridView1.Columns[1].WrapText = true;
}));
}
