/// <summary>
///根据主键值查找Log_Operate记录
/// </summary>
/// <param name="keyId">KeyId</param>
/// <returns>Log_Operate</returns>
public Log_Operate FindLog_Operate(int keyId)
{
string sql = @"SELECT KeyId, PersonId, OperateTime, OperateModule, OperateType, OperateFunction FROM dbo.Log_Operate WHERE KeyId = @KeyId";
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
db.AddInParameter(command, "KeyId", DbType.Int32, keyId);
Log_Operate log_Operate = null;
using (IDataReader dr = db.ExecuteReader(command))
{
if (dr.Read())
{
log_Operate = new Log_Operate();
log_Operate.KeyId = (int)dr["KeyId"];
log_Operate.PersonId = (int)dr["PersonId"];
log_Operate.OperateTime = (DateTime)dr["OperateTime"];
log_Operate.OperateModule = (int)dr["OperateModule"];
log_Operate.OperateType = (string)dr["OperateType"];
log_Operate.OperateFunction = dr["OperateFunction"] == DBNull.Value ? null : (string)dr["OperateFunction"];
}
}
return(log_Operate);
}
/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="operateUser">操作用户</param>
/// <param name="moduleName">模块名称</param>
/// <param name="opType">操作类型，如新增、修改、删除等</param>
/// <param name="opContent">操作内容</param>
/// <param name="IsOpSuccess">是否成功</param>
/// <param name="opErrMsg">操作异常信息</param>
public static void AddOperateLog(UserInfo operateUser, string moduleName, string opType, string opContent, bool IsOpSuccess, string opErrMsg)
{
try
{
if (operateUser == null || string.IsNullOrEmpty(moduleName))
{
return;
}
//构建操作日志对象
UserInfo admin = UserOperate.GetSuperAdmin();
Log_Operate operateLog = new Log_Operate();
operateLog.Id = Guid.NewGuid();
operateLog.ModuleName = moduleName;
operateLog.OperateType = opType;
operateLog.OperateContent = opContent;
operateLog.OperateResult = IsOpSuccess ? "操作成功" : "操作失败";
operateLog.OperateTip = opErrMsg;
operateLog.UserId = operateUser.UserName;
operateLog.UserAlias = operateUser.AliasName;
operateLog.OperateTime = DateTime.Now;
operateLog.ClientIp = operateUser.ClientIP;
operateLog.CreateDate = DateTime.Now;
operateLog.CreateUserId = admin.UserId;
operateLog.CreateUserName = admin.AliasName;
operateLog.ModifyDate = DateTime.Now;
operateLog.ModifyUserId = admin.UserId;
operateLog.ModifyUserName = admin.AliasName;
string errMsg = string.Empty;
//保存日志
CommonOperate.OperateRecord <Log_Operate>(operateLog, OperateHandle.ModelRecordOperateType.Add, out errMsg, null, false);
}
catch { }
}
/// <summary>
/// 插入Log_Operate记录
/// </summary>
/// <param name="log_Operate">Log_Operate对象</param>
/// <returns></returns>
public int InsertLog_Operate(Log_Operate log_Operate)
{
string sql = @"INSERT INTO dbo.Log_Operate(PersonId, OperateTime, OperateModule, OperateType, OperateFunction) VALUES(@PersonId, @OperateTime, @OperateModule, @OperateType, @OperateFunction); 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, "PersonId", DbType.Int32, log_Operate.PersonId);
db.AddInParameter(command, "OperateTime", DbType.DateTime, log_Operate.OperateTime);
db.AddInParameter(command, "OperateModule", DbType.Int32, log_Operate.OperateModule);
db.AddInParameter(command, "OperateType", DbType.String, log_Operate.OperateType);
db.AddInParameter(command, "OperateFunction", DbType.String, string.IsNullOrEmpty(log_Operate.OperateFunction) ? DBNull.Value : (object)log_Operate.OperateFunction);
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_Operate记录
/// </summary>
/// <param name="log_Operate">Log_Operate对象</param>
/// <returns>受影响的记录数</returns>
public int UpdateLog_Operate(Log_Operate log_Operate)
{
string sql = @"UPDATE dbo.Log_Operate SET PersonId = @PersonId, OperateTime = @OperateTime, OperateModule = @OperateModule, OperateType = @OperateType, OperateFunction = @OperateFunction WHERE KeyId = @KeyId";
Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString());
DbCommand command = db.GetSqlStringCommand(sql);
db.AddInParameter(command, "KeyId", DbType.Int32, log_Operate.KeyId);
db.AddInParameter(command, "PersonId", DbType.Int32, log_Operate.PersonId);
db.AddInParameter(command, "OperateTime", DbType.DateTime, log_Operate.OperateTime);
db.AddInParameter(command, "OperateModule", DbType.Int32, log_Operate.OperateModule);
db.AddInParameter(command, "OperateType", DbType.String, log_Operate.OperateType);
db.AddInParameter(command, "OperateFunction", DbType.String, string.IsNullOrEmpty(log_Operate.OperateFunction) ? DBNull.Value : (object)log_Operate.OperateFunction);
return(db.ExecuteNonQuery(command));
}
/// <summary>
/// 返回满足查询条件的Log_Operate实体列表
/// </summary>
/// <param name="param">查询条件</param>
/// <returns>Log_Operate实体列表</returns>
public IList <Log_Operate> GetLog_Operates(QueryParameter param)
{
string sql = @"SELECT KeyId, PersonId, OperateTime, OperateModule, OperateType, OperateFunction FROM dbo.Log_Operate";
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_Operate> list = new List <Log_Operate>();
using (IDataReader dr = db.ExecuteReader(command))
{
while (dr.Read())
{
Log_Operate log_Operate = new Log_Operate();
log_Operate.KeyId = (int)dr["KeyId"];
log_Operate.PersonId = (int)dr["PersonId"];
log_Operate.OperateTime = (DateTime)dr["OperateTime"];
log_Operate.OperateModule = (int)dr["OperateModule"];
log_Operate.OperateType = (string)dr["OperateType"];
log_Operate.OperateFunction = dr["OperateFunction"] == DBNull.Value ? null : (string)dr["OperateFunction"];
list.Add(log_Operate);
}
}
return(list);
}
/// <summary>
/// 删除Log_Login
/// </summary>
/// <param name="Log_LoginId">主码</param>
/// <param name="logEntity">日志类</param>
/// <returns></returns>
public string DeleteLog_Login(int keyId, Log_Operate logEntity)
{
string strResult = "";
using (TransactionScope trans = new TransactionScope())
{
try
{
this._log_LoginDAO.DeleteLog_Login(keyId);
Log_OperateFacade logFacade = new Log_OperateFacade();
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(strResult);
}
/// <summary>
/// 更新Sys_BusiUnitType
/// </summary>
/// <param name="sys_BusiUnitType">实体类</param>
/// <param name="logEntity">日志类</param>
/// <returns></returns>
public string UpdateSys_BusiUnitType(Sys_BusiUnitType sys_BusiUnitType, Log_Operate logEntity)
{
string strResult = "";
using (TransactionScope trans = new TransactionScope())
{
try
{
this._sys_BusiUnitTypeDAO.UpdateSys_BusiUnitType(sys_BusiUnitType);
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>
/// <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_Login
/// </summary>
/// <param name="log_Login">实体类</param>
/// <param name="logEntity">日志类</param>
/// <param name="strResult">错误信息</param>
/// <returns></returns>
public int InsertLog_Login(Log_Login log_Login, Log_Operate logEntity, ref string strResult)
{
int intResult = 0;
using (TransactionScope trans = new TransactionScope())
{
try
{
this._log_LoginDAO.InsertLog_Login(log_Login);
Log_OperateFacade logFacade = new Log_OperateFacade();
logEntity.OperateFunction = "新增_log_Login表ID为" + intResult.ToString() + "的数据";
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(intResult);
}
/// <summary>
/// 删除Sys_Person
/// </summary>
/// <param name="Sys_PersonId">主码</param>
/// <param name="logEntity">日志类</param>
/// <returns></returns>
public string DeleteSys_Person_Ex(int keyId, Log_Operate logEntity)
{
string strResult = "";
using (TransactionScope trans = new TransactionScope())
{
try
{
new Sys_PersonBusiUnitDAO().DeleteByPerson(keyId.ToString());
this._sys_PersonDAO.DeleteSys_Person(keyId);
Log_OperateFacade logFacade = new Log_OperateFacade();
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(strResult);
}
/// <summary>
/// 更新Log_Operate记录
/// </summary>
/// <param name="log_Operate">
/// Log_Operate对象</param>
/// <returns>受影响的记录数</returns>
public int UpdateLog_Operate(Log_Operate log_Operate)
{
return(this._log_OperateDAO.UpdateLog_Operate(log_Operate));
}
/// <summary>
/// 创建Log_Operate记录
/// </summary>
/// <param name="log_Operate">
/// Log_Operate对象</param>
/// <returns></returns>
public int CreateLog_Operate(Log_Operate log_Operate)
{
return(this._log_OperateDAO.InsertLog_Operate(log_Operate));
}
/// <summary>
/// 创建Sys_PersonDeskTopConfig
/// </summary>
/// <param name="sys_PersonDeskTopConfig">实体类</param>
/// <param name="logEntity">日志类</param>
/// <param name="strResult">错误信息</param>
/// <returns></returns>
public int InsertSys_PersonDeskTopConfig(Sys_PersonDeskTopConfig sys_PersonDeskTopConfig, Log_Operate logEntity, ref string strResult)
{
int intResult = 0;
using (TransactionScope trans = new TransactionScope())
{
try
{
this._sys_PersonDeskTopConfigDAO.InsertSys_PersonDeskTopConfig(sys_PersonDeskTopConfig);
Log_OperateFacade logFacade = new Log_OperateFacade();
logEntity.OperateFunction = "新增_sys_PersonDeskTopConfig表ID为" + intResult.ToString() + "的数据";
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(intResult);
}
/// <summary>
/// 更新Sys_PersonDeskTopConfig
/// </summary>
/// <param name="sys_PersonDeskTopConfig">实体类</param>
/// <param name="logEntity">日志类</param>
/// <returns></returns>
public string UpdateSys_PersonDeskTopConfig(Sys_PersonDeskTopConfig sys_PersonDeskTopConfig, Log_Operate logEntity)
{
string strResult = "";
using (TransactionScope trans = new TransactionScope())
{
try
{
this._sys_PersonDeskTopConfigDAO.UpdateSys_PersonDeskTopConfig(sys_PersonDeskTopConfig);
Log_OperateFacade logFacade = new Log_OperateFacade();
int intLog = logFacade.CreateLog_Operate(logEntity);
trans.Complete();
}
catch (Exception ex)
{
strResult = ex.Message;
}
}
return(strResult);
}
