public void UpdateSyncLog(OracleDbOperation oracleDb, SyncDataLog syncLog)
{
syncLog.Succ = 0;
string strSql = SqlBuilder.BuildUpdateSql(syncLog);
oracleDb.ExecuteNonQuery(strSql, null);
}
public SyncDataLog GetSyncLogInfo(OracleDbOperation oracleDb, string code)
{
SyncDataLog dataInfo = null;
string strSql = "select * from syncdataLog where ccode = '{0}' and syncType = {1} order by syncdate desc";
strSql = string.Format(strSql, code, ((int)SyncDataType.System).ToString());
DataTable dt = oracleDb.ExecuteDataTable(strSql);
if (dt.Rows.Count > 0)
{
dataInfo = (SyncDataLog) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(SyncDataLog));
}
return(dataInfo);
}
/// <summary>
/// 插入失败的记录
/// </summary>
/// <param name="localDb"></param>
/// <param name="targetConfig"></param>
/// <param name="dataType"></param>
public SyncDataLog InsertSyncLog(OracleDbOperation oracleDb, SyncConfigTarget targetConfig, SyncDataType dataType, string fileName)
{
SyncDataLog syncLog = new SyncDataLog();
syncLog.LogId = Guid.NewGuid().ToString();
syncLog.CCode = targetConfig.Code;
syncLog.CName = targetConfig.Name;
syncLog.Synctype = dataType;
syncLog.SyncDate = System.DateTime.Now;
syncLog.FileName = fileName;
syncLog.Succ = 1;
string strSql = SqlBuilder.BuildInsertSql(syncLog);
oracleDb.ExecuteNonQuery(strSql, null);
return(syncLog);
}