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

  {

  InitializeComponent();

  this. WindowState = FormWindowState. Maximized;

  m_IDRequest = _IDRequest;

  }

  private void RequestList_Load(object sender, EventArgs e)

  {

  if (m_IDRequest == 1)

  {

  landRequestAdapter = (new Realty. realtyDataSetTableAdapters. landRequestListTableAdapter());

  landRequestAdapter. ClearBeforeFill = true;

  landRequestAdapter. Connection = Program. accessConnection;

  SetColumns();

  landRequestAdapter. Fill(this. realtyDataSet. landRequestListTable);

  requestBindingSource. DataSource = this. realtyDataSet. landRequestListTable;

  this. Text = "Заявки на градостроительный план";

  }

  else if (m_IDRequest == 2)

  {

  objectRequestAdapter = (new Realty. realtyDataSetTableAdapters. objectRequestListTableAdapter());

  objectRequestAdapter. ClearBeforeFill = true;

  objectRequestAdapter. Connection = Program. accessConnection;

  SetColumns();

  objectRequestAdapter. Fill(this. realtyDataSet. objectRequestListTable);

  requestBindingSource. DataSource = this. realtyDataSet. objectRequestListTable;

  this. Text = "Заявки на ввод объекта в эксплуатацию";

  }

  else

  {

  buildRequestAdapter = (new Realty. realtyDataSetTableAdapters. buildRequestListTableAdapter());

  buildRequestAdapter. ClearBeforeFill = true;

  buildRequestAdapter. Connection = Program. accessConnection;

  SetColumns();

  buildRequestAdapter. Fill(this. realtyDataSet. buildRequestListTable);

  requestBindingSource. DataSource = this. realtyDataSet. buildRequestListTable;

  this. Text = "Заявки на разрешение на строительство";

  }

  }

  private void SetColumns()

  {

  this. id_request. DataPropertyName = "id_request";

  this. dateRequest. DataPropertyName = "date_req";

  this. ownerString. DataPropertyName = "ownerInfo";

  this. region. DataPropertyName = "region";

  this. district. DataPropertyName = "district";

  this. city. DataPropertyName = "city";

  this. place. DataPropertyName = "place";

  this. street. DataPropertyName = "street";

  this. home. DataPropertyName = "home";

  this. status. DataPropertyName = "status";

  }

  private void OnAddClick(object sender, EventArgs e)

  {

  EditRequest(0, m_IDRequest);

  }

  private void OnEditClick(object sender, EventArgs e)

  {

  int _index = (int)(requestDataGrid. SelectedRows[0].Cells["id_request"].Value);

  EditRequest(_index, m_IDRequest);

  }

  private void OnDeleteClick(object sender, EventArgs e)

  {

  int _index = (int)(requestDataGrid. SelectedRows[0].Cells["id_request"].Value);

  try

  {

  //Проверяем, не исполнена ли заявка. Если исполнена - удалять нельзя

  int _status = (int)requestDataGrid. SelectedRows[0].Cells["status"].Value;

  if (_status == 2)

  {

  MessageBox. Show("Заявка исполнена, удаление запрещено!", "Внимание!", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  return;

  }

  string _commText = String. Format("DELETE t_request.* FROM t_request WHERE id_request={0}", _index. ToString());

  OleDbCommand _command = new OleDbCommand(_commText, Program. accessConnection);

  int _result = _command. ExecuteNonQuery();

  if (_result == 0) MessageBox. Show("Не удалось удалить запись.", "Ошибка", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  RetrieveGrids();

  }

  catch (OleDbException _ex)

  {

  MessageBox. Show("Не удалось удалить запись. " + _ex. Message, "Ошибка", MessageBoxButtons. OK, MessageBoxIcon. Exclamation);

  }

  }

  private void EditRequest(int _index, int _type)

  {

  RequestDialog _dlg = new RequestDialog(_index, _type);

  if (_dlg. m_Result == Constants. LOAD_OK)

  {

  _dlg. ShowDialog(this);

  RetrieveGrids();

  }

  else

  {

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

  }

  }

  public void RetrieveGrids()

  {

  if (m_IDRequest == 1)

  {

  this. realtyDataSet. landRequestListTable. Clear();

  landRequestAdapter. Fill(this. realtyDataSet. landRequestListTable);

  requestDataGrid. Refresh();

  }

  else if (m_IDRequest == 2)

  {

  this. realtyDataSet. objectRequestListTable. Clear();

  objectRequestAdapter. Fill(this. realtyDataSet. objectRequestListTable);

  requestDataGrid. Refresh();

  }

  else

  {

  this. realtyDataSet. buildRequestListTable. Clear();

  buildRequestAdapter. Fill(this. realtyDataSet. buildRequestListTable);

  requestDataGrid. Refresh();

  }

  }

  private void OnCellFormatting(object sender, DataGridViewCellFormattingEventArgs e)

  {

  DataGridView grid = sender as DataGridView;

  DataGridViewRow row = grid. Rows[e. RowIndex];

  row. Cells["addresStr"].Value = Address. GetAddrString(row. Cells["region"].Value as string, row. Cells["district"].Value as string, row. Cells["city"].Value as string, row. Cells["place"].Value as string, row. Cells["street"].Value as string, row. Cells["home"].Value as string, "", "");

  int _status = (int)row. Cells["status"].Value;

  row. Cells["statusStr"].Value = (_status == 1) ? "Новая" : "Обработана";

  }

  private void OnMouseDown(object sender, MouseEventArgs e)

  {

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

  int rowSelected = hti. RowIndex;

  int columnSelected = hti. ColumnIndex;

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

  {

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

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

  menuRequestEdit. Enabled = true;

  menuRequestDelete. Enabled = true;

  }

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

  {

  this. requestDataGrid. CurrentCell = null;

  this. requestDataGrid. ClearSelection();

  menuRequestEdit. Enabled = false;

  menuRequestDelete. Enabled = false;

  }

  }

  }

}

Файл SpravList. 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;

using System. Data. OleDb;

namespace Realty

{

  public partial class SpravList : MyChildForm

  {

  public int m_IDSprav;

  private OleDbDataAdapter querySpravAdapter;

  private DataTable spravDataTable;

  private int editedRow = -1;

  public SpravList() : base()

  {

  InitializeComponent();

  }

  public SpravList(MainFrame _mainFrame, FrameType _frameType, int _idSprav) : base(_mainFrame, _frameType)

  {

  InitializeComponent();

  this. WindowState = FormWindowState. Maximized;

  m_IDSprav = _idSprav;

  }

  private void OnLoad(object sender, EventArgs e)

  {

  querySpravAdapter = new OleDbDataAdapter("SELECT * FROM t_sprav WHERE id_sprav = " + m_IDSprav. ToString(), Program. accessConnection);

  spravDataTable = new DataTable();

  querySpravAdapter. Fill(spravDataTable);

  spravBindingSource. DataSource = spravDataTable;

  SetTitle();

  SetColumns();

  }

  private void SetColumns()

  {

  this. id_item. DataPropertyName = "id_item";

  this. val_1.DataPropertyName = "val_1";

  this. val_2.DataPropertyName = "val_2";

  }

  private void SetTitle()

  {

  OleDbCommand _command = new OleDbCommand();

  mandType = CommandType. Text;

  _command. Connection = Program. accessConnection;

  mandText = "SELECT val_1 FROM t_sprav WHERE id_sprav=0 AND id_item=" + m_IDSprav. ToString();

  string _spravName = _command. ExecuteScalar() as string;

  this. Text = "Справочник \"" + _spravName + "\"";

  }

  private void OnCellValueChanged(object sender, DataGridViewCellEventArgs e)

  {

  editedRow = e. RowIndex;

  }

  private void OnCurrentCellChanged(object sender, EventArgs e)

  {

  DataGridViewSelectedCellCollection newCells = ((DataGridView)sender).SelectedCells;

  if (editedRow!= -1 && (newCells. Count == 0 || editedRow!= newCells[0].RowIndex))

  {

  object _obj = (((DataGridView)sender).Rows[editedRow].Cells["id_item"].Value);

  int _IDItem = ((_obj. Equals(DBNull. Value)) ? 0 : (int)_obj);

  string _val1 = (((DataGridView)sender).Rows[editedRow].Cells["val_1"].Value) as string;

  string _val2 = (((DataGridView)sender).Rows[editedRow].Cells["val_2"].Value) as string;

  SaveUpdateSprav(_IDItem, _val1, _val2);

  editedRow = -1;

  RetrieveGrids();

  }

  }

  private void SaveUpdateSprav(int _IDItem, string _val1, string _val2)

  {

  try

  {

  OleDbCommand _command = new OleDbCommand();

  mandType = CommandType. Text;

  _command. Connection = Program. accessConnection;

  if (_IDItem == 0)

  {

  mandText = "SELECT Max(id_item) FROM t_sprav WHERE id_sprav=" + m_IDSprav. ToString();

  object _obj = _command. ExecuteScalar();

  int _newID = ((_obj. Equals(DBNull. Value)) ? 0 : (int)_obj) + 1;