public ClientView(BPS.BLL.Clients.DataSets.dsClients dsClnt, BPS.BLL.Clients.DataSets.dsGroups dsGroups) { // // Required for Windows Form Designer support // InitializeComponent(); InterestRates = new BPS.BLL.Clients.coInterestRates(); this.dvClientRate.Table = dsInterestRate1.InterestRate; BPS.App.SetDataGridTableStyle(this.dataGridTableStyle2); this.BindingContext[this.dataView1].CurrentChanged += new EventHandler(BindingContextChange); this.dsClients1 = dsClnt; this.dataView1.Table = dsClients1.Clients; // Groups this.dvGroups.Table = dsGroups.ClientsGroups; // InterestRates dsInterestRate1 = InterestRates.DsInterestRates; this.dvClientRate.Table = dsInterestRate1.InterestRate; // ReqTypes InterestRates.FillDSReqType(); // InterestRatesList InterestRates.FillDSInterestRateList(); this.dsInterestRateList1 = this.InterestRates.DSInterestRateList; this.dvRateList.Table = this.dsInterestRateList1.InterestRates; }
/// <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); }
/// <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); }
/// <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.dsInterestRate1 = new BPS.BLL.Clients.DataSets.dsInterestRate(); this.dsReqTypes1 = new BPS.BLL.ClientRequest.DataSets.dsReqTypes(); this.sqlSelectClientsOrgs = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.daInterestRateList = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.daReqTypes = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); this.dsInterestRateList1 = new BPS.BLL.Clients.DataSets.dsInterestRateList(); ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInterestRateList1)).BeginInit(); // // dsInterestRate1 // this.dsInterestRate1.DataSetName = "dsInterestRate"; this.dsInterestRate1.Locale = new System.Globalization.CultureInfo("en-US"); // // dsReqTypes1 // this.dsReqTypes1.DataSetName = "dsReqTypes"; this.dsReqTypes1.Locale = new System.Globalization.CultureInfo("ru-RU"); // // 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.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID")); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "[InterestRatesSelectCommand]"; this.sqlSelectCommand3.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); // // sqlConnection1 // this.sqlConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string)))); // // daInterestRateList // this.daInterestRateList.DeleteCommand = this.sqlDeleteCommand1; this.daInterestRateList.InsertCommand = this.sqlInsertCommand1; this.daInterestRateList.SelectCommand = this.sqlSelectCommand1; this.daInterestRateList.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "InterestRates", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("RateID", "RateID"), new System.Data.Common.DataColumnMapping("ClientID", "ClientID"), new System.Data.Common.DataColumnMapping("RequestTypeID", "RequestTypeID"), new System.Data.Common.DataColumnMapping("IsNormal", "IsNormal"), new System.Data.Common.DataColumnMapping("ServiceCharge", "ServiceCharge"), new System.Data.Common.DataColumnMapping("MaxSum", "MaxSum") }) }); this.daInterestRateList.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM InterestRates WHERE (RateID = @Original_RateID)"; this.sqlDeleteCommand1.Connection = this.sqlConnection1; this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_RateID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RateID", System.Data.DataRowVersion.Original, null)); // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = @"INSERT INTO InterestRates(ClientID, RequestTypeID, IsNormal, ServiceCharge, MaxSum) VALUES (@ClientID, @RequestTypeID, @IsNormal, @ServiceCharge, @MaxSum); SELECT RateID, ClientID, RequestTypeID, IsNormal, ServiceCharge, MaxSum FROM InterestRates WHERE (RateID = @@IDENTITY)"; this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestTypeID", System.Data.SqlDbType.Int, 4, "RequestTypeID")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNormal", System.Data.SqlDbType.Bit, 1, "IsNormal")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ServiceCharge", System.Data.SqlDbType.Float, 8, "ServiceCharge")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MaxSum", System.Data.SqlDbType.Float, 8, "MaxSum")); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT RateID, ClientID, RequestTypeID, IsNormal, ServiceCharge, MaxSum FROM Inte" + "restRates"; this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = @"UPDATE InterestRates SET ClientID = @ClientID, RequestTypeID = @RequestTypeID, IsNormal = @IsNormal, ServiceCharge = @ServiceCharge, MaxSum = @MaxSum WHERE (RateID = @Original_RateID); SELECT RateID, ClientID, RequestTypeID, IsNormal, ServiceCharge, MaxSum FROM InterestRates WHERE (RateID = @RateID)"; this.sqlUpdateCommand1.Connection = this.sqlConnection1; this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestTypeID", System.Data.SqlDbType.Int, 4, "RequestTypeID")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNormal", System.Data.SqlDbType.Bit, 1, "IsNormal")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ServiceCharge", System.Data.SqlDbType.Float, 8, "ServiceCharge")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@MaxSum", System.Data.SqlDbType.Float, 8, "MaxSum")); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_RateID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RateID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RateID", System.Data.SqlDbType.Int, 4, "RateID")); // // daReqTypes // this.daReqTypes.SelectCommand = this.sqlSelectCommand4; this.daReqTypes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ClientsRequestTypes", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("RequestTypeID", "RequestTypeID"), new System.Data.Common.DataColumnMapping("RequestTypeName", "RequestTypeName"), new System.Data.Common.DataColumnMapping("IsInner", "IsInner") }) }); // // sqlSelectCommand4 // this.sqlSelectCommand4.CommandText = "SELECT RequestTypeID, RequestTypeName, IsInner FROM ClientsRequestTypes"; this.sqlSelectCommand4.Connection = this.sqlConnection1; // // dsInterestRateList1 // this.dsInterestRateList1.DataSetName = "dsInterestRateList"; this.dsInterestRateList1.Locale = new System.Globalization.CultureInfo("ru-RU"); ((System.ComponentModel.ISupportInitialize)(this.dsInterestRate1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInterestRateList1)).EndInit(); }