Example #1
0
 public virtual int FillPage(sp_REKAP_ISPLATADataSet dataSet, string iDOBRACUN, string vBDIBANKE, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault         = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.sp_REKAP_ISPLATASet = dataSet;
     this.rowsp_REKAP_ISPLATA = this.sp_REKAP_ISPLATASet.sp_REKAP_ISPLATA.Newsp_REKAP_ISPLATARow();
     this.SetFillParameters(iDOBRACUN, vBDIBANKE);
     this.AV8IDOBRAC = iDOBRACUN;
     this.AV9VBDIBAN = vBDIBANKE;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
Example #2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmsp_REKAP_ISPLATASelect2 = this.connDefault.GetCommand("S_PLACA_NA_RUKE_ISPLATA", true);
            this.cmsp_REKAP_ISPLATASelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmsp_REKAP_ISPLATASelect2.IDbCommand.Parameters.Clear();
            this.cmsp_REKAP_ISPLATASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", this.AV8IDOBRAC));
            this.cmsp_REKAP_ISPLATASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@VBDIBANKE", this.AV9VBDIBAN));
            this.cmsp_REKAP_ISPLATASelect2.ErrorMask |= ErrorMask.Lock;
            this.sp_REKAP_ISPLATASelect2              = this.cmsp_REKAP_ISPLATASelect2.FetchData();
            while (this.cmsp_REKAP_ISPLATASelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmsp_REKAP_ISPLATASelect2.HasMoreRows = this.sp_REKAP_ISPLATASelect2.Read();
            }
            int num = 0;

            while (this.cmsp_REKAP_ISPLATASelect2.HasMoreRows && (num != maxRows))
            {
                this.rowsp_REKAP_ISPLATA["IDRADNIK"]        = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["IDRADNIK"]);
                this.rowsp_REKAP_ISPLATA["PREZIME"]         = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["PREZIME"]);
                this.rowsp_REKAP_ISPLATA["IME"]             = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["IME"]);
                this.rowsp_REKAP_ISPLATA["JMBG"]            = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["JMBG"]);
                this.rowsp_REKAP_ISPLATA["TEKUCI"]          = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["TEKUCI"]);
                this.rowsp_REKAP_ISPLATA["ZBIRNINETO"]      = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["ZBIRNINETO"]);
                this.rowsp_REKAP_ISPLATA["VBDIBANKE"]       = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["VBDIBANKE"]);
                this.rowsp_REKAP_ISPLATA["ZRNBANKE"]        = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["ZRNBANKE"]);
                this.rowsp_REKAP_ISPLATA["IDBANKE"]         = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["IDBANKE"]);
                this.rowsp_REKAP_ISPLATA["NAZIVBANKE1"]     = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["NAZIVBANKE1"]);
                this.rowsp_REKAP_ISPLATA["NAZIVBANKE2"]     = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["NAZIVBANKE2"]);
                this.rowsp_REKAP_ISPLATA["UKUPNOZAISPLATU"] = RuntimeHelpers.GetObjectValue(this.sp_REKAP_ISPLATASelect2["UKUPNOZAISPLATU"]);
                this.AddRowSp_rekap_isplata();
                num++;
                this.rowsp_REKAP_ISPLATA = this.sp_REKAP_ISPLATASet.sp_REKAP_ISPLATA.Newsp_REKAP_ISPLATARow();
                this.cmsp_REKAP_ISPLATASelect2.HasMoreRows = this.sp_REKAP_ISPLATASelect2.Read();
            }
            this.sp_REKAP_ISPLATASelect2.Close();
            this.Cleanup();
        }