public virtual int FillPage(sp_diskete_za_bankuDataSet dataSet, string idobracun, string vbdibanke, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.sp_diskete_za_bankuSet = dataSet; this.rowsp_diskete_za_banku = this.sp_diskete_za_bankuSet.sp_diskete_za_banku.Newsp_diskete_za_bankuRow(); 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_diskete_za_bankuSelect2 = this.connDefault.GetCommand("S_PLACA_ISPLATE_ZA_BANKU", true); this.cmsp_diskete_za_bankuSelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Clear(); this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idobracun", this.AV8idobrac)); this.cmsp_diskete_za_bankuSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vbdibanke", this.AV9vbdiban)); this.cmsp_diskete_za_bankuSelect2.ErrorMask |= ErrorMask.Lock; this.sp_diskete_za_bankuSelect2 = this.cmsp_diskete_za_bankuSelect2.FetchData(); while (this.cmsp_diskete_za_bankuSelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmsp_diskete_za_bankuSelect2.HasMoreRows = this.sp_diskete_za_bankuSelect2.Read(); } int num = 0; while (this.cmsp_diskete_za_bankuSelect2.HasMoreRows && (num != maxRows)) { this.rowsp_diskete_za_banku["IDRADNIK"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["idradnik"]); this.rowsp_diskete_za_banku["PREZIME"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["prezime"]); this.rowsp_diskete_za_banku["IME"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["ime"]); this.rowsp_diskete_za_banku["JMBG"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["jmbg"]); this.rowsp_diskete_za_banku["TEKUCI"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["tekuci"]); this.rowsp_diskete_za_banku["SIFRAOPISAPLACANJANETO"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["sifraopisaplacanjaneto"]); this.rowsp_diskete_za_banku["OPISPLACANJANETO"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["opisplacanjaneto"]); this.rowsp_diskete_za_banku["VBDIBANKE"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["vbdibanke"]); this.rowsp_diskete_za_banku["ZRNBANKE"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["zrnbanke"]); this.rowsp_diskete_za_banku["UKUPNOZAISPLATU"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["ukupnozaisplatu"]); this.rowsp_diskete_za_banku["NAZIVBANKE1"] = RuntimeHelpers.GetObjectValue(this.sp_diskete_za_bankuSelect2["nazivbanke1"]); this.AddRowSp_diskete_za_banku(); num++; this.rowsp_diskete_za_banku = this.sp_diskete_za_bankuSet.sp_diskete_za_banku.Newsp_diskete_za_bankuRow(); this.cmsp_diskete_za_bankuSelect2.HasMoreRows = this.sp_diskete_za_bankuSelect2.Read(); } this.sp_diskete_za_bankuSelect2.Close(); this.Cleanup(); }