/// <summary> /// 操作日志写入方法 /// </summary> /// <param name="summary">日志摘要</param> /// <param name="message">日志详情</param> public void Log(string summary, string message) { var mOperationLog = new JMP.MDL.CoOperationLog(); var bllOperationLog = new JMP.BLL.CoOperationLog(); mOperationLog.CreatedById = UserInfo.UserId; mOperationLog.IpAddress = RequestHelper.GetClientIp(); mOperationLog.CreatedByName = UserInfo.UserName; mOperationLog.Message = message; mOperationLog.Summary = summary; mOperationLog.CreatedOn = DateTime.Now; bllOperationLog.Add(mOperationLog); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.CoOperationLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CoOperationLog set "); strSql.Append(" Summary = @Summary , "); strSql.Append(" Message = @Message , "); strSql.Append(" CreatedOn = @CreatedOn , "); strSql.Append(" CreatedById = @CreatedById , "); strSql.Append(" CreatedByName = @CreatedByName , "); strSql.Append(" IpAddress = @IpAddress "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Summary", SqlDbType.NVarChar, 255), new SqlParameter("@Message", SqlDbType.NVarChar, -1), new SqlParameter("@CreatedOn", SqlDbType.DateTime), new SqlParameter("@CreatedById", SqlDbType.Int, 4), new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50), new SqlParameter("@IpAddress", SqlDbType.NVarChar, 32) }; parameters[0].Value = model.Id; parameters[1].Value = model.Summary; parameters[2].Value = model.Message; parameters[3].Value = model.CreatedOn; parameters[4].Value = model.CreatedById; parameters[5].Value = model.CreatedByName; parameters[6].Value = model.IpAddress; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.CoOperationLog GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, Summary, Message, CreatedOn, CreatedById, CreatedByName, IpAddress "); strSql.Append(" from CoOperationLog "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; JMP.MDL.CoOperationLog model = new JMP.MDL.CoOperationLog(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.Summary = ds.Tables[0].Rows[0]["Summary"].ToString(); model.Message = ds.Tables[0].Rows[0]["Message"].ToString(); if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "") { model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString()); } if (ds.Tables[0].Rows[0]["CreatedById"].ToString() != "") { model.CreatedById = int.Parse(ds.Tables[0].Rows[0]["CreatedById"].ToString()); } model.CreatedByName = ds.Tables[0].Rows[0]["CreatedByName"].ToString(); model.IpAddress = ds.Tables[0].Rows[0]["IpAddress"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.CoOperationLog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CoOperationLog("); strSql.Append("Summary,Message,CreatedOn,CreatedById,CreatedByName,IpAddress"); strSql.Append(") values ("); strSql.Append("@Summary,@Message,@CreatedOn,@CreatedById,@CreatedByName,@IpAddress"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Summary", SqlDbType.NVarChar, 255), new SqlParameter("@Message", SqlDbType.NVarChar, -1), new SqlParameter("@CreatedOn", SqlDbType.DateTime), new SqlParameter("@CreatedById", SqlDbType.Int, 4), new SqlParameter("@CreatedByName", SqlDbType.NVarChar, 50), new SqlParameter("@IpAddress", SqlDbType.NVarChar, 32) }; parameters[0].Value = model.Summary; parameters[1].Value = model.Message; parameters[2].Value = model.CreatedOn; parameters[3].Value = model.CreatedById; parameters[4].Value = model.CreatedByName; parameters[5].Value = model.IpAddress; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }