private void radGridView3_UserAddingRow(object sender, GridViewRowCancelEventArgs e)
{
if (e.Rows[0].Cells[1].Value == null)
{
AlertOperation("job_soc_rabotnik_add", new string[] { "Не указана дата начала.", "1" });
e.Cancel = true;
return;
}
_status = true;
var commandServer = new CommandServer();
var line = radGridViewSoc.CurrentRow.Cells[0].Value + ",'" + e.Rows[0].Cells[1].Value + "',";
radGridViewSoc.CurrentRow.Cells[2].Value = e.Rows[0].Cells[1].Value;
if (e.Rows[0].Cells[2].Value != null)
{
line += "'" + e.Rows[0].Cells[2].Value + "'";
radGridViewSoc.CurrentRow.Cells[3].Value = e.Rows[0].Cells[2].Value;
}
else
{
line += "null";
}
var returnSqlServer = commandServer.ExecReturnServer("job_soc_rabotnik_add", line);
UpdateLoadJobTime();
AlertOperation("job_soc_rabotnik_add " + line, returnSqlServer);
}
private void radGridView4_UserAddingRow(object sender, GridViewRowCancelEventArgs e)
{
if (e.Rows[0].Cells[1].Value == null)
{
AlertOperation("job_spezialist_add", new string[] { "Не указана дата начала.", "1" });
e.Cancel = true;
return;
}
_status = true;
var commandServer = new CommandServer();
var line = radGridView2.CurrentRow.Cells[0].Value + ",'" + e.Rows[0].Cells[1].Value + "',";
if (e.Rows[0].Cells[2].Value != null)
{
line += "'" + e.Rows[0].Cells[2].Value + "'";
}
else
{
line += "null";
}
var returnSqlServer = commandServer.ExecReturnServer("job_spezialist_add", line);
if (returnSqlServer[1] == "1")
{
LoadGridFio();
LoadGridFioOff();
}
AlertOperation("job_spezialist_add " + line, returnSqlServer);
}
private void radGridView3_RowsChanging(object sender, GridViewCollectionChangingEventArgs e)
{
var commandServer = new CommandServer();
var commandClient = new CommandClient();
if (e.Action == NotifyCollectionChangedAction.ItemChanging)
{
var line = (GridViewRowInfo)e.NewItems[0];
if (line.Cells[0].Value != null)
{
_status = true;
var parameters = "'" + line.Cells[0].Value.ToString() + "','";
if (e.PropertyName == "date_start")
{
parameters += e.NewValue.ToString() + "',";
radGridViewSoc.CurrentRow.Cells[2].Value = e.NewValue;
}
else
{
parameters += line.Cells[1].Value.ToString() + "',";
}
if (e.PropertyName == "date_end")
{
if (e.NewValue == null)
{
parameters += "null";
}
else
{
parameters += "'" + e.NewValue.ToString() + "'";
radGridViewSoc.CurrentRow.Cells[3].Value = e.NewValue;
}
}
else
{
if (line.Cells[2].Value == null)
{
parameters += "null";
}
else
{
parameters += "'" + line.Cells[2].Value.ToString() + "'";
}
}
var returnSqlServer = commandServer.ExecReturnServer("job_soc_rabotnik_edit", parameters);
UpdateLoadJobTime();
AlertOperation("job_soc_rabotnik_edit " + line.Cells[1].Value, returnSqlServer);
//radGridViewSoc.Invoke(new MethodInvoker(delegate ()
//{
// radGridViewSoc.DataSource = _bindingSource_soc;
//}));
//loadGridSoc();
//LoadGridSoc();
}
}
}
//редактирование
private void radGridView1_RowsChanging(object sender, GridViewCollectionChangingEventArgs e)
{
if (_status)
{
_status = false;
return;
}
var commandServer = new CommandServer();
var commandClient = new CommandClient();
if (e.Action == NotifyCollectionChangedAction.ItemChanging)
{
var line = (GridViewRowInfo)e.NewItems[0];
if (line.Cells[0].Value != null)
{
if (e.PropertyName == "ФИО")
{
var parameters = "'" + line.Cells[1].Value.ToString() + "','";
string text = null;
if (e.NewValue.ToString().Split(' ').Length == 3)
{
text = commandClient.CharTo(e.NewValue.ToString().Split(' ')[0]) + " " +
commandClient.CharTo(e.NewValue.ToString().Split(' ')[1]) + " " +
commandClient.CharTo(e.NewValue.ToString().Split(' ')[2]);
}
else
{
text = e.NewValue.ToString();
}
parameters += text + "'";
var returnSqlServer = commandServer.ExecReturnServer("socRabotnik_edit", parameters);
if (returnSqlServer[1] == "0")
{
e.Cancel = true;
}
//loadGridSoc();
//LoadGridSoc();
AlertOperation("socRabotnik_edit " + line.Cells[1].Value, returnSqlServer);
}
}
}
}
//добавление
private void radGridView1_UserAddingRow(object sender, GridViewRowCancelEventArgs e)
{
if (_status)
{
_status = false;
return;
}
if (e.Rows[0].Cells[1].Value == null || e.Rows[0].Cells[1].Value.ToString() == "")
{
AlertOperation("addSocRabotnik", new string[] { "Не указано ФИО.", "1" });
e.Cancel = true;
return;
}
var commandServer = new CommandServer();
var commandClient = new CommandClient();
string fio;
var line = e.Rows[0].Cells[1].Value.ToString();
if (e.Rows[0].Cells[1].Value.ToString().Split(' ').Length == 3)
{
fio = commandClient.CharTo(e.Rows[0].Cells[1].Value.ToString().Split(' ')[0]) + " " +
commandClient.CharTo(e.Rows[0].Cells[1].Value.ToString().Split(' ')[1]) + " " +
commandClient.CharTo(e.Rows[0].Cells[1].Value.ToString().Split(' ')[2]);
}
else
{
fio = e.Rows[0].Cells[1].Value.ToString();
}
var parameters = "'" + fio + "'";
var returnSqlServer = commandServer.ExecReturnServer("socRabotnik_add", parameters);
if (returnSqlServer[1] == "0")
{
e.Cancel = true;
}
//loadGridSoc();
//LoadGridSoc();
AlertOperation("socRabotnik_add " + parameters, returnSqlServer);
}
private void radGridView6_RowsChanging(object sender, GridViewCollectionChangingEventArgs e)
{
var commandServer = new CommandServer();
var commandClient = new CommandClient();
bool update = false;
if (e.Action == NotifyCollectionChangedAction.ItemChanging)
{
var line = (GridViewRowInfo)e.NewItems[0];
if (line.Cells[0].Value != null)
{
_status = true;
var parameters = "'" + line.Cells[0].Value.ToString() + "','";
if (e.PropertyName == "date_start")
{
parameters += e.NewValue.ToString() + "',";
radGridView5.CurrentRow.Cells[2].Value = e.NewValue;
}
else
{
parameters += line.Cells[1].Value.ToString() + "',";
}
if (e.PropertyName == "date_end")
{
if (e.NewValue == null)
{
parameters += "null";
}
else
{
parameters += "'" + e.NewValue.ToString() + "'";
radGridView5.CurrentRow.Cells[3].Value = e.NewValue;
update = true;
}
}
else
{
if (line.Cells[2].Value == null || line.Cells[2].Value.ToString() == "")
{
parameters += "null";
}
else
{
parameters += "'" + line.Cells[2].Value.ToString() + "'";
}
}
var returnSqlServer = commandServer.ExecReturnServer("job_spezialist_edit", parameters);
AlertOperation("job_spezialist_edit " + line.Cells[1].Value, returnSqlServer);
if (update)
{
LoadGridFio();
LoadGridFioOff();
}
else
{
UpdateLoadJobTime();
}
}
}
}
