public CurrHistory()
{
bllCurrency = App.bllCurrency;
BPS.BLL.Currency.DataSets.dsCurrHistory dsH = bllCurrency.DataSetHistory;
BPS.BLL.Currency.DataSets.dsCurr dsC = bllCurrency.DataSet;
InitializeComponent();
this.dtCurr = new DataTable("CurrHistory");
DataColumn currID = new DataColumn("Currency");
this.dtCurr.Columns.Add(currID);
for (int i = 0; i < dsC.Currencies.Rows.Count; i++)
{
DataColumn dc = new DataColumn(dsC.Currencies.Rows[i]["CurrencyID"].ToString());
dc.DataType = System.Type.GetType("System.Double");
this.dtCurr.Columns.Add(dc);
}
dataGridTableStyle1 = new DataGridTableStyle();
this.dataGridTableStyle1.MappingName = "CurrHistory";
this.dataView1.Table = this.dtCurr; //dsH.CurrenciesHistory;
this.dataGridV1.DataSource = this.dataView1; //this.dtCurr;
this.setDgStyle();
this.dataGridV1.TableStyles.Add(this.dataGridTableStyle1);
this.dvHistory.Table = dsH.CurrenciesHistory;
this.checkBox1.Checked = true;
App.SetDataGridTableStyle(this.dataGridTableStyle1);
}
public CurrList()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
App.SetDataGridTableStyle(this.dataGridTableStyle1);
bllCurrency = App.bllCurrency;
this.dsCurr1 = bllCurrency.DataSet;
this.dataView1.Table = this.dsCurr1.Currencies;
}
/// <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();
}
/// <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(CurrList));
this.dataGrid1 = new AM_Controls.DataGridV();
this.contextMenu1 = new System.Windows.Forms.ContextMenu();
this.dataView1 = new System.Data.DataView();
this.dsCurr1 = new BPS.BLL.Currency.DataSets.dsCurr();
this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
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.tbbRate = new System.Windows.Forms.ToolBarButton();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
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.menuItem1 = new System.Windows.Forms.MenuItem();
this.mnuSetCurrencyRate = new System.Windows.Forms.MenuItem();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1._CanEdit = false;
this.dataGrid1._InvisibleColumn = 0;
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.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 72);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(340, 175);
this.dataGrid1.TabIndex = 1;
this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
this.dataGridTableStyle1
});
this.dataGrid1.DoubleClick += new System.EventHandler(this.dataGrid1_DoubleClick);
//
// dataView1
//
this.dataView1.Table = this.dsCurr1.Currencies;
//
// dsCurr1
//
this.dsCurr1.DataSetName = "dsCurr";
this.dsCurr1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// dataGridTableStyle1
//
this.dataGridTableStyle1.DataGrid = this.dataGrid1;
this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
this.dataGridTextBoxColumn1,
this.dataGridTextBoxColumn2,
this.dataGridTextBoxColumn3
});
this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGridTableStyle1.MappingName = "Currencies";
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.Format = "";
this.dataGridTextBoxColumn1.FormatInfo = null;
this.dataGridTextBoxColumn1.HeaderText = "Код";
this.dataGridTextBoxColumn1.MappingName = "CurrencyID";
this.dataGridTextBoxColumn1.NullText = "?";
this.dataGridTextBoxColumn1.Width = 50;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.Format = "";
this.dataGridTextBoxColumn2.FormatInfo = null;
this.dataGridTextBoxColumn2.HeaderText = "Название";
this.dataGridTextBoxColumn2.MappingName = "CurrencyName";
this.dataGridTextBoxColumn2.NullText = "";
this.dataGridTextBoxColumn2.Width = 150;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.Format = "#,##0.00";
this.dataGridTextBoxColumn3.FormatInfo = null;
this.dataGridTextBoxColumn3.HeaderText = "Курс";
this.dataGridTextBoxColumn3.MappingName = "CurrencyRate";
this.dataGridTextBoxColumn3.NullText = "-";
this.dataGridTextBoxColumn3.Width = 75;
//
// 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.tbbRate
});
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(340, 72);
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 = 3;
this.toolBarButton1.Text = "Новый";
//
// toolBarButton2
//
this.toolBarButton2.ImageIndex = 0;
this.toolBarButton2.Text = "Изменить";
//
// toolBarButton4
//
this.toolBarButton4.ImageIndex = 1;
this.toolBarButton4.Text = "Удалить";
//
// toolBarButton3
//
this.toolBarButton3.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
//
// toolBarButton5
//
this.toolBarButton5.ImageIndex = 2;
this.toolBarButton5.Text = "Обновить";
//
// tbbRate
//
this.tbbRate.ImageIndex = 4;
this.tbbRate.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;
//
// 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.menuItem1,
this.mnuSetCurrencyRate
});
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);
//
// menuItem1
//
this.menuItem1.Index = 5;
this.menuItem1.Text = "-";
//
// mnuSetCurrencyRate
//
this.mnuSetCurrencyRate.Index = 6;
this.mnuSetCurrencyRate.Text = "Изменить Курс";
this.mnuSetCurrencyRate.Click += new System.EventHandler(this.mnuSetCurrencyRate_Click);
//
// CurrList
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
this.ClientSize = new System.Drawing.Size(340, 247);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.toolBar1);
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 = "CurrList";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "Валюты";
this.Load += new System.EventHandler(this.CurrList_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).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.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.dsDataSet = new BPS.BLL.Currency.DataSets.dsCurr();
this.sqlDataAdapter1 = 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.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.daCurrHistory = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
this.dsCurrHistory1 = new BPS.BLL.Currency.DataSets.dsCurrHistory();
this.sqlCmdSetRate = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dsDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurrHistory1)).BeginInit();
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string))));
//
// dsDataSet
//
this.dsDataSet.DataSetName = "dsCurr";
this.dsDataSet.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Currencies", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CurrencyID", "CurrencyID"),
new System.Data.Common.DataColumnMapping("CurrencyName", "CurrencyName"),
new System.Data.Common.DataColumnMapping("CurrencyRate", "CurrencyRate"),
new System.Data.Common.DataColumnMapping("IsBase", "IsBase")
})
});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = "DELETE FROM Currencies WHERE (CurrencyID = @Original_CurrencyID) AND (CurrencyNam" +
"e = @Original_CurrencyName) AND (CurrencyRate = @Original_CurrencyRate) AND (IsB" +
"ase = @Original_IsBase)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyName", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyName", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyRate", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyRate", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsBase", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsBase", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO Currencies(CurrencyID, CurrencyName, CurrencyRate, IsBase) VALUES (@C" +
"urrencyID, @CurrencyName, @CurrencyRate, @IsBase); SELECT CurrencyID, CurrencyNa" +
"me, CurrencyRate, IsBase FROM Currencies WHERE (CurrencyID = @CurrencyID)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyID", System.Data.SqlDbType.NVarChar, 3, "CurrencyID"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyName", System.Data.SqlDbType.NVarChar, 50, "CurrencyName"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyRate", System.Data.SqlDbType.Float, 8, "CurrencyRate"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsBase", System.Data.SqlDbType.Bit, 1, "IsBase"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT CurrencyID, CurrencyName, CurrencyRate, IsBase FROM Currencies";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE Currencies SET CurrencyID = @CurrencyID, CurrencyName = @CurrencyName, CurrencyRate = @CurrencyRate, IsBase = @IsBase WHERE (CurrencyID = @Original_CurrencyID) AND (CurrencyName = @Original_CurrencyName) AND (CurrencyRate = @Original_CurrencyRate) AND (IsBase = @Original_IsBase); SELECT CurrencyID, CurrencyName, CurrencyRate, IsBase FROM Currencies WHERE (CurrencyID = @CurrencyID)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyID", System.Data.SqlDbType.NVarChar, 3, "CurrencyID"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyName", System.Data.SqlDbType.NVarChar, 50, "CurrencyName"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyRate", System.Data.SqlDbType.Float, 8, "CurrencyRate"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsBase", System.Data.SqlDbType.Bit, 1, "IsBase"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyName", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyName", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyRate", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyRate", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_IsBase", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsBase", System.Data.DataRowVersion.Original, null));
//
// daCurrHistory
//
this.daCurrHistory.DeleteCommand = this.sqlDeleteCommand3;
this.daCurrHistory.InsertCommand = this.sqlInsertCommand3;
this.daCurrHistory.SelectCommand = this.sqlSelectCommand2;
this.daCurrHistory.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "CurrenciesHistory", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CurrDate", "CurrDate"),
new System.Data.Common.DataColumnMapping("CurrencyID", "CurrencyID"),
new System.Data.Common.DataColumnMapping("CurrRate", "CurrRate"),
new System.Data.Common.DataColumnMapping("BaseCurrencyID", "BaseCurrencyID")
})
});
this.daCurrHistory.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand3
//
this.sqlDeleteCommand3.CommandText = "DELETE FROM CurrenciesHistory WHERE (ID = @Original_ID) AND (BaseCurrencyID = @Or" +
"iginal_BaseCurrencyID) AND (CurrDate = @Original_CurrDate) AND (CurrRate = @Orig" +
"inal_CurrRate) AND (CurrencyID = @Original_CurrencyID)";
this.sqlDeleteCommand3.Connection = this.sqlConnection1;
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_BaseCurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BaseCurrencyID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrDate", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrRate", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrRate", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyID", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "INSERT INTO CurrenciesHistory(CurrDate, CurrencyID, CurrRate, BaseCurrencyID) VAL" +
"UES (@CurrDate, @CurrencyID, @CurrRate, @BaseCurrencyID); SELECT ID, CurrDate, C" +
"urrencyID, CurrRate, BaseCurrencyID FROM CurrenciesHistory WHERE (ID = @@IDENTIT" +
"Y)";
this.sqlInsertCommand3.Connection = this.sqlConnection1;
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrDate", System.Data.SqlDbType.DateTime, 8, "CurrDate"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyID", System.Data.SqlDbType.NVarChar, 3, "CurrencyID"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrRate", System.Data.SqlDbType.Float, 8, "CurrRate"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@BaseCurrencyID", System.Data.SqlDbType.NVarChar, 3, "BaseCurrencyID"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = @"SELECT CurrenciesHistory.ID, CurrenciesHistory.CurrDate, CurrenciesHistory.CurrencyID, CurrenciesHistory.CurrRate, CurrenciesHistory.BaseCurrencyID, Currencies.CurrencyName FROM CurrenciesHistory INNER JOIN Currencies ON CurrenciesHistory.CurrencyID = Currencies.CurrencyID";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = @"UPDATE CurrenciesHistory SET CurrDate = @CurrDate, CurrencyID = @CurrencyID, CurrRate = @CurrRate, BaseCurrencyID = @BaseCurrencyID WHERE (ID = @Original_ID) AND (BaseCurrencyID = @Original_BaseCurrencyID) AND (CurrDate = @Original_CurrDate) AND (CurrRate = @Original_CurrRate) AND (CurrencyID = @Original_CurrencyID); SELECT ID, CurrDate, CurrencyID, CurrRate, BaseCurrencyID FROM CurrenciesHistory WHERE (ID = @ID)";
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrDate", System.Data.SqlDbType.DateTime, 8, "CurrDate"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrencyID", System.Data.SqlDbType.NVarChar, 3, "CurrencyID"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CurrRate", System.Data.SqlDbType.Float, 8, "CurrRate"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@BaseCurrencyID", System.Data.SqlDbType.NVarChar, 3, "BaseCurrencyID"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_BaseCurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "BaseCurrencyID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrDate", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrRate", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrRate", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CurrencyID", System.Data.SqlDbType.NVarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CurrencyID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
//
// dsCurrHistory1
//
this.dsCurrHistory1.DataSetName = "dsCurrHistory";
this.dsCurrHistory1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// sqlCmdSetRate
//
this.sqlCmdSetRate.CommandText = "[CurrencyChangeRate]";
this.sqlCmdSetRate.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlCmdSetRate.Connection = this.sqlConnection1;
this.sqlCmdSetRate.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));
this.sqlCmdSetRate.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sCurrencyID", System.Data.SqlDbType.NVarChar, 3));
this.sqlCmdSetRate.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fRate", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(15)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
((System.ComponentModel.ISupportInitialize)(this.dsDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurrHistory1)).EndInit();
}
/// <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(EditCurr));
this.tbCurrID = new System.Windows.Forms.TextBox();
this.dataView1 = new System.Data.DataView();
this.dsCurr1 = new BPS.BLL.Currency.DataSets.dsCurr();
this.tbCurrName = new System.Windows.Forms.TextBox();
this.btnOK = new System.Windows.Forms.Button();
this.btnCancel = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.tbvRate = new AM_Controls.TextBoxV();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).BeginInit();
this.SuspendLayout();
//
// tbCurrID
//
this.tbCurrID.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.tbCurrID.Location = new System.Drawing.Point(70, 0);
this.tbCurrID.MaxLength = 3;
this.tbCurrID.Name = "tbCurrID";
this.tbCurrID.Size = new System.Drawing.Size(50, 21);
this.tbCurrID.TabIndex = 1;
this.tbCurrID.Text = "";
//
// dataView1
//
this.dataView1.Table = this.dsCurr1.Currencies;
//
// dsCurr1
//
this.dsCurr1.DataSetName = "dsCurr";
this.dsCurr1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// tbCurrName
//
this.tbCurrName.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.tbCurrName.Location = new System.Drawing.Point(70, 22);
this.tbCurrName.MaxLength = 50;
this.tbCurrName.Name = "tbCurrName";
this.tbCurrName.Size = new System.Drawing.Size(192, 21);
this.tbCurrName.TabIndex = 3;
this.tbCurrName.Text = "";
//
// btnOK
//
this.btnOK.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.btnOK.Location = new System.Drawing.Point(100, 90);
this.btnOK.Name = "btnOK";
this.btnOK.Size = new System.Drawing.Size(80, 22);
this.btnOK.TabIndex = 6;
this.btnOK.Text = "Сохранить";
this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
//
// btnCancel
//
this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.btnCancel.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.btnCancel.Location = new System.Drawing.Point(182, 90);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(80, 22);
this.btnCancel.TabIndex = 7;
this.btnCancel.Text = "Отменить";
//
// label1
//
this.label1.Location = new System.Drawing.Point(4, 3);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(64, 16);
this.label1.TabIndex = 0;
this.label1.Text = "Код:";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label2
//
this.label2.Location = new System.Drawing.Point(4, 25);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(64, 16);
this.label2.TabIndex = 2;
this.label2.Text = "Название:";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label3
//
this.label3.Location = new System.Drawing.Point(4, 48);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(64, 16);
this.label3.TabIndex = 4;
this.label3.Text = "Курс:";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// tbvRate
//
this.tbvRate.AllowDrop = true;
this.tbvRate.dValue = 0;
this.tbvRate.IsPcnt = false;
this.tbvRate.Location = new System.Drawing.Point(70, 44);
this.tbvRate.MaxDecPos = 2;
this.tbvRate.MaxPos = 8;
this.tbvRate.Name = "tbvRate";
this.tbvRate.nValue = ((long)(0));
this.tbvRate.TabIndex = 5;
this.tbvRate.Text = "0";
this.tbvRate.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
this.tbvRate.TextMode = false;
//
// EditCurr
//
this.AcceptButton = this.btnOK;
this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
this.CancelButton = this.btnCancel;
this.ClientSize = new System.Drawing.Size(268, 117);
this.Controls.Add(this.tbvRate);
this.Controls.Add(this.tbCurrID);
this.Controls.Add(this.tbCurrName);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.btnOK);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.label3);
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 = "EditCurr";
this.ShowInTaskbar = false;
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "Валюта";
((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsCurr1)).EndInit();
this.ResumeLayout(false);
}
