private static void DoSave(string logType, LogLevel level, string msg)
{
ThreadPool.QueueUserWorkItem(new WaitCallback((o) =>
{
try
{
Maticsoft.BLL.SMT_LOG_INFO logBll = new Maticsoft.BLL.SMT_LOG_INFO();
Maticsoft.Model.SMT_LOG_INFO model = new Maticsoft.Model.SMT_LOG_INFO();
model.OPR_CONTENT = msg;
model.LOG_LEVEL = (int)level;
model.OPR_TIME = DateTime.Now;
model.LOG_TYPE = logType;
model.OPR_USERID = UserInfoHelper.UserID;
if (string.IsNullOrWhiteSpace(UserInfoHelper.UserInfo.REAL_NAME))
{
model.OPR_REALNAME = UserInfoHelper.UserInfo.USER_NAME;
}
else
{
model.OPR_REALNAME = UserInfoHelper.UserInfo.USER_NAME + "(" + UserInfoHelper.UserInfo.REAL_NAME + ")";
}
logBll.Add(model);
}
catch (Exception ex)
{
log.Error("保存日志到数据库异常：" + ex.Message + "=>" + logType + "," + level + "," + msg);
}
}));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_LOG_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_LOG_INFO set ");
strSql.Append("LOG_TYPE=@LOG_TYPE,");
strSql.Append("LOG_LEVEL=@LOG_LEVEL,");
strSql.Append("OPR_USERID=@OPR_USERID,");
strSql.Append("OPR_REALNAME=@OPR_REALNAME,");
strSql.Append("OPR_TIME=@OPR_TIME,");
strSql.Append("OPR_CONTENT=@OPR_CONTENT");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@LOG_TYPE", SqlDbType.VarChar, 50),
new SqlParameter("@LOG_LEVEL", SqlDbType.SmallInt, 2),
new SqlParameter("@OPR_USERID", SqlDbType.Decimal, 9),
new SqlParameter("@OPR_REALNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@OPR_TIME", SqlDbType.DateTime),
new SqlParameter("@OPR_CONTENT", SqlDbType.NVarChar, 400),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.LOG_TYPE;
parameters[1].Value = model.LOG_LEVEL;
parameters[2].Value = model.OPR_USERID;
parameters[3].Value = model.OPR_REALNAME;
parameters[4].Value = model.OPR_TIME;
parameters[5].Value = model.OPR_CONTENT;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_LOG_INFO DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_LOG_INFO model = new Maticsoft.Model.SMT_LOG_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["LOG_TYPE"] != null)
{
model.LOG_TYPE = row["LOG_TYPE"].ToString();
}
if (row["LOG_LEVEL"] != null && row["LOG_LEVEL"].ToString() != "")
{
model.LOG_LEVEL = int.Parse(row["LOG_LEVEL"].ToString());
}
if (row["OPR_USERID"] != null && row["OPR_USERID"].ToString() != "")
{
model.OPR_USERID = decimal.Parse(row["OPR_USERID"].ToString());
}
if (row["OPR_REALNAME"] != null)
{
model.OPR_REALNAME = row["OPR_REALNAME"].ToString();
}
if (row["OPR_TIME"] != null && row["OPR_TIME"].ToString() != "")
{
model.OPR_TIME = DateTime.Parse(row["OPR_TIME"].ToString());
}
if (row["OPR_CONTENT"] != null)
{
model.OPR_CONTENT = row["OPR_CONTENT"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_LOG_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_LOG_INFO(");
strSql.Append("LOG_TYPE,LOG_LEVEL,OPR_USERID,OPR_REALNAME,OPR_TIME,OPR_CONTENT)");
strSql.Append(" values (");
strSql.Append("@LOG_TYPE,@LOG_LEVEL,@OPR_USERID,@OPR_REALNAME,@OPR_TIME,@OPR_CONTENT)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@LOG_TYPE", SqlDbType.VarChar, 50),
new SqlParameter("@LOG_LEVEL", SqlDbType.SmallInt, 2),
new SqlParameter("@OPR_USERID", SqlDbType.Decimal, 9),
new SqlParameter("@OPR_REALNAME", SqlDbType.NVarChar, 100),
new SqlParameter("@OPR_TIME", SqlDbType.DateTime),
new SqlParameter("@OPR_CONTENT", SqlDbType.NVarChar, 400)
};
parameters[0].Value = model.LOG_TYPE;
parameters[1].Value = model.LOG_LEVEL;
parameters[2].Value = model.OPR_USERID;
parameters[3].Value = model.OPR_REALNAME;
parameters[4].Value = model.OPR_TIME;
parameters[5].Value = model.OPR_CONTENT;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_LOG_INFO GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,LOG_TYPE,LOG_LEVEL,OPR_USERID,OPR_REALNAME,OPR_TIME,OPR_CONTENT from SMT_LOG_INFO ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_LOG_INFO model = new Maticsoft.Model.SMT_LOG_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
