/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dsReqTypes1 = new BPS.BLL.ClientsRequests.DataSets.dsReqTypes();
this.dsReqState1 = new BPS.BLL.ClientsRequests.DataSets.dsReqState();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqldaReqStates = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqldaReqTypes = new System.Data.SqlClient.SqlDataAdapter();
this.dsClientsRequests1 = new BPS.BLL.ClientsRequests.DataSets.dsClientsRequests();
this.sqldaRequests = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand5 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsReqState1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsClientsRequests1)).BeginInit();
//
// dsReqTypes1
//
this.dsReqTypes1.DataSetName = "dsReqTypes";
this.dsReqTypes1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// dsReqState1
//
this.dsReqState1.DataSetName = "dsReqState";
this.dsReqState1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT RequestStateID, RequestStateName FROM ClientsRequestStates";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=\"B-1-3\";packet size=4096;integrated security=SSPI;data source=\"B-1" +
"-3-TEST\";persist security info=False;initial catalog=bp2";
//
// sqldaReqStates
//
this.sqldaReqStates.SelectCommand = this.sqlSelectCommand1;
this.sqldaReqStates.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ClientsRequestStates", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("RequestStateID", "RequestStateID"),
new System.Data.Common.DataColumnMapping("RequestStateName", "RequestStateName")
})
});
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT RequestTypeID, RequestTypeName, IsInner, IsIn, IsOut FROM ClientsRequestTy" +
"pes";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqldaReqTypes
//
this.sqldaReqTypes.SelectCommand = this.sqlSelectCommand2;
this.sqldaReqTypes.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"),
new System.Data.Common.DataColumnMapping("IsIn", "IsIn"),
new System.Data.Common.DataColumnMapping("IsOut", "IsOut")
})
});
//
// dsClientsRequests1
//
this.dsClientsRequests1.DataSetName = "dsClientsRequests";
this.dsClientsRequests1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// sqldaRequests
//
this.sqldaRequests.DeleteCommand = this.sqlCommand3;
this.sqldaRequests.InsertCommand = this.sqlCommand4;
this.sqldaRequests.SelectCommand = this.sqlCommand2;
this.sqldaRequests.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ClientsRequests", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("RequestStateName", "RequestStateName"),
new System.Data.Common.DataColumnMapping("RequestTypeName", "RequestTypeName"),
new System.Data.Common.DataColumnMapping("ClientName", "ClientName"),
new System.Data.Common.DataColumnMapping("RequestID", "RequestID"),
new System.Data.Common.DataColumnMapping("RequestTypeID", "RequestTypeID"),
new System.Data.Common.DataColumnMapping("RequestDate", "RequestDate"),
new System.Data.Common.DataColumnMapping("ClientID", "ClientID"),
new System.Data.Common.DataColumnMapping("RequestStateID", "RequestStateID"),
new System.Data.Common.DataColumnMapping("RequestSum", "RequestSum"),
new System.Data.Common.DataColumnMapping("AccountFrom", "AccountFrom"),
new System.Data.Common.DataColumnMapping("AccountTo", "AccountTo"),
new System.Data.Common.DataColumnMapping("Remarks", "Remarks"),
new System.Data.Common.DataColumnMapping("OrgFrom", "OrgFrom"),
new System.Data.Common.DataColumnMapping("OrgTo", "OrgTo"),
new System.Data.Common.DataColumnMapping("OrgFromINN", "OrgFromINN"),
new System.Data.Common.DataColumnMapping("OrgToINN", "OrgToINN"),
new System.Data.Common.DataColumnMapping("OrgFromKPP", "OrgFromKPP"),
new System.Data.Common.DataColumnMapping("OrgToKPP", "OrgToKPP"),
new System.Data.Common.DataColumnMapping("CurrencyFrom", "CurrencyFrom"),
new System.Data.Common.DataColumnMapping("CurrencyTo", "CurrencyTo"),
new System.Data.Common.DataColumnMapping("BankName", "BankName"),
new System.Data.Common.DataColumnMapping("CodeBIK", "CodeBIK"),
new System.Data.Common.DataColumnMapping("VAT", "VAT"),
new System.Data.Common.DataColumnMapping("Purpose", "Purpose"),
new System.Data.Common.DataColumnMapping("ExecutedSum", "ExecutedSum"),
new System.Data.Common.DataColumnMapping("ClientGroupID", "ClientGroupID"),
new System.Data.Common.DataColumnMapping("ClientGroupName", "ClientGroupName")
})
});
this.sqldaRequests.UpdateCommand = this.sqlCommand5;
//
// sqlCommand3
//
this.sqlCommand3.CommandText = "DELETE FROM ClientsRequests WHERE (RequestID = @RequestID)";
this.sqlCommand3.Connection = this.sqlConnection1;
this.sqlCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RequestID", System.Data.DataRowVersion.Original, null));
//
// sqlCommand4
//
this.sqlCommand4.CommandText = @"INSERT INTO ClientsRequests (RequestTypeID, RequestDate, ClientID, RequestStateID, RequestSum, AccountFrom, AccountTo, Remarks, OrgFrom, OrgTo, OrgFromINN, OrgToINN, OrgFromKPP, OrgToKPP, CurrencyFrom, CurrencyTo, BankName, CodeBIK, VAT, Purpose) VALUES (@RequestTypeID, @RequestDate, @ClientID, @RequestStateID, @RequestSum, @AccountFrom, @AccountTo, @Remarks, @OrgFrom, @OrgTo, @OrgFromINN, @OrgToINN, @OrgFromKPP, @OrgToKPP, @CurrencyFrom, @CurrencyTo, @BankName, @CodeBIK, @VAT, @Purpose); SELECT RequestID, RequestTypeID, RequestDate, ClientID, RequestStateID, RequestSum, AccountFrom, AccountTo, Remarks, OrgFrom, OrgTo, OrgFromINN, OrgToINN, CurrencyFrom, CurrencyTo, BankName, CodeBIK, VAT, Purpose FROM ClientsRequests WHERE (RequestID = @@IDENTITY)";
this.sqlCommand4.Connection = this.sqlConnection1;
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestTypeID", System.Data.SqlDbType.Int, 4, "RequestTypeID"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestDate", System.Data.SqlDbType.DateTime, 8, "RequestDate"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestStateID", System.Data.SqlDbType.Int, 4, "RequestStateID"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestSum", System.Data.SqlDbType.Float, 8, "RequestSum"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AccountFrom", System.Data.SqlDbType.NVarChar, 50, "AccountFrom"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AccountTo", System.Data.SqlDbType.NVarChar, 50, "AccountTo"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Remarks", System.Data.SqlDbType.NVarChar, 256, "Remarks"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFrom", System.Data.SqlDbType.NVarChar, 256, "OrgFrom"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgTo", System.Data.SqlDbType.NVarChar, 256, "OrgTo"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFromINN", System.Data.SqlDbType.NVarChar, 12, "OrgFromINN"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgToINN", System.Data.SqlDbType.NVarChar, 12, "OrgToINN"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFromKPP", System.Data.SqlDbType.NVarChar, 16, "OrgFromKPP"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgToKPP", System.Data.SqlDbType.NVarChar, 16, "OrgToKPP"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyFrom", System.Data.SqlDbType.NVarChar, 3, "CurrencyFrom"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyTo", System.Data.SqlDbType.NVarChar, 3, "CurrencyTo"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@BankName", System.Data.SqlDbType.NVarChar, 128, "BankName"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CodeBIK", System.Data.SqlDbType.NVarChar, 50, "CodeBIK"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@VAT", System.Data.SqlDbType.Float, 8, "VAT"));
this.sqlCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Purpose", System.Data.SqlDbType.NVarChar, 256, "Purpose"));
//
// sqlCommand2
//
this.sqlCommand2.CommandText = @"SELECT ClientsRequestStates.RequestStateName, ClientsRequestTypes.RequestTypeName, Clients.ClientName, ClientsRequests.RequestID, ClientsRequests.RequestTypeID, ClientsRequests.RequestDate, ClientsRequests.ClientID, ClientsRequests.RequestStateID, ClientsRequests.RequestSum, ClientsRequests.AccountFrom, ClientsRequests.AccountTo, ClientsRequests.Remarks, ClientsRequests.OrgFrom, ClientsRequests.OrgTo, ClientsRequests.OrgFromINN, ClientsRequests.OrgToINN, ClientsRequests.OrgFromKPP, ClientsRequests.OrgToKPP, ClientsRequests.CurrencyFrom, ClientsRequests.CurrencyTo, ClientsRequests.BankName, ClientsRequests.CodeBIK, ClientsRequests.VAT, ClientsRequests.Purpose, ClientsRequests.ExecutedSum, Clients.ClientGroupID, ClientsGroups.ClientGroupName FROM ClientsRequests INNER JOIN ClientsRequestStates ON ClientsRequests.RequestStateID = ClientsRequestStates.RequestStateID INNER JOIN ClientsRequestTypes ON ClientsRequests.RequestTypeID = ClientsRequestTypes.RequestTypeID INNER JOIN Clients ON ClientsRequests.ClientID = Clients.ClientID INNER JOIN ClientsGroups ON Clients.ClientGroupID = ClientsGroups.ClientGroupID WHERE (ClientsRequests.RequestDate >= @DateFrom) AND (ClientsRequests.RequestDate <= @DateTo)";
this.sqlCommand2.Connection = this.sqlConnection1;
this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateFrom", System.Data.SqlDbType.DateTime, 8, "RequestDate"));
this.sqlCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateTo", System.Data.SqlDbType.DateTime, 8, "RequestDate"));
//
// sqlCommand5
//
this.sqlCommand5.CommandText = @"UPDATE ClientsRequests SET RequestTypeID = @RequestTypeID, RequestDate = @RequestDate, ClientID = @ClientID, RequestStateID = @RequestStateID, RequestSum = @RequestSum, AccountFrom = @AccountFrom, AccountTo = @AccountTo, Remarks = @Remarks, OrgFrom = @OrgFrom, OrgTo = @OrgTo, OrgFromINN = @OrgFromINN, OrgToINN = @OrgToINN, CurrencyFrom = @CurrencyFrom, CurrencyTo = @CurrencyTo, BankName = @BankName, CodeBIK = @CodeBIK, VAT = @VAT, Purpose = @Purpose, OrgFromKPP = @OrgFromKPP, OrgToKPP = @OrgToKPP WHERE (RequestID = @Original_RequestID)";
this.sqlCommand5.Connection = this.sqlConnection1;
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestTypeID", System.Data.SqlDbType.Int, 4, "RequestTypeID"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestDate", System.Data.SqlDbType.DateTime, 8, "RequestDate"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientID", System.Data.SqlDbType.Int, 4, "ClientID"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestStateID", System.Data.SqlDbType.Int, 4, "RequestStateID"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RequestSum", System.Data.SqlDbType.Float, 8, "RequestSum"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AccountFrom", System.Data.SqlDbType.NVarChar, 50, "AccountFrom"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AccountTo", System.Data.SqlDbType.NVarChar, 50, "AccountTo"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Remarks", System.Data.SqlDbType.NVarChar, 256, "Remarks"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFrom", System.Data.SqlDbType.NVarChar, 256, "OrgFrom"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgTo", System.Data.SqlDbType.NVarChar, 256, "OrgTo"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFromINN", System.Data.SqlDbType.NVarChar, 12, "OrgFromINN"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgToINN", System.Data.SqlDbType.NVarChar, 12, "OrgToINN"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyFrom", System.Data.SqlDbType.NVarChar, 3, "CurrencyFrom"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyTo", System.Data.SqlDbType.NVarChar, 3, "CurrencyTo"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@BankName", System.Data.SqlDbType.NVarChar, 128, "BankName"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CodeBIK", System.Data.SqlDbType.NVarChar, 50, "CodeBIK"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@VAT", System.Data.SqlDbType.Float, 8, "VAT"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Purpose", System.Data.SqlDbType.NVarChar, 256, "Purpose"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgFromKPP", System.Data.SqlDbType.NVarChar, 16, "OrgFromKPP"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OrgToKPP", System.Data.SqlDbType.NVarChar, 16, "OrgToKPP"));
this.sqlCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_RequestID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "RequestID", System.Data.DataRowVersion.Original, null));
((System.ComponentModel.ISupportInitialize)(this.dsReqTypes1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsReqState1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsClientsRequests1)).EndInit();
}
/// <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.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.dsInterestRate1 = new BPS.BLL.Clients.DataSets.dsInterestRate();
this.dsReqTypes1 = new BPS.BLL.ClientsRequests.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();
}
