Zbiór zmian 11 dla Baza Reklam 2 - Faktury/FacturesFormNEW.cs

Data:

2008-12-21 15:55:05 (17 years ago)

Autor:

dorota

Opis:

VIEW_ZESTAWIENIE_FAKTUR_NOWE + kosmetyka

Pliki:

• Baza Reklam 2 - Faktury/FacturesFormNEW.cs (zmodyfikowane) (14 diffs)

Baza Reklam 2 - Faktury/FacturesFormNEW.cs

@@ -35 +35 @@
 
             //podmiana connstringa
-            zestawienieFakturNEWTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
+            VIEW_ZESTAWIENIE_FAKTUR_NOWETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
             reklamaTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value;
          
@@ -122 +122 @@
                                         this.Cursor = Cursors.WaitCursor;
 
-                                        rEKLAMADataSet.ZestawienieFakturNEW.Clear();
+                                        rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE.Clear();
 
                                         command.CommandText += " WHERE YEAR(dataWplaty) = @rok AND (suma_zaplat is null OR (CONVERT(int, suma_zaplat * 100) <> CONVERT(int, BRUTTO * 100))) order by dataWplaty";
 
                                         command.Parameters.AddWithValue("@rok", e.Node.Name);
-                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieFakturNEW);
+                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE);
                                         commandExecuted = true;
                                         fakturyDataGridView.Refresh();
@@ -138 +138 @@
                                         this.Cursor = Cursors.WaitCursor;
 
-                                        rEKLAMADataSet.ZestawienieFakturNEW.Clear();
+                                        rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE.Clear();
                                         command.CommandText += " WHERE YEAR(DATA_SPRZEDAZY) = @rok AND (suma_zaplat is not null AND suma_zaplat<>0) AND (dataWplaty is null) order by DATA_SPRZEDAZY";
                                         command.Parameters.AddWithValue("@rok", e.Node.Name);
-                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieFakturNEW);
+                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE);
                                         commandExecuted = true;
                                         fakturyDataGridView.Refresh();
@@ -165 +165 @@
                                         this.Cursor = Cursors.WaitCursor;
 
-                                        rEKLAMADataSet.ZestawienieFakturNEW.Clear();
+                                        rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE.Clear();
                                         command.CommandText += " WHERE YEAR([dataWplaty]) = @rok AND MONTH(dataWplaty) = @miesiac AND (suma_zaplat is null OR (CONVERT(int, suma_zaplat * 100) <> CONVERT(int, BRUTTO * 100))) order by dataWplaty";
                                         command.Parameters.AddWithValue("@rok", e.Node.Parent.Name);
                                         command.Parameters.AddWithValue("@miesiac", e.Node.Name);
-                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieFakturNEW);
+                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE);
                                         commandExecuted = true;
                                         fakturyDataGridView.Refresh();
@@ -179 +179 @@
                                         this.Cursor = Cursors.WaitCursor;
 
-                                        rEKLAMADataSet.ZestawienieFakturNEW.Clear();
+                                        rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE.Clear();
                                         command.CommandText += " WHERE YEAR(DATA_SPRZEDAZY) = @rok AND MONTH(DATA_SPRZEDAZY) = @miesiac AND (suma_zaplat is not null AND suma_zaplat<>0) AND (dataWplaty is null) order by DATA_SPRZEDAZY";
                                         command.Parameters.AddWithValue("@rok", e.Node.Parent.Name);
                                         command.Parameters.AddWithValue("@miesiac", e.Node.Name);
-                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieFakturNEW);
+                                        sqlDataAdapter.Fill(this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE);
                                         commandExecuted = true;
                                         fakturyDataGridView.Refresh();
@@ -312 +312 @@
         private void fakturyDataGridView_CellLeave(object sender, DataGridViewCellEventArgs e)
         {
-            zestawienieFakturNEWBindingSource.CancelEdit();
+            VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.CancelEdit();
         }
        
@@ -324 +324 @@
             command.CommandText = query;
 
-            this.rEKLAMADataSet.ZestawienieFakturNEW.Clear();
+            this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE.Clear();
 
             command.CommandText += " where 1=1 ";
