public bool Add(ActionLogModel model)
{
try
{
return(new ActionLogDal().Add(model));
}
catch (Exception ex)
{
nwbase_utils.TextLog.Error("error", "Add Action Log", ex);
return(false);
}
}
public bool Add(ActionLogModel model)
{
string sql = "INSERT INTO actionlog (UserId, UserIP, `Action`, Content, Level) VALUES (?UserId, ?UserIP, ?Action, ?Content, ?Level);";
List <MySql.Data.MySqlClient.MySqlParameter> param = new List <MySql.Data.MySqlClient.MySqlParameter>();
param.Add(MySqlHelper.MakeInParam("?UserId", MySql.Data.MySqlClient.MySqlDbType.Int32, 0, model.UserId));
param.Add(MySqlHelper.MakeInParam("?UserIP", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50, model.UserIP));
param.Add(MySqlHelper.MakeInParam("?Action", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50, model.Action));
param.Add(MySqlHelper.MakeInParam("?Content", MySql.Data.MySqlClient.MySqlDbType.VarChar, 3000, model.Content));
param.Add(MySqlHelper.MakeInParam("?Level", MySql.Data.MySqlClient.MySqlDbType.Int32, 0, model.Level));
var result = _DBHelper.ExecuteNonQuery(CommandType.Text, sql, param.ToArray());
return(result > 0);
}