public Cities()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
BPSCity = new BPS.BLL.City.coCities();
FillCities();
this.dvCities.Table = this.BPSCity.DataSet.Cities;
App.SetDataGridTableStyle(this.dataGridTableStyle1);
}
public CityEdit(BPS.BLL.City.coCities Cities, string CityName)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
if (CityName != null)
{
this.tbCityName.Text = CityName;
AddNewCity = false;
}
this.BPSCity = Cities;
}
public EditBank(BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw, BPS.BLL.City.coCities bll)
{
drowBank = rw;
//
// Required for Windows Form Designer support
//
InitializeComponent();
bllCity = bll;
this.dsCities1 = bllCity.DataSet;
this.dvCities.Table = this.dsCities1.Cities;
this.dvCities.Sort = "CityName";
}
public static bool AddBankDialog(BPS.BLL.Bank.coBanks bll, BPS.BLL.City.coCities bllC)
{
BPS.BLL.Bank.DataSets.dsBanks.BanksRow rw = bll.DataSet.Banks.NewBanksRow();
EditBank eb = new EditBank(rw, bllC);
eb.ShowDialog();
if (eb.DialogResult == DialogResult.OK)
{
bll.DataSet.Banks.AddBanksRow(rw);
bll.Update();
return(true);
}
return(false);
}
public CheckOrgTo(BLL.ClientsRequests.DataSets.dsClientsRequests.ClientsRequestsRow rw, int iCheckType, int iOrgIDOrgAccountID)
{
//
// Required for Windows Form Designer support
//
this.rwReq = rw;
this.iCheckType = iCheckType;
//App.FillOrgsAccount();
this.iOrgID = iOrgIDOrgAccountID;
this.iOrgAccountID = iOrgIDOrgAccountID;
InitializeComponent();
if (iCheckType == 2)
{
App.FillOrgsAccount();
this.dvRAccounts.Table = App.DsOrgsAccount.OrgsAccounts;
this.dvRAccounts.RowFilter = "OrgID=" + iOrgID + " and CurrencyID='" + rw.CurrencyFrom + "'";
this.dataGrid1.DataSource = this.dvRAccounts;
App.SetDataGridTableStyle(this.dataGridTableStyle2);
this.dataGridTableStyle2.SelectionForeColor = System.Drawing.Color.Red;
if (this.dvRAccounts.Count == 0)
{
this.bnSelect.Enabled = false;
}
this.tbMessage.Text = "Не найден р.счёт организации получателя <" + rw.OrgTo + "> с ИНН " + rw.OrgToINN + ".\r\n Возможно есть неточность в реквизитах.\r\n" +
"Если в списке счетов имеется подходящий, выделите его и нажмите кнопку <Выбрать>.\r\n Для создания нового счёта нажмите <Новый>.";
}
else
{
bllBank = new BPS.BLL.Bank.coBanks();
bllCity = new BPS.BLL.City.coCities();
bllBank.Fill();
bllCity.Fill();
// this.dvBanks.Table = App.DsBanks.Banks;
this.dvBanks.Table = bllBank.DataSet.Banks;
this.dataGrid1.DataSource = this.dvBanks;
App.SetDataGridTableStyle(this.dataGridTableStyle3);
this.dataGridTableStyle3.SelectionForeColor = System.Drawing.Color.Red;
this.tbMessage.Text = "Не найден банк организации получателя <" + rw.OrgTo + "> с ИНН " + rw.OrgToINN + ".\r\n Возможно есть неточность в реквизитах.\r\n" +
"Если в списке банков имеется подходящий, выделите его и нажмите кнопку <Выбрать>. \r\nДля создания нового банка нажмите <Новый>.";
}
//
// TODO: Add any constructor code after InitializeComponent call
//
}
static App()
{
AM_Controls.Settings AMSet = new AM_Controls.Settings(new System.Configuration.AppSettingsReader());
ReportsDirectory = LoadDirectoryString("ReportsDirectory", "..\\..\\_Reports\\");
AM_Controls.MsgBoxX.Header = "BPS";
Connection = new System.Data.SqlClient.SqlConnection();
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
Connection.ConnectionString =
ConnectionString = ((string)(configurationAppSettings.GetValue("ConnectionString", typeof(string))));
OleDbConnectionString = ((string)(configurationAppSettings.GetValue("OleDbConnectionString", typeof(string))));
POFormatSettingsFileName = ((string)(configurationAppSettings.GetValue("POFormatSettingsFile", typeof(string))));
sqlData = new AM_Lib.sqlData(ConnectionString);
AppSettingsGet();
bllBank = new BPS.BLL.Bank.coBanks(Connection);
bllBank.Fill();
bllCity = new BPS.BLL.City.coCities(Connection);
bllCity.Fill();
bllCurrency = new BPS.BLL.Currency.coCurrency(Connection);
bllCurrency.Fill();
bllCurrency.FillHistory();
bllOrgs = new BPS.BLL.Orgs.coOrgs(Connection);
bllOrgs.Fill();
bllRequests = new BPS.BLL.ClientsRequests.coRequest(Connection);
bllRequests.FillDirectories();
BPSClients =
bllClients = new BPS.BLL.Clients.coClientEx(Connection);
bllClients.DataGridStyle += new BPS.BLL.Clients.coClientEx.DataGridStyleEventHandler(OnSetStyle);
bllClients.AddClient += new BPS.BLL.Clients.coClientEx.AddClientEventHandler(OnAddingClient);
DBLock = new AM_Lib.Lock(Connection);
dsOrgsAccount1 = new BPS.dsOrgsAccount();
}
public BanksList()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
App.SetDataGridTableStyle(this.dataGridTableStyle1);
// this.bllBank = new BPS.BLL.Bank.coBanks();
// this.bllCity = new BPS.BLL.City.coCities();
// this.bllBank.Fill();
// this.bllCity.Fill();
this.bllBank = App.bllBank;
this.bllCity = App.bllCity;
this.dvCities.Table = this.bllCity.DataSet.Cities;
this.dsBanks1 = this.bllBank.DataSet;
this.dvBanks.Table = this.dsBanks1.Banks;
// this.dataGrid1.DataSource = this.dvBanks;
}