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