public virtual int FillPage(S_OS_BILANCA_STANJA_NA_DANDataSet dataSet, DateTime dATUM, string sORT, short vrsta, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.S_OS_BILANCA_STANJA_NA_DANSet = dataSet; this.rowS_OS_BILANCA_STANJA_NA_DAN = this.S_OS_BILANCA_STANJA_NA_DANSet.S_OS_BILANCA_STANJA_NA_DAN.NewS_OS_BILANCA_STANJA_NA_DANRow(); this.SetFillParameters(dATUM, sORT, vrsta); this.AV8DATUM = DateTimeUtil.ResetTime(dATUM); this.AV9SORT = sORT; this.AV10vrsta = vrsta; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmS_OS_BILANCA_STANJA_NA_DANSelect2 = this.connDefault.GetCommand("S_OS_BILANCA_STANJA_NA_DAN", true); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Clear(); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DATUM", this.AV8DATUM)); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@SORT", this.AV9SORT)); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vrsta", this.AV10vrsta)); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.ErrorMask |= ErrorMask.Lock; this.S_OS_BILANCA_STANJA_NA_DANSelect2 = this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.FetchData(); while (this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows = this.S_OS_BILANCA_STANJA_NA_DANSelect2.Read(); } int num = 0; while (this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows && (num != maxRows)) { this.rowS_OS_BILANCA_STANJA_NA_DAN["NAZIVOS"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["NAZIVOS"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["INVBROJ"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["INVBROJ"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["KOLICINA"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KOLICINA"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["NABAVNA"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["NABAVNA"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["ISPRAVAK"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["ISPRAVAK"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["SADASNJA"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["SADASNJA"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["KTOISPRAVKAIDKONTO"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTOISPRAVKAIDKONTO"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["KTONABAVKEIDKONTO"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTONABAVKEIDKONTO"]); this.rowS_OS_BILANCA_STANJA_NA_DAN["KTOIZVORAIDKONTO"] = RuntimeHelpers.GetObjectValue(this.S_OS_BILANCA_STANJA_NA_DANSelect2["KTOIZVORAIDKONTO"]); this.AddRowS_os_bilanca_stanja_na_dan(); num++; this.rowS_OS_BILANCA_STANJA_NA_DAN = this.S_OS_BILANCA_STANJA_NA_DANSet.S_OS_BILANCA_STANJA_NA_DAN.NewS_OS_BILANCA_STANJA_NA_DANRow(); this.cmS_OS_BILANCA_STANJA_NA_DANSelect2.HasMoreRows = this.S_OS_BILANCA_STANJA_NA_DANSelect2.Read(); } this.S_OS_BILANCA_STANJA_NA_DANSelect2.Close(); this.Cleanup(); }