- Data:
- 2009-07-28 15:37:51 (17 years ago)
- Lokalizacja:
- branches/Emisje/BazaReklam
- Pliki:
-
- 24 zmodyfikowane
-
AddClient.cs (zmodyfikowane) (2 diffs)
-
AddKontoForm.cs (zmodyfikowane) (1 diff)
-
AddZamowienieForm.cs (zmodyfikowane) (1 diff)
-
AdminForm.cs (zmodyfikowane) (1 diff)
-
AgencjaAddForm.cs (zmodyfikowane) (1 diff)
-
AgentAddForm.cs (zmodyfikowane) (1 diff)
-
ClientsForm.cs (zmodyfikowane) (1 diff)
-
DaneKlientaViewer.cs (zmodyfikowane) (2 diffs)
-
FactureViewer.cs (zmodyfikowane) (2 diffs)
-
Facturer.cs (zmodyfikowane) (1 diff)
-
FacturesForm.cs (zmodyfikowane) (1 diff)
-
FakturowaniePoznanKatowice.cs (zmodyfikowane) (1 diff)
-
FullInfoProjectForm.cs (zmodyfikowane) (1 diff)
-
InfoForm.cs (zmodyfikowane) (1 diff)
-
LetterViewer.cs (zmodyfikowane) (2 diffs)
-
ListaReklamNaWydanieForm.cs (zmodyfikowane) (1 diff)
-
LogaKlientowForm.cs (zmodyfikowane) (1 diff)
-
OrderDetails.cs (zmodyfikowane) (1 diff)
-
OrderViewer.cs (zmodyfikowane) (2 diffs)
-
PaymentForm.cs (zmodyfikowane) (4 diffs)
-
PaymentForm2.cs (zmodyfikowane) (3 diffs)
-
ProductionForm.cs (zmodyfikowane) (1 diff)
-
ZamowieniaForm.cs (zmodyfikowane) (1 diff)
-
ZestawienieZamowienForm.cs (zmodyfikowane) (1 diff)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
branches/Emisje/BazaReklam/AddClient.cs
r732 r789 50 50 { 51 51 LoadTitleList(); 52 clientsAdapter.Connection.ConnectionString = ConnString.getConnString().Value;53 clientTitlesAdapter.Connection.ConnectionString = ConnString.getConnString().Value;52 //clientsAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 53 //clientTitlesAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 54 54 55 55 ComboBoxHelper.Bind(CountryRepository.FindAll(), cbCountry); … … 173 173 { 174 174 SLOWNIKDataSetTableAdapters.LISTA_TYTULOWTableAdapter titleListAdapter = new SLOWNIKDataSetTableAdapters.LISTA_TYTULOWTableAdapter(); 175 titleListAdapter.Connection.ConnectionString = ConnString.getConnString().Value;175 //titleListAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 176 176 lbTitles.DataSource = titleListAdapter.GetData(); 177 177 lbTitles.DisplayMember = "SYMB"; -
branches/Emisje/BazaReklam/AddKontoForm.cs
r65 r789 15 15 InitializeComponent(); 16 16 17 this.kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;17 //this.kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 18 18 19 19 -
branches/Emisje/BazaReklam/AddZamowienieForm.cs
r676 r789 23 23 InitializeComponent(); 24 24 25 zamowieniaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;26 kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;27 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;28 klienciTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;25 //zamowieniaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 26 //kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 27 //aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 28 //klienciTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 29 29 30 30 procentProwizjiTextBox.DataBindings[0].Format += DecimalToProcent; -
branches/Emisje/BazaReklam/AdminForm.cs
r591 r789 35 35 errProvider = new ErrorProvider(); 36 36 37 uZYTKOWNICYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;37 //uZYTKOWNICYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 38 38 } 39 39 -
branches/Emisje/BazaReklam/AgencjaAddForm.cs
r65 r789 15 15 InitializeComponent(); 16 16 17 this.aGENCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;17 //this.aGENCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 18 18 19 19 if (idAgencji == 0) -
branches/Emisje/BazaReklam/AgentAddForm.cs
r591 r789 18 18 InitializeComponent(); 19 19 20 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;21 pLANY_PROWIZJITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;20 //aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 21 //pLANY_PROWIZJITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 22 22 pLANY_PROWIZJITableAdapter.Fill(sLOWNIKDataSet.PLANY_PROWIZJI); 23 23 cbInvoiceProvider.DataSource = InvoiceProviderFactory.GetInvoiceProviders(); -
branches/Emisje/BazaReklam/ClientsForm.cs
r732 r789 44 44 MdiParent = parent; 45 45 46 // podmiana connstringa47 kL_1TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;48 kL_2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;49 kL_3TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;50 kL_KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;51 kLIENCI_OSOBY_DO_KONTAKTUTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;52 kLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;53 kONTAKTYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;54 zestawienieFakturTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;55 rEKLAMATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;56 fakturA_DETAILSTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;57 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;58 shedulerTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;59 oFERTY_MAINTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;60 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;61 kLIENCI_TYTULTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;62 vIEW_KOREKTYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;63 kontaktTypTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;46 ////podmiana connstringa 47 //kL_1TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 48 //kL_2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 49 //kL_3TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 50 //kL_KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 51 //kLIENCI_OSOBY_DO_KONTAKTUTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 52 //kLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 53 //kONTAKTYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 54 //zestawienieFakturTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 55 //rEKLAMATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 56 //fakturA_DETAILSTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 57 //fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 58 //shedulerTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 59 //oFERTY_MAINTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 60 //aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 61 //kLIENCI_TYTULTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 62 //vIEW_KOREKTYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 63 //kontaktTypTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 64 64 65 65 SqlConnection conn = new SqlConnection(ConnString.getConnString().Value); -
branches/Emisje/BazaReklam/DaneKlientaViewer.cs
r65 r789 17 17 InitializeComponent(); 18 18 19 KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;20 kliencI_OSOBY_DO_KONTAKTUTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value;19 //KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 20 //kliencI_OSOBY_DO_KONTAKTUTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value; 21 21 22 22 KLIENCITableAdapter.FillByCustomerId(REKLAMADataSet.KLIENCI, custId); … … 30 30 InitializeComponent(); 31 31 32 KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;33 kliencI_OSOBY_DO_KONTAKTUTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value;32 //KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 33 //kliencI_OSOBY_DO_KONTAKTUTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value; 34 34 35 35 KLIENCITableAdapter.ClearBeforeFill = false; -
branches/Emisje/BazaReklam/FactureViewer.cs
r707 r789 120 120 proforma = r; 121 121 122 fakturaTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value;123 fAKTURA_DETAILS2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;124 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;125 proformaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;126 127 122 ds = new DataSet(); 128 123 … … 244 239 245 240 btnRefresh.Click += zapiszKorektaButton_Click; 246 247 fakturaTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value;248 fAKTURA_DETAILS2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;249 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;250 proformaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;251 241 252 242 ds = new DataSet(); -
branches/Emisje/BazaReklam/Facturer.cs
r676 r789 20 20 reklamaId = rekId; 21 21 22 kLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;23 kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;24 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;25 rEKLAMATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;26 emisjeTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;27 fakturA_DETAILSTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;28 datyWydanTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;22 //kLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 23 //kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 24 //fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 25 //rEKLAMATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 26 //emisjeTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 27 //fakturA_DETAILSTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 28 //datyWydanTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 29 29 } 30 30 -
branches/Emisje/BazaReklam/FacturesForm.cs
r732 r789 32 32 33 33 MdiParent = parent; 34 35 //podmiana connstringa 36 zestawienieFakturTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 37 reklamaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 38 34 39 35 //obiekty wykorzytywane przy wyszukiwaniu 40 36 SqlConnection conn = new SqlConnection(ConnString.getConnString().Value); -
branches/Emisje/BazaReklam/FakturowaniePoznanKatowice.cs
r621 r789 24 24 25 25 txtYear.Text = DateTime.Now.Year.ToString(); 26 27 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;28 fakturA_DETAILSTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;29 klienciTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;30 agencjeTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;31 kontaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;32 26 33 27 dtpZmianaDaty.Value = DateTime.Today; -
branches/Emisje/BazaReklam/FullInfoProjectForm.cs
r591 r789 15 15 InitializeComponent(); 16 16 17 this.pRODUKCJATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;18 17 this.pRODUKCJATableAdapter.FillById(this.rEKLAMADataSet.PRODUKCJA,id); 19 18 } -
branches/Emisje/BazaReklam/InfoForm.cs
r676 r789 31 31 32 32 MdiParent = parent; 33 34 //podmiana connstringa35 nAZWY_MODULOWTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;36 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;37 gRZBIETYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;38 koszty_BiuraTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;39 bUDZET_BIURTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;40 nRTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;41 daty_publikacjiTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;42 pLANY_PROWIZJITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;43 kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;44 aGENCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;45 lISTA_TYTULOWTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;46 pROMOCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;47 kursy_WalutTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;48 33 49 34 ImageList imageList = new ImageList(); -
branches/Emisje/BazaReklam/LetterViewer.cs
r65 r789 19 19 this.nrGS1 = nrGS1; 20 20 this.nrGS2 = nrGS2; 21 22 KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;23 ListaReklamDoWydaniaNrTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;24 21 25 22 KLIENCITableAdapter.FillByCustomerId(REKLAMADataSet.KLIENCI, custId); … … 50 47 this.nrGS1 = nrGS1; 51 48 this.nrGS2 = nrGS2; 52 53 KLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;54 ListaReklamDoWydaniaNrTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;55 49 56 50 KLIENCITableAdapter.ClearBeforeFill = false; -
branches/Emisje/BazaReklam/ListaReklamNaWydanieForm.cs
r735 r789 30 30 31 31 MdiParent = parent; 32 listaReklamNaWydanie2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 33 32 34 33 bindingNavigator1.Items.Insert(17, new ToolStripLabel("DR")); 35 34 bindingNavigator1.Items.Insert(18, new ToolStripControlHost(new CheckBox(), "DRCheckBox")); -
branches/Emisje/BazaReklam/LogaKlientowForm.cs
r591 r789 25 25 InitializeComponent(); 26 26 this.customerId = customerId; 27 28 this.kLIENCI_INTERNET_LOGOTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;29 27 } 30 28 -
branches/Emisje/BazaReklam/OrderDetails.cs
r784 r789 1361 1361 issue.Lokalizacja = editAdIssue.Lokalizacja.Text; 1362 1362 issue.LokalizacjaId = editAdIssue.Lokalizacja.Id; 1363 1364 //TODO: czy jest mozliwoæ aby ustawiaæ dzial lub rozdzial na NULL? 1365 //Teraz to siê nie uda... 1363 1366 if (editAdIssue.Dzial != null) 1364 1367 { -
branches/Emisje/BazaReklam/OrderViewer.cs
r732 r789 28 28 ds = new DataSet(); 29 29 30 zamowienieTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;31 32 30 Stream s = Assembly.GetExecutingAssembly().GetManifestResourceStream("Baza_Reklam.Raporty.zamowienie.xml"); 33 31 ds.ReadXml(s); … … 69 67 70 68 ds = new DataSet(); 71 72 zamowienie2TableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;73 invoiceProviderTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;74 69 75 70 reportViewer1.LocalReport.ReportEmbeddedResource = "Baza_Reklam.Raporty.zamowienie2.rdlc"; -
branches/Emisje/BazaReklam/PaymentForm.cs
r65 r789 1 1 using System; 2 using System.Collections.Generic;3 using System.ComponentModel;4 2 using System.Data; 5 using System.Drawing;6 using System.Text;7 3 using System.Windows.Forms; 8 4 … … 22 18 private void PaymentForm_Load(object sender, EventArgs e) 23 19 { 24 rEKLAMATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 25 fAKTURYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 26 27 this.rEKLAMATableAdapter.FillByReklamaId(this.rEKLAMADataSet.REKLAMA, reklamaId); 20 rEKLAMATableAdapter.FillByReklamaId(rEKLAMADataSet.REKLAMA, reklamaId); 28 21 29 22 … … 37 30 } 38 31 39 if ((row["FAKTURA WYSTAWIONO"] != DBNull.Value) && (Convert.ToBoolean(row["FAKTURA WYSTAWIONO"]) == true))32 if ((row["FAKTURA WYSTAWIONO"] != DBNull.Value) && Convert.ToBoolean(row["FAKTURA WYSTAWIONO"])) 40 33 { 41 34 int id_faktury = Convert.ToInt32(row["ID_FAKTURY"]); 42 35 43 this.fAKTURYTableAdapter.FillByIdFaktury(this.rEKLAMADataSet.FAKTURY, id_faktury);36 fAKTURYTableAdapter.FillByIdFaktury(rEKLAMADataSet.FAKTURY, id_faktury); 44 37 } 45 38 } … … 64 57 } 65 58 66 this.Validate();67 this.rEKLAMABindingSource.EndEdit();68 this.rEKLAMATableAdapter.Update(this.rEKLAMADataSet.REKLAMA);69 this.DialogResult = DialogResult.OK;59 Validate(); 60 rEKLAMABindingSource.EndEdit(); 61 rEKLAMATableAdapter.Update(rEKLAMADataSet.REKLAMA); 62 DialogResult = DialogResult.OK; 70 63 71 64 } -
branches/Emisje/BazaReklam/PaymentForm2.cs
r230 r789 33 33 rEKLAMADataSet.Wplaty.Constraints.Remove("FAKTURY_Wplaty"); 34 34 35 wplatyTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;36 VIEW_ZESTAWIENIE_FAKTUR_NOWETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;37 zestawienieFakturTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;38 39 35 if (idWplaty != 0) 40 36 { … … 53 49 } 54 50 } 55 56 //REKLAMADataSet.WplatyRow wplata = rEKLAMADataSet.Wplaty.FindByidWplaty(idWplaty);57 58 //if (wplata == null || wplata.IsdataWplatyNull())59 //{60 // //stara faktura61 // UstawBindowanieDlaStarychFaktur();62 63 // zestawienieFakturTableAdapter.FillByIdFaktury(rEKLAMADataSet.ZestawienieFaktur, idFaktury);64 //}65 //else66 //{67 // VIEW_ZESTAWIENIE_FAKTUR_NOWETableAdapter.FillByIdFaktury(rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE, idFaktury);68 //}69 51 } 70 52 … … 88 70 private void dodajButton_Click(object sender, EventArgs e) 89 71 { 90 /*91 if ((sYMBOL_POTWIERDZENIATextBox.Text == "") | (rODZAJ_POTWIERDZENIAComboBox.SelectedIndex == -1))92 {93 MessageBox.Show("Uzupe³nij wszystkie pola");94 return;95 }96 97 this.Validate();98 99 this.wplatyBindingSource.EndEdit();100 this.wplatyTableAdapter.Update(this.rEKLAMADataSet.Wplaty);101 this.idWplaty = rEKLAMADataSet.Wplaty[0].idWplaty;102 */103 72 DialogResult = DialogResult.OK; 104 73 } -
branches/Emisje/BazaReklam/ProductionForm.cs
r745 r789 37 37 38 38 MdiParent = parent; 39 40 gRZBIETYTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;41 grzbietyProdukcjaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;42 aGENCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;43 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;44 lISTA_TYTULOWTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;45 reklamaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;46 pRODUKCJATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;47 listaReklamDoWydaniaNrTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;48 aGENCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;49 aGENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;50 listyTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;51 listyPodsumowanieTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;52 klienciTableAdapter1.Connection.ConnectionString = ConnString.getConnString().Value;53 39 54 40 zwrotToolStripButton.Enabled = false; -
branches/Emisje/BazaReklam/ZamowieniaForm.cs
r764 r789 1162 1162 private void zamowieniaBindingSource_CurrentChanged(object sender, EventArgs e) 1163 1163 { 1164 if (zamowieniaBindingSource.Current != null) 1165 { 1166 DataRowView z = (DataRowView)zamowieniaBindingSource.Current; 1167 REKLAMADataSet.zamowieniaRow zamowienie = (REKLAMADataSet.zamowieniaRow)z.Row; 1168 1169 rEKLAMATableAdapter.FillByIdZamowienia(rEKLAMADataSet.REKLAMA, zamowienie.idZamowienia); 1170 fAKTURYTableAdapter.FillByIdZamowienia(rEKLAMADataSet.FAKTURY, zamowienie.idZamowienia); 1171 1172 dodajDoZamButton.Enabled = !zamowienie.zafakturowanoWszystko; 1173 usunZZamButton.Enabled = !zamowienie.zafakturowanoWszystko; 1174 fakturujButton.Enabled = !zamowienie.zafakturowanoWszystko; 1175 1176 if (!zamowienie.IsdataOstatniejZafakturowanejEmisjiNull()) 1177 { 1178 DateTime data = zamowienie.dataOstatniejZafakturowanejEmisji; 1179 DateTime dzis = DateTime.Today; 1180 1181 if ((dzis.Year > data.Year) || 1182 (dzis.Year == data.Year & dzis.Month > data.Month)) 1183 { 1184 fakturujButton.Enabled = true; 1185 } 1186 else 1187 { 1188 fakturujButton.Enabled = false; 1189 } 1164 if (zamowieniaBindingSource.Current == null) return; 1165 1166 RestoreConnections(); 1167 1168 DataRowView z = (DataRowView) zamowieniaBindingSource.Current; 1169 REKLAMADataSet.zamowieniaRow zamowienie = (REKLAMADataSet.zamowieniaRow) z.Row; 1170 1171 rEKLAMATableAdapter.FillByIdZamowienia(rEKLAMADataSet.REKLAMA, zamowienie.idZamowienia); 1172 fAKTURYTableAdapter.FillByIdZamowienia(rEKLAMADataSet.FAKTURY, zamowienie.idZamowienia); 1173 1174 dodajDoZamButton.Enabled = !zamowienie.zafakturowanoWszystko; 1175 usunZZamButton.Enabled = !zamowienie.zafakturowanoWszystko; 1176 fakturujButton.Enabled = !zamowienie.zafakturowanoWszystko; 1177 1178 if (!zamowienie.IsdataOstatniejZafakturowanejEmisjiNull()) 1179 { 1180 DateTime data = zamowienie.dataOstatniejZafakturowanejEmisji; 1181 DateTime dzis = DateTime.Today; 1182 1183 if ((dzis.Year > data.Year) || 1184 (dzis.Year == data.Year & dzis.Month > data.Month)) 1185 { 1186 fakturujButton.Enabled = true; 1187 } 1188 else 1189 { 1190 fakturujButton.Enabled = false; 1190 1191 } 1191 1192 } -
branches/Emisje/BazaReklam/ZestawienieZamowienForm.cs
r732 r789 33 33 34 34 MdiParent = parent; 35 36 //podmiana connstringa 37 VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 38 reklamyZestawienieTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 39 35 40 36 //obiekty wykorzytywane przy wyszukiwaniu 41 37 SqlConnection conn = new SqlConnection(ConnString.getConnString().Value);
