Інформаційна система торгівельного закладу

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

if (disposing && (components != null))

components.Dispose();

base.Dispose(disposing);

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.components = new System.ComponentModel.Container();

this.toolTip = new System.Windows.Forms.ToolTip(this.components);

this.splitter = new System.Windows.Forms.Splitter();

this.clrpnlQueryView = new TurFirm.ColorPanel();

this.dgvQuery = new System.Windows.Forms.DataGridView();

this.clrpnlQueryText = new TurFirm.ColorPanel();

this.btnExecute = new System.Windows.Forms.Button();

this.pnlTools = new System.Windows.Forms.Panel();

this.btnZoomOut = new System.Windows.Forms.Button();

this.btnZoomIn = new System.Windows.Forms.Button();

this.btnErase = new System.Windows.Forms.Button();

this.btnRedo = new System.Windows.Forms.Button();

this.btnUndo = new System.Windows.Forms.Button();

this.rtbQueryText = new System.Windows.Forms.RichTextBox();

this.clrpnlQueryView.SuspendLayout();

((System.ComponentModel.ISupportInitialize)(this.dgvQuery)).BeginInit();

this.clrpnlQueryText.SuspendLayout();

this.pnlTools.SuspendLayout();

this.SuspendLayout();

//

// splitter

//

this.splitter.Cursor = System.Windows.Forms.Cursors.SizeNS;

this.splitter.Dock = System.Windows.Forms.DockStyle.Top;

this.splitter.Location = new System.Drawing.Point(0, 274);

this.splitter.Name = "splitter";

this.splitter.Size = new System.Drawing.Size(619, 3);

this.splitter.TabIndex = 1;

this.splitter.TabStop = false;

//

// clrpnlQueryView

//

this.clrpnlQueryView.BorderColor = System.Drawing.Color.Silver;

this.clrpnlQueryView.ColorBorderEnabled = true;

this.clrpnlQueryView.Controls.Add(this.dgvQuery);

this.clrpnlQueryView.DisplayRectangleColor = System.Drawing.Color.Empty;

this.clrpnlQueryView.Dock = System.Windows.Forms.DockStyle.Fill;

this.clrpnlQueryView.Location = new System.Drawing.Point(0, 277);

this.clrpnlQueryView.Name = "clrpnlQueryView";

this.clrpnlQueryView.Padding = new System.Windows.Forms.Padding(2);

this.clrpnlQueryView.Size = new System.Drawing.Size(619, 139);

this.clrpnlQueryView.TabIndex = 2;

//

// dgvQuery

//

this.dgvQuery.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)

| System.Windows.Forms.AnchorStyles.Left)

| System.Windows.Forms.AnchorStyles.Right)));

this.dgvQuery.BackgroundColor = System.Drawing.Color.WhiteSmoke;

this.dgvQuery.BorderStyle = System.Windows.Forms.BorderStyle.None;

this.dgvQuery.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize

this.dgvQuery.Location = new System.Drawing.Point(3, 3);

this.dgvQuery.Margin = new System.Windows.Forms.Padding(1);

this.dgvQuery.Name = "dgvQuery";

this.dgvQuery.Size = new System.Drawing.Size(613, 133);

this.dgvQuery.TabIndex = 0;

//

// clrpnlQueryText

//

this.clrpnlQueryText.BorderColor = System.Drawing.Color.Silver;

this.clrpnlQueryText.ColorBorderEnabled = true;

this.clrpnlQueryText.Controls.Add(this.btnExecute);

this.clrpnlQueryText.Controls.Add(this.pnlTools);

this.clrpnlQueryText.Controls.Add(this.rtbQueryText);

this.clrpnlQueryText.DisplayRectangleColor = System.Drawing.Color.Empty;

this.clrpnlQueryText.Dock = System.Windows.Forms.DockStyle.Top;

this.clrpnlQueryText.Location = new System.Drawing.Point(0, 0);

this.clrpnlQueryText.Name = "clrpnlQueryText";

this.clrpnlQueryText.Padding = new System.Windows.Forms.Padding(2);

this.clrpnlQueryText.Size = new System.Drawing.Size(619, 274);

this.clrpnlQueryText.TabIndex = 0;

//

// btnExecute

//

this.btnExecute.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)

| System.Windows.Forms.AnchorStyles.Right)));

this.btnExecute.BackColor = System.Drawing.Color.White;

this.btnExecute.FlatAppearance.BorderSize = 0;

this.btnExecute.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnExecute.Image = global::TurFirm.Properties.Resources.Download_58_45;

this.btnExecute.Location = new System.Drawing.Point(3, 221);

this.btnExecute.Margin = new System.Windows.Forms.Padding(1, 0, 1, 1);

this.btnExecute.Name = "btnExecute";

this.btnExecute.Size = new System.Drawing.Size(616, 50);

this.btnExecute.TabIndex = 2;

this.btnExecute.UseVisualStyleBackColor = false;

this.btnExecute.Click += new System.EventHandler(this.btnExecute_Click);

//

// pnlTools

//

this.pnlTools.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)

| System.Windows.Forms.AnchorStyles.Right)));

this.pnlTools.BackColor = System.Drawing.Color.White;

this.pnlTools.Controls.Add(this.btnZoomOut);

this.pnlTools.Controls.Add(this.btnZoomIn);

this.pnlTools.Controls.Add(this.btnErase);

this.pnlTools.Controls.Add(this.btnRedo);

this.pnlTools.Controls.Add(this.btnUndo);

this.pnlTools.Location = new System.Drawing.Point(3, 3);

this.pnlTools.Margin = new System.Windows.Forms.Padding(1, 1, 1, 0);

this.pnlTools.Name = "pnlTools";

this.pnlTools.Size = new System.Drawing.Size(613, 28);

this.pnlTools.TabIndex = 1;

//

// btnZoomOut

//

this.btnZoomOut.Dock = System.Windows.Forms.DockStyle.Left;

this.btnZoomOut.FlatAppearance.BorderSize = 0;

this.btnZoomOut.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnZoomOut.Image = global::TurFirm.Properties.Resources.ZoomOut_24;

this.btnZoomOut.Location = new System.Drawing.Point(112, 0);

this.btnZoomOut.Name = "btnZoomOut";

this.btnZoomOut.Size = new System.Drawing.Size(28, 28);

this.btnZoomOut.TabIndex = 4;

this.btnZoomOut.UseVisualStyleBackColor = true;

this.btnZoomOut.Click += new System.EventHandler(this.btnZoomOut_Click);

//

// btnZoomIn

//

this.btnZoomIn.Dock = System.Windows.Forms.DockStyle.Left;

this.btnZoomIn.FlatAppearance.BorderSize = 0;

this.btnZoomIn.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnZoomIn.Image = global::TurFirm.Properties.Resources.ZoomIn_24;

this.btnZoomIn.Location = new System.Drawing.Point(84, 0);

this.btnZoomIn.Name = "btnZoomIn";

this.btnZoomIn.Size = new System.Drawing.Size(28, 28);

this.btnZoomIn.TabIndex = 3;

this.btnZoomIn.UseVisualStyleBackColor = true;

this.btnZoomIn.Click += new System.EventHandler(this.btnZoomIn_Click);

//

// btnErase

//

this.btnErase.Dock = System.Windows.Forms.DockStyle.Left;

this.btnErase.FlatAppearance.BorderSize = 0;

this.btnErase.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnErase.Image = global::TurFirm.Properties.Resources.Erase_24;

this.btnErase.Location = new System.Drawing.Point(56, 0);

this.btnErase.Name = "btnErase";

this.btnErase.Size = new System.Drawing.Size(28, 28);

this.btnErase.TabIndex = 2;

this.btnErase.UseVisualStyleBackColor = true;

this.btnErase.Click += new System.EventHandler(this.btnErase_Click);

//

// btnRedo

//

this.btnRedo.Dock = System.Windows.Forms.DockStyle.Left;

this.btnRedo.FlatAppearance.BorderSize = 0;

this.btnRedo.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnRedo.Image = global::TurFirm.Properties.Resources.Redo_24;

this.btnRedo.Location = new System.Drawing.Point(28, 0);

this.btnRedo.Name = "btnRedo";

this.btnRedo.Size = new System.Drawing.Size(28, 28);

this.btnRedo.TabIndex = 1;

this.btnRedo.UseVisualStyleBackColor = true;

this.btnRedo.Click += new System.EventHandler(this.btnRedo_Click);

//

// btnUndo

//

this.btnUndo.Dock = System.Windows.Forms.DockStyle.Left;

this.btnUndo.FlatAppearance.BorderSize = 0;

this.btnUndo.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

this.btnUndo.Image = global::TurFirm.Properties.Resources.Undo_24;

this.btnUndo.Location = new System.Drawing.Point(0, 0);

this.btnUndo.Name = "btnUndo";

