Esempio n. 1
0
 public int GetAvailableOrgs(int ClientID, BPS.BLL.Clients.DataSets.dsOrgsClients dsOrgsClients)
 {
     dsOrgsClients.Clear();
     sqldaGetAvailableOrgs.SelectCommand.Connection = this.sqlConnection1;
     sqldaGetAvailableOrgs.SelectCommand.Parameters["@ClientID"].Value = ClientID;
     return(sqldaGetAvailableOrgs.Fill(dsOrgsClients));
 }
Esempio n. 2
0
        public AddClient(BPS.BLL.Clients.DataSets.dsClients.ClientsRow dr, DataView dv, DataView dvRate, BPS.BLL.Clients.DataSets.dsOrgsClients dsOrgsClientsEd)
        {
            this.dvGroups = dv;
            rw            = dr;
            InitializeComponent();
            BPS.App.SetDataGridTableStyle(this.dataGridTableStyle1);
            BPS.App.SetDataGridTableStyle(this.dataGridTableStyle2);
            BPS.App.SetDataGridTableStyle(this.dataGridTableStyle3);
            try
            {
                //this.sqlDataAdapter2.Fill(this.dsGroups1);
                this.cmbGroup.DataSource    = this.dvGroups;             //dv.Table;//this.dsGroups1.Tables[0];
                this.cmbGroup.ValueMember   = "ClientGroupID";
                this.cmbGroup.DisplayMember = "ClientGroupName";
                this.cmbGroup.SelectedValue = dr.ClientGroupID;    //["ClientGroupID"];
                this.tbClient.Text          = dr.ClientName;       //["ClientName"].ToString();
                this.tbRemarks.Text         = dr.ClientRemarks;    //["ClientRemarks"].ToString();
                //this.cbSpecial.Checked = dr.IsSpecial;
                this.dataGrid1.DataSource = dvRate;
                if (dr.IsInner || dr.IsSpecial)
                {
                    this.cmbGroup.Enabled = false;
                }
                else
                {
                    dv.RowFilter = "IsInner=false and IsSpecial=false";
                }
//				this.sqlSelectClientsOrgs.Parameters["@ClientID"].Value = dr.ClientID;
//				this.sqldaSelOrgsClients.Fill(this.dsOrgsClients1);
                this.dsOrgsClients1      = dsOrgsClientsEd;
                this.dvSend.Table        = this.dsOrgsClients1.OrgsClients;
                this.dvSend.RowFilter    = "Direction=1 and IsRemoved=0";
                this.dvReceive.Table     = this.dsOrgsClients1.OrgsClients;
                this.dvReceive.RowFilter = "Direction=0 and IsRemoved=0";
            }
            catch (Exception ex)
            {
                MsgBoxX.Show(ex.Message, "BPS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            if (dr.IsInner || dr.IsSpecial)
            {
                this.cmbGroup.Enabled = false;
            }
        }
Esempio n. 3
0
 /// <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.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ClientView));
     this.dsClients1             = new BPS.BLL.Clients.DataSets.dsClients();
     this.groupBox1              = new System.Windows.Forms.GroupBox();
     this.cbSpecial              = new System.Windows.Forms.CheckBox();
     this.cbIsInner              = new System.Windows.Forms.CheckBox();
     this.tbName                 = new System.Windows.Forms.TextBox();
     this.label2                 = new System.Windows.Forms.Label();
     this.imageList1             = new System.Windows.Forms.ImageList(this.components);
     this.dataGrid1              = new AM_Controls.DataGridV();
     this.contextMenu1           = new System.Windows.Forms.ContextMenu();
     this.dataView1              = new System.Data.DataView();
     this.dataGridTableStyle1    = new System.Windows.Forms.DataGridTableStyle();
     this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.panel2                 = new System.Windows.Forms.Panel();
     this.toolBar1               = new System.Windows.Forms.ToolBar();
     this.toolBarButton1         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton2         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton4         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton3         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton5         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton6         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton7         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton8         = new System.Windows.Forms.ToolBarButton();
     this.toolBarButton9         = new System.Windows.Forms.ToolBarButton();
     this.dvGroups               = new System.Data.DataView();
     this.panel3                 = new System.Windows.Forms.Panel();
     this.panel1                 = new System.Windows.Forms.Panel();
     this.dataGridV1             = new AM_Controls.DataGridV();
     this.dvClientRate           = new System.Data.DataView();
     this.dsInterestRate1        = new BPS.BLL.Clients.DataSets.dsInterestRate();
     this.dataGridTableStyle2    = new System.Windows.Forms.DataGridTableStyle();
     this.ReqType                = new System.Windows.Forms.DataGridTextBoxColumn();
     this.ReqTypeName            = new System.Windows.Forms.DataGridTextBoxColumn();
     this.RateNormal             = new System.Windows.Forms.DataGridTextBoxColumn();
     this.RateBlack              = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dvRateList             = new System.Data.DataView();
     this.dsInterestRateList1    = new BPS.BLL.Clients.DataSets.dsInterestRateList();
     this.dsReqTypes1            = new BPS.BLL.ClientsRequests.DataSets.dsReqTypes();
     this.mainMenu1              = new System.Windows.Forms.MainMenu();
     this.mnuEdit                = new System.Windows.Forms.MenuItem();
     this.menuItem2              = new System.Windows.Forms.MenuItem();
     this.menuItem3              = new System.Windows.Forms.MenuItem();
     this.menuItem4              = new System.Windows.Forms.MenuItem();
     this.menuItem5              = new System.Windows.Forms.MenuItem();
     this.menuItem6              = new System.Windows.Forms.MenuItem();
     this.menuItem7              = new System.Windows.Forms.MenuItem();
     this.menuItem8              = new System.Windows.Forms.MenuItem();
     this.menuItem9              = new System.Windows.Forms.MenuItem();
     this.menuItem10             = new System.Windows.Forms.MenuItem();
     this.dsOrgsClients1         = new BPS.BLL.Clients.DataSets.dsOrgsClients();
     ((System.ComponentModel.ISupportInitialize)(this.dsClients1)).BeginInit();
     this.groupBox1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
     this.panel2.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dvGroups)).BeginInit();
     this.panel3.SuspendLayout();
     this.panel1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dataGridV1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvClientRate)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvRateList)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRateList1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).BeginInit();
     this.SuspendLayout();
     //
     // dsClients1
     //
     this.dsClients1.DataSetName = "dsClients";
     this.dsClients1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // groupBox1
     //
     this.groupBox1.Controls.Add(this.cbSpecial);
     this.groupBox1.Controls.Add(this.cbIsInner);
     this.groupBox1.Controls.Add(this.tbName);
     this.groupBox1.Controls.Add(this.label2);
     this.groupBox1.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.groupBox1.Location = new System.Drawing.Point(0, 28);
     this.groupBox1.Name     = "groupBox1";
     this.groupBox1.Size     = new System.Drawing.Size(792, 38);
     this.groupBox1.TabIndex = 0;
     this.groupBox1.TabStop  = false;
     this.groupBox1.Text     = "Фильтр";
     //
     // cbSpecial
     //
     this.cbSpecial.Location = new System.Drawing.Point(520, 14);
     this.cbSpecial.Name     = "cbSpecial";
     this.cbSpecial.TabIndex = 4;
     this.cbSpecial.Text     = "Специальные";
     //
     // cbIsInner
     //
     this.cbIsInner.Location = new System.Drawing.Point(414, 14);
     this.cbIsInner.Name     = "cbIsInner";
     this.cbIsInner.Size     = new System.Drawing.Size(88, 24);
     this.cbIsInner.TabIndex = 3;
     this.cbIsInner.Text     = "Внутренний";
     //
     // tbName
     //
     this.tbName.Location = new System.Drawing.Point(64, 16);
     this.tbName.Name     = "tbName";
     this.tbName.Size     = new System.Drawing.Size(184, 21);
     this.tbName.TabIndex = 0;
     this.tbName.Text     = "";
     //
     // label2
     //
     this.label2.Location = new System.Drawing.Point(12, 20);
     this.label2.Name     = "label2";
     this.label2.Size     = new System.Drawing.Size(48, 16);
     this.label2.TabIndex = 2;
     this.label2.Text     = "Клиент:";
     //
     // imageList1
     //
     this.imageList1.ImageSize        = new System.Drawing.Size(16, 16);
     this.imageList1.ImageStream      = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
     this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
     //
     // dataGrid1
     //
     this.dataGrid1._CanEdit             = false;
     this.dataGrid1._InvisibleColumn     = 0;
     this.dataGrid1.AlternatingBackColor = System.Drawing.Color.LightGray;
     this.dataGrid1.BackColor            = System.Drawing.Color.Gainsboro;
     this.dataGrid1.CaptionVisible       = false;
     this.dataGrid1.ContextMenu          = this.contextMenu1;
     this.dataGrid1.DataMember           = "";
     this.dataGrid1.DataSource           = this.dataView1;
     this.dataGrid1.Dock            = System.Windows.Forms.DockStyle.Fill;
     this.dataGrid1.GridLineColor   = System.Drawing.Color.LightGray;
     this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGrid1.Location        = new System.Drawing.Point(0, 0);
     this.dataGrid1.Name            = "dataGrid1";
     this.dataGrid1.ReadOnly        = true;
     this.dataGrid1.Size            = new System.Drawing.Size(792, 391);
     this.dataGrid1.TabIndex        = 1;
     this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
         this.dataGridTableStyle1
     });
     this.dataGrid1.DoubleClick += new System.EventHandler(this.dataGrid1_DoubleClick);
     this.dataGrid1.Paint       += new System.Windows.Forms.PaintEventHandler(this.dataGrid1_Paint);
     //
     // dataView1
     //
     this.dataView1.Table = this.dsClients1.Clients;
     //
     // dataGridTableStyle1
     //
     this.dataGridTableStyle1.AlternatingBackColor = System.Drawing.Color.LightGray;
     this.dataGridTableStyle1.BackColor            = System.Drawing.Color.Gainsboro;
     this.dataGridTableStyle1.DataGrid             = this.dataGrid1;
     this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
         this.dataGridTextBoxColumn1,
         this.dataGridTextBoxColumn3,
         this.dataGridTextBoxColumn2,
         this.dataGridTextBoxColumn4
     });
     this.dataGridTableStyle1.GridLineColor   = System.Drawing.Color.LightGray;
     this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGridTableStyle1.MappingName     = "Clients";
     //
     // dataGridTextBoxColumn1
     //
     this.dataGridTextBoxColumn1.Format      = "";
     this.dataGridTextBoxColumn1.FormatInfo  = null;
     this.dataGridTextBoxColumn1.MappingName = "ClientID";
     this.dataGridTextBoxColumn1.NullText    = "";
     this.dataGridTextBoxColumn1.Width       = 40;
     //
     // dataGridTextBoxColumn3
     //
     this.dataGridTextBoxColumn3.Format      = "";
     this.dataGridTextBoxColumn3.FormatInfo  = null;
     this.dataGridTextBoxColumn3.HeaderText  = "Группа";
     this.dataGridTextBoxColumn3.MappingName = "ClientGroupName";
     this.dataGridTextBoxColumn3.NullText    = "";
     this.dataGridTextBoxColumn3.Width       = 130;
     //
     // dataGridTextBoxColumn2
     //
     this.dataGridTextBoxColumn2.Format      = "";
     this.dataGridTextBoxColumn2.FormatInfo  = null;
     this.dataGridTextBoxColumn2.HeaderText  = "Имя клиента";
     this.dataGridTextBoxColumn2.MappingName = "ClientName";
     this.dataGridTextBoxColumn2.NullText    = "";
     this.dataGridTextBoxColumn2.Width       = 250;
     //
     // dataGridTextBoxColumn4
     //
     this.dataGridTextBoxColumn4.Format      = "";
     this.dataGridTextBoxColumn4.FormatInfo  = null;
     this.dataGridTextBoxColumn4.HeaderText  = "Примечание";
     this.dataGridTextBoxColumn4.MappingName = "ClientRemarks";
     this.dataGridTextBoxColumn4.NullText    = "";
     this.dataGridTextBoxColumn4.Width       = 330;
     //
     // panel2
     //
     this.panel2.Controls.Add(this.groupBox1);
     this.panel2.Controls.Add(this.toolBar1);
     this.panel2.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel2.Location = new System.Drawing.Point(0, 0);
     this.panel2.Name     = "panel2";
     this.panel2.Size     = new System.Drawing.Size(792, 66);
     this.panel2.TabIndex = 10;
     //
     // toolBar1
     //
     this.toolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat;
     this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
         this.toolBarButton1,
         this.toolBarButton2,
         this.toolBarButton4,
         this.toolBarButton3,
         this.toolBarButton5,
         this.toolBarButton6,
         this.toolBarButton7,
         this.toolBarButton8,
         this.toolBarButton9
     });
     this.toolBar1.ButtonSize     = new System.Drawing.Size(100, 22);
     this.toolBar1.DropDownArrows = true;
     this.toolBar1.ImageList      = this.imageList1;
     this.toolBar1.Location       = new System.Drawing.Point(0, 0);
     this.toolBar1.Name           = "toolBar1";
     this.toolBar1.ShowToolTips   = true;
     this.toolBar1.Size           = new System.Drawing.Size(792, 28);
     this.toolBar1.TabIndex       = 0;
     this.toolBar1.TextAlign      = System.Windows.Forms.ToolBarTextAlign.Right;
     this.toolBar1.ButtonClick   += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
     //
     // toolBarButton1
     //
     this.toolBarButton1.ImageIndex = 0;
     this.toolBarButton1.Text       = "Новый";
     //
     // toolBarButton2
     //
     this.toolBarButton2.ImageIndex = 1;
     this.toolBarButton2.Text       = "Открыть";
     //
     // toolBarButton4
     //
     this.toolBarButton4.ImageIndex = 2;
     this.toolBarButton4.Text       = "Удалить";
     //
     // toolBarButton3
     //
     this.toolBarButton3.ImageIndex = 2;
     this.toolBarButton3.Style      = System.Windows.Forms.ToolBarButtonStyle.Separator;
     //
     // toolBarButton5
     //
     this.toolBarButton5.ImageIndex = 3;
     this.toolBarButton5.Text       = "Обновить";
     //
     // toolBarButton6
     //
     this.toolBarButton6.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
     //
     // toolBarButton7
     //
     this.toolBarButton7.ImageIndex = 5;
     this.toolBarButton7.Text       = "Выбрать";
     //
     // toolBarButton8
     //
     this.toolBarButton8.ImageIndex = 6;
     this.toolBarButton8.Text       = "Сбросить";
     //
     // toolBarButton9
     //
     this.toolBarButton9.ImageIndex = 7;
     this.toolBarButton9.Text       = "Очистить";
     //
     // panel3
     //
     this.panel3.Controls.Add(this.dataGrid1);
     this.panel3.Controls.Add(this.panel1);
     this.panel3.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel3.Location = new System.Drawing.Point(0, 66);
     this.panel3.Name     = "panel3";
     this.panel3.Size     = new System.Drawing.Size(792, 507);
     this.panel3.TabIndex = 11;
     //
     // panel1
     //
     this.panel1.Controls.Add(this.dataGridV1);
     this.panel1.Dock     = System.Windows.Forms.DockStyle.Bottom;
     this.panel1.Location = new System.Drawing.Point(0, 391);
     this.panel1.Name     = "panel1";
     this.panel1.Size     = new System.Drawing.Size(792, 116);
     this.panel1.TabIndex = 3;
     //
     // dataGridV1
     //
     this.dataGridV1._CanEdit         = false;
     this.dataGridV1._InvisibleColumn = 0;
     this.dataGridV1.CaptionBackColor = System.Drawing.SystemColors.Control;
     this.dataGridV1.CaptionForeColor = System.Drawing.SystemColors.WindowText;
     this.dataGridV1.CaptionText      = "Процентные ставки";
     this.dataGridV1.DataMember       = "";
     this.dataGridV1.DataSource       = this.dvClientRate;
     this.dataGridV1.HeaderForeColor  = System.Drawing.SystemColors.ControlText;
     this.dataGridV1.Location         = new System.Drawing.Point(0, 0);
     this.dataGridV1.Name             = "dataGridV1";
     this.dataGridV1.ReadOnly         = true;
     this.dataGridV1.Size             = new System.Drawing.Size(440, 116);
     this.dataGridV1.TabIndex         = 2;
     this.dataGridV1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
         this.dataGridTableStyle2
     });
     //
     // dvClientRate
     //
     this.dvClientRate.AllowDelete = false;
     this.dvClientRate.AllowNew    = false;
     this.dvClientRate.Table       = this.dsInterestRate1.InterestRate;
     //
     // dsInterestRate1
     //
     this.dsInterestRate1.DataSetName = "dsInterestRate";
     this.dsInterestRate1.Locale      = new System.Globalization.CultureInfo("en-US");
     //
     // dataGridTableStyle2
     //
     this.dataGridTableStyle2.DataGrid = this.dataGridV1;
     this.dataGridTableStyle2.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
         this.ReqType,
         this.ReqTypeName,
         this.RateNormal,
         this.RateBlack
     });
     this.dataGridTableStyle2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGridTableStyle2.MappingName     = "InterestRate";
     //
     // ReqType
     //
     this.ReqType.Alignment   = System.Windows.Forms.HorizontalAlignment.Right;
     this.ReqType.Format      = "";
     this.ReqType.FormatInfo  = null;
     this.ReqType.HeaderText  = "ID";
     this.ReqType.MappingName = "ReqType";
     this.ReqType.Width       = 40;
     //
     // ReqTypeName
     //
     this.ReqTypeName.Format      = "";
     this.ReqTypeName.FormatInfo  = null;
     this.ReqTypeName.HeaderText  = "Тип операции";
     this.ReqTypeName.MappingName = "ReqTypeName";
     this.ReqTypeName.NullText    = "-";
     this.ReqTypeName.Width       = 200;
     //
     // RateNormal
     //
     this.RateNormal.Alignment   = System.Windows.Forms.HorizontalAlignment.Right;
     this.RateNormal.Format      = "#,##0.00";
     this.RateNormal.FormatInfo  = null;
     this.RateNormal.HeaderText  = "Процент н.";
     this.RateNormal.MappingName = "RateNormal";
     this.RateNormal.NullText    = "-";
     this.RateNormal.Width       = 80;
     //
     // RateBlack
     //
     this.RateBlack.Alignment   = System.Windows.Forms.HorizontalAlignment.Right;
     this.RateBlack.Format      = "#,##0.00";
     this.RateBlack.FormatInfo  = null;
     this.RateBlack.HeaderText  = "Процент ч.";
     this.RateBlack.MappingName = "RateBlack";
     this.RateBlack.NullText    = "-";
     this.RateBlack.Width       = 80;
     //
     // dvRateList
     //
     this.dvRateList.Table = this.dsInterestRateList1.InterestRates;
     //
     // dsInterestRateList1
     //
     this.dsInterestRateList1.DataSetName = "dsInterestRateList";
     this.dsInterestRateList1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // dsReqTypes1
     //
     this.dsReqTypes1.DataSetName = "dsReqTypes";
     this.dsReqTypes1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // mainMenu1
     //
     this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
         this.mnuEdit
     });
     //
     // mnuEdit
     //
     this.mnuEdit.Index = 0;
     this.mnuEdit.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
         this.menuItem2,
         this.menuItem3,
         this.menuItem4,
         this.menuItem5,
         this.menuItem6,
         this.menuItem7,
         this.menuItem8,
         this.menuItem9,
         this.menuItem10
     });
     this.mnuEdit.Text = "Редактирование";
     //
     // menuItem2
     //
     this.menuItem2.Index    = 0;
     this.menuItem2.Shortcut = System.Windows.Forms.Shortcut.F3;
     this.menuItem2.Text     = "Новый";
     this.menuItem2.Click   += new System.EventHandler(this.menuItem2_Click);
     //
     // menuItem3
     //
     this.menuItem3.Index    = 1;
     this.menuItem3.Shortcut = System.Windows.Forms.Shortcut.F10;
     this.menuItem3.Text     = "Изменить";
     this.menuItem3.Click   += new System.EventHandler(this.menuItem3_Click);
     //
     // menuItem4
     //
     this.menuItem4.Index    = 2;
     this.menuItem4.Shortcut = System.Windows.Forms.Shortcut.CtrlDel;
     this.menuItem4.Text     = "Удалить";
     this.menuItem4.Click   += new System.EventHandler(this.menuItem4_Click);
     //
     // menuItem5
     //
     this.menuItem5.Index = 3;
     this.menuItem5.Text  = "-";
     //
     // menuItem6
     //
     this.menuItem6.Index    = 4;
     this.menuItem6.Shortcut = System.Windows.Forms.Shortcut.F5;
     this.menuItem6.Text     = "Обновить";
     this.menuItem6.Click   += new System.EventHandler(this.menuItem6_Click);
     //
     // menuItem7
     //
     this.menuItem7.Index = 5;
     this.menuItem7.Text  = "-";
     //
     // menuItem8
     //
     this.menuItem8.Index  = 6;
     this.menuItem8.Text   = "Выбрать";
     this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
     //
     // menuItem9
     //
     this.menuItem9.Index  = 7;
     this.menuItem9.Text   = "Сбросить";
     this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
     //
     // menuItem10
     //
     this.menuItem10.Index  = 8;
     this.menuItem10.Text   = "Очистить";
     this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
     //
     // dsOrgsClients1
     //
     this.dsOrgsClients1.DataSetName = "dsOrgsClients";
     this.dsOrgsClients1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // ClientView
     //
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
     this.ClientSize        = new System.Drawing.Size(792, 573);
     this.Controls.Add(this.panel3);
     this.Controls.Add(this.panel2);
     this.Font              = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.Icon              = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.Menu              = this.mainMenu1;
     this.Name              = "ClientView";
     this.Text              = "Клиенты";
     this.WindowState       = System.Windows.Forms.FormWindowState.Maximized;
     this.MdiChildActivate += new System.EventHandler(this.ClientView_MdiChildActivate);
     this.Load             += new System.EventHandler(this.ClientView_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dsClients1)).EndInit();
     this.groupBox1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
     this.panel2.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dvGroups)).EndInit();
     this.panel3.ResumeLayout(false);
     this.panel1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dataGridV1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvClientRate)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvRateList)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRateList1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).EndInit();
     this.ResumeLayout(false);
 }
Esempio n. 4
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.sqlConnection1        = new System.Data.SqlClient.SqlConnection();
     this.sqldaClients          = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand2     = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand2     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand1     = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand2     = new System.Data.SqlClient.SqlCommand();
     this.dsClients1            = new BPS.BLL.Clients.DataSets.dsClients();
     this.sqlDataAdapter2       = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlDeleteCommand1     = new System.Data.SqlClient.SqlCommand();
     this.sqlInsertCommand1     = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectCommand2     = new System.Data.SqlClient.SqlCommand();
     this.sqlUpdateCommand1     = new System.Data.SqlClient.SqlCommand();
     this.dsGroups1             = new BPS.BLL.Clients.DataSets.dsGroups();
     this.dsCurr1               = new BPS.BLL.Currency.DataSets.dsCurr();
     this.sqldaSelOrgsClients   = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlCommand2           = new System.Data.SqlClient.SqlCommand();
     this.sqlSelectClientsOrgs  = new System.Data.SqlClient.SqlCommand();
     this.sqlCommand1           = new System.Data.SqlClient.SqlCommand();
     this.dsOrgsClients1        = new BPS.BLL.Clients.DataSets.dsOrgsClients();
     this.sqldaGetAvailableOrgs = new System.Data.SqlClient.SqlDataAdapter();
     this.sqlCommand3           = new System.Data.SqlClient.SqlCommand();
     this.sqlCommand4           = new System.Data.SqlClient.SqlCommand();
     this.sqlCommand5           = new System.Data.SqlClient.SqlCommand();
     ((System.ComponentModel.ISupportInitialize)(this.dsClients1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsGroups1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).BeginInit();
     //
     // sqlConnection1
     //
     this.sqlConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string))));
     //
     // sqldaClients
     //
     this.sqldaClients.DeleteCommand = this.sqlDeleteCommand2;
     this.sqldaClients.InsertCommand = this.sqlInsertCommand2;
     this.sqldaClients.SelectCommand = this.sqlSelectCommand1;
     this.sqldaClients.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Clients", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ClientID", "ClientID"),
             new System.Data.Common.DataColumnMapping("ClientGroupID", "ClientGroupID"),
             new System.Data.Common.DataColumnMapping("ClientName", "ClientName"),
             new System.Data.Common.DataColumnMapping("ClientRemarks", "ClientRemarks"),
             new System.Data.Common.DataColumnMapping("IsInner", "IsInner"),
             new System.Data.Common.DataColumnMapping("IsSpecial", "IsSpecial"),
             new System.Data.Common.DataColumnMapping("Password", "Password")
         })
     });
     this.sqldaClients.UpdateCommand = this.sqlUpdateCommand2;
     //
     // sqlDeleteCommand2
     //
     this.sqlDeleteCommand2.CommandText = "[ClientDelete]";
     this.sqlDeleteCommand2.CommandType = System.Data.CommandType.StoredProcedure;
     this.sqlDeleteCommand2.Connection  = this.sqlConnection1;
     this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ClientID", System.Data.DataRowVersion.Current, null));
     this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
     //
     // sqlInsertCommand2
     //
     this.sqlInsertCommand2.CommandText = @"INSERT INTO Clients (ClientGroupID, ClientName, ClientRemarks, IsInner, IsSpecial, Password) VALUES (@ClientGroupID, @ClientName, @ClientRemarks, @IsInner, @IsSpecial, @Password); SELECT Clients.ClientID, Clients.ClientGroupID, Clients.ClientName, Clients.ClientRemarks, ClientsGroups.ClientGroupName, Clients.IsInner, Clients.IsSpecial, Clients.Password FROM Clients INNER JOIN ClientsGroups ON Clients.ClientGroupID = ClientsGroups.ClientGroupID WHERE (Clients.ClientID = @@IDENTITY)";
     this.sqlInsertCommand2.Connection  = this.sqlConnection1;
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupID", System.Data.SqlDbType.Int, 4, "ClientGroupID"));
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientName", System.Data.SqlDbType.NVarChar, 50, "ClientName"));
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientRemarks", System.Data.SqlDbType.NVarChar, 255, "ClientRemarks"));
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsInner", System.Data.SqlDbType.Bit, 1, "IsInner"));
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsSpecial", System.Data.SqlDbType.Bit, 1, "IsSpecial"));
     this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Password", System.Data.SqlDbType.NVarChar, 48, "Password"));
     //
     // sqlSelectCommand1
     //
     this.sqlSelectCommand1.CommandText = @"SELECT Clients.ClientID, Clients.ClientGroupID, Clients.ClientName, Clients.ClientRemarks, Clients.IsInner, Clients.IsSpecial, Clients.Password, ClientsGroups.ClientGroupName FROM Clients INNER JOIN ClientsGroups ON Clients.ClientGroupID = ClientsGroups.ClientGroupID ORDER BY Clients.ClientName";
     this.sqlSelectCommand1.Connection  = this.sqlConnection1;
     //
     // sqlUpdateCommand2
     //
     this.sqlUpdateCommand2.CommandText = @"UPDATE Clients SET ClientGroupID = @ClientGroupID, ClientName = @ClientName, ClientRemarks = @ClientRemarks, IsInner = @IsInner, IsSpecial = @IsSpecial, Password = @Password WHERE (ClientID = @Original_ClientID) AND (ClientGroupID = @Original_ClientGroupID) AND (ClientName = @Original_ClientName) AND (ClientRemarks = @Original_ClientRemarks) AND (IsInner = @Original_IsInner) AND (IsSpecial = @Original_IsSpecial OR @Original_IsSpecial IS NULL AND IsSpecial IS NULL) AND (Password = @Original_Password OR @Original_Password IS NULL AND Password IS NULL); SELECT ClientID, ClientGroupID, ClientName, ClientRemarks, IsInner, IsSpecial, Password FROM Clients WHERE (ClientID = @ClientID)";
     this.sqlUpdateCommand2.Connection  = this.sqlConnection1;
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupID", System.Data.SqlDbType.Int, 4, "ClientGroupID"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientName", System.Data.SqlDbType.NVarChar, 50, "ClientName"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientRemarks", System.Data.SqlDbType.NVarChar, 255, "ClientRemarks"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsInner", System.Data.SqlDbType.Bit, 1, "IsInner"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsSpecial", System.Data.SqlDbType.Bit, 1, "IsSpecial"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Password", System.Data.SqlDbType.NVarChar, 128, "Password"));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientID", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupID", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientName", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientName", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientRemarks", System.Data.SqlDbType.NVarChar, 255, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientRemarks", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsInner", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsInner", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsSpecial", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsSpecial", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Password", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Password", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
     //
     // dsClients1
     //
     this.dsClients1.DataSetName = "dsClients";
     this.dsClients1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // sqlDataAdapter2
     //
     this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand1;
     this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand1;
     this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
     this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "ClientsGroups", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ClientGroupID", "ClientGroupID"),
             new System.Data.Common.DataColumnMapping("ClientGroupName", "ClientGroupName"),
             new System.Data.Common.DataColumnMapping("ClientGroupRemarks", "ClientGroupRemarks"),
             new System.Data.Common.DataColumnMapping("IsInner", "IsInner"),
             new System.Data.Common.DataColumnMapping("IsSpecial", "IsSpecial")
         })
     });
     this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand1;
     //
     // sqlDeleteCommand1
     //
     this.sqlDeleteCommand1.CommandText = "DELETE FROM ClientsGroups WHERE (ClientGroupID = @Original_ClientGroupID) AND (Cl" +
                                          "ientGroupName = @Original_ClientGroupName) AND (ClientGroupRemarks = @Original_C" +
                                          "lientGroupRemarks) AND (IsInner = @Original_IsInner) AND (IsSpecial = @Original_" +
                                          "IsSpecial)";
     this.sqlDeleteCommand1.Connection = this.sqlConnection1;
     this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupID", System.Data.DataRowVersion.Original, null));
     this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupName", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupName", System.Data.DataRowVersion.Original, null));
     this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupRemarks", System.Data.SqlDbType.NVarChar, 512, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupRemarks", System.Data.DataRowVersion.Original, null));
     this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsInner", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsInner", System.Data.DataRowVersion.Original, null));
     this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsSpecial", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsSpecial", System.Data.DataRowVersion.Original, null));
     //
     // sqlInsertCommand1
     //
     this.sqlInsertCommand1.CommandText = @"INSERT INTO ClientsGroups(ClientGroupName, ClientGroupRemarks, IsInner, IsSpecial) VALUES (@ClientGroupName, @ClientGroupRemarks, @IsInner, @IsSpecial); SELECT ClientGroupID, ClientGroupName, ClientGroupRemarks, IsInner, IsSpecial FROM ClientsGroups WHERE (ClientGroupID = @@IDENTITY)";
     this.sqlInsertCommand1.Connection  = this.sqlConnection1;
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupName", System.Data.SqlDbType.NVarChar, 50, "ClientGroupName"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupRemarks", System.Data.SqlDbType.NVarChar, 512, "ClientGroupRemarks"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsInner", System.Data.SqlDbType.Bit, 1, "IsInner"));
     this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsSpecial", System.Data.SqlDbType.Bit, 1, "IsSpecial"));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "SELECT ClientGroupID, ClientGroupName, ClientGroupRemarks, IsInner, IsSpecial FRO" +
                                          "M ClientsGroups ORDER BY ClientGroupName";
     this.sqlSelectCommand2.Connection = this.sqlConnection1;
     //
     // sqlUpdateCommand1
     //
     this.sqlUpdateCommand1.CommandText = @"UPDATE ClientsGroups SET ClientGroupName = @ClientGroupName, ClientGroupRemarks = @ClientGroupRemarks, IsInner = @IsInner, IsSpecial = @IsSpecial WHERE (ClientGroupID = @Original_ClientGroupID) AND (ClientGroupName = @Original_ClientGroupName) AND (ClientGroupRemarks = @Original_ClientGroupRemarks) AND (IsInner = @Original_IsInner) AND (IsSpecial = @Original_IsSpecial); SELECT ClientGroupID, ClientGroupName, ClientGroupRemarks, IsInner, IsSpecial FROM ClientsGroups WHERE (ClientGroupID = @ClientGroupID)";
     this.sqlUpdateCommand1.Connection  = this.sqlConnection1;
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupName", System.Data.SqlDbType.NVarChar, 50, "ClientGroupName"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupRemarks", System.Data.SqlDbType.NVarChar, 512, "ClientGroupRemarks"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsInner", System.Data.SqlDbType.Bit, 1, "IsInner"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsSpecial", System.Data.SqlDbType.Bit, 1, "IsSpecial"));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupID", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupName", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupName", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientGroupRemarks", System.Data.SqlDbType.NVarChar, 512, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientGroupRemarks", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsInner", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsInner", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsSpecial", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsSpecial", System.Data.DataRowVersion.Original, null));
     this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientGroupID", System.Data.SqlDbType.Int, 4, "ClientGroupID"));
     //
     // dsGroups1
     //
     this.dsGroups1.DataSetName = "dsGroups";
     this.dsGroups1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // dsCurr1
     //
     this.dsCurr1.DataSetName = "dsCurr";
     this.dsCurr1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // sqldaSelOrgsClients
     //
     this.sqldaSelOrgsClients.InsertCommand = this.sqlCommand2;
     this.sqldaSelOrgsClients.SelectCommand = this.sqlSelectClientsOrgs;
     this.sqldaSelOrgsClients.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "OrgsClients", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ClientID", "ClientID"),
             new System.Data.Common.DataColumnMapping("OrgID", "OrgID"),
             new System.Data.Common.DataColumnMapping("Direction", "Direction"),
             new System.Data.Common.DataColumnMapping("IsAvailable", "IsAvailable"),
             new System.Data.Common.DataColumnMapping("OrgName", "OrgName"),
             new System.Data.Common.DataColumnMapping("CodeINN", "CodeINN"),
             new System.Data.Common.DataColumnMapping("IsRemoved", "IsRemoved")
         })
     });
     this.sqldaSelOrgsClients.UpdateCommand = this.sqlCommand1;
     //
     // sqlCommand2
     //
     this.sqlCommand2.CommandText = "INSERT INTO OrgsClients (ClientID, OrgID, Direction, IsAvailable) VALUES (@Client" +
                                    "ID, @OrgID, @Direction, @IsAvailable)";
     this.sqlCommand2.Connection = this.sqlConnection1;
     this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
     this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgID", System.Data.SqlDbType.Int, 4, "OrgID"));
     this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Direction", System.Data.SqlDbType.TinyInt, 1, "Direction"));
     this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsAvailable", System.Data.SqlDbType.Bit, 1, "IsAvailable"));
     //
     // sqlSelectClientsOrgs
     //
     this.sqlSelectClientsOrgs.CommandText = @"SELECT OrgsClients.ClientID, OrgsClients.OrgID, OrgsClients.Direction, OrgsClients.IsAvailable, Orgs.OrgName, Orgs.CodeINN, Orgs.IsRemoved FROM OrgsClients INNER JOIN Orgs ON OrgsClients.OrgID = Orgs.OrgID WHERE (OrgsClients.ClientID = @ClientID) AND (Orgs.IsRemoved = 0)";
     this.sqlSelectClientsOrgs.Connection  = this.sqlConnection1;
     this.sqlSelectClientsOrgs.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
     //
     // sqlCommand1
     //
     this.sqlCommand1.CommandText = "UPDATE OrgsClients SET IsAvailable = @IsAvailable WHERE (ClientID = @Original_Cli" +
                                    "entID) AND (Direction = @Original_Direction) AND (OrgID = @Original_OrgID)";
     this.sqlCommand1.Connection = this.sqlConnection1;
     this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsAvailable", System.Data.SqlDbType.Bit, 1, "IsAvailable"));
     this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientID", System.Data.DataRowVersion.Original, null));
     this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Direction", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Direction", System.Data.DataRowVersion.Original, null));
     this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrgID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrgID", System.Data.DataRowVersion.Original, null));
     //
     // dsOrgsClients1
     //
     this.dsOrgsClients1.DataSetName = "dsOrgsClients";
     this.dsOrgsClients1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     //
     // sqldaGetAvailableOrgs
     //
     this.sqldaGetAvailableOrgs.InsertCommand = this.sqlCommand3;
     this.sqldaGetAvailableOrgs.SelectCommand = this.sqlCommand4;
     this.sqldaGetAvailableOrgs.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "OrgsClients", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ClientID", "ClientID"),
             new System.Data.Common.DataColumnMapping("OrgID", "OrgID"),
             new System.Data.Common.DataColumnMapping("Direction", "Direction"),
             new System.Data.Common.DataColumnMapping("IsAvailable", "IsAvailable"),
             new System.Data.Common.DataColumnMapping("OrgName", "OrgName"),
             new System.Data.Common.DataColumnMapping("CodeINN", "CodeINN"),
             new System.Data.Common.DataColumnMapping("IsRemoved", "IsRemoved"),
             new System.Data.Common.DataColumnMapping("CodeKPP", "CodeKPP")
         })
     });
     this.sqldaGetAvailableOrgs.UpdateCommand = this.sqlCommand5;
     //
     // sqlCommand3
     //
     this.sqlCommand3.CommandText = "INSERT INTO OrgsClients (ClientID, OrgID, Direction, IsAvailable) VALUES (@Client" +
                                    "ID, @OrgID, @Direction, @IsAvailable)";
     this.sqlCommand3.Connection = this.sqlConnection1;
     this.sqlCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
     this.sqlCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgID", System.Data.SqlDbType.Int, 4, "OrgID"));
     this.sqlCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Direction", System.Data.SqlDbType.TinyInt, 1, "Direction"));
     this.sqlCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsAvailable", System.Data.SqlDbType.Bit, 1, "IsAvailable"));
     //
     // sqlCommand4
     //
     this.sqlCommand4.CommandText = @"SELECT OrgsClients.ClientID, OrgsClients.OrgID, OrgsClients.Direction, OrgsClients.IsAvailable, Orgs.OrgName, Orgs.CodeINN, Orgs.IsRemoved, Orgs.CodeKPP FROM OrgsClients INNER JOIN Orgs ON OrgsClients.OrgID = Orgs.OrgID WHERE (OrgsClients.ClientID = @ClientID) AND (Orgs.IsRemoved = 0) AND (OrgsClients.IsAvailable = 1) ORDER BY Orgs.OrgName";
     this.sqlCommand4.Connection  = this.sqlConnection1;
     this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
     //
     // sqlCommand5
     //
     this.sqlCommand5.CommandText = "UPDATE OrgsClients SET IsAvailable = @IsAvailable WHERE (ClientID = @Original_Cli" +
                                    "entID) AND (Direction = @Original_Direction) AND (OrgID = @Original_OrgID)";
     this.sqlCommand5.Connection = this.sqlConnection1;
     this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsAvailable", System.Data.SqlDbType.Bit, 1, "IsAvailable"));
     this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientID", System.Data.DataRowVersion.Original, null));
     this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Direction", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Direction", System.Data.DataRowVersion.Original, null));
     this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_OrgID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OrgID", System.Data.DataRowVersion.Original, null));
     ((System.ComponentModel.ISupportInitialize)(this.dsClients1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsGroups1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).EndInit();
 }
