public Dictionary<int, SystemLog> GetAllSystemLogs(ref string errMessage) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; var list = new Dictionary<int, SystemLog>(); try { DataSet ds = SystemLogDataAccess.GetAllSystemLogs(db); SystemLog systemLog; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { systemLog = new SystemLog(ds.Tables[0].Rows[i]); list.Add(systemLog.Id, systemLog); } return list; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
public static int Insert(Database db, SystemLog systemLog) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO SystemLog("); sbValue.Append("values("); sbField.Append("Happentime"); sbValue.AppendFormat("'{0}'", systemLog.HappenTime); sbField.Append(",systemtypeid"); sbValue.AppendFormat(",{0}", systemLog.SystemTypeId); sbField.Append(",systemtypename"); sbValue.AppendFormat(",'{0}'", systemLog.SystemTypeName); sbField.Append(",content"); sbValue.AppendFormat(",'{0}'", systemLog.Content); sbField.Append(",sysusername"); sbValue.AppendFormat(",'{0}'", systemLog.SyeUserName); sbField.Append(",clientusername"); sbValue.AppendFormat(",'{0}'", systemLog.ClientUserName); sbField.Append(",clientuserid)"); sbValue.AppendFormat(",{0})", systemLog.ClientUserId); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public int Insert(ref string errMessage, SystemLog systemLog) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return SystemLogDataAccess.Insert(db, systemLog); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }