Учет и обработка строительной документации (стр. 19 )

  mandText = "INSERT INTO t_sprav ([id_sprav],[id_item],[val_1],[val_2]) VALUES (" + m_IDSprav. ToString() + "," + _newID. ToString() + ",'" + _val1 + "','" + _val2 +"')";

  }

  else

  {

  mandText = String. Format("UPDATE t_sprav SET [val_1]='{2}',[val_2]='{3}' WHERE [id_sprav]={0} AND [id_item]={1}", m_IDSprav. ToString(), _IDItem. ToString(), _val1, _val2);

  }

  int _result = _command. ExecuteNonQuery();

  if (_result!= 1) MessageBox. Show("Ошибка записи в базу данных", "Ошибка!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  catch (OleDbException _ex)

  {

  MessageBox. Show("Ошибка записи в базу данных: " + _ex. Message, "Ошибка!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  }

  public void RetrieveGrids()

  {

  this. spravDataTable. Clear();

  querySpravAdapter. Fill(spravDataTable);

  gridSpravList. Refresh();

  }

  private void OnDeletingRow(object sender, DataGridViewRowCancelEventArgs e)

  {

  try

  {

  int deletedID = e. Row. Cells["id_item"].Value. ToString() == "" ? 0 : (int)e. Row. Cells["id_item"].Value;

  if (deletedID!= 0)

  {

  OleDbCommand _command = new OleDbCommand();

  mandType = CommandType. Text;

  _command. Connection = Program. accessConnection;

  switch (m_IDSprav)

  {

  case 1:

  mandText = "SELECT count(*) FROM t_clients WHERE doc_type="+deletedID. ToString();

  break;

  case 2:

  mandText = "SELECT count(*) FROM t_users WHERE position=" + deletedID. ToString();

  break;

  default:

  break;

  }

  int _rowCount = (int)_command. ExecuteScalar();

  if (_rowCount > 0)

  {

  e. Cancel = true;

  MessageBox. Show("Ошибка удаления, есть связанные записи, возможно нарушение целостности БД.", "Ошибка!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  else

  {

  mandText = String. Format("DELETE t_sprav.* FROM t_sprav WHERE id_sprav={0} AND id_item={1}", m_IDSprav. ToString(),deletedID. ToString());

  int _result = _command. ExecuteNonQuery();

  if (_result == 0)

  {

  e. Cancel = true;

  MessageBox. Show("Ошибка удаления записи.", "Ошибка!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  }

  }

  }

  catch (OleDbException _ex)

  {

  editedRow = -1;

  MessageBox. Show("Ошибка записи в базу данных: " + _ex. Message, "Ошибка!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  }

  }

}

Файл UserList. cs

using System;

using System. Collections. Generic;

using ponentModel;

using System. Data;

using System. Drawing;

using System. Linq;

using System. Text;

using System. Windows. Forms;

namespace Realty

{

  public partial class UserList : MyChildForm

  {

  public UserList() : base()

  {

  InitializeComponent();

  }

  public UserList(MainFrame _mainFrame, FrameType _frameType) : base(_mainFrame, _frameType)

  {

  InitializeComponent();

  this. WindowState = FormWindowState. Maximized;

  }

  private void OnAddClick(object sender, EventArgs e)

  {

  EditUser();

  }

  private void OnEditClick(object sender, EventArgs e)

  {

  int _index = (int)(gridUserList. SelectedRows[0].Cells["id_user"].Value);

  EditUser(_index);

  }

  private void OnDeleteClick(object sender, EventArgs e)

  {

  }

  private void UserList_Load(object sender, EventArgs e)

  {

  this. usersListTableAdapter. Connection = Program. accessConnection;

  this. usersListTableAdapter. Fill(this. realtyDataSet. usersListTable);

  }

  private void OnMouseDown(object sender, MouseEventArgs e)

  {

  DataGridView. HitTestInfo hti = gridUserList. HitTest(e. X, e. Y);

  int rowSelected = hti. RowIndex;

  int columnSelected = hti. ColumnIndex;

  if (rowSelected!= -1 && columnSelected!= -1)

  {

  this. gridUserList. CurrentCell = gridUserList. Rows[rowSelected].Cells[columnSelected];

  this. gridUserList. Rows[rowSelected].Selected = true;

  menuUserEdit. Enabled = true;

  menuUserDelete. Enabled = true;

  }

  else if (e. Button == MouseButtons. Right)

  {

  this. gridUserList. CurrentCell = null;

  this. gridUserList. ClearSelection();

  menuUserEdit. Enabled = false;

  menuUserDelete. Enabled = false;

  }

  }

  private void EditUser(int _index = 0)

  {

  UserDialog _dlg = new UserDialog(_index);

  if (_dlg. m_Result == Constants. LOAD_OK)

  {

  _dlg. ShowDialog(this);

  RetrieveGrids();

  }

  else

  {

  MessageBox. Show("Ошибка загрузки данных пользователя.", "Ошибка", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  }

  private void RetrieveGrids()

  {

  this. realtyDataSet. usersListTable. Clear();

  this. usersListTableAdapter. Fill(this. realtyDataSet. usersListTable);

  gridUserList. Refresh();

  }

  }

}