public virtual int FillPage(S_FIN_BLAGAJNA_U_GKDataSet dataSet, DateTime dAT1, DateTime dAT2, int bLAG, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.S_FIN_BLAGAJNA_U_GKSet = dataSet; this.rowS_FIN_BLAGAJNA_U_GK = this.S_FIN_BLAGAJNA_U_GKSet.S_FIN_BLAGAJNA_U_GK.NewS_FIN_BLAGAJNA_U_GKRow(); this.SetFillParameters(dAT1, dAT2, bLAG); this.AV8DAT1 = DateTimeUtil.ResetTime(dAT1); this.AV9DAT2 = DateTimeUtil.ResetTime(dAT2); this.AV10BLAG = bLAG; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmS_FIN_BLAGAJNA_U_GKSelect2 = this.connDefault.GetCommand("S_FIN_BLAGAJNA_U_GK", true); this.cmS_FIN_BLAGAJNA_U_GKSelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmS_FIN_BLAGAJNA_U_GKSelect2.IDbCommand.Parameters.Clear(); this.cmS_FIN_BLAGAJNA_U_GKSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DAT1", this.AV8DAT1)); this.cmS_FIN_BLAGAJNA_U_GKSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DAT2", this.AV9DAT2)); this.cmS_FIN_BLAGAJNA_U_GKSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@BLAG", this.AV10BLAG)); this.cmS_FIN_BLAGAJNA_U_GKSelect2.ErrorMask |= ErrorMask.Lock; this.S_FIN_BLAGAJNA_U_GKSelect2 = this.cmS_FIN_BLAGAJNA_U_GKSelect2.FetchData(); while (this.cmS_FIN_BLAGAJNA_U_GKSelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmS_FIN_BLAGAJNA_U_GKSelect2.HasMoreRows = this.S_FIN_BLAGAJNA_U_GKSelect2.Read(); } int num = 0; while (this.cmS_FIN_BLAGAJNA_U_GKSelect2.HasMoreRows && (num != maxRows)) { this.rowS_FIN_BLAGAJNA_U_GK["NAZIVVRSTEDOK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["NAZIVVRSTEDOK"]); this.rowS_FIN_BLAGAJNA_U_GK["BLGDATUMDOKUMENTA"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["BLGDATUMDOKUMENTA"]); this.rowS_FIN_BLAGAJNA_U_GK["IDBLGVRSTEDOK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["IDBLGVRSTEDOK"]); this.rowS_FIN_BLAGAJNA_U_GK["OPIS"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["OPIS"]); this.rowS_FIN_BLAGAJNA_U_GK["BLGSTAVKEBLAGAJNEKONTOIDKONTO"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["BLGSTAVKEBLAGAJNEKONTOIDKONTO"]); this.rowS_FIN_BLAGAJNA_U_GK["BLGMTIDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["BLGMTIDMJESTOTROSKA"]); this.rowS_FIN_BLAGAJNA_U_GK["BLGORGJEDIDORGJED"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["BLGORGJEDIDORGJED"]); this.rowS_FIN_BLAGAJNA_U_GK["IZDATAK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["IZDATAK"]); this.rowS_FIN_BLAGAJNA_U_GK["PRIMITAK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_BLAGAJNA_U_GKSelect2["PRIMITAK"]); this.AddRowS_fin_blagajna_u_gk(); num++; this.rowS_FIN_BLAGAJNA_U_GK = this.S_FIN_BLAGAJNA_U_GKSet.S_FIN_BLAGAJNA_U_GK.NewS_FIN_BLAGAJNA_U_GKRow(); this.cmS_FIN_BLAGAJNA_U_GKSelect2.HasMoreRows = this.S_FIN_BLAGAJNA_U_GKSelect2.Read(); } this.S_FIN_BLAGAJNA_U_GKSelect2.Close(); this.Cleanup(); }