public void executePrivate(int startRow, int maxRows)
{
this.m_WhereString = "" + this.filterString + " ";
if (maxRows >= 0)
{
if (startRow == 0)
{
this.scmdbuf = "SELECT TOP " + maxRows.ToString() + " TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[MB], TM1.[PARTNERMJESTO], TM1.[PARTNERULICA], TM1.[PARTNEREMAIL], TM1.[PARTNEROIB], TM1.[PARTNERFAX], TM1.[PARTNERTELEFON], TM1.[PARTNERZIRO1], TM1.[PARTNERZIRO2] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.orderString + "";
}
else
{
string[] strArray = new string[] { " SELECT * FROM ( SELECT TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[MB], TM1.[PARTNERMJESTO], TM1.[PARTNERULICA], TM1.[PARTNEREMAIL], TM1.[PARTNEROIB], TM1.[PARTNERFAX], TM1.[PARTNERTELEFON], TM1.[PARTNERZIRO1], TM1.[PARTNERZIRO2], ROW_NUMBER() OVER ( ", this.orderString, " ) AS DK_PAGENUM FROM [PARTNER] TM1 ", this.m_WhereString, " ) AS DK_PAGE WHERE DK_PAGENUM BETWEEN ", (startRow + 1).ToString(), " AND ", (startRow + maxRows).ToString() };
this.scmdbuf = string.Concat(strArray);
}
}
else
{
this.scmdbuf = "SELECT TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[MB], TM1.[PARTNERMJESTO], TM1.[PARTNERULICA], TM1.[PARTNEREMAIL], TM1.[PARTNEROIB], TM1.[PARTNERFAX], TM1.[PARTNERTELEFON], TM1.[PARTNERZIRO1], TM1.[PARTNERZIRO2] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.orderString + " ";
}
this.cmPARTNERSelect2 = this.connDefault.GetCommand(this.scmdbuf, false);
this.cmPARTNERSelect2.ErrorMask |= ErrorMask.Lock;
this.PARTNERSelect2 = this.cmPARTNERSelect2.FetchData();
int num = 0;
while (this.cmPARTNERSelect2.HasMoreRows && (num != maxRows))
{
this.m_IDPARTNER = this.dsDefault.Db.GetInt32(this.PARTNERSelect2, 0, ref this.m__IDPARTNERIsNull);
this.m_NAZIVPARTNER = this.dsDefault.Db.GetString(this.PARTNERSelect2, 1, ref this.m__NAZIVPARTNERIsNull).TrimEnd(new char[] { ' ' });
this.m_MB = this.dsDefault.Db.GetString(this.PARTNERSelect2, 2, ref this.m__MBIsNull);
this.m_PARTNERMJESTO = this.dsDefault.Db.GetString(this.PARTNERSelect2, 3, ref this.m__PARTNERMJESTOIsNull);
this.m_PARTNERULICA = this.dsDefault.Db.GetString(this.PARTNERSelect2, 4, ref this.m__PARTNERULICAIsNull);
this.m_PARTNEREMAIL = this.dsDefault.Db.GetString(this.PARTNERSelect2, 5, ref this.m__PARTNEREMAILIsNull);
this.m_PARTNEROIB = this.dsDefault.Db.GetString(this.PARTNERSelect2, 6, ref this.m__PARTNEROIBIsNull);
this.m_PARTNERFAX = this.dsDefault.Db.GetString(this.PARTNERSelect2, 7, ref this.m__PARTNERFAXIsNull);
this.m_PARTNERTELEFON = this.dsDefault.Db.GetString(this.PARTNERSelect2, 8, ref this.m__PARTNERTELEFONIsNull);
this.m_PARTNERZIRO1 = this.dsDefault.Db.GetString(this.PARTNERSelect2, 9, ref this.m__PARTNERZIRO1IsNull);
this.m_PARTNERZIRO2 = this.dsDefault.Db.GetString(this.PARTNERSelect2, 10, ref this.m__PARTNERZIRO2IsNull);
this.rowPARTNER = this.partnerabecedaSet.PARTNER.NewPARTNERRow();
this.rowPARTNER["IDPARTNER"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDPARTNERIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDPARTNER));
this.rowPARTNER["NAZIVPARTNER"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__NAZIVPARTNERIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_NAZIVPARTNER));
this.rowPARTNER["MB"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__MBIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_MB));
this.rowPARTNER["PARTNERMJESTO"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERMJESTOIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERMJESTO));
this.rowPARTNER["PARTNERULICA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERULICAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERULICA));
this.rowPARTNER["PARTNEREMAIL"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNEREMAILIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNEREMAIL));
this.rowPARTNER["PARTNEROIB"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNEROIBIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNEROIB));
this.rowPARTNER["PARTNERFAX"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERFAXIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERFAX));
this.rowPARTNER["PARTNERTELEFON"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERTELEFONIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERTELEFON));
this.rowPARTNER["PARTNERZIRO1"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERZIRO1IsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERZIRO1));
this.rowPARTNER["PARTNERZIRO2"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERZIRO2IsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERZIRO2));
this.AddRowPartner();
num++;
this.cmPARTNERSelect2.HasMoreRows = this.PARTNERSelect2.Read();
}
this.PARTNERSelect2.Close();
this.Cleanup();
}
public virtual int FillPage(PARTNERDataSet dataSet, int startRow, int maxRows)
{
this.Initialize();
this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction);
this.partnerabecedaSet = dataSet;
this.rowPARTNER = this.partnerabecedaSet.PARTNER.NewPARTNERRow();
this.orderString = GetOrderString(this.Order, true);
this.reverseOrderString = GetOrderString(this.Order, false);
try
{
this.executePrivate(startRow, maxRows);
}
finally
{
this.Cleanup();
}
return(0);
}
