public void executePrivate(int startRow, int maxRows) { this.cmsp_RSOBRAZACSelect2 = this.connDefault.GetCommand("S_RSM_OBRAZAC", true); this.cmsp_RSOBRAZACSelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Clear(); this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", this.AV8IDOBRAC)); this.cmsp_RSOBRAZACSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@dd", this.AV9dd)); this.cmsp_RSOBRAZACSelect2.ErrorMask |= ErrorMask.Lock; this.sp_RSOBRAZACSelect2 = this.cmsp_RSOBRAZACSelect2.FetchData(); while (this.cmsp_RSOBRAZACSelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmsp_RSOBRAZACSelect2.HasMoreRows = this.sp_RSOBRAZACSelect2.Read(); } int num = 0; while (this.cmsp_RSOBRAZACSelect2.HasMoreRows && (num != maxRows)) { this.rowsp_RSOBRAZAC["REDNIBROJ"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["REDNIBROJ"]); this.rowsp_RSOBRAZAC["IDRADNIK"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDRADNIK"]); this.rowsp_RSOBRAZAC["PREZIMEIIME"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["PREZIMEIIME"]); this.rowsp_RSOBRAZAC["MBGOSIGURANIKA"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MBGOSIGURANIKA"]); this.rowsp_RSOBRAZAC["SIFRAGRADARADA"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["SIFRAGRADARADA"]); this.rowsp_RSOBRAZAC["OO"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OO"]); this.rowsp_RSOBRAZAC["B"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["B"]); this.rowsp_RSOBRAZAC["OD"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OD"]); this.rowsp_RSOBRAZAC["DOO"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["DOO"]); this.rowsp_RSOBRAZAC["IZNOSOBRACUNANEPLACERSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSOBRACUNANEPLACERSMB"]); this.rowsp_RSOBRAZAC["IZNOSOSNOVICEZADOPRINOSERSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSOSNOVICEZADOPRINOSERSMB"]); this.rowsp_RSOBRAZAC["IDDOPRINOSMIO1"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDDOPRINOSMIO1"]); this.rowsp_RSOBRAZAC["STOPAMIO1"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["STOPAMIO1"]); this.rowsp_RSOBRAZAC["MIO1RSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MIO1RSMB"]); this.rowsp_RSOBRAZAC["IDDOPRINOSMIO2"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IDDOPRINOSMIO2"]); this.rowsp_RSOBRAZAC["STOPAMIO2"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["STOPAMIO2"]); this.rowsp_RSOBRAZAC["MIO2RSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["MIO2RSMB"]); this.rowsp_RSOBRAZAC["POREZIPRIREZ"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["POREZIPRIREZ"]); this.rowsp_RSOBRAZAC["IZNOSISPLACENEPLACERSMB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["IZNOSISPLACENEPLACERSMB"]); this.rowsp_RSOBRAZAC["OIB"] = RuntimeHelpers.GetObjectValue(this.sp_RSOBRAZACSelect2["OIB"]); this.AddRowSp_rsobrazac(); num++; this.rowsp_RSOBRAZAC = this.sp_RSOBRAZACSet.sp_RSOBRAZAC.Newsp_RSOBRAZACRow(); this.cmsp_RSOBRAZACSelect2.HasMoreRows = this.sp_RSOBRAZACSelect2.Read(); } this.sp_RSOBRAZACSelect2.Close(); this.Cleanup(); }
public virtual int FillPage(sp_RSOBRAZACDataSet dataSet, string iDOBRACUN, short dd, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.sp_RSOBRAZACSet = dataSet; this.rowsp_RSOBRAZAC = this.sp_RSOBRAZACSet.sp_RSOBRAZAC.Newsp_RSOBRAZACRow(); this.SetFillParameters(iDOBRACUN, dd); this.AV8IDOBRAC = iDOBRACUN; this.AV9dd = dd; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }