private void LoadDataDokument(int maxRows) { int num = 0; if (this.RcdFound184 != 0) { this.ScanLoadDokument(); while ((this.RcdFound184 != 0) && (num != maxRows)) { num++; this.LoadRowDokument(); this.CreateNewRowDokument(); this.ScanNextDokument(); } } if (num > 0) { this.RcdFound184 = 1; } this.ScanEndDokument(); if (this.DOKUMENTSet.DOKUMENT.Count > 0) { this.rowDOKUMENT = this.DOKUMENTSet.DOKUMENT[this.DOKUMENTSet.DOKUMENT.Count - 1]; } }
public DOKUMENTDataSet.DOKUMENTRow AddDOKUMENTRow(int iDDOKUMENT, string nAZIVDOKUMENT, int iDTIPDOKUMENTA, bool pS) { DOKUMENTDataSet.DOKUMENTRow row = (DOKUMENTDataSet.DOKUMENTRow) this.NewRow(); row["IDDOKUMENT"] = iDDOKUMENT; row["NAZIVDOKUMENT"] = nAZIVDOKUMENT; row["IDTIPDOKUMENTA"] = iDTIPDOKUMENTA; row["PS"] = pS; this.Rows.Add(row); return(row); }
private void LoadByIDTIPDOKUMENTA(int startRow, int maxRows) { bool enforceConstraints = this.DOKUMENTSet.EnforceConstraints; this.DOKUMENTSet.DOKUMENT.BeginLoadData(); this.ScanByIDTIPDOKUMENTA(startRow, maxRows); this.DOKUMENTSet.DOKUMENT.EndLoadData(); this.DOKUMENTSet.EnforceConstraints = enforceConstraints; if (this.DOKUMENTSet.DOKUMENT.Count > 0) { this.rowDOKUMENT = this.DOKUMENTSet.DOKUMENT[this.DOKUMENTSet.DOKUMENT.Count - 1]; } }
public void executePrivate(int startRow, int maxRows) { this.m_WhereString = " WHERE " + this.filterString + " TM1.[IDTIPDOKUMENTA] = 2"; if (maxRows >= 0) { if (startRow == 0) { this.scmdbuf = "SELECT TOP " + maxRows.ToString() + " TM1.[IDDOKUMENT], TM1.[NAZIVDOKUMENT], TM1.[IDTIPDOKUMENTA], T2.[NAZIVTIPDOKUMENTA], TM1.[PS] FROM ([DOKUMENT] TM1 INNER JOIN [TIPDOKUMENTA] T2 ON T2.[IDTIPDOKUMENTA] = TM1.[IDTIPDOKUMENTA])" + this.m_WhereString + "" + this.orderString + ""; } else { string[] strArray = new string[] { " SELECT * FROM ( SELECT TM1.[IDDOKUMENT], TM1.[NAZIVDOKUMENT], TM1.[IDTIPDOKUMENTA], T2.[NAZIVTIPDOKUMENTA], TM1.[PS], ROW_NUMBER() OVER ( ", this.orderString, " ) AS DK_PAGENUM FROM ([DOKUMENT] TM1 INNER JOIN [TIPDOKUMENTA] T2 ON T2.[IDTIPDOKUMENTA] = TM1.[IDTIPDOKUMENTA]) ", 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.[IDDOKUMENT], TM1.[NAZIVDOKUMENT], TM1.[IDTIPDOKUMENTA], T2.[NAZIVTIPDOKUMENTA], TM1.[PS] FROM ([DOKUMENT] TM1 INNER JOIN [TIPDOKUMENTA] T2 ON T2.[IDTIPDOKUMENTA] = TM1.[IDTIPDOKUMENTA])" + this.m_WhereString + "" + this.orderString + " "; } this.cmDOKUMENTSelect2 = this.connDefault.GetCommand(this.scmdbuf, false); this.cmDOKUMENTSelect2.ErrorMask |= ErrorMask.Lock; this.DOKUMENTSelect2 = this.cmDOKUMENTSelect2.FetchData(); int num = 0; while (this.cmDOKUMENTSelect2.HasMoreRows && (num != maxRows)) { this.m_IDDOKUMENT = this.dsDefault.Db.GetInt32(this.DOKUMENTSelect2, 0, ref this.m__IDDOKUMENTIsNull); this.m_NAZIVDOKUMENT = this.dsDefault.Db.GetString(this.DOKUMENTSelect2, 1, ref this.m__NAZIVDOKUMENTIsNull).TrimEnd(new char[] { ' ' }); this.m_IDTIPDOKUMENTA = this.dsDefault.Db.GetInt32(this.DOKUMENTSelect2, 2, ref this.m__IDTIPDOKUMENTAIsNull); this.m_NAZIVTIPDOKUMENTA = this.dsDefault.Db.GetString(this.DOKUMENTSelect2, 3, ref this.m__NAZIVTIPDOKUMENTAIsNull); this.m_PS = this.dsDefault.Db.GetBoolean(this.DOKUMENTSelect2, 4, ref this.m__PSIsNull); this.m_NAZIVTIPDOKUMENTA = this.dsDefault.Db.GetString(this.DOKUMENTSelect2, 3, ref this.m__NAZIVTIPDOKUMENTAIsNull); this.rowDOKUMENT = this.uraDocsSet.DOKUMENT.NewDOKUMENTRow(); this.rowDOKUMENT["IDDOKUMENT"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDDOKUMENTIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDDOKUMENT)); this.rowDOKUMENT["NAZIVDOKUMENT"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__NAZIVDOKUMENTIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_NAZIVDOKUMENT)); this.rowDOKUMENT["IDTIPDOKUMENTA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__IDTIPDOKUMENTAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_IDTIPDOKUMENTA)); this.rowDOKUMENT["NAZIVTIPDOKUMENTA"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__NAZIVTIPDOKUMENTAIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_NAZIVTIPDOKUMENTA)); this.rowDOKUMENT["PS"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(this.m__PSIsNull, RuntimeHelpers.GetObjectValue(Convert.DBNull), this.m_PS)); this.AddRowDokument(); num++; this.cmDOKUMENTSelect2.HasMoreRows = this.DOKUMENTSelect2.Read(); } this.DOKUMENTSelect2.Close(); this.Cleanup(); }
public virtual int FillPageByIDTIPDOKUMENTA(DOKUMENTDataSet dataSet, int iDTIPDOKUMENTA, int startRow, int maxRows) { this.InitializeMembers(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.DOKUMENTSet = dataSet; this.rowDOKUMENT = this.DOKUMENTSet.DOKUMENT.NewDOKUMENTRow(); this.rowDOKUMENT.IDTIPDOKUMENTA = iDTIPDOKUMENTA; try { this.LoadByIDTIPDOKUMENTA(startRow, maxRows); dataSet.AcceptChanges(); } finally { this.Cleanup(); } return(0); }
public virtual int FillPage(DOKUMENTDataSet dataSet, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.uraDocsSet = dataSet; this.rowDOKUMENT = this.uraDocsSet.DOKUMENT.NewDOKUMENTRow(); this.orderString = GetOrderString(this.Order, true); this.reverseOrderString = GetOrderString(this.Order, false); try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(0); }
private void ReadRowDokument() { this.Gx_mode = Mode.FromRowState(this.rowDOKUMENT.RowState); if (this.rowDOKUMENT.RowState != DataRowState.Added) { this.m__NAZIVDOKUMENTOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["NAZIVDOKUMENT", DataRowVersion.Original]); this.m__PSOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["PS", DataRowVersion.Original]); this.m__IDTIPDOKUMENTAOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["IDTIPDOKUMENTA", DataRowVersion.Original]); } else { this.m__NAZIVDOKUMENTOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["NAZIVDOKUMENT"]); this.m__PSOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["PS"]); this.m__IDTIPDOKUMENTAOriginal = RuntimeHelpers.GetObjectValue(this.rowDOKUMENT["IDTIPDOKUMENTA"]); } this._Gxremove = this.rowDOKUMENT.RowState == DataRowState.Deleted; if (this._Gxremove) { this.rowDOKUMENT = (DOKUMENTDataSet.DOKUMENTRow)DataSetUtil.CloneOriginalDataRow(this.rowDOKUMENT); } }
public virtual bool FillByIDDOKUMENT(DOKUMENTDataSet dataSet, int iDDOKUMENT) { this.InitializeMembers(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.DOKUMENTSet = dataSet; this.rowDOKUMENT = this.DOKUMENTSet.DOKUMENT.NewDOKUMENTRow(); this.rowDOKUMENT.IDDOKUMENT = iDDOKUMENT; try { this.LoadByIDDOKUMENT(0, -1); dataSet.AcceptChanges(); } finally { this.Cleanup(); } if (this.RcdFound184 == 0) { return(false); } return(true); }
public virtual int Update(DataSet dataSet) { this.InitializeMembers(); this.DOKUMENTSet = (DOKUMENTDataSet)dataSet; this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); if (this.DOKUMENTSet == null) { throw new ArgumentException(this.resourceManager.GetString("nulldset")); } try { IEnumerator enumerator = null; this.connDefault.BeginTransaction(); try { enumerator = this.DOKUMENTSet.DOKUMENT.GetEnumerator(); while (enumerator.MoveNext()) { DOKUMENTDataSet.DOKUMENTRow current = (DOKUMENTDataSet.DOKUMENTRow)enumerator.Current; this.rowDOKUMENT = current; if (Helpers.IsRowChanged(this.rowDOKUMENT)) { this.ReadRowDokument(); if (this.rowDOKUMENT.RowState == DataRowState.Added) { this.InsertDokument(); } else { if (this._Gxremove) { this.Delete(); continue; } this.UpdateDokument(); } } } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } dataSet.AcceptChanges(); this.connDefault.Commit(); } catch (System.Exception exception1) { throw exception1; //this.connDefault.Rollback(); } finally { this.Cleanup(); } return(0); }
private void CreateNewRowDokument() { this.rowDOKUMENT = this.DOKUMENTSet.DOKUMENT.NewDOKUMENTRow(); }
public DOKUMENTEventArgs(DOKUMENTDataSet.DOKUMENTRow row, System.Data.StatementType statementType) { this.m_dataRow = row; this.m_statementType = statementType; }
public DOKUMENTRowChangeEvent(DOKUMENTDataSet.DOKUMENTRow row, DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public void RemoveDOKUMENTRow(DOKUMENTDataSet.DOKUMENTRow row) { this.Rows.Remove(row); }
public void AddDOKUMENTRow(DOKUMENTDataSet.DOKUMENTRow row) { this.Rows.Add(row); }