this.btnUndo.Size = new System.Drawing.Size(28, 28);

this.btnUndo.TabIndex = 0;

this.btnUndo.UseVisualStyleBackColor = true;

this.btnUndo.Click += new System.EventHandler(this.btnUndo_Click);

//

// rtbQueryText

//

this.rtbQueryText.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)

| System.Windows.Forms.AnchorStyles.Left)

| System.Windows.Forms.AnchorStyles.Right)));

this.rtbQueryText.BackColor = System.Drawing.Color.White;

this.rtbQueryText.BorderStyle = System.Windows.Forms.BorderStyle.None;

this.rtbQueryText.Font = new System.Drawing.Font("Consolas", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204)));

this.rtbQueryText.Location = new System.Drawing.Point(3, 31);

this.rtbQueryText.Margin = new System.Windows.Forms.Padding(1, 0, 1, 0);

this.rtbQueryText.Name = "rtbQueryText";

this.rtbQueryText.Size = new System.Drawing.Size(613, 190);

this.rtbQueryText.TabIndex = 0;

this.rtbQueryText.Text = "";

this.rtbQueryText.TextChanged += new System.EventHandler(this.rtbQueryText_TextChanged);

//

// QueryForm

//

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(619, 416);

this.Controls.Add(this.clrpnlQueryView);

this.Controls.Add(this.splitter);

this.Controls.Add(this.clrpnlQueryText);

this.Name = "QueryForm";

this.Text = "Редактор запросов";

this.Deactivate += new System.EventHandler(this.QueryForm_Deactivate);

this.FormClosed += new System.Windows.Forms.FormClosedEventHandler(this.QueryForm_FormClosed);

this.Load += new System.EventHandler(this.QueryForm_Load);

this.Enter += new System.EventHandler(this.QueryForm_Enter);

this.clrpnlQueryView.ResumeLayout(false);

((System.ComponentModel.ISupportInitialize)(this.dgvQuery)).EndInit();

this.clrpnlQueryText.ResumeLayout(false);

this.pnlTools.ResumeLayout(false);

this.ResumeLayout(false);

}

#endregion

private System.Windows.Forms.ToolTip toolTip;

private ColorPanel clrpnlQueryText;

private System.Windows.Forms.Splitter splitter;

private ColorPanel clrpnlQueryView;

private System.Windows.Forms.Panel pnlTools;

private System.Windows.Forms.RichTextBox rtbQueryText;

private System.Windows.Forms.DataGridView dgvQuery;

private System.Windows.Forms.Button btnExecute;

private System.Windows.Forms.Button btnUndo;

private System.Windows.Forms.Button btnZoomOut;

private System.Windows.Forms.Button btnZoomIn;

private System.Windows.Forms.Button btnErase;

private System.Windows.Forms.Button btnRedo;

}

Файл TurFirmTable.cs

using System;

using System.Data;

namespace TurFirm

{

public class TurFirmTable

{

// Событие, которое происходит после внесения изменений в базу данных.

public static event Action DataChanged;

protected TurFirmTable(string tableName)

{

Table = new DataTable(tableName);

Name = tableName;

}

// Имя таблицы в базе данных.

public string Name { get; protected set; }

public DataTable Table { get; protected set; }

// Проверяет, есть ли изменения в таблице.

public virtual bool HasChanges

{

get { return Table.GetChanges() != null; }

}

// Текст запроса на заполнение таблицы.

protected string FillCommandText

{

get { return String.Format("SELECT * FROM [{0}]", Name); }

}

// Сохраняет, внесённые в таблицу изменения, в базу данных.

public virtual void SaveChanges()

{

DataTable changesTable = Table.GetChanges();

if (changesTable == null)

return;

OleDbPackage.UpdateTable(changesTable, FillCommandText);

Table.AcceptChanges();

OnDataChanged();

}

// Обновляет информацию в таблице.

public virtual void Update()

{

Clear();

Fill();

}

// Заполняет таблицу данными из базы.

public virtual void Fill()

{

OleDbPackage.FillTable(Table, FillCommandText);

}

// Возвращает отфильтрованное отображение таблицы.

public virtual DataView GetFilteredView(string filterString)

{

var dataView = new DataView(Table) {RowFilter = filterString};

return dataView;

}

// Очищает таблицу.

public virtual void Clear()

{

Table.Clear();

}

// Вызывает событие DataChanged.

protected static void OnDataChanged()

{

if (DataChanged != null)

DataChanged();

}

Размещено на Allbest.ru