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