public virtual int FillPage(sp_VIRMANIDataSet dataSet, string iDOBRACUN, string zaduzenje, string poreziprirezodvojeno, string pl1, string pl2, string pl3, string vbd, string zrn, string mb, string dd, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.sp_VIRMANISet = dataSet; this.rowsp_VIRMANI = this.sp_VIRMANISet.sp_VIRMANI.Newsp_VIRMANIRow(); this.SetFillParameters(iDOBRACUN, zaduzenje, poreziprirezodvojeno, pl1, pl2, pl3, vbd, zrn, mb, dd); this.AV8IDOBRAC = iDOBRACUN; this.AV9zaduzen = zaduzenje; this.AV10porezi = poreziprirezodvojeno; this.AV11pl1 = pl1; this.AV12pl2 = pl2; this.AV13pl3 = pl3; this.AV14vbd = vbd; this.AV15zrn = zrn; this.AV16mb = mb; this.AV17dd = dd; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmsp_VIRMANISelect2 = this.connDefault.GetCommand("S_VIRMANI", true); this.cmsp_VIRMANISelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Clear(); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", this.AV8IDOBRAC)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@zaduzenje", this.AV9zaduzen)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@poreziprirezodvojeno", this.AV10porezi)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl1", this.AV11pl1)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl2", this.AV12pl2)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@pl3", this.AV13pl3)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vbd", this.AV14vbd)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@zrn", this.AV15zrn)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@mb", this.AV16mb)); this.cmsp_VIRMANISelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@dd", this.AV17dd)); this.cmsp_VIRMANISelect2.ErrorMask |= ErrorMask.Lock; this.sp_VIRMANISelect2 = this.cmsp_VIRMANISelect2.FetchData(); while (this.cmsp_VIRMANISelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmsp_VIRMANISelect2.HasMoreRows = this.sp_VIRMANISelect2.Read(); } int num = 0; while (this.cmsp_VIRMANISelect2.HasMoreRows && (num != maxRows)) { this.rowsp_VIRMANI["SIFRAOBRACUNAVIRMAN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["SIFRAOBRACUNAVIRMAN"]); this.rowsp_VIRMANI["PLA1"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA1"]); this.rowsp_VIRMANI["PLA2"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA2"]); this.rowsp_VIRMANI["PLA3"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PLA3"]); this.rowsp_VIRMANI["BROJRACUNAPLA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["BROJRACUNAPLA"]); this.rowsp_VIRMANI["MODELZADUZENJA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["MODELZADUZENJA"]); this.rowsp_VIRMANI["POZIVZADUZENJA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["POZIVZADUZENJA"]); this.rowsp_VIRMANI["PRI1"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI1"]); this.rowsp_VIRMANI["PRI2"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI2"]); this.rowsp_VIRMANI["PRI3"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["PRI3"]); this.rowsp_VIRMANI["BROJRACUNAPRI"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["BROJRACUNAPRI"]); this.rowsp_VIRMANI["MODELODOBRENJA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["MODELODOBRENJA"]); this.rowsp_VIRMANI["POZIVODOBRENJA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["POZIVODOBRENJA"]); this.rowsp_VIRMANI["SIFRAOPISAPLACANJAVIRMAN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["SIFRAOPISAPLACANJAVIRMAN"]); this.rowsp_VIRMANI["OPISPLACANJAVIRMAN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["OPISPLACANJAVIRMAN"]); this.rowsp_VIRMANI["DATUMVALUTE"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["DATUMVALUTE"]); this.rowsp_VIRMANI["DATUMPODNOSENJA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["DATUMPODNOSENJA"]); this.rowsp_VIRMANI["IZVORDOKUMENTA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["IZVORDOKUMENTA"]); this.rowsp_VIRMANI["OZNACEN"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["OZNACEN"]); this.rowsp_VIRMANI["IZNOS"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["IZNOS"]); this.rowsp_VIRMANI["NAMJENA"] = RuntimeHelpers.GetObjectValue(this.sp_VIRMANISelect2["NAMJENA"]); this.AddRowSp_virmani(); num++; this.rowsp_VIRMANI = this.sp_VIRMANISet.sp_VIRMANI.Newsp_VIRMANIRow(); this.cmsp_VIRMANISelect2.HasMoreRows = this.sp_VIRMANISelect2.Read(); } this.sp_VIRMANISelect2.Close(); this.Cleanup(); }