public virtual int FillPage(S_FIN_IZVRSENJE_PLANADataSet dataSet, int iDORGJED, string godina, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_FIN_IZVRSENJE_PLANASet = dataSet;
this.rowS_FIN_IZVRSENJE_PLANA = this.S_FIN_IZVRSENJE_PLANASet.S_FIN_IZVRSENJE_PLANA.NewS_FIN_IZVRSENJE_PLANARow();
this.SetFillParameters(iDORGJED, godina);
this.AV8IDORGJE = iDORGJED;
this.AV9godina = godina;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public virtual int FillPage(S_FIN_FINANCIJSKO_UPRAVLJANJEDataSet dataSet, DateTime rAZDOBLJEOD, DateTime rAZDOBLJEDO, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_FIN_FINANCIJSKO_UPRAVLJANJESet = dataSet;
this.rowS_FIN_FINANCIJSKO_UPRAVLJANJE = this.S_FIN_FINANCIJSKO_UPRAVLJANJESet.S_FIN_FINANCIJSKO_UPRAVLJANJE.NewS_FIN_FINANCIJSKO_UPRAVLJANJERow();
this.SetFillParameters(rAZDOBLJEOD, rAZDOBLJEDO);
this.AV8RAZDOBL = DateTimeUtil.ResetTime(rAZDOBLJEOD);
this.AV9RAZDOBL = DateTimeUtil.ResetTime(rAZDOBLJEDO);
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public virtual int Fill(trazi_partneraDataSet dataSet, string nAZIVPARTNER)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.trazi_partneraSet = dataSet;
this.SetFillParameters(nAZIVPARTNER);
this.AV8NAZIVPA = nAZIVPARTNER;
this.orderString = GetOrderString(this.Order, true);
this.reverseOrderString = GetOrderString(this.Order, false);
try
{
this.executePrivate(0, -1);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount()
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_OS_BROJ_I_DATUMSelect1 = this.connDefault.GetCommand("S_OS_BROJ_I_DATUM", true);
this.cmS_OS_BROJ_I_DATUMSelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_OS_BROJ_I_DATUMSelect1.IDbCommand.Parameters.Clear();
this.cmS_OS_BROJ_I_DATUMSelect1.ErrorMask |= ErrorMask.Lock;
this.S_OS_BROJ_I_DATUMSelect1 = this.cmS_OS_BROJ_I_DATUMSelect1.FetchData();
if (this.S_OS_BROJ_I_DATUMSelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_OS_BROJ_I_DATUMSelect1.GetInt32(0);
}
this.S_OS_BROJ_I_DATUMSelect1.Close();
return(this.m_RecordCount);
}
public virtual int FillPage(trazi_proizvodDataSet dataSet, string nazivproizvod, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.trazi_proizvodSet = dataSet;
this.SetFillParameters(nazivproizvod);
this.AV8nazivpr = nazivproizvod;
this.orderString = GetOrderString(this.Order, true);
this.reverseOrderString = GetOrderString(this.Order, false);
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public virtual int Fill(S_PLACA_RAD1G_IIIDataSet dataSet, string mJESECISPLATE, string gODINAISPLATE)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_PLACA_RAD1G_IIISet = dataSet;
this.rowS_PLACA_RAD1G_III = this.S_PLACA_RAD1G_IIISet.S_PLACA_RAD1G_III.NewS_PLACA_RAD1G_IIIRow();
this.SetFillParameters(mJESECISPLATE, gODINAISPLATE);
this.AV8MJESECI = mJESECISPLATE;
this.AV9GODINAI = gODINAISPLATE;
try
{
this.executePrivate(0, -1);
}
finally
{
this.Cleanup();
}
return(0);
}
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);
}
private int GetInternalRecordCount()
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
string str = " WHERE [AKTIVAN] = 1";
this.scmdbuf = "SELECT COUNT(*) FROM [RADNIK]" + str + " ";
this.cmRADNIKSelect1 = this.connDefault.GetCommand(this.scmdbuf, false);
this.cmRADNIKSelect1.ErrorMask |= ErrorMask.Lock;
this.RADNIKSelect1 = this.cmRADNIKSelect1.FetchData();
if (this.RADNIKSelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.RADNIKSelect1.GetInt32(0);
}
this.RADNIKSelect1.Close();
return(this.m_RecordCount);
}
public IDataReader Open(DateTime rAZDOBLJEOD, DateTime rAZDOBLJEDO, string oRG, string mT, string dOK, short aNA, short sKR, string kLASA, short vRSTABILANCE)
{
this.init_reader();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_FIN_BILANCASelect3 = this.connDefault.GetCommand("S_FIN_BILANCA", true);
this.cmS_FIN_BILANCASelect3.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Clear();
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEOD", rAZDOBLJEOD));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@RAZDOBLJEDO", rAZDOBLJEDO));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ORG", oRG));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@MT", mT));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@DOK", dOK));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@ANA", aNA));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@SKR", sKR));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@KLASA", kLASA));
this.cmS_FIN_BILANCASelect3.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@VRSTABILANCE", vRSTABILANCE));
this.cmS_FIN_BILANCASelect3.ErrorMask |= ErrorMask.Lock;
this.S_FIN_BILANCASelect3 = this.cmS_FIN_BILANCASelect3.ExecuteReader((CommandBehavior)Conversions.ToInteger(Interaction.IIf(this.daCurrentTransaction == null, Configuration.ReaderCommandBehavior, CommandBehavior.Default)));
return(this.S_FIN_BILANCASelect3);
}
private int GetInternalRecordCount(int godina)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1 = this.connDefault.GetCommand("S_FIN_PARTNERI_SA_OTVORENIMA", true);
this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1.IDbCommand.Parameters.Clear();
this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@godina", godina));
this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1.ErrorMask |= ErrorMask.Lock;
this.S_FIN_PARTNERI_SA_OTVORENIMASelect1 = this.cmS_FIN_PARTNERI_SA_OTVORENIMASelect1.FetchData();
if (this.S_FIN_PARTNERI_SA_OTVORENIMASelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_FIN_PARTNERI_SA_OTVORENIMASelect1.GetInt32(0);
}
this.S_FIN_PARTNERI_SA_OTVORENIMASelect1.Close();
return(this.m_RecordCount);
}
public virtual int FillPage(S_OD_BOLOVANJE_FONDDataSet dataSet, string oDD, string dOOO, int idradnik, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_OD_BOLOVANJE_FONDSet = dataSet;
this.rowS_OD_BOLOVANJE_FOND = this.S_OD_BOLOVANJE_FONDSet.S_OD_BOLOVANJE_FOND.NewS_OD_BOLOVANJE_FONDRow();
this.SetFillParameters(oDD, dOOO, idradnik);
this.AV8ODD = oDD;
this.AV9DOOO = dOOO;
this.AV10idradn = idradnik;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public virtual int FillPage(S_FIN_BLAGAJNA_U_GKDataSet dataSet, DateTime dAT1, DateTime dAT2, int bLAG, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_FIN_BLAGAJNA_U_GKSet = dataSet;
this.rowS_FIN_BLAGAJNA_U_GK = this.S_FIN_BLAGAJNA_U_GKSet.S_FIN_BLAGAJNA_U_GK.NewS_FIN_BLAGAJNA_U_GKRow();
this.SetFillParameters(dAT1, dAT2, bLAG);
this.AV8DAT1 = DateTimeUtil.ResetTime(dAT1);
this.AV9DAT2 = DateTimeUtil.ResetTime(dAT2);
this.AV10BLAG = bLAG;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount(int iDDOKUMENT)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmSP_FIN_URAPLACANJESelect1 = this.connDefault.GetCommand("S_FIN_URA_PLACANJE", true);
this.cmSP_FIN_URAPLACANJESelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmSP_FIN_URAPLACANJESelect1.IDbCommand.Parameters.Clear();
this.cmSP_FIN_URAPLACANJESelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDDOKUMENT", iDDOKUMENT));
this.cmSP_FIN_URAPLACANJESelect1.ErrorMask |= ErrorMask.Lock;
this.SP_FIN_URAPLACANJESelect1 = this.cmSP_FIN_URAPLACANJESelect1.FetchData();
if (this.SP_FIN_URAPLACANJESelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.SP_FIN_URAPLACANJESelect1.GetInt32(0);
}
this.SP_FIN_URAPLACANJESelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCount(long invbroj)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_OS_STANJE_LOKACIJASelect1 = this.connDefault.GetCommand("S_OS_STANJE_LOKACIJA", true);
this.cmS_OS_STANJE_LOKACIJASelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_OS_STANJE_LOKACIJASelect1.IDbCommand.Parameters.Clear();
this.cmS_OS_STANJE_LOKACIJASelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@invbroj", invbroj));
this.cmS_OS_STANJE_LOKACIJASelect1.ErrorMask |= ErrorMask.Lock;
this.S_OS_STANJE_LOKACIJASelect1 = this.cmS_OS_STANJE_LOKACIJASelect1.FetchData();
if (this.S_OS_STANJE_LOKACIJASelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_OS_STANJE_LOKACIJASelect1.GetInt32(0);
}
this.S_OS_STANJE_LOKACIJASelect1.Close();
return(this.m_RecordCount);
}
public virtual int Fill(S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIDataSet dataSet, DateTime dATUM, string sORT, int vRSTA)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJISet = dataSet;
this.rowS_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJI = this.S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJISet.S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJI.NewS_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIRow();
this.SetFillParameters(dATUM, sORT, vRSTA);
this.AV8DATUM = DateTimeUtil.ResetTime(dATUM);
this.AV9SORT = sORT;
this.AV10VRSTA = vRSTA;
try
{
this.executePrivate(0, -1);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount()
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
string str = " WHERE T1.[AKTIVNO] = 1";
this.scmdbuf = "SELECT COUNT(*) FROM ((([PARTNERZADUZENJE] T1 INNER JOIN [PROIZVOD] T2 ON T2.[IDPROIZVOD] = T1.[IDPROIZVOD]) INNER JOIN [FINPOREZ] T3 ON T3.[FINPOREZIDPOREZ] = T2.[FINPOREZIDPOREZ]) INNER JOIN [PARTNER] T4 ON T4.[IDPARTNER] = T1.[IDPARTNER])" + str + " ";
this.cmPARTNERZADUZENJESelect1 = this.connDefault.GetCommand(this.scmdbuf, false);
this.cmPARTNERZADUZENJESelect1.ErrorMask |= ErrorMask.Lock;
this.PARTNERZADUZENJESelect1 = this.cmPARTNERZADUZENJESelect1.FetchData();
if (this.PARTNERZADUZENJESelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.PARTNERZADUZENJESelect1.GetInt32(0);
}
this.PARTNERZADUZENJESelect1.Close();
return(this.m_RecordCount);
}
public virtual int FillPage(S_FIN_DNEVNIKBLAGAJNEDataSet dataSet, DateTime dat1, DateTime dat2, int blag, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_FIN_DNEVNIKBLAGAJNESet = dataSet;
this.rowS_FIN_DNEVNIKBLAGAJNE = this.S_FIN_DNEVNIKBLAGAJNESet.S_FIN_DNEVNIKBLAGAJNE.NewS_FIN_DNEVNIKBLAGAJNERow();
this.SetFillParameters(dat1, dat2, blag);
this.AV8dat1 = DateTimeUtil.ResetTime(dat1);
this.AV9dat2 = DateTimeUtil.ResetTime(dat2);
this.AV10blag = blag;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount(string idobracun)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1 = this.connDefault.GetCommand("S_PLACA_KONACNI_POREZ_PO_OPCINAMA", true);
this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1.IDbCommand.Parameters.Clear();
this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idobracun", idobracun));
this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1.ErrorMask |= ErrorMask.Lock;
this.S_OD_KONACNI_POREZ_PO_OPCINAMASelect1 = this.cmS_OD_KONACNI_POREZ_PO_OPCINAMASelect1.FetchData();
if (this.S_OD_KONACNI_POREZ_PO_OPCINAMASelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_OD_KONACNI_POREZ_PO_OPCINAMASelect1.GetInt32(0);
}
this.S_OD_KONACNI_POREZ_PO_OPCINAMASelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCount(string godina)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmsp_ip_zaglavljeSelect1 = this.connDefault.GetCommand("S_PLACA_IP", true);
this.cmsp_ip_zaglavljeSelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmsp_ip_zaglavljeSelect1.IDbCommand.Parameters.Clear();
this.cmsp_ip_zaglavljeSelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@godina", godina));
this.cmsp_ip_zaglavljeSelect1.ErrorMask |= ErrorMask.Lock;
this.sp_ip_zaglavljeSelect1 = this.cmsp_ip_zaglavljeSelect1.FetchData();
if (this.sp_ip_zaglavljeSelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.sp_ip_zaglavljeSelect1.GetInt32(0);
}
this.sp_ip_zaglavljeSelect1.Close();
return(this.m_RecordCount);
}
public virtual int FillPage(S_OS_BILANCA_STANJA_NA_DANDataSet dataSet, DateTime dATUM, string sORT, short vrsta, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_OS_BILANCA_STANJA_NA_DANSet = dataSet;
this.rowS_OS_BILANCA_STANJA_NA_DAN = this.S_OS_BILANCA_STANJA_NA_DANSet.S_OS_BILANCA_STANJA_NA_DAN.NewS_OS_BILANCA_STANJA_NA_DANRow();
this.SetFillParameters(dATUM, sORT, vrsta);
this.AV8DATUM = DateTimeUtil.ResetTime(dATUM);
this.AV9SORT = sORT;
this.AV10vrsta = vrsta;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public virtual int FillPage(S_OD_BOLOVANJE_POSLODAVACDataSet dataSet, string odd, string dooo, int iDRADNIK, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_OD_BOLOVANJE_POSLODAVACSet = dataSet;
this.rowS_OD_BOLOVANJE_POSLODAVAC = this.S_OD_BOLOVANJE_POSLODAVACSet.S_OD_BOLOVANJE_POSLODAVAC.NewS_OD_BOLOVANJE_POSLODAVACRow();
this.SetFillParameters(odd, dooo, iDRADNIK);
this.AV8odd = odd;
this.AV9dooo = dooo;
this.AV10IDRADN = iDRADNIK;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount(string iDOBRACUN)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_OD_REKAP_POSTOTNESelect1 = this.connDefault.GetCommand("S_PLACA_OBUSTAVE_POSTOTNE", true);
this.cmS_OD_REKAP_POSTOTNESelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_OD_REKAP_POSTOTNESelect1.IDbCommand.Parameters.Clear();
this.cmS_OD_REKAP_POSTOTNESelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDOBRACUN", iDOBRACUN));
this.cmS_OD_REKAP_POSTOTNESelect1.ErrorMask |= ErrorMask.Lock;
this.S_OD_REKAP_POSTOTNESelect1 = this.cmS_OD_REKAP_POSTOTNESelect1.FetchData();
if (this.S_OD_REKAP_POSTOTNESelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_OD_REKAP_POSTOTNESelect1.GetInt32(0);
}
this.S_OD_REKAP_POSTOTNESelect1.Close();
return(this.m_RecordCount);
}
public virtual int Fill(S_DD_KRIZNI_POREZDataSet dataSet, string iDOBRACUN, string mJESECISPLATE, string gODINAISPLATE)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_DD_KRIZNI_POREZSet = dataSet;
this.rowS_DD_KRIZNI_POREZ = this.S_DD_KRIZNI_POREZSet.S_DD_KRIZNI_POREZ.NewS_DD_KRIZNI_POREZRow();
this.SetFillParameters(iDOBRACUN, mJESECISPLATE, gODINAISPLATE);
this.AV8IDOBRAC = iDOBRACUN;
this.AV9MJESECI = mJESECISPLATE;
this.AV10GODINA = gODINAISPLATE;
try
{
this.executePrivate(0, -1);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount(string gODINAOBRACUNA)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_PLACA_RAD1G_SATISelect1 = this.connDefault.GetCommand("S_PLACA_RAD1G_SATI", true);
this.cmS_PLACA_RAD1G_SATISelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_PLACA_RAD1G_SATISelect1.IDbCommand.Parameters.Clear();
this.cmS_PLACA_RAD1G_SATISelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@GODINAOBRACUNA", gODINAOBRACUNA));
this.cmS_PLACA_RAD1G_SATISelect1.ErrorMask |= ErrorMask.Lock;
this.S_PLACA_RAD1G_SATISelect1 = this.cmS_PLACA_RAD1G_SATISelect1.FetchData();
if (this.S_PLACA_RAD1G_SATISelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_PLACA_RAD1G_SATISelect1.GetInt32(0);
}
this.S_PLACA_RAD1G_SATISelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCount()
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
string str = " WHERE T1.[IDVRSTAELEMENTA] = 2";
this.scmdbuf = "SELECT COUNT(*) FROM ([ELEMENT] T1 INNER JOIN [VRSTAELEMENT] T2 ON T2.[IDVRSTAELEMENTA] = T1.[IDVRSTAELEMENTA])" + str + " ";
this.cmELEMENTSelect1 = this.connDefault.GetCommand(this.scmdbuf, false);
this.cmELEMENTSelect1.ErrorMask |= ErrorMask.Lock;
this.ELEMENTSelect1 = this.cmELEMENTSelect1.FetchData();
if (this.ELEMENTSelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.ELEMENTSelect1.GetInt32(0);
}
this.ELEMENTSelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCount(int brojdok)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1 = this.connDefault.GetCommand("S_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJA", true);
this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.IDbCommand.Parameters.Clear();
this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@brojdok", brojdok));
this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.ErrorMask |= ErrorMask.Lock;
this.S_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1 = this.cmS_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.FetchData();
if (this.S_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.S_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.GetInt32(0);
}
this.S_OS_PREGLED_AMORTIZACIJE_REKAPITULACIJASelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCount()
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
string str = "";
this.scmdbuf = "SELECT COUNT(*) FROM [VW_PLACA_GODINE_ISPLATE]" + str + " ";
this.cmVW_GODINE_ISPLATESelect1 = this.connDefault.GetCommand(this.scmdbuf, true);
this.cmVW_GODINE_ISPLATESelect1.ErrorMask |= ErrorMask.Lock;
this.VW_GODINE_ISPLATESelect1 = this.cmVW_GODINE_ISPLATESelect1.FetchData();
if (this.VW_GODINE_ISPLATESelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.VW_GODINE_ISPLATESelect1.GetInt32(0);
}
this.VW_GODINE_ISPLATESelect1.Close();
return(this.m_RecordCount);
}
public virtual int FillPage(S_OD_PROSJEK_PLACEDataSet dataSet, string oDD, string dOOO, int iDRADNIK, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.S_OD_PROSJEK_PLACESet = dataSet;
this.rowS_OD_PROSJEK_PLACE = this.S_OD_PROSJEK_PLACESet.S_OD_PROSJEK_PLACE.NewS_OD_PROSJEK_PLACERow();
this.SetFillParameters(oDD, dOOO, iDRADNIK);
this.AV8ODD = oDD;
this.AV9DOOO = dOOO;
this.AV10IDRADN = iDRADNIK;
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
private int GetInternalRecordCount(string idobracun, string vbdibanke)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmsp_diskete_za_bankuSelect1 = this.connDefault.GetCommand("S_PLACA_ISPLATE_ZA_BANKU", true);
this.cmsp_diskete_za_bankuSelect1.IDbCommand.CommandType = CommandType.StoredProcedure;
this.cmsp_diskete_za_bankuSelect1.IDbCommand.Parameters.Clear();
this.cmsp_diskete_za_bankuSelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@idobracun", idobracun));
this.cmsp_diskete_za_bankuSelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@vbdibanke", vbdibanke));
this.cmsp_diskete_za_bankuSelect1.ErrorMask |= ErrorMask.Lock;
this.sp_diskete_za_bankuSelect1 = this.cmsp_diskete_za_bankuSelect1.FetchData();
if (this.sp_diskete_za_bankuSelect1.IsDBNull(0))
{
this.m_RecordCount = 0;
}
else
{
this.m_RecordCount = this.sp_diskete_za_bankuSelect1.GetInt32(0);
}
this.sp_diskete_za_bankuSelect1.Close();
return(this.m_RecordCount);
}
private int GetInternalRecordCountByIDRADNIK(int iDRADNIK)
{
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.cmGOOBRACUNSelect1 = this.connDefault.GetCommand("SELECT COUNT(*) FROM [GOOBRACUN] WITH (NOLOCK) WHERE [IDRADNIK] = @IDRADNIK ", false);
if (this.cmGOOBRACUNSelect1.IDbCommand.Parameters.Count == 0)
{
this.cmGOOBRACUNSelect1.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@IDRADNIK", DbType.Int32));
}
this.cmGOOBRACUNSelect1.SetParameter(0, iDRADNIK);
this.GOOBRACUNSelect1 = this.cmGOOBRACUNSelect1.FetchData();
if (this.GOOBRACUNSelect1.IsDBNull(0))
{
this.recordCount = 0;
}
else
{
this.recordCount = this.GOOBRACUNSelect1.GetInt32(0);
}
this.GOOBRACUNSelect1.Close();
return(this.recordCount);
}
