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); }
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(); }