/// <summary> /// 根据名字模糊查询日志 /// </summary> /// <param name="name"></param> /// <returns></returns> public List <M_JournalInfo> selJournalInfoByName(string name) { List <M_JournalInfo> mj = new List <M_JournalInfo>(); try { SqlParameter[] mysql = new SqlParameter[] { new SqlParameter("@LoginName", name) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "selJournalByName", mysql); while (reader.Read()) { M_JournalInfo j = new M_JournalInfo(); j.LoginName = reader["LoginName"].ToString(); j.ReleaseTime = (DateTime)reader["ReleaseTime"]; j.Content = reader["Content"].ToString(); j.JID = int.Parse(reader["JID"].ToString()); j.Remark = reader["Remark"].ToString(); j.State = reader["State"].ToString(); mj.Add(j); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(mj); }
/// <summary> /// 根据时间查询日志 /// </summary> /// <param name="time"></param> /// <returns></returns> public List <M_JournalInfo> selJournalInfoByTimes(string time) { List <M_JournalInfo> mj = new List <M_JournalInfo>(); try { //string sql = "select * from [dbo].[M_JournalInfo] where ReleaseTime='"+time+ "' order by ReleaseTime"; SqlParameter[] mysql = new SqlParameter[] { new SqlParameter("@ReleaseTime", time) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, "selJournalByTime", mysql); while (reader.Read()) { M_JournalInfo j = new M_JournalInfo(); j.LoginName = reader["LoginName"].ToString(); j.ReleaseTime = (DateTime)reader["ReleaseTime"]; j.Content = reader["Content"].ToString(); j.JID = int.Parse(reader["JID"].ToString()); j.Remark = reader["Remark"].ToString(); j.State = reader["State"].ToString(); mj.Add(j); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(mj); }
/// <summary> /// 系统日志 /// </summary> /// <param name="ji"></param> public void AddJournalInfo(M_JournalInfo ji) { try { SqlParameter[] sql = new SqlParameter[] { new SqlParameter("@Content", ji.Content), new SqlParameter("@ReleaseTime", ji.ReleaseTime), new SqlParameter("@LoginName", ji.LoginName) }; SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "AddJournalInfo", sql); } catch (Exception) { throw; } }
/// <summary> /// 查询日志信息 /// </summary> /// <returns></returns> public List <M_JournalInfo> SelJournal() { List <M_JournalInfo> mj = new List <M_JournalInfo>(); string sql = "select * from M_JournalInfo order by ReleaseTime desc"; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { M_JournalInfo j = new M_JournalInfo(); j.LoginName = reader["LoginName"].ToString(); j.ReleaseTime = (DateTime)reader["ReleaseTime"]; j.Content = reader["Content"].ToString(); j.JID = int.Parse(reader["JID"].ToString()); j.Remark = reader["Remark"].ToString(); j.State = reader["State"].ToString(); mj.Add(j); } return(mj); }
/// <summary> /// 系统日志 /// </summary> /// <param name="ji"></param> public void AddJournalInfo(M_JournalInfo ji) { ud.AddJournalInfo(ji); }