/// <summary>
///根据主键值查找Log_SqlError记录
/// </summary>
/// <param name="keyId">KeyId</param>
/// <returns>Log_SqlError</returns>
public Log_SqlError FindLog_SqlError(int keyId)
{
string sql = @"SELECT KeyId, SPName, Description, LogTime FROM dbo.Log_SqlError WHERE KeyId = @KeyId";
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
db.AddInParameter(command, "KeyId", DbType.Int32, keyId);
Log_SqlError log_SqlError = null;
using (IDataReader dr = db.ExecuteReader(command))
{
if (dr.Read())
{
log_SqlError = new Log_SqlError();
log_SqlError.KeyId = (int)dr["KeyId"];
log_SqlError.SPName = (string)dr["SPName"];
log_SqlError.Description = (string)dr["Description"];
log_SqlError.LogTime = (DateTime)dr["LogTime"];
}
}
return(log_SqlError);
}
/// <summary>
/// 插入Log_SqlError记录
/// </summary>
/// <param name="log_SqlError">Log_SqlError对象</param>
/// <returns></returns>
public int InsertLog_SqlError(Log_SqlError log_SqlError)
{
string sql = @"INSERT INTO dbo.Log_SqlError(SPName, Description, LogTime) VALUES(@SPName, @Description, @LogTime); SELECT @KeyId = SCOPE_IDENTITY()";
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
db.AddOutParameter(command, "KeyId", DbType.Int32, sizeof(int));
db.AddInParameter(command, "SPName", DbType.String, log_SqlError.SPName);
db.AddInParameter(command, "Description", DbType.String, log_SqlError.Description);
db.AddInParameter(command, "LogTime", DbType.DateTime, log_SqlError.LogTime);
int affectedRecords = db.ExecuteNonQuery(command);
if (affectedRecords < 1)
{
throw new ApplicationException("插入数据失败, 没有记录被插入");
}
else
{
string strTemp = "select @@identity";
DataTable dt = GetDataTable(strTemp);
if (dt != null && dt.Rows.Count > 0)
{
affectedRecords = int.Parse(dt.Rows[0][0].ToString());
}
}
return(affectedRecords);
}
/// <summary>
/// 更新Log_SqlError记录
/// </summary>
/// <param name="log_SqlError">Log_SqlError对象</param>
/// <returns>受影响的记录数</returns>
public int UpdateLog_SqlError(Log_SqlError log_SqlError)
{
string sql = @"UPDATE dbo.Log_SqlError SET SPName = @SPName, Description = @Description, LogTime = @LogTime WHERE KeyId = @KeyId";
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
db.AddInParameter(command, "KeyId", DbType.Int32, log_SqlError.KeyId);
db.AddInParameter(command, "SPName", DbType.String, log_SqlError.SPName);
db.AddInParameter(command, "Description", DbType.String, log_SqlError.Description);
db.AddInParameter(command, "LogTime", DbType.DateTime, log_SqlError.LogTime);
return(db.ExecuteNonQuery(command));
}
/// <summary>
/// 返回满足查询条件的Log_SqlError实体列表
/// </summary>
/// <param name="param">查询条件</param>
/// <returns>Log_SqlError实体列表</returns>
public IList <Log_SqlError> GetLog_SqlErrors(QueryParameter param)
{
string sql = @"SELECT KeyId, SPName, Description, LogTime FROM dbo.Log_SqlError";
if (param != null)
{
sql = QueryParameter.CompleteSqlString(sql, param);
}
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
if (param != null)
{
//设置参数
foreach (IExpression exp in param.WhereExpressions)
{
if (exp is SimpleExpression)
{
SimpleExpression simple = exp as SimpleExpression;
db.AddInParameter(command, simple.ExpName, simple.DbType, simple.Value);
}
}
}
IList <Log_SqlError> list = new List <Log_SqlError>();
using (IDataReader dr = db.ExecuteReader(command))
{
while (dr.Read())
{
Log_SqlError log_SqlError = new Log_SqlError();
log_SqlError.KeyId = (int)dr["KeyId"];
log_SqlError.SPName = (string)dr["SPName"];
log_SqlError.Description = (string)dr["Description"];
log_SqlError.LogTime = (DateTime)dr["LogTime"];
list.Add(log_SqlError);
}
}
return(list);
}
/// <summary>
/// 更新Log_SqlError
/// </summary>
/// <param name="log_SqlError">实体类</param>
/// <param name="logEntity">日志类</param>
/// <returns></returns>
public string UpdateLog_SqlError(Log_SqlError log_SqlError, Log_Operate logEntity)
{
string strResult = "";
using (TransactionScope trans = new TransactionScope())
{
try
{
this._log_SqlErrorDAO.UpdateLog_SqlError(log_SqlError);
Log_OperateFacade logFacade = new Log_OperateFacade();
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(strResult);
}
/// <summary>
/// 创建Log_SqlError
/// </summary>
/// <param name="log_SqlError">实体类</param>
/// <param name="logEntity">日志类</param>
/// <param name="strResult">错误信息</param>
/// <returns></returns>
public int InsertLog_SqlError(Log_SqlError log_SqlError, Log_Operate logEntity, ref string strResult)
{
int intResult = 0;
using (TransactionScope trans = new TransactionScope())
{
try
{
this._log_SqlErrorDAO.InsertLog_SqlError(log_SqlError);
Log_OperateFacade logFacade = new Log_OperateFacade();
logEntity.OperateFunction = "新增_log_SqlError表ID为" + intResult.ToString() + "的数据";
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(intResult);
}
/// <summary>
/// 更新Log_SqlError记录
/// </summary>
/// <param name="log_SqlError">
/// Log_SqlError对象</param>
/// <returns>受影响的记录数</returns>
public int UpdateLog_SqlError(Log_SqlError log_SqlError)
{
return(this._log_SqlErrorDAO.UpdateLog_SqlError(log_SqlError));
}
/// <summary>
/// 创建Log_SqlError记录
/// </summary>
/// <param name="log_SqlError">
/// Log_SqlError对象</param>
/// <returns></returns>
public int CreateLog_SqlError(Log_SqlError log_SqlError)
{
return(this._log_SqlErrorDAO.InsertLog_SqlError(log_SqlError));
}
