public AccountStatementNewHeader()
{
//
// Required for Windows Form Designer support
//
App.FillOrgsAccount();
InitializeComponent();
/*
* this.dvOrgs.Table = App.DsOrgs.Orgs;
* this.cmbOrgs.DataSource = this.dvOrgs;
* this.cmbOrgs.DisplayMember = "OrgName";
* this.cmbOrgs.ValueMember = "OrgID";
* this.dvOrgs.RowFilter = "IsInner=true";
* this.dvOrgsAccounts.Table = App.DsOrgsAccount._Table;
* this.cmbOrgsAccounts.DataSource = this.dvOrgsAccounts;
* this.cmbOrgsAccounts.DisplayMember = "RAccount";
* this.cmbOrgsAccounts.ValueMember = "AccountID";
*/
bll.Fill(App.UserLogonID);
this.dsUsersOrgsAndAccounts1 = bll.DataSet;
this.dvOrgs.Table = this.dsUsersOrgsAndAccounts1.Orgs;
this.dvOrgs.Sort = "OrgName";
this.dvOrgsAccounts.Table = this.dsUsersOrgsAndAccounts1.OrgsAccounts;
this.dvOrgsAccounts.Sort = "RAccount";
}
/// <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.dadUsersOrgsAccounts = new System.Data.SqlClient.SqlDataAdapter();
this.sqlOrgsAccounts_SelectAvailableForUser = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.dsUsersOrgsAndAccounts1 = new BPS.BLL.Orgs.DataSets.dsUsersOrgsAndAccounts();
this.dadUsersOrgs = new System.Data.SqlClient.SqlDataAdapter();
this.sqlOrgs_SelectAvailableForUser = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).BeginInit();
//
// dadUsersOrgsAccounts
//
this.dadUsersOrgsAccounts.SelectCommand = this.sqlOrgsAccounts_SelectAvailableForUser;
this.dadUsersOrgsAccounts.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "OrgsAccounts", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("RAccount", "RAccount"),
new System.Data.Common.DataColumnMapping("OrgID", "OrgID"),
new System.Data.Common.DataColumnMapping("AccountID", "AccountID"),
new System.Data.Common.DataColumnMapping("OrgsAccountsID", "OrgsAccountsID")
})
});
//
// sqlOrgsAccounts_SelectAvailableForUser
//
this.sqlOrgsAccounts_SelectAvailableForUser.CommandText = "[OrgsAccounts_SelectAvailableForUser]";
this.sqlOrgsAccounts_SelectAvailableForUser.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlOrgsAccounts_SelectAvailableForUser.Connection = this.sqlConnection1;
this.sqlOrgsAccounts_SelectAvailableForUser.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));
this.sqlOrgsAccounts_SelectAvailableForUser.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserID", System.Data.SqlDbType.Int, 4));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string))));
//
// dsUsersOrgsAndAccounts1
//
this.dsUsersOrgsAndAccounts1.DataSetName = "dsUsersOrgsAndAccounts";
this.dsUsersOrgsAndAccounts1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// dadUsersOrgs
//
this.dadUsersOrgs.SelectCommand = this.sqlOrgs_SelectAvailableForUser;
this.dadUsersOrgs.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Orgs", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("OrgID", "OrgID"),
new System.Data.Common.DataColumnMapping("OrgName", "OrgName"),
new System.Data.Common.DataColumnMapping("OrgName2", "OrgName2")
})
});
//
// sqlOrgs_SelectAvailableForUser
//
this.sqlOrgs_SelectAvailableForUser.CommandText = "[Orgs_SelectAvailableForUser]";
this.sqlOrgs_SelectAvailableForUser.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlOrgs_SelectAvailableForUser.Connection = this.sqlConnection1;
this.sqlOrgs_SelectAvailableForUser.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));
this.sqlOrgs_SelectAvailableForUser.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserID", System.Data.SqlDbType.Int, 4));
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.cmbRAccount = new System.Windows.Forms.ComboBox();
this.dvRAccount = new System.Data.DataView();
this.dsUsersOrgsAndAccounts1 = new BPS.BLL.Orgs.DataSets.dsUsersOrgsAndAccounts();
this.lblAccountHeader = new System.Windows.Forms.Label();
this.cmbOrg = new System.Windows.Forms.ComboBox();
this.dvOrgs = new System.Data.DataView();
this.lblOrgHeader = new System.Windows.Forms.Label();
this.pnlOrg = new System.Windows.Forms.Panel();
this.pnlAccount = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.dvRAccount)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvOrgs)).BeginInit();
this.pnlOrg.SuspendLayout();
this.pnlAccount.SuspendLayout();
this.SuspendLayout();
//
// cmbRAccount
//
this.cmbRAccount.DataSource = this.dvRAccount;
this.cmbRAccount.DisplayMember = "RAccount";
this.cmbRAccount.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmbRAccount.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.cmbRAccount.Location = new System.Drawing.Point(27, 2);
this.cmbRAccount.Name = "cmbRAccount";
this.cmbRAccount.Size = new System.Drawing.Size(150, 21);
this.cmbRAccount.TabIndex = 7;
this.cmbRAccount.ValueMember = "OrgsAccountsID";
this.cmbRAccount.SelectedIndexChanged += new System.EventHandler(this.cmbRAccount_SelectedIndexChanged);
//
// dvRAccount
//
this.dvRAccount.Table = this.dsUsersOrgsAndAccounts1.OrgsAccounts;
//
// dsUsersOrgsAndAccounts1
//
this.dsUsersOrgsAndAccounts1.DataSetName = "dsUsersOrgsAndAccounts";
this.dsUsersOrgsAndAccounts1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// lblAccountHeader
//
this.lblAccountHeader.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.lblAccountHeader.Location = new System.Drawing.Point(0, 5);
this.lblAccountHeader.Name = "lblAccountHeader";
this.lblAccountHeader.Size = new System.Drawing.Size(26, 14);
this.lblAccountHeader.TabIndex = 8;
this.lblAccountHeader.Text = "Р/C:";
this.lblAccountHeader.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// cmbOrg
//
this.cmbOrg.DataSource = this.dvOrgs;
this.cmbOrg.DisplayMember = "OrgName";
this.cmbOrg.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmbOrg.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.cmbOrg.Location = new System.Drawing.Point(77, 2);
this.cmbOrg.MaxDropDownItems = 20;
this.cmbOrg.Name = "cmbOrg";
this.cmbOrg.Size = new System.Drawing.Size(150, 21);
this.cmbOrg.TabIndex = 5;
this.cmbOrg.ValueMember = "OrgID";
this.cmbOrg.SelectedIndexChanged += new System.EventHandler(this.cmbOrg_SelectedIndexChanged);
//
// dvOrgs
//
this.dvOrgs.Table = this.dsUsersOrgsAndAccounts1.Orgs;
//
// lblOrgHeader
//
this.lblOrgHeader.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(204)));
this.lblOrgHeader.Location = new System.Drawing.Point(0, 5);
this.lblOrgHeader.Name = "lblOrgHeader";
this.lblOrgHeader.Size = new System.Drawing.Size(76, 14);
this.lblOrgHeader.TabIndex = 6;
this.lblOrgHeader.Text = "Организация:";
this.lblOrgHeader.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// pnlOrg
//
this.pnlOrg.Controls.Add(this.cmbOrg);
this.pnlOrg.Controls.Add(this.lblOrgHeader);
this.pnlOrg.Location = new System.Drawing.Point(0, 0);
this.pnlOrg.Name = "pnlOrg";
this.pnlOrg.Size = new System.Drawing.Size(227, 24);
this.pnlOrg.TabIndex = 9;
//
// pnlAccount
//
this.pnlAccount.Controls.Add(this.lblAccountHeader);
this.pnlAccount.Controls.Add(this.cmbRAccount);
this.pnlAccount.Location = new System.Drawing.Point(235, 0);
this.pnlAccount.Name = "pnlAccount";
this.pnlAccount.Size = new System.Drawing.Size(179, 24);
this.pnlAccount.TabIndex = 10;
//
// OrgsAndAccounts
//
this.Controls.Add(this.pnlAccount);
this.Controls.Add(this.pnlOrg);
this.Name = "OrgsAndAccounts";
this.Size = new System.Drawing.Size(418, 26);
this.SizeChanged += new System.EventHandler(this.OrgsAndAccounts_SizeChanged);
((System.ComponentModel.ISupportInitialize)(this.dvRAccount)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvOrgs)).EndInit();
this.pnlOrg.ResumeLayout(false);
this.pnlAccount.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(AccountStatementNewHeader));
this.cmbOrgsAccounts = new System.Windows.Forms.ComboBox();
this.dvOrgsAccounts = new System.Data.DataView();
this.dsUsersOrgsAndAccounts1 = new BPS.BLL.Orgs.DataSets.dsUsersOrgsAndAccounts();
this.label3 = new System.Windows.Forms.Label();
this.cmbOrgs = new System.Windows.Forms.ComboBox();
this.dvOrgs = new System.Data.DataView();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.dtpExtractDate = new System.Windows.Forms.DateTimePicker();
this.bnOk = new System.Windows.Forms.Button();
this.bnCancel = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dvOrgsAccounts)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dvOrgs)).BeginInit();
this.SuspendLayout();
//
// cmbOrgsAccounts
//
this.cmbOrgsAccounts.DataSource = this.dvOrgsAccounts;
this.cmbOrgsAccounts.DisplayMember = "RAccount";
this.cmbOrgsAccounts.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmbOrgsAccounts.Location = new System.Drawing.Point(86, 24);
this.cmbOrgsAccounts.Name = "cmbOrgsAccounts";
this.cmbOrgsAccounts.Size = new System.Drawing.Size(164, 21);
this.cmbOrgsAccounts.TabIndex = 2;
this.cmbOrgsAccounts.ValueMember = "OrgsAccountID";
//
// dvOrgsAccounts
//
this.dvOrgsAccounts.Table = this.dsUsersOrgsAndAccounts1.OrgsAccounts;
//
// dsUsersOrgsAndAccounts1
//
this.dsUsersOrgsAndAccounts1.DataSetName = "dsUsersOrgsAndAccounts";
this.dsUsersOrgsAndAccounts1.Locale = new System.Globalization.CultureInfo("ru-RU");
//
// label3
//
this.label3.Location = new System.Drawing.Point(8, 22);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(44, 23);
this.label3.TabIndex = 4;
this.label3.Text = "Р/счёт:";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// cmbOrgs
//
this.cmbOrgs.DataSource = this.dvOrgs;
this.cmbOrgs.DisplayMember = "OrgName";
this.cmbOrgs.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cmbOrgs.Location = new System.Drawing.Point(86, 2);
this.cmbOrgs.MaxDropDownItems = 20;
this.cmbOrgs.Name = "cmbOrgs";
this.cmbOrgs.Size = new System.Drawing.Size(164, 21);
this.cmbOrgs.TabIndex = 1;
this.cmbOrgs.ValueMember = "OrgID";
this.cmbOrgs.SelectedIndexChanged += new System.EventHandler(this.cmbOrgs_SelectedIndexChanged);
//
// dvOrgs
//
this.dvOrgs.Table = this.dsUsersOrgsAndAccounts1.Orgs;
//
// label2
//
this.label2.Location = new System.Drawing.Point(8, 2);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(78, 23);
this.label2.TabIndex = 2;
this.label2.Text = "Организация:";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label1
//
this.label1.Location = new System.Drawing.Point(258, 2);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(38, 23);
this.label1.TabIndex = 1;
this.label1.Text = "Дата:";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// dtpExtractDate
//
this.dtpExtractDate.Font = new System.Drawing.Font("Tahoma", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.dtpExtractDate.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpExtractDate.Location = new System.Drawing.Point(298, 2);
this.dtpExtractDate.Name = "dtpExtractDate";
this.dtpExtractDate.Size = new System.Drawing.Size(84, 21);
this.dtpExtractDate.TabIndex = 3;
//
// bnOk
//
this.bnOk.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.bnOk.Location = new System.Drawing.Point(210, 56);
this.bnOk.Name = "bnOk";
this.bnOk.Size = new System.Drawing.Size(84, 26);
this.bnOk.TabIndex = 4;
this.bnOk.Text = "Создать";
this.bnOk.Click += new System.EventHandler(this.bnOk_Click);
//
// bnCancel
//
this.bnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.bnCancel.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.bnCancel.Location = new System.Drawing.Point(296, 56);
this.bnCancel.Name = "bnCancel";
this.bnCancel.Size = new System.Drawing.Size(84, 26);
this.bnCancel.TabIndex = 5;
this.bnCancel.Text = "Отменить";
this.bnCancel.Click += new System.EventHandler(this.bnCancel_Click);
//
// AccountStatementNewHeader
//
this.AcceptButton = this.bnOk;
this.AutoScaleBaseSize = new System.Drawing.Size(5, 14);
this.CancelButton = this.bnCancel;
this.ClientSize = new System.Drawing.Size(388, 89);
this.Controls.Add(this.bnCancel);
this.Controls.Add(this.bnOk);
this.Controls.Add(this.label3);
this.Controls.Add(this.dtpExtractDate);
this.Controls.Add(this.label2);
this.Controls.Add(this.cmbOrgs);
this.Controls.Add(this.label1);
this.Controls.Add(this.cmbOrgsAccounts);
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 = "AccountStatementNewHeader";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
this.Text = "Создание новой банковской выписки";
this.Load += new System.EventHandler(this.AccountStatementNewHeader_Load);
((System.ComponentModel.ISupportInitialize)(this.dvOrgsAccounts)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsUsersOrgsAndAccounts1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dvOrgs)).EndInit();
this.ResumeLayout(false);
}
