public int InsertSYS_Log(SYS_Log sys_log)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_log.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCTIONID, sys_log.FunctionId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ACTION, sys_log.Action, false));
para.Add(_DbHelper.CreateParameter(FIELD_DESCRIPTION, sys_log.Description, false));
para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_log.Time, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDBC, sys_log.IDBC, false));
para.Add(_DbHelper.CreateParameter(FIELD_PHANLOAI, sys_log.PhanLoai, false));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Log_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_LogDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void UpdateSYS_Logstr(SYS_Log sys_log, string connect)
{
DbConnection conn = _DbHelper.CreateConnection(connect);
conn.Open();
try
{
List<DbParameter> para = new List<DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_log.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_log.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCTIONID, sys_log.FunctionId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ACTION, sys_log.Action, false));
para.Add(_DbHelper.CreateParameter(FIELD_DESCRIPTION, sys_log.Description, false));
para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_log.Time, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Log_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_LogDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public SYS_Log SelectSYS_Logstr(string connect, int ID)
{
SYS_Log sys_log = new SYS_Log();
DbDataReader reader = null;
DbConnection connection = _DbHelper.CreateConnection(connect);
connection.Open();
try
{
List<DbParameter> para = new List<DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Log_SelectById]", para.ToArray());
if (reader.HasRows && reader.Read())
SYS_LogDataAccess.SetSYS_LogInfo(reader, ref sys_log);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_LogDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
reader.Close();
connection.Close();
}
return sys_log;
}
public void DeleteSYS_Logstr(SYS_Log sys_log, string connect)
{
DbConnection conn = _DbHelper.CreateConnection(connect);
conn.Open();
List<DbParameter> para = new List<DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_log.ID, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Log_Delete]", para.ToArray());
conn.Close();
}
private static void SetBindingListSYS_LogInfo(ref DbDataReader reader, ref BindingList <SYS_Log> sys_logs)
{
SYS_Log sys_log = null;
while (reader.Read())
{
sys_log = new SYS_Log();
SYS_LogDataAccess.SetSYS_LogInfo(reader, ref sys_log);
sys_logs.Add(sys_log);
}
}
public void Add(SystemLogType logType, string keyWord, string remark)
{
var log = new SYS_Log
{
CreatedBy = Max.Framework.Authorization.AuthorizeHelper.GetCurrentUser().UserName,
CreateTime = DateTime.Now,
LogId = Guid.NewGuid().ToString(),
LogType = (int)logType,
Remark = remark,
KeyWord = keyWord
};
logRepository.Add(log);
}
public void WriteLog(string Description, int action, int IDBC, int PhanLoai)
{
SYS_LogService isys_log = new SYS_LogService();
SYS_Log sys_log = new SYS_Log();
sys_log.Time = DateTime.Now;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
sys_log.UserId = session.User.IDUSER;
sys_log.FunctionId = int.Parse(session.FuncID);
sys_log.Description = Description;
sys_log.Action = action;
sys_log.IDBC = IDBC;
sys_log.PhanLoai = PhanLoai;
isys_log.InsertSYS_Log(sys_log);
//0 Update, 1 Create, 2 Delete, 3 Approve
}
public void DeleteSYS_Log(SYS_Log sys_log)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_log.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Log_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{ conn.Close(); }
}
public void UpdateSYS_Log(DbTransaction transaction, SYS_Log sys_log)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_log.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_log.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCTIONID, sys_log.FunctionId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ACTION, sys_log.Action, false));
para.Add(_DbHelper.CreateParameter(FIELD_DESCRIPTION, sys_log.Description, false));
para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_log.Time, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDBC, sys_log.IDBC, false));
para.Add(_DbHelper.CreateParameter(FIELD_PHANLOAI, sys_log.PhanLoai, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Log_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_LogDataAccess.Update: {0}", ex.Message));
}
}
public List<SYS_Log> SelectSYSLogByIDBCPhanLoai(int IDBC,int phanLoai)
{
List<SYS_Log> sys_log = new List<SYS_Log>();
DbDataReader reader = null;
DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString);
connection.Open();
try
{
List<DbParameter> para = new List<DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_IDBC, IDBC, false));
para.Add(_DbHelper.CreateParameter(FIELD_PHANLOAI, phanLoai, false));
reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Log_SelectAllbyIDBCPhanLoai]", para.ToArray());
if (reader.HasRows)
{
while (reader.Read())
{
var temp = new SYS_Log();
SetSYS_LogInfo(reader, ref temp);
//temp.Username = reader["Username"].ToString();
//temp.FuncName = reader["FuncName"].ToString();
sys_log.Add(temp);
}
}
}
catch (Exception ex)
{
throw new Exception(String.Format(" SYS_LogDataAccess.SelectFull: {0}", ex.Message));
}
finally
{
if (reader != null)
reader.Close();
connection.Close();
}
return sys_log;
}
private static void SetSYS_LogInfo(DbDataReader reader, ref SYS_Log sys_log)
{
sys_log.ID = int.Parse("0" + reader[FIELD_ID]);
sys_log.UserId = int.Parse("0" + reader[FIELD_USERID]);
sys_log.FunctionId = int.Parse("0" + reader[FIELD_FUNCTIONID]);
sys_log.Action = int.Parse("0" + reader[FIELD_ACTION]);
sys_log.Description = "" + reader[FIELD_DESCRIPTION];
DateTime Time = (DateTime)reader[FIELD_TIME];
sys_log.Time = Time != null ? (DateTime)Time : DateTime.Now;
sys_log.IDBC = int.Parse("0" + reader[FIELD_IDBC]);
sys_log.PhanLoai = int.Parse("0" + reader[FIELD_PHANLOAI]);
SYS_UserDataAccess sysUserDataAccess = new SYS_UserDataAccess();
SYS_User sysUser = sysUserDataAccess.SelectSYS_User(sys_log.UserId);
sys_log.Username = sysUser.Name;
SYS_RightDataAccess sysRightDataAccess = new SYS_RightDataAccess();
SYS_Right sysRight = sysRightDataAccess.SelectSYS_Right(sys_log.FunctionId);
sys_log.FuncName = sysRight.FuncName;
}
public List<SYS_Log> SelectFullSYS_Logstr(string connect)
{
List<SYS_Log> sys_log = new List<SYS_Log>();
DbDataReader reader = null;
DbConnection connection = _DbHelper.CreateConnection(connect);
connection.Open();
try
{
reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Log_SelectFull]", (DbParameter[])null);
if (reader.HasRows)
{
while (reader.Read())
{
var temp = new SYS_Log();
SetSYS_LogInfo(reader, ref temp);
temp.Username = reader["Username"].ToString();
temp.FuncName = reader["FuncName"].ToString();
sys_log.Add(temp);
}
}
}
catch (Exception ex)
{
throw new Exception(String.Format(" SYS_LogDataAccess.SelectFull: {0}", ex.Message));
}
finally
{
if (reader != null)
reader.Close();
connection.Close();
}
return sys_log;
}
public void DeleteSYS_Log(SYS_Log sys_logs)
{
_sys_logDataAccess.DeleteSYS_Log(sys_logs);
}
public void UpdateSYS_Log(SYS_Log sys_log)
{
_sys_logDataAccess.UpdateSYS_Log(sys_log);
}
public int InsertSYS_Log(SYS_Log sys_log)
{
return(_sys_logDataAccess.InsertSYS_Log(sys_log));
}
