Разработка ИС для учета детских садов города

            //

            this.bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.bindingNavigatorMoveNextItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveNextItem.Image")));

            this.bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem";

            this.bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true;

            this.bindingNavigatorMoveNextItem.Size = new System.Drawing.Size(23, 22);

            this.bindingNavigatorMoveNextItem.Text = "Move next";

            //

            // bindingNavigatorMoveLastItem

            //

            this.bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.bindingNavigatorMoveLastItem.Image = ((System.Drawing.Image)(resources.GetObject("bindingNavigatorMoveLastItem.Image")));

            this.bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem";

            this.bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true;

            this.bindingNavigatorMoveLastItem.Size = new System.Drawing.Size(23, 22);

            this.bindingNavigatorMoveLastItem.Text = "Move last";

            //

            // bindingNavigatorSeparator2

            //

            this.bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator2";

            this.bindingNavigatorSeparator2.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripButton1

            //

            this.toolStripButton1.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton1.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton1.Image")));

            this.toolStripButton1.ImageTransparentColor = System.Drawing.Color.Magenta;

            this.toolStripButton1.Name = "toolStripButton1";

            this.toolStripButton1.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton1.Text = "Обновить";

            this.toolStripButton1.Click += new System.EventHandler(this.toolStripButton1_Click);

            //

            // toolStripButton2

            //

            this.toolStripButton2.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton2.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton2.Image")));

            this.toolStripButton2.ImageTransparentColor = System.Drawing.Color.Magenta;

            this.toolStripButton2.Name = "toolStripButton2";

            this.toolStripButton2.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton2.Text = "Персонал детского сада";

            this.toolStripButton2.Click += new System.EventHandler(this.toolStripButton2_Click);

            //

            // toolStripButton3

            //

            this.toolStripButton3.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton3.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton3.Image")));

            this.toolStripButton3.ImageTransparentColor = System.Drawing.Color.Magenta;

            this.toolStripButton3.Name = "toolStripButton3";

            this.toolStripButton3.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton3.Text = "Группы";

            this.toolStripButton3.Click += new System.EventHandler(this.toolStripButton3_Click);

            //

            // dataGridView1

            //

            this.dataGridView1.AutoGenerateColumns = false;

            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

            this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.кодDataGridViewTextBoxColumn,

            this.наименованиеDataGridViewTextBoxColumn,

            this.адресDataGridViewTextBoxColumn,

            this.номерDataGridViewTextBoxColumn});

            this.dataGridView1.DataSource = this.садыBindingSource;

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

            this.dataGridView1.Name = "dataGridView1";

            this.dataGridView1.Size = new System.Drawing.Size(778, 489);

            this.dataGridView1.TabIndex = 1;

            //

            // кодDataGridViewTextBoxColumn

            //

            this.кодDataGridViewTextBoxColumn.DataPropertyName = "Код";

            this.кодDataGridViewTextBoxColumn.HeaderText = "Код";

            this.кодDataGridViewTextBoxColumn.Name = "кодDataGridViewTextBoxColumn";

            this.кодDataGridViewTextBoxColumn.ReadOnly = true;

            this.кодDataGridViewTextBoxColumn.Visible = false;

            //

            // наименованиеDataGridViewTextBoxColumn

            //

            this.наименованиеDataGridViewTextBoxColumn.DataPropertyName = "Наименование";

            this.наименованиеDataGridViewTextBoxColumn.HeaderText = "Наименование";

            this.наименованиеDataGridViewTextBoxColumn.Name = "наименованиеDataGridViewTextBoxColumn";

            this.наименованиеDataGridViewTextBoxColumn.Width = 300;

            //

            // адресDataGridViewTextBoxColumn

            //

            this.адресDataGridViewTextBoxColumn.DataPropertyName = "Адрес";

            this.адресDataGridViewTextBoxColumn.HeaderText = "Адрес";

            this.адресDataGridViewTextBoxColumn.Name = "адресDataGridViewTextBoxColumn";

            this.адресDataGridViewTextBoxColumn.Width = 300;

            //

            // номерDataGridViewTextBoxColumn

            //

            this.номерDataGridViewTextBoxColumn.DataPropertyName = "Номер";

            this.номерDataGridViewTextBoxColumn.HeaderText = "Номер";

            this.номерDataGridViewTextBoxColumn.Name = "номерDataGridViewTextBoxColumn";

            //

            // садыTableAdapter

            //

            this.садыTableAdapter.ClearBeforeFill = true;

            //

            // sprKinderGarten

            //

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

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

            this.ClientSize = new System.Drawing.Size(778, 518);

            this.Controls.Add(this.dataGridView1);

            this.Controls.Add(this.bindingNavigator1);

            this.Name = "sprKinderGarten";

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

            this.Text = "Справочник детские сады";

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

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

            this.bindingNavigator1.ResumeLayout(false);

            this.bindingNavigator1.PerformLayout();

            ((System.ComponentModel.ISupportInitialize)(this.садыBindingSource)).EndInit();

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

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

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

            this.ResumeLayout(false);

            this.PerformLayout();

 

        }

 

        #endregion

 

        private System.Windows.Forms.BindingNavigator bindingNavigator1;

        private System.Windows.Forms.ToolStripButton bindingNavigatorAddNewItem;

        private System.Windows.Forms.ToolStripLabel bindingNavigatorCountItem;

        private System.Windows.Forms.ToolStripButton bindingNavigatorDeleteItem;

        private System.Windows.Forms.ToolStripButton bindingNavigatorMoveFirstItem;

        private System.Windows.Forms.ToolStripButton bindingNavigatorMovePreviousItem;

        private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator;

        private System.Windows.Forms.ToolStripTextBox bindingNavigatorPositionItem;

        private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator1;

        private System.Windows.Forms.ToolStripButton bindingNavigatorMoveNextItem;

        private System.Windows.Forms.ToolStripButton bindingNavigatorMoveLastItem;

        private System.Windows.Forms.ToolStripSeparator bindingNavigatorSeparator2;

        private System.Windows.Forms.ToolStripButton toolStripButton1;

        private System.Windows.Forms.ToolStripButton toolStripButton2;

        private System.Windows.Forms.ToolStripButton toolStripButton3;

        private System.Windows.Forms.BindingSource bindingSource1;

        private System.Windows.Forms.DataGridView dataGridView1;

        private KinderGartenDataSet2 kinderGartenDataSet2;

        private System.Windows.Forms.BindingSource садыBindingSource;

        private KinderGartenDataSet2TableAdapters.СадыTableAdapter садыTableAdapter;

        private System.Windows.Forms.DataGridViewTextBoxColumn кодDataGridViewTextBoxColumn;

        private System.Windows.Forms.DataGridViewTextBoxColumn наименованиеDataGridViewTextBoxColumn;

        private System.Windows.Forms.DataGridViewTextBoxColumn адресDataGridViewTextBoxColumn;

        private System.Windows.Forms.DataGridViewTextBoxColumn номерDataGridViewTextBoxColumn;

    }

}

 

