Example #1
0
 public virtual int FillPage(S_OD_IP_ZBIRNIDataSet dataSet, string gODINA, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault       = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.S_OD_IP_ZBIRNISet = dataSet;
     this.rowS_OD_IP_ZBIRNI = this.S_OD_IP_ZBIRNISet.S_OD_IP_ZBIRNI.NewS_OD_IP_ZBIRNIRow();
     this.SetFillParameters(gODINA);
     this.AV8GODINA = gODINA;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
Example #2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmS_OD_IP_ZBIRNISelect2 = this.connDefault.GetCommand("S_PLACA_IP_ZBIRNI", true);
            this.cmS_OD_IP_ZBIRNISelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmS_OD_IP_ZBIRNISelect2.IDbCommand.Parameters.Clear();
            this.cmS_OD_IP_ZBIRNISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@GODINA", this.AV8GODINA));
            this.cmS_OD_IP_ZBIRNISelect2.ErrorMask |= ErrorMask.Lock;
            this.S_OD_IP_ZBIRNISelect2              = this.cmS_OD_IP_ZBIRNISelect2.FetchData();
            while (this.cmS_OD_IP_ZBIRNISelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmS_OD_IP_ZBIRNISelect2.HasMoreRows = this.S_OD_IP_ZBIRNISelect2.Read();
            }
            int num = 0;

            while (this.cmS_OD_IP_ZBIRNISelect2.HasMoreRows && (num != maxRows))
            {
                this.rowS_OD_IP_ZBIRNI["ukupnobruto"]     = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["UKUPNOBRUTO"]);
                this.rowS_OD_IP_ZBIRNI["ukupnodoprinosi"] = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["UKUPNODOPRINOSI"]);
                this.rowS_OD_IP_ZBIRNI["ukupnoolaksice"]  = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["UKUPNOOLAKSICE"]);
                this.rowS_OD_IP_ZBIRNI["dohodak"]         = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["DOHODAK"]);
                this.rowS_OD_IP_ZBIRNI["UKUPNOOO"]        = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["UKUPNOOO"]);
                this.rowS_OD_IP_ZBIRNI["poreznaosnovica"] = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["POREZNAOSNOVICA"]);
                this.rowS_OD_IP_ZBIRNI["POREZPRIREZ"]     = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["POREZPRIREZ"]);
                this.rowS_OD_IP_ZBIRNI["netoisplata"]     = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["NETOISPLATA"]);
                this.rowS_OD_IP_ZBIRNI["netoplaca"]       = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["NETOPLACA"]);
                this.rowS_OD_IP_ZBIRNI["POREZKRIZNI"]     = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["POREZKRIZNI"]);
                this.rowS_OD_IP_ZBIRNI["PREZIME"]         = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["PREZIME"]);
                this.rowS_OD_IP_ZBIRNI["IME"]             = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["IME"]);
                this.rowS_OD_IP_ZBIRNI["OIB"]             = RuntimeHelpers.GetObjectValue(this.S_OD_IP_ZBIRNISelect2["OIB"]);
                this.AddRowS_od_ip_zbirni();
                num++;
                this.rowS_OD_IP_ZBIRNI = this.S_OD_IP_ZBIRNISet.S_OD_IP_ZBIRNI.NewS_OD_IP_ZBIRNIRow();
                this.cmS_OD_IP_ZBIRNISelect2.HasMoreRows = this.S_OD_IP_ZBIRNISelect2.Read();
            }
            this.S_OD_IP_ZBIRNISelect2.Close();
            this.Cleanup();
        }