예제 #1
0
 public virtual int FillPage(sp_VIRMANIDataSet dataSet, string iDOBRACUN, string zaduzenje, string poreziprirezodvojeno, string pl1, string pl2, string pl3, string vbd, string zrn, string mb, string dd, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault   = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.sp_VIRMANISet = dataSet;
     this.rowsp_VIRMANI = this.sp_VIRMANISet.sp_VIRMANI.Newsp_VIRMANIRow();
     this.SetFillParameters(iDOBRACUN, zaduzenje, poreziprirezodvojeno, pl1, pl2, pl3, vbd, zrn, mb, dd);
     this.AV8IDOBRAC = iDOBRACUN;
     this.AV9zaduzen = zaduzenje;
     this.AV10porezi = poreziprirezodvojeno;
     this.AV11pl1    = pl1;
     this.AV12pl2    = pl2;
     this.AV13pl3    = pl3;
     this.AV14vbd    = vbd;
     this.AV15zrn    = zrn;
     this.AV16mb     = mb;
     this.AV17dd     = dd;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
예제 #2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmsp_VIRMANISelect2 = this.connDefault.GetCommand("S_VIRMANI", true);
            this.cmsp_VIRMANISelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Clear();
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", this.AV8IDOBRAC));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@zaduzenje", this.AV9zaduzen));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@poreziprirezodvojeno", this.AV10porezi));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl1", this.AV11pl1));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl2", this.AV12pl2));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl3", this.AV13pl3));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vbd", this.AV14vbd));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@zrn", this.AV15zrn));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@mb", this.AV16mb));
            this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@dd", this.AV17dd));
            this.cmsp_VIRMANISelect2.ErrorMask |= ErrorMask.Lock;
            this.sp_VIRMANISelect2              = this.cmsp_VIRMANISelect2.FetchData();
            while (this.cmsp_VIRMANISelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmsp_VIRMANISelect2.HasMoreRows = this.sp_VIRMANISelect2.Read();
            }
            int num = 0;

            while (this.cmsp_VIRMANISelect2.HasMoreRows && (num != maxRows))
            {
                this.rowsp_VIRMANI["SIFRAOBRACUNAVIRMAN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["SIFRAOBRACUNAVIRMAN"]);
                this.rowsp_VIRMANI["PLA1"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA1"]);
                this.rowsp_VIRMANI["PLA2"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA2"]);
                this.rowsp_VIRMANI["PLA3"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA3"]);
                this.rowsp_VIRMANI["BROJRACUNAPLA"]            = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["BROJRACUNAPLA"]);
                this.rowsp_VIRMANI["MODELZADUZENJA"]           = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["MODELZADUZENJA"]);
                this.rowsp_VIRMANI["POZIVZADUZENJA"]           = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["POZIVZADUZENJA"]);
                this.rowsp_VIRMANI["PRI1"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI1"]);
                this.rowsp_VIRMANI["PRI2"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI2"]);
                this.rowsp_VIRMANI["PRI3"]                     = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI3"]);
                this.rowsp_VIRMANI["BROJRACUNAPRI"]            = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["BROJRACUNAPRI"]);
                this.rowsp_VIRMANI["MODELODOBRENJA"]           = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["MODELODOBRENJA"]);
                this.rowsp_VIRMANI["POZIVODOBRENJA"]           = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["POZIVODOBRENJA"]);
                this.rowsp_VIRMANI["SIFRAOPISAPLACANJAVIRMAN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["SIFRAOPISAPLACANJAVIRMAN"]);
                this.rowsp_VIRMANI["OPISPLACANJAVIRMAN"]       = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["OPISPLACANJAVIRMAN"]);
                this.rowsp_VIRMANI["DATUMVALUTE"]              = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["DATUMVALUTE"]);
                this.rowsp_VIRMANI["DATUMPODNOSENJA"]          = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["DATUMPODNOSENJA"]);
                this.rowsp_VIRMANI["IZVORDOKUMENTA"]           = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["IZVORDOKUMENTA"]);
                this.rowsp_VIRMANI["OZNACEN"]                  = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["OZNACEN"]);
                this.rowsp_VIRMANI["IZNOS"]                    = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["IZNOS"]);
                this.rowsp_VIRMANI["NAMJENA"]                  = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["NAMJENA"]);
                this.AddRowSp_virmani();
                num++;
                this.rowsp_VIRMANI = this.sp_VIRMANISet.sp_VIRMANI.Newsp_VIRMANIRow();
                this.cmsp_VIRMANISelect2.HasMoreRows = this.sp_VIRMANISelect2.Read();
            }
            this.sp_VIRMANISelect2.Close();
            this.Cleanup();
        }