// --
/// <summary>
/// Сохраняет запись в таблицу BrLogDet
/// </summary>
/// <param name="id">Идентификатор FK на BrLog</param>
public static List<LogRecordDetail> Load(string id)
{
QuerySelectPDA q=new QuerySelectPDA();
List<LogRecordDetail> list=new List<LogRecordDetail>();
q.Select("select * from LogRecordDetail where idlog=" + id);
List<DataRows> rows = q.GetRows();
foreach (DataRows row in rows)
{
LogRecordDetail lrd=new LogRecordDetail();
lrd.fieldName = row.FieldByName("fieldName");
lrd.fieldDescr = row.FieldByName("fieldDescr");
lrd.valueOld = row.FieldByName("valueOld");
lrd.valueNew = row.FieldByName("valueNew");
list.Add(lrd);
}
return list;
}
// --
/// <summary>
/// Сохраняет запись в таблицу BrLogDet
/// </summary>
/// <param name="id">Идентификатор FK на BrLog</param>
public static List <LogRecordDetail> Load(string id)
{
QuerySelectPDA q = new QuerySelectPDA();
List <LogRecordDetail> list = new List <LogRecordDetail>();
q.Select("select * from LogRecordDetail where idlog=" + id);
List <DataRows> rows = q.GetRows();
foreach (DataRows row in rows)
{
LogRecordDetail lrd = new LogRecordDetail();
lrd.fieldName = row.FieldByName("fieldName");
lrd.fieldDescr = row.FieldByName("fieldDescr");
lrd.valueOld = row.FieldByName("valueOld");
lrd.valueNew = row.FieldByName("valueNew");
list.Add(lrd);
}
return(list);
}
public List <LogRecordDetail> detailRecords;// = new List<LogRecordDetail>();
// ---
/// <summary>
/// Получает данные из базу.
/// </summary>
public List <LogRecord> Load()
{
List <LogRecord> list = new List <LogRecord>();
QuerySelectPDA q = new QuerySelectPDA();
q.Select("select * from Brlog");
List <DataRows> rows = q.GetRows();
foreach (DataRows row in rows)
{
LogRecord lr = new LogRecord();
lr.idBr = Int32.Parse(row.FieldByName("idbr"));
lr.sqlText = row.FieldByName("sqltext");
lr.runDate = row.FieldByName("rundate");
lr.logType = (LogType)Enum.Parse(typeof(LogType), row.FieldByName("logtype"));
lr.tableName = row.FieldByName("tablename");
lr.tableDescr = row.FieldByName("tableDescr");
string idlog = row.FieldByName("idlog");
lr.detailRecords = LogRecordDetail.Load(idlog);
list.Add(lr);
}
return(list);
}