public virtual int FillPage(SP_FIN_URAPLACANJEDataSet dataSet, int iDDOKUMENT, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.SP_FIN_URAPLACANJESet = dataSet; this.rowSP_FIN_URAPLACANJE = this.SP_FIN_URAPLACANJESet.SP_FIN_URAPLACANJE.NewSP_FIN_URAPLACANJERow(); this.SetFillParameters(iDDOKUMENT); this.AV8IDDOKUM = iDDOKUMENT; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmSP_FIN_URAPLACANJESelect2 = this.connDefault.GetCommand("S_FIN_URA_PLACANJE", true); this.cmSP_FIN_URAPLACANJESelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmSP_FIN_URAPLACANJESelect2.IDbCommand.Parameters.Clear(); this.cmSP_FIN_URAPLACANJESelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDDOKUMENT", this.AV8IDDOKUM)); this.cmSP_FIN_URAPLACANJESelect2.ErrorMask |= ErrorMask.Lock; this.SP_FIN_URAPLACANJESelect2 = this.cmSP_FIN_URAPLACANJESelect2.FetchData(); while (this.cmSP_FIN_URAPLACANJESelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmSP_FIN_URAPLACANJESelect2.HasMoreRows = this.SP_FIN_URAPLACANJESelect2.Read(); } int num = 0; while (this.cmSP_FIN_URAPLACANJESelect2.HasMoreRows && (num != maxRows)) { this.rowSP_FIN_URAPLACANJE["ZATVARANJE_IZNOS"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["ZATVARANJE_IZNOS"]); this.rowSP_FIN_URAPLACANJE["ZATVARANJE_DATUM"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["ZATVARANJE_DATUM"]); this.rowSP_FIN_URAPLACANJE["URABROJ"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URABROJ"]); this.rowSP_FIN_URAPLACANJE["IDTIPURA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["IDTIPURA"]); this.rowSP_FIN_URAPLACANJE["URABROJRACUNADOBAVLJACA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URABROJRACUNADOBAVLJACA"]); this.rowSP_FIN_URAPLACANJE["urapartnerIDPARTNER"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAPARTNERIDPARTNER"]); this.rowSP_FIN_URAPLACANJE["URANAPOMENA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URANAPOMENA"]); this.rowSP_FIN_URAPLACANJE["URAVALUTA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAVALUTA"]); this.rowSP_FIN_URAPLACANJE["URAUKUPNO"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAUKUPNO"]); this.rowSP_FIN_URAPLACANJE["URADATUM"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URADATUM"]); this.rowSP_FIN_URAPLACANJE["URAGODIDGODINE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAGODIDGODINE"]); this.rowSP_FIN_URAPLACANJE["NAZIVPARTNER"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["NAZIVPARTNER"]); this.rowSP_FIN_URAPLACANJE["MB"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["MB"]); this.rowSP_FIN_URAPLACANJE["URADOKIDDOKUMENT"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URADOKIDDOKUMENT"]); this.rowSP_FIN_URAPLACANJE["PARTNEROIB"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PARTNEROIB"]); this.rowSP_FIN_URAPLACANJE["Status"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["Status"]); this.rowSP_FIN_URAPLACANJE["URAMODEL"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAMODEL"]); this.rowSP_FIN_URAPLACANJE["URAPOZIVNABROJ"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["URAPOZIVNABROJ"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA0"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA0"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA5"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA5"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA10"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA10"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA22"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA22"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA23"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA23"]); this.rowSP_FIN_URAPLACANJE["PDV5DA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV5DA"]); this.rowSP_FIN_URAPLACANJE["PDV5NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV5NE"]); this.rowSP_FIN_URAPLACANJE["PDV10DA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV10DA"]); this.rowSP_FIN_URAPLACANJE["PDV10NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV10NE"]); this.rowSP_FIN_URAPLACANJE["PDV22DA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV22DA"]); this.rowSP_FIN_URAPLACANJE["PDV22NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV22NE"]); this.rowSP_FIN_URAPLACANJE["PDV23DA"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV23DA"]); this.rowSP_FIN_URAPLACANJE["PDV23NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["PDV23NE"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA5NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA5NE"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA10NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA10NE"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA23NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA23NE"]); this.rowSP_FIN_URAPLACANJE["OSNOVICA22NE"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["OSNOVICA22NE"]); this.rowSP_FIN_URAPLACANJE["R2"] = RuntimeHelpers.GetObjectValue(this.SP_FIN_URAPLACANJESelect2["R2"]); this.AddRowSp_fin_uraplacanje(); num++; this.rowSP_FIN_URAPLACANJE = this.SP_FIN_URAPLACANJESet.SP_FIN_URAPLACANJE.NewSP_FIN_URAPLACANJERow(); this.cmSP_FIN_URAPLACANJESelect2.HasMoreRows = this.SP_FIN_URAPLACANJESelect2.Read(); } this.SP_FIN_URAPLACANJESelect2.Close(); this.Cleanup(); }