public virtual int FillPage(S_FIN_KARTICEPARTNERADataSet dataSet, int oRG, int mT, int dOK, DateTime rAZDOBLJEOD, DateTime rAZDOBLJEDO, string pOCETNIKONTO, string zAVRSNIKONTO, int iDAKTIVNOST, int iDPARTNER, string sORT, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.S_FIN_KARTICEPARTNERASet = dataSet; this.rowS_FIN_KARTICEPARTNERA = this.S_FIN_KARTICEPARTNERASet.S_FIN_KARTICEPARTNERA.NewS_FIN_KARTICEPARTNERARow(); this.SetFillParameters(oRG, mT, dOK, rAZDOBLJEOD, rAZDOBLJEDO, pOCETNIKONTO, zAVRSNIKONTO, iDAKTIVNOST, iDPARTNER, sORT); this.AV8ORG = oRG; this.AV9MT = mT; this.AV10DOK = dOK; this.AV11RAZDOB = DateTimeUtil.ResetTime(rAZDOBLJEOD); this.AV12RAZDOB = DateTimeUtil.ResetTime(rAZDOBLJEDO); this.AV13POCETN = pOCETNIKONTO; this.AV14ZAVRSN = zAVRSNIKONTO; this.AV15IDAKTI = iDAKTIVNOST; this.AV16IDPART = iDPARTNER; this.AV17SORT = sORT; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmS_FIN_KARTICEPARTNERASelect2 = this.connDefault.GetCommand("S_FIN_KARTICE_PARTNERA", true); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Clear(); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ORG", this.AV8ORG)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@MT", this.AV9MT)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DOK", this.AV10DOK)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEOD", this.AV11RAZDOB)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEDO", this.AV12RAZDOB)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@POCETNIKONTO", this.AV13POCETN)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ZAVRSNIKONTO", this.AV14ZAVRSN)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDAKTIVNOST", this.AV15IDAKTI)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDPARTNER", this.AV16IDPART)); this.cmS_FIN_KARTICEPARTNERASelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@SORT", this.AV17SORT)); this.cmS_FIN_KARTICEPARTNERASelect2.ErrorMask |= ErrorMask.Lock; this.S_FIN_KARTICEPARTNERASelect2 = this.cmS_FIN_KARTICEPARTNERASelect2.FetchData(); while (this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows = this.S_FIN_KARTICEPARTNERASelect2.Read(); } int num = 0; while (this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows && (num != maxRows)) { this.rowS_FIN_KARTICEPARTNERA["duguje"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DUGUJE"]); this.rowS_FIN_KARTICEPARTNERA["POTRAZUJE"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["POTRAZUJE"]); this.rowS_FIN_KARTICEPARTNERA["konto"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["KONTO"]); this.rowS_FIN_KARTICEPARTNERA["DATUMDVO"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMDVO"]); this.rowS_FIN_KARTICEPARTNERA["DATUMVALUTE"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMVALUTE"]); this.rowS_FIN_KARTICEPARTNERA["DATUMDOK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["DATUMDOK"]); this.rowS_FIN_KARTICEPARTNERA["SKRACENI"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["SKRACENI"]); this.rowS_FIN_KARTICEPARTNERA["BROJDOK"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["BROJDOK"]); this.rowS_FIN_KARTICEPARTNERA["BROJSTAVKE"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["BROJSTAVKE"]); this.rowS_FIN_KARTICEPARTNERA["OPISKNJIZENJA"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["OPISKNJIZENJA"]); this.rowS_FIN_KARTICEPARTNERA["IDPARTNER"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDPARTNER"]); this.rowS_FIN_KARTICEPARTNERA["NAZIVKONTO"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVKONTO"]); this.rowS_FIN_KARTICEPARTNERA["IDDOKUMENT"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDDOKUMENT"]); this.rowS_FIN_KARTICEPARTNERA["NAZIVPARTNER"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVPARTNER"]); this.rowS_FIN_KARTICEPARTNERA["IDORGJED"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDORGJED"]); this.rowS_FIN_KARTICEPARTNERA["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["IDMJESTOTROSKA"]); this.rowS_FIN_KARTICEPARTNERA["MB"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["MB"]); this.rowS_FIN_KARTICEPARTNERA["PARTNERMJESTO"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["PARTNERMJESTO"]); this.rowS_FIN_KARTICEPARTNERA["PARTNERULICA"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["PARTNERULICA"]); this.rowS_FIN_KARTICEPARTNERA["ORIGINALNIDOKUMENT"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["ORIGINALNIDOKUMENT"]); this.rowS_FIN_KARTICEPARTNERA["NAZIVOJ"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVOJ"]); this.rowS_FIN_KARTICEPARTNERA["NAZIVMT"] = RuntimeHelpers.GetObjectValue(this.S_FIN_KARTICEPARTNERASelect2["NAZIVMT"]); this.AddRowS_fin_karticepartnera(); num++; this.rowS_FIN_KARTICEPARTNERA = this.S_FIN_KARTICEPARTNERASet.S_FIN_KARTICEPARTNERA.NewS_FIN_KARTICEPARTNERARow(); this.cmS_FIN_KARTICEPARTNERASelect2.HasMoreRows = this.S_FIN_KARTICEPARTNERASelect2.Read(); } this.S_FIN_KARTICEPARTNERASelect2.Close(); this.Cleanup(); }