public V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow AddV_DD_PREGLED_OBRACUNARow(string dDOBRACUNIDOBRACUN, string dDOPISOBRACUN, DateTime dDDATUMOBRACUNA, bool dDZAKLJUCAN, string dDRSM) { V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow row = (V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow) this.NewRow(); row.ItemArray = new object[] { dDOBRACUNIDOBRACUN, dDOPISOBRACUN, dDDATUMOBRACUNA, dDZAKLJUCAN, dDRSM }; this.Rows.Add(row); return(row); }
public virtual int FillPage(V_DD_PREGLED_OBRACUNADataSet dataSet, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.V_DD_PREGLED_OBRACUNASet = dataSet; this.rowV_DD_PREGLED_OBRACUNA = this.V_DD_PREGLED_OBRACUNASet.V_DD_PREGLED_OBRACUNA.NewV_DD_PREGLED_OBRACUNARow(); 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 = "" + this.filterString + " "; if (maxRows >= 0) { if (startRow == 0) { this.scmdbuf = "SELECT TOP " + maxRows.ToString() + " TM1.[DDOBRACUNIDOBRACUN], TM1.[DDOPISOBRACUN], TM1.[DDDATUMOBRACUNA], TM1.[DDZAKLJUCAN], TM1.[DDRSM] FROM [VW_DD_PREGLED_OBRACUNA] TM1" + this.m_WhereString + "" + this.orderString + ""; } else { string[] strArray = new string[] { " SELECT * FROM ( SELECT TM1.[DDOBRACUNIDOBRACUN], TM1.[DDOPISOBRACUN], TM1.[DDDATUMOBRACUNA], TM1.[DDZAKLJUCAN], TM1.[DDRSM], ROW_NUMBER() OVER ( ", this.orderString, " ) AS DK_PAGENUM FROM [VW_DD_PREGLED_OBRACUNA] 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.[DDOBRACUNIDOBRACUN], TM1.[DDOPISOBRACUN], TM1.[DDDATUMOBRACUNA], TM1.[DDZAKLJUCAN], TM1.[DDRSM] FROM [VW_DD_PREGLED_OBRACUNA] TM1" + this.m_WhereString + "" + this.orderString + " "; } this.cmV_DD_PREGLED_OBRACUNASelect2 = this.connDefault.GetCommand(this.scmdbuf, true); this.cmV_DD_PREGLED_OBRACUNASelect2.ErrorMask |= ErrorMask.Lock; this.V_DD_PREGLED_OBRACUNASelect2 = this.cmV_DD_PREGLED_OBRACUNASelect2.FetchData(); int num = 0; while (this.cmV_DD_PREGLED_OBRACUNASelect2.HasMoreRows && (num != maxRows)) { this.m_DDOBRACUNIDOBRACUN = this.dsDefault.Db.GetString(this.V_DD_PREGLED_OBRACUNASelect2, 0, ref this.m__DDOBRACUNIDOBRACUNIsNull); this.m_DDOPISOBRACUN = this.dsDefault.Db.GetString(this.V_DD_PREGLED_OBRACUNASelect2, 1, ref this.m__DDOPISOBRACUNIsNull); this.m_DDDATUMOBRACUNA = this.dsDefault.Db.GetDateTime(this.V_DD_PREGLED_OBRACUNASelect2, 2, ref this.m__DDDATUMOBRACUNAIsNull); this.m_DDZAKLJUCAN = this.dsDefault.Db.GetBoolean(this.V_DD_PREGLED_OBRACUNASelect2, 3, ref this.m__DDZAKLJUCANIsNull); this.m_DDRSM = this.dsDefault.Db.GetString(this.V_DD_PREGLED_OBRACUNASelect2, 4, ref this.m__DDRSMIsNull); this.rowV_DD_PREGLED_OBRACUNA = this.V_DD_PREGLED_OBRACUNASet.V_DD_PREGLED_OBRACUNA.NewV_DD_PREGLED_OBRACUNARow(); this.rowV_DD_PREGLED_OBRACUNA["DDOBRACUNIDOBRACUN"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DDOBRACUNIDOBRACUNIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DDOBRACUNIDOBRACUN)); this.rowV_DD_PREGLED_OBRACUNA["DDOPISOBRACUN"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DDOPISOBRACUNIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DDOPISOBRACUN)); this.rowV_DD_PREGLED_OBRACUNA["DDDATUMOBRACUNA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DDDATUMOBRACUNAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DDDATUMOBRACUNA)); this.rowV_DD_PREGLED_OBRACUNA["DDZAKLJUCAN"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DDZAKLJUCANIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DDZAKLJUCAN)); this.rowV_DD_PREGLED_OBRACUNA["DDRSM"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__DDRSMIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_DDRSM)); this.AddRowV_dd_pregled_obracuna(); num++; this.cmV_DD_PREGLED_OBRACUNASelect2.HasMoreRows = this.V_DD_PREGLED_OBRACUNASelect2.Read(); } this.V_DD_PREGLED_OBRACUNASelect2.Close(); this.Cleanup(); }
public V_DD_PREGLED_OBRACUNARowChangeEvent(V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow row, DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public void RemoveV_DD_PREGLED_OBRACUNARow(V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow row) { this.Rows.Remove(row); }
public void AddV_DD_PREGLED_OBRACUNARow(V_DD_PREGLED_OBRACUNADataSet.V_DD_PREGLED_OBRACUNARow row) { this.Rows.Add(row); }