public trazi_partneraDataSet.PARTNERRow AddPARTNERRow(int iDPARTNER, string nAZIVPARTNER, string pARTNERMJESTO, string pARTNEREMAIL, string pARTNERULICA, string mB, string pARTNEROIB, string pT)
{
trazi_partneraDataSet.PARTNERRow row = (trazi_partneraDataSet.PARTNERRow) this.NewRow();
row.ItemArray = new object[] { iDPARTNER, nAZIVPARTNER, pARTNERMJESTO, pARTNEREMAIL, pARTNERULICA, mB, pARTNEROIB, pT };
this.Rows.Add(row);
return(row);
}
public void RemovePARTNERRow(trazi_partneraDataSet.PARTNERRow row)
{
this.Rows.Remove(row);
}
public PARTNERRowChangeEvent(trazi_partneraDataSet.PARTNERRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void AddPARTNERRow(trazi_partneraDataSet.PARTNERRow row)
{
this.Rows.Add(row);
}
public void executePrivate(int startRow, int maxRows)
{
this.m_WhereString = " WHERE " + this.filterString + " TM1.[NAZIVPARTNER] like '%' + @NAZIVPARTNER + '%'";
if (maxRows >= 0)
{
if (startRow == 0)
{
this.scmdbuf = "SELECT TOP " + maxRows.ToString() + " TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[PARTNERMJESTO], TM1.[PARTNEREMAIL], TM1.[PARTNERULICA], TM1.[MB], TM1.[PARTNEROIB] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.orderString + "";
}
else
{
if (string.Compare(this.m_WhereString.TrimEnd(new char[] { ' ' }), "".TrimEnd(new char[] { ' ' }), false, CultureInfo.CurrentCulture) == 0)
{
this.sWhereSep = " WHERE ";
}
else
{
this.sWhereSep = " AND ";
}
int internalRecordCount = this.GetInternalRecordCount(this.AV8NAZIVPA);
this.m_TopRowCount = Conversions.ToInteger(Interaction.IIf(internalRecordCount >= (startRow + maxRows), maxRows, RuntimeHelpers.GetObjectValue(Interaction.IIf(internalRecordCount >= startRow, internalRecordCount - startRow, 0))));
if (this.m_TopRowCount == 0)
{
return;
}
this.scmdbuf = "SELECT TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[PARTNERMJESTO], TM1.[PARTNEREMAIL], TM1.[PARTNERULICA], TM1.[MB], TM1.[PARTNEROIB] FROM [PARTNER] TM1 WHERE TM1.[IDPARTNER] IN ( SELECT TOP " + maxRows.ToString() + " TM1.[IDPARTNER] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.sWhereSep + "TM1.[IDPARTNER] NOT IN ( SELECT TOP " + startRow.ToString() + " TM1.[IDPARTNER] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.orderString + ")" + this.orderString + ")" + this.orderString + "";
}
}
else
{
this.scmdbuf = "SELECT TM1.[IDPARTNER], TM1.[NAZIVPARTNER], TM1.[PARTNERMJESTO], TM1.[PARTNEREMAIL], TM1.[PARTNERULICA], TM1.[MB], TM1.[PARTNEROIB] FROM [PARTNER] TM1" + this.m_WhereString + "" + this.orderString + " ";
}
this.cmPARTNERSelect2 = this.connDefault.GetCommand(this.scmdbuf, false);
if (this.cmPARTNERSelect2.IDbCommand.Parameters.Count == 0)
{
this.cmPARTNERSelect2.IDbCommand.Parameters.Add(this.dsDefault.GetDbParameter("@NAZIVPARTNER", DbType.String, 100));
}
this.lV8NAZIVPA = StringUtil.PadRight(StringUtil.RTrim(this.AV8NAZIVPA), 100, "%");
this.cmPARTNERSelect2.SetParameter(0, this.lV8NAZIVPA);
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_PARTNERMJESTO = this.dsDefault.Db.GetString(this.PARTNERSelect2, 2, ref this.m__PARTNERMJESTOIsNull);
this.m_PARTNEREMAIL = this.dsDefault.Db.GetString(this.PARTNERSelect2, 3, ref this.m__PARTNEREMAILIsNull);
this.m_PARTNERULICA = this.dsDefault.Db.GetString(this.PARTNERSelect2, 4, ref this.m__PARTNERULICAIsNull);
this.m_MB = this.dsDefault.Db.GetString(this.PARTNERSelect2, 5, ref this.m__MBIsNull);
this.m_PARTNEROIB = this.dsDefault.Db.GetString(this.PARTNERSelect2, 6, ref this.m__PARTNEROIBIsNull);
this.m_PT = this.m_NAZIVPARTNER + " | " + NumberUtil.ToString((long)this.m_IDPARTNER, "");
this.rowPARTNER = this.trazi_partneraSet.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["PARTNERMJESTO"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERMJESTOIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERMJESTO));
this.rowPARTNER["PARTNEREMAIL"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNEREMAILIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNEREMAIL));
this.rowPARTNER["PARTNERULICA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNERULICAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNERULICA));
this.rowPARTNER["MB"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__MBIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_MB));
this.rowPARTNER["PARTNEROIB"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PARTNEROIBIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PARTNEROIB));
this.rowPARTNER.PT = this.m_PT;
this.AddRowPartner();
num++;
this.cmPARTNERSelect2.HasMoreRows = this.PARTNERSelect2.Read();
}
this.PARTNERSelect2.Close();
this.Cleanup();
}
