Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  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. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement