public List <UserLogInfo> List(string userName, int totalNum, string action)
{
var list = new List <UserLogInfo>();
var sqlString = "SELECT * FROM bairong_UserLog WHERE UserName = @UserName";
if (!string.IsNullOrEmpty(action))
{
sqlString += " And Action = @Action";
}
else
{
action = EUserActionTypeUtils.GetValue(EUserActionType.Login);
sqlString += " And Action <> @Action";
}
sqlString += " ORDER BY ID DESC";
var parms = new IDataParameter[]
{
GetParameter(ParmUserName, EDataType.VarChar, 50, userName),
GetParameter(ParmAction, EDataType.NVarChar, 255, action)
};
using (var rdr = ExecuteReader(sqlString, parms))
{
while (rdr.Read())
{
var i = 0;
var info = new UserLogInfo(GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i++), GetString(rdr, i));
list.Add(info);
}
}
return(list);
}
public IHttpActionResult Main()
{
try
{
var body = new RequestBody();
if (!body.IsUserLoggin)
{
return(Unauthorized());
}
var action = body.GetPostString("action");
var totalNum = TranslateUtils.ToInt(body.GetPostString("totalNum"), 10);
var list = BaiRongDataProvider.UserLogDao.List(body.UserName, totalNum, action);
foreach (var logInfo in list)
{
logInfo.Action = EUserActionTypeUtils.GetText(EUserActionTypeUtils.GetEnumType(logInfo.Action));
}
return(Ok(list));
}
catch (Exception ex)
{
//return InternalServerError(ex);
return(InternalServerError(new Exception("程序错误")));
}
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var ltlUserName = (Literal)e.Item.FindControl("ltlUserName");
var ltlAddDate = (Literal)e.Item.FindControl("ltlAddDate");
var ltlIpAddress = (Literal)e.Item.FindControl("ltlIPAddress");
var ltlAction = (Literal)e.Item.FindControl("ltlAction");
var ltlSummary = (Literal)e.Item.FindControl("ltlSummary");
ltlUserName.Text = SqlUtils.EvalString(e.Item.DataItem, "UserName");
ltlAddDate.Text = DateUtils.GetDateAndTimeString(SqlUtils.EvalDateTime(e.Item.DataItem, "AddDate"));
ltlIpAddress.Text = SqlUtils.EvalString(e.Item.DataItem, "IPAddress");
ltlAction.Text = EUserActionTypeUtils.GetText(EUserActionTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "Action")));
ltlSummary.Text = SqlUtils.EvalString(e.Item.DataItem, "Summary");
}
}
private static void RptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem)
{
return;
}
var ltlUserName = (Literal)e.Item.FindControl("ltlUserName");
var ltlAddDate = (Literal)e.Item.FindControl("ltlAddDate");
var ltlIpAddress = (Literal)e.Item.FindControl("ltlIpAddress");
var ltlAction = (Literal)e.Item.FindControl("ltlAction");
var ltlSummary = (Literal)e.Item.FindControl("ltlSummary");
ltlUserName.Text = SqlUtils.EvalString(e.Item.DataItem, nameof(UserLogInfo.UserName));
ltlAddDate.Text = DateUtils.GetDateAndTimeString(SqlUtils.EvalDateTime(e.Item.DataItem, nameof(UserLogInfo.AddDate)));
ltlIpAddress.Text = SqlUtils.EvalString(e.Item.DataItem, nameof(UserLogInfo.IpAddress));
ltlAction.Text = EUserActionTypeUtils.GetText(EUserActionTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, nameof(UserLogInfo.Action))));
ltlSummary.Text = SqlUtils.EvalString(e.Item.DataItem, nameof(UserLogInfo.Summary));
}
public static void AddUserLog(string userName, EUserActionType actionType, string summary)
{
if (!ConfigManager.SystemConfigInfo.IsLogUser)
{
return;
}
try
{
BaiRongDataProvider.UserLogDao.Delete(ConfigManager.SystemConfigInfo.IsTimeThreshold ? ConfigManager.SystemConfigInfo.TimeThreshold : 0, ConfigManager.SystemConfigInfo.IsCounterThreshold ? ConfigManager.SystemConfigInfo.CounterThreshold * 10000 : 0);
if (!string.IsNullOrEmpty(summary))
{
summary = StringUtils.MaxLengthText(summary, 250);
}
BaiRongDataProvider.UserLogDao.Insert(new UserLogInfo(0, userName, PageUtils.GetIpAddress(), DateTime.Now, EUserActionTypeUtils.GetValue(actionType), summary));
}
catch (Exception ex)
{
AddErrorLog(ex);
}
}
public static void AddUserLog(string userName, EUserActionType actionType, string summary)
{
AddUserLog(userName, EUserActionTypeUtils.GetText(actionType), summary);
}
