SHARE
TWEET

Untitled

a guest Jun 25th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  private void ladowanie_listy_paczek()
  2.     {
  3.       Cursor.Current = Cursors.WaitCursor;
  4.       try
  5.       {
  6.         this.flaga_zmiany = false;
  7.         this.comboBox1.DataSource = (object) null;
  8.         this.comboBox1.Items.Clear();
  9.         string[][] strArray1 = new string[1][];
  10.         string[][] strArray2 = new string[1][];
  11.         int int32 = Convert.ToInt32(this.sqlzap("select count(cdn.wyspaczki.wyp_idpaczki) from cdn.wyspaczki where wyp_datautw <= datediff(day,convert(datetime,'1800-12-28',120),convert(datetime,'" + (object) this.dateTimePicker_to.Value + "',120)) and wyp_datautw >=datediff(day,convert(datetime,'1800-12-28',120),convert(datetime,'" + (object) this.dateTimePicker_from.Value + "',120))", this.stringpolaczenie)[0][0]);
  12.         string[][] strArray3 = this.sqlzap("select cdn.wyspaczki.wyp_idpaczki as idpaczki, CDN.NumerDokumentuTRN(340,0,0, cdn.WysPaczki.WyP_Numer, cdn.WysPaczki.WyP_Rok , cdn.WysPaczki.WyP_Seria) as numerpelny, cdn.wyspaczki.wyp_datautw from cdn.wyspaczki where wyp_datautw <= datediff(day,convert(datetime,'1800-12-28',120),convert(datetime,'" + (object) this.dateTimePicker_to.Value + "',120)) and wyp_datautw >=datediff(day,convert(datetime,'1800-12-28',120),convert(datetime,'" + (object) this.dateTimePicker_from.Value + "',120))", this.stringpolaczenie);
  13.         if (this.lista_paczek.Count > 0)
  14.           this.lista_paczek.Clear();
  15.         if (int32 > 0)
  16.         {
  17.           for (int index = 0; index < int32; ++index)
  18.             this.lista_paczek.Add(new paczka(strArray3[index][0], strArray3[index][1]));
  19.           this.comboBox1.DataSource = (object) this.lista_paczek;
  20.           this.comboBox1.DisplayMember = "Wartosc";
  21.         }
  22.       }
  23.       catch (Exception ex)
  24.       {
  25.                 MessageBox.Show(ex.ToString());
  26.                 MessageBox.Show(this.dateTimePicker_to.Value.ToString());
  27.       }
  28.       Cursor.Current = Cursors.Default;
  29.     }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top