sprKinderGarten.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

 

namespace kindergarten

{

    public partial class sprKinderGarten : Form

    {

        public sprKinderGarten()

        {

            InitializeComponent();

        }

 

        private void sprKinderGarten_Load(object sender, EventArgs e)

        {

            // TODO: This line of code loads data into the 'kinderGartenDataSet2.Сады' table. You can move, or remove it, as needed.

            this.садыTableAdapter.Fill(this.kinderGartenDataSet2.Сады);

            // TODO: This line of code loads data into the 'kinderGartenDataSet1.Сады' table. You can move, or remove it, as needed.

            //this.садыTableAdapter.Fill(this.kinderGartenDataSet1.Сады);

 

        }

 

        private void toolStripButton1_Click(object sender, EventArgs e)

        {

            садыTableAdapter.Update(kinderGartenDataSet2);

        }

 

        private void toolStripButton2_Click(object sender, EventArgs e)

        {

            int kod = Convert.ToInt32(((DataRowView)садыBindingSource.Current).Row["Код"]);

           

            sprPersonal spr = new sprPersonal();

            spr.SetCodParent(kod);

            spr.ShowDialog();

        }

 

        private void toolStripButton3_Click(object sender, EventArgs e)

        {

            int kod = Convert.ToInt32(((DataRowView)садыBindingSource.Current).Row["Код"]);

 

            GrupsKinder spr = new GrupsKinder();

            spr.SetCodParent(kod);

            spr.ShowDialog();

        }

    }

}

 

Приложение 3. Форма справочника Должностей fposition. cs

fposition.Designer.cs

namespace kindergarten

{

    partial class fposition

    {

        /// <summary>

        /// Required designer variable.

        /// </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();

            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(fposition));

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

            this.наименованиеDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.должностиBindingSource = new System.Windows.Forms.BindingSource(this.components);

            this.bindingSource1 = new System.Windows.Forms.BindingSource(this.components);

            this.kinderGartenDataSet = new kindergarten.KinderGartenDataSet();

            this.должностиTableAdapter = new kindergarten.KinderGartenDataSetTableAdapters.ДолжностиTableAdapter();

            this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components);

            this.bindingNavigatorAddNewItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorCountItem = new System.Windows.Forms.ToolStripLabel();

            this.bindingNavigatorDeleteItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorMoveFirstItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorMovePreviousItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorSeparator = new System.Windows.Forms.ToolStripSeparator();

            this.bindingNavigatorPositionItem = new System.Windows.Forms.ToolStripTextBox();

            this.bindingNavigatorSeparator1 = new System.Windows.Forms.ToolStripSeparator();

            this.bindingNavigatorMoveNextItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorMoveLastItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorSeparator2 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton1 = new System.Windows.Forms.ToolStripButton();

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

            ((System.ComponentModel.ISupportInitialize)(this.должностиBindingSource)).BeginInit();

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

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

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

            this.bindingNavigator1.SuspendLayout();

            this.SuspendLayout();

            //

            // dgPosition

            //

            this.dgPosition.AutoGenerateColumns = false;

            this.dgPosition.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

            this.dgPosition.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.наименованиеDataGridViewTextBoxColumn});

            this.dgPosition.DataSource = this.должностиBindingSource;

            this.dgPosition.Location = new System.Drawing.Point(-4, 28);

            this.dgPosition.Name = "dgPosition";

            this.dgPosition.Size = new System.Drawing.Size(560, 246);

            this.dgPosition.TabIndex = 1;

            this.dgPosition.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgPosition_CellContentClick);

            //

            // наименованиеDataGridViewTextBoxColumn

            //

            this.наименованиеDataGridViewTextBoxColumn.DataPropertyName = "Наименование";

            this.наименованиеDataGridViewTextBoxColumn.HeaderText = "Наименование";

            this.наименованиеDataGridViewTextBoxColumn.Name = "наименованиеDataGridViewTextBoxColumn";

            this.наименованиеDataGridViewTextBoxColumn.Width = 500;

            //

            // должностиBindingSource

            //

            this.должностиBindingSource.DataMember = "Должности";

            this.должностиBindingSource.DataSource = this.bindingSource1;

            //

            // bindingSource1

            //

            this.bindingSource1.DataSource = this.kinderGartenDataSet;

            this.bindingSource1.Position = 0;

            //