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); } }