示例#1
0
 public virtual int FillPage(sp_diskete_za_bankuDataSet dataSet, string idobracun, string vbdibanke, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault            = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.sp_diskete_za_bankuSet = dataSet;
     this.rowsp_diskete_za_banku = this.sp_diskete_za_bankuSet.sp_diskete_za_banku.Newsp_diskete_za_bankuRow();
     this.SetFillParameters(idobracun, vbdibanke);
     this.AV8idobrac = idobracun;
     this.AV9vbdiban = vbdibanke;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
示例#2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmsp_diskete_za_bankuSelect2 = this.connDefault.GetCommand("S_PLACA_ISPLATE_ZA_BANKU", true);
            this.cmsp_diskete_za_bankuSelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Clear();
            this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idobracun", this.AV8idobrac));
            this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vbdibanke", this.AV9vbdiban));
            this.cmsp_diskete_za_bankuSelect2.ErrorMask |= ErrorMask.Lock;
            this.sp_diskete_za_bankuSelect2              = this.cmsp_diskete_za_bankuSelect2.FetchData();
            while (this.cmsp_diskete_za_bankuSelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmsp_diskete_za_bankuSelect2.HasMoreRows = this.sp_diskete_za_bankuSelect2.Read();
            }
            int num = 0;

            while (this.cmsp_diskete_za_bankuSelect2.HasMoreRows && (num != maxRows))
            {
                this.rowsp_diskete_za_banku["IDRADNIK"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["idradnik"]);
                this.rowsp_diskete_za_banku["PREZIME"]  = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["prezime"]);
                this.rowsp_diskete_za_banku["IME"]      = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["ime"]);
                this.rowsp_diskete_za_banku["JMBG"]     = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["jmbg"]);
                this.rowsp_diskete_za_banku["TEKUCI"]   = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["tekuci"]);
                this.rowsp_diskete_za_banku["SIFRAOPISAPLACANJANETO"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["sifraopisaplacanjaneto"]);
                this.rowsp_diskete_za_banku["OPISPLACANJANETO"]       = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["opisplacanjaneto"]);
                this.rowsp_diskete_za_banku["VBDIBANKE"]       = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["vbdibanke"]);
                this.rowsp_diskete_za_banku["ZRNBANKE"]        = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["zrnbanke"]);
                this.rowsp_diskete_za_banku["UKUPNOZAISPLATU"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["ukupnozaisplatu"]);
                this.rowsp_diskete_za_banku["NAZIVBANKE1"]     = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["nazivbanke1"]);
                this.AddRowSp_diskete_za_banku();
                num++;
                this.rowsp_diskete_za_banku = this.sp_diskete_za_bankuSet.sp_diskete_za_banku.Newsp_diskete_za_bankuRow();
                this.cmsp_diskete_za_bankuSelect2.HasMoreRows = this.sp_diskete_za_bankuSelect2.Read();
            }
            this.sp_diskete_za_bankuSelect2.Close();
            this.Cleanup();
        }