Esempio n. 5
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     System.Resources.ResourceManager       resources = new System.Resources.ResourceManager(typeof(AddClient));
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.cmbGroup               = new System.Windows.Forms.ComboBox();
     this.tbClient               = new System.Windows.Forms.TextBox();
     this.tbRemarks              = new System.Windows.Forms.TextBox();
     this.label1                 = new System.Windows.Forms.Label();
     this.label2                 = new System.Windows.Forms.Label();
     this.label3                 = new System.Windows.Forms.Label();
     this.btAddGroup             = new System.Windows.Forms.Button();
     this.bnOK                   = new System.Windows.Forms.Button();
     this.bnCancel               = new System.Windows.Forms.Button();
     this.sqlConnection1         = new System.Data.SqlClient.SqlConnection();
     this.sqlSelectCommand2      = new System.Data.SqlClient.SqlCommand();
     this.sqlDataAdapter2        = new System.Data.SqlClient.SqlDataAdapter();
     this.dataView1              = new System.Data.DataView();
     this.dataGrid1              = new System.Windows.Forms.DataGrid();
     this.dvClientRate           = new System.Data.DataView();
     this.dsInterestRate1        = new BPS.BLL.Clients.DataSets.dsInterestRate();
     this.dataGridTableStyle2    = new System.Windows.Forms.DataGridTableStyle();
     this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn5 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.tbPassw                = new System.Windows.Forms.TextBox();
     this.label4                 = new System.Windows.Forms.Label();
     this.tbConfirmPassw         = new System.Windows.Forms.TextBox();
     this.label5                 = new System.Windows.Forms.Label();
     this.tabControl1            = new System.Windows.Forms.TabControl();
     this.tabPage1               = new System.Windows.Forms.TabPage();
     this.tabPage2               = new System.Windows.Forms.TabPage();
     this.dgSendFrom             = new System.Windows.Forms.DataGrid();
     this.dvSend                 = new System.Data.DataView();
     this.dsOrgsClients1         = new BPS.BLL.Clients.DataSets.dsOrgsClients();
     this.dataGridTableStyle1    = new System.Windows.Forms.DataGridTableStyle();
     this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridBoolColumn1    = new System.Windows.Forms.DataGridBoolColumn();
     this.tabPage3               = new System.Windows.Forms.TabPage();
     this.dataGrid2              = new System.Windows.Forms.DataGrid();
     this.dvReceive              = new System.Data.DataView();
     this.dataGridTableStyle3    = new System.Windows.Forms.DataGridTableStyle();
     this.dataGridTextBoxColumn6 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridTextBoxColumn7 = new System.Windows.Forms.DataGridTextBoxColumn();
     this.dataGridBoolColumn2    = new System.Windows.Forms.DataGridBoolColumn();
     ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvClientRate)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).BeginInit();
     this.tabControl1.SuspendLayout();
     this.tabPage1.SuspendLayout();
     this.tabPage2.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dgSendFrom)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvSend)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).BeginInit();
     this.tabPage3.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvReceive)).BeginInit();
     this.SuspendLayout();
     //
     // cmbGroup
     //
     this.cmbGroup.Location = new System.Drawing.Point(86, 2);
     this.cmbGroup.Name     = "cmbGroup";
     this.cmbGroup.Size     = new System.Drawing.Size(160, 21);
     this.cmbGroup.TabIndex = 0;
     this.cmbGroup.Leave   += new System.EventHandler(this.cmbGroup_Leave);
     //
     // tbClient
     //
     this.tbClient.Location = new System.Drawing.Point(86, 24);
     this.tbClient.Name     = "tbClient";
     this.tbClient.Size     = new System.Drawing.Size(344, 21);
     this.tbClient.TabIndex = 2;
     this.tbClient.Text     = "";
     //
     // tbRemarks
     //
     this.tbRemarks.Location = new System.Drawing.Point(86, 90);
     this.tbRemarks.Name     = "tbRemarks";
     this.tbRemarks.Size     = new System.Drawing.Size(344, 21);
     this.tbRemarks.TabIndex = 5;
     this.tbRemarks.Text     = "";
     //
     // label1
     //
     this.label1.Location  = new System.Drawing.Point(6, 0);
     this.label1.Name      = "label1";
     this.label1.Size      = new System.Drawing.Size(50, 23);
     this.label1.TabIndex  = 3;
     this.label1.Text      = "Группа:";
     this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // label2
     //
     this.label2.Location  = new System.Drawing.Point(6, 24);
     this.label2.Name      = "label2";
     this.label2.Size      = new System.Drawing.Size(76, 23);
     this.label2.TabIndex  = 4;
     this.label2.Text      = "Клиент:";
     this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // label3
     //
     this.label3.Location  = new System.Drawing.Point(6, 90);
     this.label3.Name      = "label3";
     this.label3.Size      = new System.Drawing.Size(72, 23);
     this.label3.TabIndex  = 5;
     this.label3.Text      = "Примечание:";
     this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // btAddGroup
     //
     this.btAddGroup.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
     this.btAddGroup.Image     = ((System.Drawing.Bitmap)(resources.GetObject("btAddGroup.Image")));
     this.btAddGroup.Location  = new System.Drawing.Point(246, 2);
     this.btAddGroup.Name      = "btAddGroup";
     this.btAddGroup.Size      = new System.Drawing.Size(24, 21);
     this.btAddGroup.TabIndex  = 1;
     this.btAddGroup.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
     this.btAddGroup.Click    += new System.EventHandler(this.btAddGroup_Click);
     //
     // bnOK
     //
     this.bnOK.Font     = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.bnOK.Location = new System.Drawing.Point(272, 360);
     this.bnOK.Name     = "bnOK";
     this.bnOK.Size     = new System.Drawing.Size(80, 26);
     this.bnOK.TabIndex = 8;
     this.bnOK.Text     = "Сохранить";
     this.bnOK.Click   += new System.EventHandler(this.bnOK_Click);
     //
     // bnCancel
     //
     this.bnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
     this.bnCancel.Font         = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.bnCancel.Location     = new System.Drawing.Point(354, 360);
     this.bnCancel.Name         = "bnCancel";
     this.bnCancel.Size         = new System.Drawing.Size(80, 26);
     this.bnCancel.TabIndex     = 9;
     this.bnCancel.Text         = "Отменить";
     this.bnCancel.Click       += new System.EventHandler(this.bnCancel_Click);
     //
     // sqlConnection1
     //
     this.sqlConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string))));
     //
     // sqlSelectCommand2
     //
     this.sqlSelectCommand2.CommandText = "SELECT ClientGroupID, ClientGroupName, ClientGroupRemarks FROM ClientsGroups";
     this.sqlSelectCommand2.Connection  = this.sqlConnection1;
     //
     // sqlDataAdapter2
     //
     this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
     //
     // dataGrid1
     //
     this.dataGrid1.AlternatingBackColor = System.Drawing.Color.LightGray;
     this.dataGrid1.BackColor            = System.Drawing.Color.DarkGray;
     this.dataGrid1.CaptionBackColor     = System.Drawing.Color.White;
     this.dataGrid1.CaptionFont          = new System.Drawing.Font("Microsoft Sans Serif", 8F);
     this.dataGrid1.CaptionForeColor     = System.Drawing.Color.Navy;
     this.dataGrid1.CaptionText          = "Процентные ставки";
     this.dataGrid1.CaptionVisible       = false;
     this.dataGrid1.DataMember           = "";
     this.dataGrid1.DataSource           = this.dvClientRate;
     this.dataGrid1.Dock                = System.Windows.Forms.DockStyle.Fill;
     this.dataGrid1.ForeColor           = System.Drawing.Color.Black;
     this.dataGrid1.GridLineColor       = System.Drawing.Color.Black;
     this.dataGrid1.GridLineStyle       = System.Windows.Forms.DataGridLineStyle.None;
     this.dataGrid1.HeaderBackColor     = System.Drawing.Color.Silver;
     this.dataGrid1.HeaderForeColor     = System.Drawing.Color.Black;
     this.dataGrid1.LinkColor           = System.Drawing.Color.Navy;
     this.dataGrid1.Name                = "dataGrid1";
     this.dataGrid1.ParentRowsBackColor = System.Drawing.Color.White;
     this.dataGrid1.ParentRowsForeColor = System.Drawing.Color.Black;
     this.dataGrid1.SelectionBackColor  = System.Drawing.Color.Navy;
     this.dataGrid1.SelectionForeColor  = System.Drawing.Color.White;
     this.dataGrid1.Size                = new System.Drawing.Size(428, 202);
     this.dataGrid1.TabIndex            = 7;
     this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
         this.dataGridTableStyle2
     });
     //
     // dvClientRate
     //
     this.dvClientRate.AllowDelete = false;
     this.dvClientRate.AllowNew    = false;
     this.dvClientRate.Table       = this.dsInterestRate1.InterestRate;
     //
     // dsInterestRate1
     //
     this.dsInterestRate1.DataSetName = "dsInterestRate";
     this.dsInterestRate1.Locale      = new System.Globalization.CultureInfo("en-US");
     this.dsInterestRate1.Namespace   = "http://tempuri.org/dsInterestRate.xsd";
     //
     // dataGridTableStyle2
     //
     this.dataGridTableStyle2.DataGrid = this.dataGrid1;
     this.dataGridTableStyle2.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
         this.dataGridTextBoxColumn3,
         this.dataGridTextBoxColumn4,
         this.dataGridTextBoxColumn5
     });
     this.dataGridTableStyle2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGridTableStyle2.MappingName     = "InterestRate";
     //
     // dataGridTextBoxColumn3
     //
     this.dataGridTextBoxColumn3.Format      = "";
     this.dataGridTextBoxColumn3.FormatInfo  = null;
     this.dataGridTextBoxColumn3.HeaderText  = "Тип операции";
     this.dataGridTextBoxColumn3.MappingName = "ReqTypeName";
     this.dataGridTextBoxColumn3.ReadOnly    = true;
     this.dataGridTextBoxColumn3.Width       = 200;
     //
     // dataGridTextBoxColumn4
     //
     this.dataGridTextBoxColumn4.Alignment   = System.Windows.Forms.HorizontalAlignment.Right;
     this.dataGridTextBoxColumn4.Format      = "0.00";
     this.dataGridTextBoxColumn4.FormatInfo  = null;
     this.dataGridTextBoxColumn4.HeaderText  = "% Норм.";
     this.dataGridTextBoxColumn4.MappingName = "RateNormal";
     this.dataGridTextBoxColumn4.NullText    = "-";
     this.dataGridTextBoxColumn4.Width       = 75;
     //
     // dataGridTextBoxColumn5
     //
     this.dataGridTextBoxColumn5.Alignment   = System.Windows.Forms.HorizontalAlignment.Right;
     this.dataGridTextBoxColumn5.Format      = "0.00";
     this.dataGridTextBoxColumn5.FormatInfo  = null;
     this.dataGridTextBoxColumn5.HeaderText  = "% Black";
     this.dataGridTextBoxColumn5.MappingName = "RateBlack";
     this.dataGridTextBoxColumn5.NullText    = "-";
     this.dataGridTextBoxColumn5.Width       = 75;
     //
     // tbPassw
     //
     this.tbPassw.Location     = new System.Drawing.Point(86, 46);
     this.tbPassw.MaxLength    = 16;
     this.tbPassw.Name         = "tbPassw";
     this.tbPassw.PasswordChar = '*';
     this.tbPassw.Size         = new System.Drawing.Size(344, 21);
     this.tbPassw.TabIndex     = 3;
     this.tbPassw.Text         = "";
     //
     // label4
     //
     this.label4.Location  = new System.Drawing.Point(6, 46);
     this.label4.Name      = "label4";
     this.label4.Size      = new System.Drawing.Size(54, 23);
     this.label4.TabIndex  = 9;
     this.label4.Text      = "Пароль:";
     this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // tbConfirmPassw
     //
     this.tbConfirmPassw.Location     = new System.Drawing.Point(86, 68);
     this.tbConfirmPassw.Name         = "tbConfirmPassw";
     this.tbConfirmPassw.PasswordChar = '*';
     this.tbConfirmPassw.Size         = new System.Drawing.Size(344, 21);
     this.tbConfirmPassw.TabIndex     = 4;
     this.tbConfirmPassw.Text         = "";
     //
     // label5
     //
     this.label5.Location  = new System.Drawing.Point(6, 70);
     this.label5.Name      = "label5";
     this.label5.Size      = new System.Drawing.Size(80, 23);
     this.label5.TabIndex  = 11;
     this.label5.Text      = "Подтвердить:";
     this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
     //
     // tabControl1
     //
     this.tabControl1.Controls.AddRange(new System.Windows.Forms.Control[] {
         this.tabPage1,
         this.tabPage2,
         this.tabPage3
     });
     this.tabControl1.Location      = new System.Drawing.Point(2, 122);
     this.tabControl1.Name          = "tabControl1";
     this.tabControl1.SelectedIndex = 0;
     this.tabControl1.Size          = new System.Drawing.Size(436, 228);
     this.tabControl1.TabIndex      = 12;
     //
     // tabPage1
     //
     this.tabPage1.Controls.AddRange(new System.Windows.Forms.Control[] {
         this.dataGrid1
     });
     this.tabPage1.Location = new System.Drawing.Point(4, 22);
     this.tabPage1.Name     = "tabPage1";
     this.tabPage1.Size     = new System.Drawing.Size(428, 202);
     this.tabPage1.TabIndex = 0;
     this.tabPage1.Text     = "% Обслуживания";
     //
     // tabPage2
     //
     this.tabPage2.Controls.AddRange(new System.Windows.Forms.Control[] {
         this.dgSendFrom
     });
     this.tabPage2.Location = new System.Drawing.Point(4, 22);
     this.tabPage2.Name     = "tabPage2";
     this.tabPage2.Size     = new System.Drawing.Size(428, 202);
     this.tabPage2.TabIndex = 1;
     this.tabPage2.Text     = "Отправка";
     //
     // dgSendFrom
     //
     this.dgSendFrom.AlternatingBackColor = System.Drawing.Color.LightGray;
     this.dgSendFrom.BackColor            = System.Drawing.Color.DarkGray;
     this.dgSendFrom.CaptionBackColor     = System.Drawing.Color.White;
     this.dgSendFrom.CaptionFont          = new System.Drawing.Font("Microsoft Sans Serif", 8F);
     this.dgSendFrom.CaptionForeColor     = System.Drawing.Color.Navy;
     this.dgSendFrom.CaptionText          = "Процентные ставки";
     this.dgSendFrom.CaptionVisible       = false;
     this.dgSendFrom.DataMember           = "";
     this.dgSendFrom.DataSource           = this.dvSend;
     this.dgSendFrom.Dock                = System.Windows.Forms.DockStyle.Fill;
     this.dgSendFrom.ForeColor           = System.Drawing.Color.Black;
     this.dgSendFrom.GridLineColor       = System.Drawing.Color.Black;
     this.dgSendFrom.GridLineStyle       = System.Windows.Forms.DataGridLineStyle.None;
     this.dgSendFrom.HeaderBackColor     = System.Drawing.Color.Silver;
     this.dgSendFrom.HeaderForeColor     = System.Drawing.Color.Black;
     this.dgSendFrom.LinkColor           = System.Drawing.Color.Navy;
     this.dgSendFrom.Name                = "dgSendFrom";
     this.dgSendFrom.ParentRowsBackColor = System.Drawing.Color.White;
     this.dgSendFrom.ParentRowsForeColor = System.Drawing.Color.Black;
     this.dgSendFrom.SelectionBackColor  = System.Drawing.Color.Navy;
     this.dgSendFrom.SelectionForeColor  = System.Drawing.Color.White;
     this.dgSendFrom.Size                = new System.Drawing.Size(428, 202);
     this.dgSendFrom.TabIndex            = 8;
     this.dgSendFrom.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
         this.dataGridTableStyle1
     });
     //
     // dvSend
     //
     this.dvSend.AllowDelete = false;
     this.dvSend.AllowNew    = false;
     this.dvSend.RowFilter   = "Direction=1";
     this.dvSend.Table       = this.dsOrgsClients1.OrgsClients;
     //
     // dsOrgsClients1
     //
     this.dsOrgsClients1.DataSetName = "dsOrgsClients";
     this.dsOrgsClients1.Locale      = new System.Globalization.CultureInfo("ru-RU");
     this.dsOrgsClients1.Namespace   = "http://www.tempuri.org/dsOrgsClients.xsd";
     //
     // dataGridTableStyle1
     //
     this.dataGridTableStyle1.DataGrid = this.dgSendFrom;
     this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
         this.dataGridTextBoxColumn1,
         this.dataGridTextBoxColumn2,
         this.dataGridBoolColumn1
     });
     this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGridTableStyle1.MappingName     = "OrgsClients";
     //
     // dataGridTextBoxColumn1
     //
     this.dataGridTextBoxColumn1.Format      = "";
     this.dataGridTextBoxColumn1.FormatInfo  = null;
     this.dataGridTextBoxColumn1.HeaderText  = "Наименование";
     this.dataGridTextBoxColumn1.MappingName = "OrgName";
     this.dataGridTextBoxColumn1.NullText    = "-";
     this.dataGridTextBoxColumn1.ReadOnly    = true;
     this.dataGridTextBoxColumn1.Width       = 150;
     //
     // dataGridTextBoxColumn2
     //
     this.dataGridTextBoxColumn2.Format      = "";
     this.dataGridTextBoxColumn2.FormatInfo  = null;
     this.dataGridTextBoxColumn2.HeaderText  = "ИНН";
     this.dataGridTextBoxColumn2.MappingName = "CodeINN";
     this.dataGridTextBoxColumn2.NullText    = "-";
     this.dataGridTextBoxColumn2.ReadOnly    = true;
     this.dataGridTextBoxColumn2.Width       = 90;
     //
     // dataGridBoolColumn1
     //
     this.dataGridBoolColumn1.Alignment   = System.Windows.Forms.HorizontalAlignment.Center;
     this.dataGridBoolColumn1.AllowNull   = false;
     this.dataGridBoolColumn1.FalseValue  = false;
     this.dataGridBoolColumn1.HeaderText  = "Разрешено";
     this.dataGridBoolColumn1.MappingName = "IsAvailable";
     this.dataGridBoolColumn1.NullValue   = ((System.DBNull)(resources.GetObject("dataGridBoolColumn1.NullValue")));
     this.dataGridBoolColumn1.TrueValue   = true;
     this.dataGridBoolColumn1.Width       = 75;
     //
     // tabPage3
     //
     this.tabPage3.Controls.AddRange(new System.Windows.Forms.Control[] {
         this.dataGrid2
     });
     this.tabPage3.Location = new System.Drawing.Point(4, 22);
     this.tabPage3.Name     = "tabPage3";
     this.tabPage3.Size     = new System.Drawing.Size(428, 202);
     this.tabPage3.TabIndex = 2;
     this.tabPage3.Text     = "Прием";
     //
     // dataGrid2
     //
     this.dataGrid2.AlternatingBackColor = System.Drawing.Color.LightGray;
     this.dataGrid2.BackColor            = System.Drawing.Color.DarkGray;
     this.dataGrid2.CaptionBackColor     = System.Drawing.Color.White;
     this.dataGrid2.CaptionFont          = new System.Drawing.Font("Microsoft Sans Serif", 8F);
     this.dataGrid2.CaptionForeColor     = System.Drawing.Color.Navy;
     this.dataGrid2.CaptionText          = "Процентные ставки";
     this.dataGrid2.CaptionVisible       = false;
     this.dataGrid2.DataMember           = "";
     this.dataGrid2.DataSource           = this.dvReceive;
     this.dataGrid2.Dock                = System.Windows.Forms.DockStyle.Fill;
     this.dataGrid2.ForeColor           = System.Drawing.Color.Black;
     this.dataGrid2.GridLineColor       = System.Drawing.Color.Black;
     this.dataGrid2.GridLineStyle       = System.Windows.Forms.DataGridLineStyle.None;
     this.dataGrid2.HeaderBackColor     = System.Drawing.Color.Silver;
     this.dataGrid2.HeaderForeColor     = System.Drawing.Color.Black;
     this.dataGrid2.LinkColor           = System.Drawing.Color.Navy;
     this.dataGrid2.Name                = "dataGrid2";
     this.dataGrid2.ParentRowsBackColor = System.Drawing.Color.White;
     this.dataGrid2.ParentRowsForeColor = System.Drawing.Color.Black;
     this.dataGrid2.SelectionBackColor  = System.Drawing.Color.Navy;
     this.dataGrid2.SelectionForeColor  = System.Drawing.Color.White;
     this.dataGrid2.Size                = new System.Drawing.Size(428, 202);
     this.dataGrid2.TabIndex            = 9;
     this.dataGrid2.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
         this.dataGridTableStyle3
     });
     //
     // dvReceive
     //
     this.dvReceive.AllowDelete = false;
     this.dvReceive.AllowNew    = false;
     this.dvReceive.RowFilter   = "Direction=0";
     this.dvReceive.Table       = this.dsOrgsClients1.OrgsClients;
     //
     // dataGridTableStyle3
     //
     this.dataGridTableStyle3.DataGrid = this.dataGrid2;
     this.dataGridTableStyle3.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
         this.dataGridTextBoxColumn6,
         this.dataGridTextBoxColumn7,
         this.dataGridBoolColumn2
     });
     this.dataGridTableStyle3.HeaderForeColor = System.Drawing.SystemColors.ControlText;
     this.dataGridTableStyle3.MappingName     = "OrgsClients";
     //
     // dataGridTextBoxColumn6
     //
     this.dataGridTextBoxColumn6.Format      = "";
     this.dataGridTextBoxColumn6.FormatInfo  = null;
     this.dataGridTextBoxColumn6.HeaderText  = "Наименование";
     this.dataGridTextBoxColumn6.MappingName = "OrgName";
     this.dataGridTextBoxColumn6.NullText    = "-";
     this.dataGridTextBoxColumn6.Width       = 150;
     //
     // dataGridTextBoxColumn7
     //
     this.dataGridTextBoxColumn7.Format      = "";
     this.dataGridTextBoxColumn7.FormatInfo  = null;
     this.dataGridTextBoxColumn7.HeaderText  = "ИНН";
     this.dataGridTextBoxColumn7.MappingName = "CodeINN";
     this.dataGridTextBoxColumn7.NullText    = "-";
     this.dataGridTextBoxColumn7.Width       = 90;
     //
     // dataGridBoolColumn2
     //
     this.dataGridBoolColumn2.Alignment   = System.Windows.Forms.HorizontalAlignment.Center;
     this.dataGridBoolColumn2.AllowNull   = false;
     this.dataGridBoolColumn2.FalseValue  = false;
     this.dataGridBoolColumn2.HeaderText  = "Разрешено";
     this.dataGridBoolColumn2.MappingName = "IsAvailable";
     this.dataGridBoolColumn2.NullText    = "-";
     this.dataGridBoolColumn2.NullValue   = ((System.DBNull)(resources.GetObject("dataGridBoolColumn2.NullValue")));
     this.dataGridBoolColumn2.TrueValue   = true;
     this.dataGridBoolColumn2.Width       = 75;
     //
     // AddClient
     //
     this.AcceptButton      = this.bnOK;
     this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
     this.CancelButton      = this.bnCancel;
     this.ClientSize        = new System.Drawing.Size(436, 387);
     this.Controls.AddRange(new System.Windows.Forms.Control[] {
         this.tabControl1,
         this.label5,
         this.tbConfirmPassw,
         this.label4,
         this.tbPassw,
         this.bnCancel,
         this.bnOK,
         this.btAddGroup,
         this.label3,
         this.label2,
         this.label1,
         this.tbRemarks,
         this.tbClient,
         this.cmbGroup
     });
     this.Font            = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
     this.Icon            = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
     this.MaximizeBox     = false;
     this.MinimizeBox     = false;
     this.Name            = "AddClient";
     this.ShowInTaskbar   = false;
     this.StartPosition   = System.Windows.Forms.FormStartPosition.CenterParent;
     this.Text            = "Клиент";
     this.Load           += new System.EventHandler(this.AddClient_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvClientRate)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).EndInit();
     this.tabControl1.ResumeLayout(false);
     this.tabPage1.ResumeLayout(false);
     this.tabPage2.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dgSendFrom)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvSend)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dsOrgsClients1)).EndInit();
     this.tabPage3.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dvReceive)).EndInit();
     this.ResumeLayout(false);
 }