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