public virtual int FillPage(PREGLEDZADUZENJADataSet dataSet, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.PREGLEDZADUZENJASet = dataSet;
this.rowPARTNERZADUZENJE = this.PREGLEDZADUZENJASet.PARTNERZADUZENJE.NewPARTNERZADUZENJERow();
this.orderString = GetOrderString(this.Order, true);
this.reverseOrderString = GetOrderString(this.Order, false);
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
public void executePrivate(int startRow, int maxRows)
{
this.m_WhereString = " WHERE " + this.filterString + " T1.[AKTIVNO] = 1";
if (maxRows >= 0)
{
if (startRow == 0)
{
this.scmdbuf = "SELECT TOP " + maxRows.ToString() + " T1.[IDPARTNER], T4.[NAZIVPARTNER], T4.[PARTNEROIB], T2.[NAZIVPROIZVOD], T1.[IDPROIZVOD], T1.[IDZADUZENJE], T1.[KOLICINAZADUZENJA], T1.[CIJENAZADUZENJA], T3.[FINPOREZSTOPA], T1.[RABATZADUZENJA], T1.[UGOVORBROJ], T1.[DATUMUGOVORA], T1.[AKTIVNO], T2.[FINPOREZIDPOREZ] 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])" + this.m_WhereString + "" + this.orderString + "";
}
else
{
string[] strArray = new string[] { "SELECT TOP ", (startRow + maxRows).ToString(), " T1.[IDPARTNER], T4.[NAZIVPARTNER], T4.[PARTNEROIB], T2.[NAZIVPROIZVOD], T1.[IDPROIZVOD], T1.[IDZADUZENJE], T1.[KOLICINAZADUZENJA], T1.[CIJENAZADUZENJA], T3.[FINPOREZSTOPA], T1.[RABATZADUZENJA], T1.[UGOVORBROJ], T1.[DATUMUGOVORA], T1.[AKTIVNO], T2.[FINPOREZIDPOREZ] 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])", this.m_WhereString, "", this.orderString, "" };
this.scmdbuf = string.Concat(strArray);
}
}
else
{
this.scmdbuf = "SELECT T1.[IDPARTNER], T4.[NAZIVPARTNER], T4.[PARTNEROIB], T2.[NAZIVPROIZVOD], T1.[IDPROIZVOD], T1.[IDZADUZENJE], T1.[KOLICINAZADUZENJA], T1.[CIJENAZADUZENJA], T3.[FINPOREZSTOPA], T1.[RABATZADUZENJA], T1.[UGOVORBROJ], T1.[DATUMUGOVORA], T1.[AKTIVNO], T2.[FINPOREZIDPOREZ] 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])" + this.m_WhereString + "" + this.orderString + " ";
}
this.cmPARTNERZADUZENJESelect2 = this.connDefault.GetCommand(this.scmdbuf, false);
this.cmPARTNERZADUZENJESelect2.ErrorMask |= ErrorMask.Lock;
this.PARTNERZADUZENJESelect2 = this.cmPARTNERZADUZENJESelect2.FetchData();
while (this.cmPARTNERZADUZENJESelect2.HasMoreRows && (startRow > 0))
{
startRow--;
this.cmPARTNERZADUZENJESelect2.HasMoreRows = this.PARTNERZADUZENJESelect2.Read();
}
int num = 0;
while (this.cmPARTNERZADUZENJESelect2.HasMoreRows && (num != maxRows))
{
this.m_IDPARTNER = this.dsDefault.Db.GetInt32(this.PARTNERZADUZENJESelect2, 0, ref this.m__IDPARTNERIsNull);
this.m_NAZIVPARTNER = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 1, ref this.m__NAZIVPARTNERIsNull).TrimEnd(new char[] { ' ' });
this.m_PARTNEROIB = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 2, ref this.m__PARTNEROIBIsNull);
this.m_NAZIVPROIZVOD = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 3, ref this.m__NAZIVPROIZVODIsNull);
this.m_IDPROIZVOD = this.dsDefault.Db.GetInt32(this.PARTNERZADUZENJESelect2, 4, ref this.m__IDPROIZVODIsNull);
this.m_IDZADUZENJE = this.dsDefault.Db.GetInt32(this.PARTNERZADUZENJESelect2, 5, ref this.m__IDZADUZENJEIsNull);
this.m_KOLICINAZADUZENJA = this.dsDefault.Db.GetDecimal(this.PARTNERZADUZENJESelect2, 6, ref this.m__KOLICINAZADUZENJAIsNull);
this.m_CIJENAZADUZENJA = this.dsDefault.Db.GetDecimal(this.PARTNERZADUZENJESelect2, 7, ref this.m__CIJENAZADUZENJAIsNull);
this.m_FINPOREZSTOPA = this.dsDefault.Db.GetDecimal(this.PARTNERZADUZENJESelect2, 8, ref this.m__FINPOREZSTOPAIsNull);
this.m_RABATZADUZENJA = this.dsDefault.Db.GetDecimal(this.PARTNERZADUZENJESelect2, 9, ref this.m__RABATZADUZENJAIsNull);
this.m_UGOVORBROJ = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 10, ref this.m__UGOVORBROJIsNull);
this.m_DATUMUGOVORA = this.dsDefault.Db.GetDateTime(this.PARTNERZADUZENJESelect2, 11, ref this.m__DATUMUGOVORAIsNull);
this.m_AKTIVNO = this.dsDefault.Db.GetBoolean(this.PARTNERZADUZENJESelect2, 12, ref this.m__AKTIVNOIsNull);
this.m_FINPOREZIDPOREZ = this.dsDefault.Db.GetInt32(this.PARTNERZADUZENJESelect2, 13, ref this.m__FINPOREZIDPOREZIsNull);
this.m_NAZIVPROIZVOD = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 3, ref this.m__NAZIVPROIZVODIsNull);
this.m_FINPOREZIDPOREZ = this.dsDefault.Db.GetInt32(this.PARTNERZADUZENJESelect2, 13, ref this.m__FINPOREZIDPOREZIsNull);
this.m_FINPOREZSTOPA = this.dsDefault.Db.GetDecimal(this.PARTNERZADUZENJESelect2, 8, ref this.m__FINPOREZSTOPAIsNull);
this.m_NAZIVPARTNER = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 1, ref this.m__NAZIVPARTNERIsNull).TrimEnd(new char[] { ' ' });
this.m_PARTNEROIB = this.dsDefault.Db.GetString(this.PARTNERZADUZENJESelect2, 2, ref this.m__PARTNEROIBIsNull);
this.m_IZNOSZADUZENJA = decimal.Multiply(this.m_CIJENAZADUZENJA, this.m_KOLICINAZADUZENJA);
if (!this.m__IZNOSZADUZENJAIsNull)
{
this.m_IZNOSRABATAZADUZENJE = DB.RoundUP(decimal.Divide(decimal.Multiply(this.m_IZNOSZADUZENJA, this.m_RABATZADUZENJA), 100M));
}
if (!this.m__IZNOSZADUZENJAIsNull && !this.m__IZNOSRABATAZADUZENJEIsNull)
{
this.m_CIJENAZAFAKTURU = decimal.Subtract(this.m_IZNOSZADUZENJA, this.m_IZNOSRABATAZADUZENJE);
}
this.rowPARTNERZADUZENJE = this.PREGLEDZADUZENJASet.PARTNERZADUZENJE.NewPARTNERZADUZENJERow();
this.rowPARTNERZADUZENJE["IDPARTNER"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDPARTNERIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDPARTNER));
this.rowPARTNERZADUZENJE["NAZIVPARTNER"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__NAZIVPARTNERIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_NAZIVPARTNER));
this.rowPARTNERZADUZENJE["PARTNEROIB"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNEROIBIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNEROIB));
this.rowPARTNERZADUZENJE["NAZIVPROIZVOD"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__NAZIVPROIZVODIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_NAZIVPROIZVOD));
this.rowPARTNERZADUZENJE["IDPROIZVOD"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDPROIZVODIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDPROIZVOD));
this.rowPARTNERZADUZENJE["IDZADUZENJE"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDZADUZENJEIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDZADUZENJE));
this.rowPARTNERZADUZENJE["KOLICINAZADUZENJA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__KOLICINAZADUZENJAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_KOLICINAZADUZENJA));
this.rowPARTNERZADUZENJE["CIJENAZADUZENJA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__CIJENAZADUZENJAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_CIJENAZADUZENJA));
this.rowPARTNERZADUZENJE["FINPOREZSTOPA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__FINPOREZSTOPAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_FINPOREZSTOPA));
this.rowPARTNERZADUZENJE.IZNOSZADUZENJA = this.m_IZNOSZADUZENJA;
this.rowPARTNERZADUZENJE["RABATZADUZENJA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__RABATZADUZENJAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_RABATZADUZENJA));
this.rowPARTNERZADUZENJE.IZNOSRABATAZADUZENJE = this.m_IZNOSRABATAZADUZENJE;
this.rowPARTNERZADUZENJE.CIJENAZAFAKTURU = this.m_CIJENAZAFAKTURU;
this.rowPARTNERZADUZENJE["UGOVORBROJ"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__UGOVORBROJIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_UGOVORBROJ));
this.rowPARTNERZADUZENJE["DATUMUGOVORA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DATUMUGOVORAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DATUMUGOVORA));
this.rowPARTNERZADUZENJE["AKTIVNO"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__AKTIVNOIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_AKTIVNO));
this.AddRowPartnerzaduzenje();
num++;
this.cmPARTNERZADUZENJESelect2.HasMoreRows = this.PARTNERZADUZENJESelect2.Read();
}
this.PARTNERZADUZENJESelect2.Close();
this.Cleanup();
}