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)); }