public virtual int FillPage(sp_maticni_kartonDataSet dataSet, string godina, int idradnik_od, int idradnik_do, bool zbirni, bool ukljucenobruto, bool ukljucenodoprinosiiz, bool ukljucenodoprinosina, bool ukljucenoporezi, bool ukljucenooo, bool ukljucenoobustave, bool ukljucenoolaksice, bool ukljucenonetoplaca, bool ukljucenonetonaknade, bool ukljucenoisplata, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.sp_maticni_kartonSet = dataSet; this.rowsp_maticni_karton = this.sp_maticni_kartonSet.sp_maticni_karton.Newsp_maticni_kartonRow(); this.SetFillParameters(godina, idradnik_od, idradnik_do, zbirni, ukljucenobruto, ukljucenodoprinosiiz, ukljucenodoprinosina, ukljucenoporezi, ukljucenooo, ukljucenoobustave, ukljucenoolaksice, ukljucenonetoplaca, ukljucenonetonaknade, ukljucenoisplata); this.AV8godina = godina; this.AV9idradni = idradnik_od; this.AV10idradn = idradnik_do; this.AV11zbirni = zbirni; this.AV12ukljuc = ukljucenobruto; this.AV13ukljuc = ukljucenodoprinosiiz; this.AV14ukljuc = ukljucenodoprinosina; this.AV15ukljuc = ukljucenoporezi; this.AV16ukljuc = ukljucenooo; this.AV17ukljuc = ukljucenoobustave; this.AV18ukljuc = ukljucenoolaksice; this.AV19ukljuc = ukljucenonetoplaca; this.AV20ukljuc = ukljucenonetonaknade; this.AV21ukljuc = ukljucenoisplata; try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
public void executePrivate(int startRow, int maxRows) { this.cmsp_maticni_kartonSelect2 = this.connDefault.GetCommand("S_PLACA_MATICNI_KARTON_ZAPOSLENIKA_ILI_USTANOVE", true); this.cmsp_maticni_kartonSelect2.IDbCommand.CommandType = CommandType.StoredProcedure; this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Clear(); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@godina", this.AV8godina)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idradnik_od", this.AV9idradni)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idradnik_do", this.AV10idradn)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@zbirni", this.AV11zbirni)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenobruto", this.AV12ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenodoprinosiiz", this.AV13ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenodoprinosina", this.AV14ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenoporezi", this.AV15ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenooo", this.AV16ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenoobustave", this.AV17ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenoolaksice", this.AV18ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenonetoplaca", this.AV19ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenonetonaknade", this.AV20ukljuc)); this.cmsp_maticni_kartonSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ukljucenoisplata", this.AV21ukljuc)); this.cmsp_maticni_kartonSelect2.ErrorMask |= ErrorMask.Lock; this.sp_maticni_kartonSelect2 = this.cmsp_maticni_kartonSelect2.FetchData(); while (this.cmsp_maticni_kartonSelect2.HasMoreRows && (startRow > 0)) { startRow--; this.cmsp_maticni_kartonSelect2.HasMoreRows = this.sp_maticni_kartonSelect2.Read(); } int num = 0; while (this.cmsp_maticni_kartonSelect2.HasMoreRows && (num != maxRows)) { this.rowsp_maticni_karton["tip"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["tip"]); this.rowsp_maticni_karton["opistip"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["opistip"]); this.rowsp_maticni_karton["vrstavrij"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["vrstavrij"]); this.rowsp_maticni_karton["IDRADNIK"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["idradnik"]); this.rowsp_maticni_karton["PREZIME"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["prezime"]); this.rowsp_maticni_karton["IME"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["ime"]); this.rowsp_maticni_karton["JMBG"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["jmbg"]); this.rowsp_maticni_karton["idpodatka"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["idpodatka"]); this.rowsp_maticni_karton["nazivpodatka"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["nazivpodatka"]); this.rowsp_maticni_karton["mj01"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj01"]); this.rowsp_maticni_karton["mj02"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj02"]); this.rowsp_maticni_karton["mj03"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj03"]); this.rowsp_maticni_karton["mj04"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj04"]); this.rowsp_maticni_karton["mj05"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj05"]); this.rowsp_maticni_karton["mj06"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj06"]); this.rowsp_maticni_karton["mj07"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj07"]); this.rowsp_maticni_karton["mj08"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj08"]); this.rowsp_maticni_karton["mj09"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj09"]); this.rowsp_maticni_karton["mj10"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj10"]); this.rowsp_maticni_karton["mj11"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj11"]); this.rowsp_maticni_karton["mj12"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["mj12"]); this.rowsp_maticni_karton["UKUPNO"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["ukupno"]); this.rowsp_maticni_karton["sati01"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati01"]); this.rowsp_maticni_karton["sati02"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati02"]); this.rowsp_maticni_karton["sati03"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati03"]); this.rowsp_maticni_karton["sati04"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati04"]); this.rowsp_maticni_karton["sati05"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati05"]); this.rowsp_maticni_karton["sati06"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati06"]); this.rowsp_maticni_karton["sati07"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati07"]); this.rowsp_maticni_karton["sati08"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati08"]); this.rowsp_maticni_karton["sati09"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati09"]); this.rowsp_maticni_karton["sati10"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati10"]); this.rowsp_maticni_karton["sati11"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati11"]); this.rowsp_maticni_karton["sati12"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["sati12"]); this.rowsp_maticni_karton["ukupnosati"] = RuntimeHelpers.GetObjectValue(this.sp_maticni_kartonSelect2["ukupnosati"]); this.AddRowSp_maticni_karton(); num++; this.rowsp_maticni_karton = this.sp_maticni_kartonSet.sp_maticni_karton.Newsp_maticni_kartonRow(); this.cmsp_maticni_kartonSelect2.HasMoreRows = this.sp_maticni_kartonSelect2.Read(); } this.sp_maticni_kartonSelect2.Close(); this.Cleanup(); }