@@ -397 +397 @@
             try
             {
-                int t = sqlDataAdapter.Fill(this.rEKLAMADataSet.ZestawienieFakturNEW);
+                int t = sqlDataAdapter.Fill(this.rEKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWE);
                 commandExecuted = true;
             }
@@ -429 +429 @@
         private void podsumuj() {
 
-            if (zestawienieFakturNEWBindingSource.List.Count != 0)
+            if (VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.List.Count != 0)
             {
             decimal brutto = Convert.ToDecimal(rEKLAMADataSet.ZestawienieFaktur.Compute("Sum(BRUTTO)",""));
@@ -469 +469 @@
         private void podgladToolStripButton_Click(object sender, EventArgs e)
         {
-            if (zestawienieFakturNEWBindingSource.Current != null)
-            {
-                DataRowView row = (DataRowView)zestawienieFakturNEWBindingSource.Current;
-                REKLAMADataSet.ZestawienieFakturNEWRow faktura = (REKLAMADataSet.ZestawienieFakturNEWRow)row.Row;
+            if (VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current != null)
+            {
+                DataRowView row = (DataRowView)VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current;
+                REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow faktura = (REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow)row.Row;
 
                 this.Cursor = Cursors.WaitCursor;
@@ -487 +487 @@
         private void klientToolStripButton_Click(object sender, EventArgs e)
         {
-            if (zestawienieFakturNEWBindingSource.Current != null)
-            {
-                DataRowView row = (DataRowView)zestawienieFakturNEWBindingSource.Current;
+            if (VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current != null)
+            {
+                DataRowView row = (DataRowView)VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current;
 
                 int custID = Convert.ToInt32(row["ID_NABYWCY"]);
@@ -532 +532 @@
                 foreach (DataGridViewRow r in fakturyDataGridView.Rows)
                 {
-                    if (r.Cells[7].Value != DBNull.Value && r.Cells[8].Value != DBNull.Value)
+                    if (r.Cells["nETTODataGridViewTextBoxColumn"].Value != 
+                        DBNull.Value && r.Cells["sumaNettoZEmisji"].Value != DBNull.Value)
                     {
-                        if (Convert.ToDecimal(r.Cells[7].Value) != Convert.ToDecimal(r.Cells[8].Value))
+                        if (Convert.ToDecimal(r.Cells["nETTODataGridViewTextBoxColumn"].Value)
+                            != Convert.ToDecimal(r.Cells["sumaNettoZEmisji"].Value))
                         {
                             r.DefaultCellStyle.ForeColor = Color.Red;
@@ -545 +547 @@
         private void wplata2toolStripButton_Click(object sender, EventArgs e)
         {
-            if (zestawienieFakturNEWBindingSource.Current != null)
-            {
-                DataRowView row = (DataRowView)zestawienieFakturNEWBindingSource.Current;
-                REKLAMADataSet.ZestawienieFakturNEWRow f = (REKLAMADataSet.ZestawienieFakturNEWRow)row.Row;
+            if (VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current != null)
+            {
+                DataRowView row = (DataRowView)VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current;
+                REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow f = (REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow)row.Row;
                 
                 PaymentForm2 pf2;
@@ -573 +575 @@
         private void zamowieniaToolStripButton_Click(object sender, EventArgs e)
         {
-            if (zestawienieFakturNEWBindingSource.Current != null)
-            {
-                DataRowView row = (DataRowView)zestawienieFakturNEWBindingSource.Current;
-                REKLAMADataSet.ZestawienieFakturNEWRow f = (REKLAMADataSet.ZestawienieFakturNEWRow)row.Row;
+            if (VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current != null)
+            {
+                DataRowView row = (DataRowView)VIEW_ZESTAWIENIE_FAKTUR_NOWEBindingSource.Current;
+                REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow f = (REKLAMADataSet.VIEW_ZESTAWIENIE_FAKTUR_NOWERow)row.Row;
 
                 ZamowieniaForm zf = new ZamowieniaForm(f.ID_NABYWCY,f.idZamowienia);