Пример #1
0
 public virtual int FillPage(S_FIN_KARTICEPARTNERADataSet dataSet, int oRG, int mT, int dOK, DateTime rAZDOBLJEOD, DateTime rAZDOBLJEDO, string pOCETNIKONTO, string zAVRSNIKONTO, int iDAKTIVNOST, int iDPARTNER, string sORT, int startRow, int maxRows)
 {
     this.Initialize();
     this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
     this.S_FIN_KARTICEPARTNERASet = dataSet;
     this.rowS_FIN_KARTICEPARTNERA = this.S_FIN_KARTICEPARTNERASet.S_FIN_KARTICEPARTNERA.NewS_FIN_KARTICEPARTNERARow();
     this.SetFillParameters(oRG, mT, dOK, rAZDOBLJEOD, rAZDOBLJEDO, pOCETNIKONTO, zAVRSNIKONTO, iDAKTIVNOST, iDPARTNER, sORT);
     this.AV8ORG     = oRG;
     this.AV9MT      = mT;
     this.AV10DOK    = dOK;
     this.AV11RAZDOB = DateTimeUtil.ResetTime(rAZDOBLJEOD);
     this.AV12RAZDOB = DateTimeUtil.ResetTime(rAZDOBLJEDO);
     this.AV13POCETN = pOCETNIKONTO;
     this.AV14ZAVRSN = zAVRSNIKONTO;
     this.AV15IDAKTI = iDAKTIVNOST;
     this.AV16IDPART = iDPARTNER;
     this.AV17SORT   = sORT;
     try
     {
         this.executePrivate(startRow, maxRows);
     }
     finally
     {
         this.Cleanup();
     }
     return(0);
 }
Пример #2
0
        public void executePrivate(int startRow, int maxRows)
        {
            this.cmS_FIN_KARTICEPARTNERASelect2 = this.connDefault.GetCommand("S_FIN_KARTICE_PARTNERA", true);
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.CommandType = CommandType.StoredProcedure;
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Clear();
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ORG", this.AV8ORG));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@MT", this.AV9MT));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DOK", this.AV10DOK));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEOD", this.AV11RAZDOB));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEDO", this.AV12RAZDOB));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@POCETNIKONTO", this.AV13POCETN));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ZAVRSNIKONTO", this.AV14ZAVRSN));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDAKTIVNOST", this.AV15IDAKTI));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDPARTNER", this.AV16IDPART));
            this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@SORT", this.AV17SORT));
            this.cmS_FIN_KARTICEPARTNERASelect2.ErrorMask |= ErrorMask.Lock;
            this.S_FIN_KARTICEPARTNERASelect2              = this.cmS_FIN_KARTICEPARTNERASelect2.FetchData();
            while (this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows && (startRow > 0))
            {
                startRow--;
                this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows = this.S_FIN_KARTICEPARTNERASelect2.Read();
            }
            int num = 0;

            while (this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows && (num != maxRows))
            {
                this.rowS_FIN_KARTICEPARTNERA["duguje"]             = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DUGUJE"]);
                this.rowS_FIN_KARTICEPARTNERA["POTRAZUJE"]          = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["POTRAZUJE"]);
                this.rowS_FIN_KARTICEPARTNERA["konto"]              = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["KONTO"]);
                this.rowS_FIN_KARTICEPARTNERA["DATUMDVO"]           = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMDVO"]);
                this.rowS_FIN_KARTICEPARTNERA["DATUMVALUTE"]        = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMVALUTE"]);
                this.rowS_FIN_KARTICEPARTNERA["DATUMDOK"]           = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMDOK"]);
                this.rowS_FIN_KARTICEPARTNERA["SKRACENI"]           = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["SKRACENI"]);
                this.rowS_FIN_KARTICEPARTNERA["BROJDOK"]            = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["BROJDOK"]);
                this.rowS_FIN_KARTICEPARTNERA["BROJSTAVKE"]         = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["BROJSTAVKE"]);
                this.rowS_FIN_KARTICEPARTNERA["OPISKNJIZENJA"]      = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["OPISKNJIZENJA"]);
                this.rowS_FIN_KARTICEPARTNERA["IDPARTNER"]          = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDPARTNER"]);
                this.rowS_FIN_KARTICEPARTNERA["NAZIVKONTO"]         = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVKONTO"]);
                this.rowS_FIN_KARTICEPARTNERA["IDDOKUMENT"]         = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDDOKUMENT"]);
                this.rowS_FIN_KARTICEPARTNERA["NAZIVPARTNER"]       = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVPARTNER"]);
                this.rowS_FIN_KARTICEPARTNERA["IDORGJED"]           = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDORGJED"]);
                this.rowS_FIN_KARTICEPARTNERA["IDMJESTOTROSKA"]     = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDMJESTOTROSKA"]);
                this.rowS_FIN_KARTICEPARTNERA["MB"]                 = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["MB"]);
                this.rowS_FIN_KARTICEPARTNERA["PARTNERMJESTO"]      = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["PARTNERMJESTO"]);
                this.rowS_FIN_KARTICEPARTNERA["PARTNERULICA"]       = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["PARTNERULICA"]);
                this.rowS_FIN_KARTICEPARTNERA["ORIGINALNIDOKUMENT"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["ORIGINALNIDOKUMENT"]);
                this.rowS_FIN_KARTICEPARTNERA["NAZIVOJ"]            = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVOJ"]);
                this.rowS_FIN_KARTICEPARTNERA["NAZIVMT"]            = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVMT"]);
                this.AddRowS_fin_karticepartnera();
                num++;
                this.rowS_FIN_KARTICEPARTNERA = this.S_FIN_KARTICEPARTNERASet.S_FIN_KARTICEPARTNERA.NewS_FIN_KARTICEPARTNERARow();
                this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows = this.S_FIN_KARTICEPARTNERASelect2.Read();
            }
            this.S_FIN_KARTICEPARTNERASelect2.Close();
            this.Cleanup();
        }