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();
}
