/// <summary>
/// 用户操作后插入日志
/// </summary>
/// <param name="model"></param>
public void InsertLog(Startech.Log.LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Log(");
strSql.Append("ApplicationName,FirstItem,SecondItem,ActionType,Description,UserId,OperationDate,Url,IP)");
strSql.Append(" values (");
strSql.Append("@ApplicationName,@FirstItem,@SecondItem,@ActionType,@Description,@UserId,@OperationDate,@Url,@IP)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ApplicationName", SqlDbType.VarChar, 50),
new SqlParameter("@FirstItem", SqlDbType.VarChar, 50),
new SqlParameter("@SecondItem", SqlDbType.VarChar, 50),
new SqlParameter("@ActionType", SqlDbType.VarChar, 50),
new SqlParameter("@Description", SqlDbType.Text),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@OperationDate", SqlDbType.DateTime),
new SqlParameter("@Url", SqlDbType.VarChar, 150),
new SqlParameter("@IP", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ApplicationName;
parameters[1].Value = model.FirstItem;
parameters[2].Value = model.SecondItem;
parameters[3].Value = model.ActionType;
parameters[4].Value = model.Description;
parameters[5].Value = model.UserId;
parameters[6].Value = model.OperationDate;
parameters[7].Value = model.Url;
parameters[8].Value = model.IP;
AdoHelper.CreateHelper("DB_Instance").ExecuteSqlNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 用户操作后插入日志
/// </summary>
/// <param name="model"></param>
public void InsertLog(Startech.Log.LogModel model)
{
model.UserId = HttpContext.Current.Session["UserId"] == null ? 0 : int.Parse(HttpContext.Current.Session["UserId"].ToString());
model.OperationDate = DateTime.Now;
model.Url = HttpContext.Current.Request.Path;
model.IP = HttpContext.Current.Request.UserHostAddress;
new LogDAL().InsertLog(model);
}
