/// <summary>
/// 增加日志
/// </summary>
/// <param name="model"></param>
public void LogUserAdd(ColoPay.Model.SysManage.UserLog model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SA_UserLog(");
strSql.Append("OPTime,Url,OPInfo,UserName,UserType,UserIP)");
strSql.Append(" values (");
strSql.Append("@OPTime,@Url,@OPInfo,@UserName,@UserType,@UserIP)");
SqlParameter[] parameters =
{
new SqlParameter("@OPTime", SqlDbType.DateTime),
new SqlParameter("@Url", SqlDbType.NVarChar, 200),
new SqlParameter("@OPInfo", SqlDbType.NVarChar),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserType", SqlDbType.Char, 2),
new SqlParameter("@UserIP", SqlDbType.NVarChar, 20)
};
parameters[0].Value = DateTime.Now;
parameters[1].Value = model.Url;
parameters[2].Value = model.OPInfo;
parameters[3].Value = model.UserName;
parameters[4].Value = model.UserType;
parameters[5].Value = model.UserIP;
DBHelper.DefaultDBHelper.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// Add User oprate log
/// </summary>
public static void AddUserLog(string Username, string UserType, string OPInfo, System.Web.UI.Page page)
{
ColoPay.Model.SysManage.UserLog model = new ColoPay.Model.SysManage.UserLog();
model.OPInfo = OPInfo;
model.Url = page.Request.Url.AbsoluteUri;
//获取的是局域网分配的IP
//string strHostName = System.Net.Dns.GetHostName();
//string clientIPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(3).ToString();
//model.UserIP = clientIPAddress;
//本地测试获取的IP为127.0.0.1
model.UserIP = page.Request.UserHostAddress;
model.UserName = Username;
model.UserType = UserType;
ColoPay.BLL.SysManage.UserLog.LogUserAdd(model);
}
