public LogModel(Entity.Log entity)
{
this.Id = entity.Id;
this.Message = entity.Message;
this.LogLevel = (LogLevel?)entity.LogLevel;
this.CreateTime = entity.CreateTime;
this.SqlType = (SqlTypeEnum)entity.SqlOperateType;
}
public List <Entity.Log> GetAll()
{
string query = "SELECT LogId, Login, Logout, Action, AccountId, ItemCode FROM Log";
SqlDataReader reader = DataAccess.GetData(query);
Entity.Log log = null;
List <Entity.Log> logList = new List <Entity.Log>();
while (reader.Read())
{
log = new Entity.Log(reader["LogId"].ToString());
log.LoginTime = Convert.ToDateTime(reader["Login"]);
log.LogoutTime = Convert.ToDateTime(reader["Logout"]);
log.Action = reader["Action"].ToString();
log.AccountId = reader["AccountId"].ToString();
log.ItemCode = reader["ItemCode"].ToString();
logList.Add(log);
}
return(logList);
}
public int Edit(Entity.Log log)
{
string query = "UPDATE Account SET Login='******', Logout='" + log.LogoutTime + "', Action='" + log.Action + "', AccountId='" + log.AccountId + "', ItemCode='" + log.ItemCode + "' WHERE LogId=" + log.LogId;
return(DataAccess.ExecuteQuery(query));
}
public int Add(Entity.Log log)
{
string query = string.Format("INSERT INTO Account(LogId, Login, Logout, Action, AccountId, ItemCode) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", log.LogId, log.LoginTime, log.LogoutTime, log.AccountId, log.ItemCode);
return(DataAccess.ExecuteQuery(query));
}
public static LogModel Convert(Entity.Log arg)
{
return(new LogModel(arg));
}
public int Edit(Entity.Log log)
{
return(LogService.logDataAccess.Edit(log));
}
public int Add(Entity.Log log)
{
return(LogService.logDataAccess.Add(log));
}
