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