/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2014/3/20 10:53:57</remarks>
public bool Update(LogErrorEntity entity, DbTransaction trans)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_LogError_Update");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx);
database.AddInParameter(commandWrapper, "@AppId", DbType.Int32, entity.AppId);
database.AddInParameter(commandWrapper, "@TerminalIP", DbType.AnsiString, entity.TerminalIP);
database.AddInParameter(commandWrapper, "@ModuleId", DbType.Int32, entity.ModuleId);
database.AddInParameter(commandWrapper, "@FunctionId", DbType.Int32, entity.FunctionId);
database.AddInParameter(commandWrapper, "@Message", DbType.AnsiString, entity.Message);
database.AddInParameter(commandWrapper, "@StackTrace", DbType.AnsiString, entity.StackTrace);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx");
return(Convert.ToBoolean(results));
}
/// <summary>
/// 将IDataReader的当前记录读取到LogErrorEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public LogErrorEntity LoadSingleRow(IDataReader reader)
{
var obj = new LogErrorEntity();
obj.Idx = (System.Int32)reader["Idx"];
obj.AppId = (System.Int32)reader["AppId"];
obj.TerminalIP = (System.String)reader["TerminalIP"];
obj.ModuleId = (System.Int32)reader["ModuleId"];
obj.FunctionId = (System.Int32)reader["FunctionId"];
obj.Message = (System.String)reader["Message"];
obj.StackTrace = (System.String)reader["StackTrace"];
obj.RowTime = (System.DateTime)reader["RowTime"];
return(obj);
}
/// <summary>
/// GetById
/// </summary>
/// <param name="idx">idx</param>
/// <returns>LogErrorEntity</returns>
/// <remarks>2014/3/20 10:53:57</remarks>
public LogErrorEntity GetById(System.Int32 idx)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_LogError_GetById");
database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx);
LogErrorEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
static void SaveError(string functionName, string errorMessage, string stackTrace, string zoneId)
{
try
{
var systemerrorlogEntity = new LogErrorEntity()
{
AppId = ShareUtil.AppId,
TerminalIP = _terminalIP,
FunctionId = FunctionAppCache.Instance.GetFunctionId(functionName),
ModuleId = 1,
Message = errorMessage,
StackTrace = stackTrace ?? "",
RowTime = DateTime.Now
};
LogErrorMgr.Insert(systemerrorlogEntity, null, zoneId);
}
catch (Exception ex)
{
LogHelper.Insert(ex);
}
}
public static bool Update(LogErrorEntity logErrorEntity, DbTransaction trans = null)
{
var provider = new LogErrorProvider();
return(provider.Update(logErrorEntity, trans));
}
public static bool Insert(LogErrorEntity logErrorEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new LogErrorProvider(zoneId);
return(provider.Insert(logErrorEntity, trans));
}
/// <summary>
/// Update
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
/// <remarks>2014/3/20 10:53:57</remarks>
public bool Update(LogErrorEntity entity)
{
return(Update(entity, null));
}
/// <summary>
/// Insert
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2014/3/20 10:53:57</remarks>
public bool Insert(LogErrorEntity entity)
{
return(Insert(entity, null));
}
