/// <summary>
/// 获取所有的系统操作日志 Sys_OpLog对象(即:一条记录
/// </summary>
public List <Sys_OpLog> GetAll()
{
List <Sys_OpLog> ret = new List <Sys_OpLog>();
string sql = "SELECT EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog where 1=1 AND ((Stat is null) or (Stat=0) ) order by EL_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_OpLog sys_OpLog = new Sys_OpLog();
if (dr["EL_ID"] != DBNull.Value)
{
sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
}
if (dr["EL_Module"] != DBNull.Value)
{
sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
}
if (dr["EL_ModuleName"] != DBNull.Value)
{
sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
}
if (dr["EL_Date"] != DBNull.Value)
{
sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
}
if (dr["EL_Author"] != DBNull.Value)
{
sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
}
if (dr["EL_AuthorName"] != DBNull.Value)
{
sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
}
if (dr["EL_ClientIP"] != DBNull.Value)
{
sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
}
if (dr["EL_RequireURL"] != DBNull.Value)
{
sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
}
if (dr["EL_Message"] != DBNull.Value)
{
sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
}
ret.Add(sys_OpLog);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的系统操作日志 Sys_OpLog对象集合
/// </summary>
public List <Sys_OpLog> GetListByWhere(string strCondition)
{
List <Sys_OpLog> ret = new List <Sys_OpLog>();
string sql = "SELECT EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY EL_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_OpLog sys_OpLog = new Sys_OpLog();
if (dr["EL_ID"] != DBNull.Value)
{
sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
}
if (dr["EL_Module"] != DBNull.Value)
{
sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
}
if (dr["EL_ModuleName"] != DBNull.Value)
{
sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
}
if (dr["EL_Date"] != DBNull.Value)
{
sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
}
if (dr["EL_Author"] != DBNull.Value)
{
sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
}
if (dr["EL_AuthorName"] != DBNull.Value)
{
sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
}
if (dr["EL_ClientIP"] != DBNull.Value)
{
sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
}
if (dr["EL_RequireURL"] != DBNull.Value)
{
sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
}
if (dr["EL_Message"] != DBNull.Value)
{
sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
}
ret.Add(sys_OpLog);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 添加系统操作日志 Sys_OpLog对象(即:一条记录)
/// </summary>
public int Add(Sys_OpLog sys_OpLog)
{
string sql = "INSERT INTO Sys_OpLog (EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat) VALUES (@EL_Module,@EL_ModuleName,@EL_Date,@EL_Author,@EL_AuthorName,@EL_ClientIP,@EL_RequireURL,@EL_Message,@Stat)";
if (string.IsNullOrEmpty(sys_OpLog.EL_Module))
{
idb.AddParameter("@EL_Module", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Module", sys_OpLog.EL_Module);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_ModuleName))
{
idb.AddParameter("@EL_ModuleName", DBNull.Value);
}
else
{
idb.AddParameter("@EL_ModuleName", sys_OpLog.EL_ModuleName);
}
if (sys_OpLog.EL_Date == DateTime.MinValue)
{
idb.AddParameter("@EL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Date", sys_OpLog.EL_Date);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_Author))
{
idb.AddParameter("@EL_Author", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Author", sys_OpLog.EL_Author);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_AuthorName))
{
idb.AddParameter("@EL_AuthorName", DBNull.Value);
}
else
{
idb.AddParameter("@EL_AuthorName", sys_OpLog.EL_AuthorName);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_ClientIP))
{
idb.AddParameter("@EL_ClientIP", DBNull.Value);
}
else
{
idb.AddParameter("@EL_ClientIP", sys_OpLog.EL_ClientIP);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_RequireURL))
{
idb.AddParameter("@EL_RequireURL", DBNull.Value);
}
else
{
idb.AddParameter("@EL_RequireURL", sys_OpLog.EL_RequireURL);
}
if (string.IsNullOrEmpty(sys_OpLog.EL_Message))
{
idb.AddParameter("@EL_Message", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Message", sys_OpLog.EL_Message);
}
if (sys_OpLog.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_OpLog.Stat);
}
return(idb.ExeCmd(sql));
}
/// <summary>
/// 获取指定的系统操作日志 Sys_OpLog对象(即:一条记录
/// </summary>
public Sys_OpLog GetByKey(decimal eL_ID)
{
Sys_OpLog sys_OpLog = new Sys_OpLog();
string sql = "SELECT EL_ID,EL_Module,EL_ModuleName,EL_Date,EL_Author,EL_AuthorName,EL_ClientIP,EL_RequireURL,EL_Message,Stat FROM Sys_OpLog WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND EL_ID=@EL_ID ";
idb.AddParameter("@EL_ID", eL_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["EL_ID"] != DBNull.Value)
{
sys_OpLog.EL_ID = Convert.ToDecimal(dr["EL_ID"]);
}
if (dr["EL_Module"] != DBNull.Value)
{
sys_OpLog.EL_Module = Convert.ToString(dr["EL_Module"]);
}
if (dr["EL_ModuleName"] != DBNull.Value)
{
sys_OpLog.EL_ModuleName = Convert.ToString(dr["EL_ModuleName"]);
}
if (dr["EL_Date"] != DBNull.Value)
{
sys_OpLog.EL_Date = Convert.ToDateTime(dr["EL_Date"]);
}
if (dr["EL_Author"] != DBNull.Value)
{
sys_OpLog.EL_Author = Convert.ToString(dr["EL_Author"]);
}
if (dr["EL_AuthorName"] != DBNull.Value)
{
sys_OpLog.EL_AuthorName = Convert.ToString(dr["EL_AuthorName"]);
}
if (dr["EL_ClientIP"] != DBNull.Value)
{
sys_OpLog.EL_ClientIP = Convert.ToString(dr["EL_ClientIP"]);
}
if (dr["EL_RequireURL"] != DBNull.Value)
{
sys_OpLog.EL_RequireURL = Convert.ToString(dr["EL_RequireURL"]);
}
if (dr["EL_Message"] != DBNull.Value)
{
sys_OpLog.EL_Message = Convert.ToString(dr["EL_Message"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_OpLog.Stat = Convert.ToInt32(dr["Stat"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(sys_OpLog);
}
/// <summary>
/// 更新系统操作日志 Sys_OpLog对象(即:一条记录
/// </summary>
public int Update(Sys_OpLog sys_OpLog)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_OpLog SET ");
if (sys_OpLog.EL_Module_IsChanged)
{
sbParameter.Append("EL_Module=@EL_Module, ");
}
if (sys_OpLog.EL_ModuleName_IsChanged)
{
sbParameter.Append("EL_ModuleName=@EL_ModuleName, ");
}
if (sys_OpLog.EL_Date_IsChanged)
{
sbParameter.Append("EL_Date=@EL_Date, ");
}
if (sys_OpLog.EL_Author_IsChanged)
{
sbParameter.Append("EL_Author=@EL_Author, ");
}
if (sys_OpLog.EL_AuthorName_IsChanged)
{
sbParameter.Append("EL_AuthorName=@EL_AuthorName, ");
}
if (sys_OpLog.EL_ClientIP_IsChanged)
{
sbParameter.Append("EL_ClientIP=@EL_ClientIP, ");
}
if (sys_OpLog.EL_RequireURL_IsChanged)
{
sbParameter.Append("EL_RequireURL=@EL_RequireURL, ");
}
if (sys_OpLog.EL_Message_IsChanged)
{
sbParameter.Append("EL_Message=@EL_Message, ");
}
if (sys_OpLog.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and EL_ID=@EL_ID; ");
string sql = sb.ToString();
if (sys_OpLog.EL_Module_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_Module))
{
idb.AddParameter("@EL_Module", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Module", sys_OpLog.EL_Module);
}
}
if (sys_OpLog.EL_ModuleName_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_ModuleName))
{
idb.AddParameter("@EL_ModuleName", DBNull.Value);
}
else
{
idb.AddParameter("@EL_ModuleName", sys_OpLog.EL_ModuleName);
}
}
if (sys_OpLog.EL_Date_IsChanged)
{
if (sys_OpLog.EL_Date == DateTime.MinValue)
{
idb.AddParameter("@EL_Date", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Date", sys_OpLog.EL_Date);
}
}
if (sys_OpLog.EL_Author_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_Author))
{
idb.AddParameter("@EL_Author", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Author", sys_OpLog.EL_Author);
}
}
if (sys_OpLog.EL_AuthorName_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_AuthorName))
{
idb.AddParameter("@EL_AuthorName", DBNull.Value);
}
else
{
idb.AddParameter("@EL_AuthorName", sys_OpLog.EL_AuthorName);
}
}
if (sys_OpLog.EL_ClientIP_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_ClientIP))
{
idb.AddParameter("@EL_ClientIP", DBNull.Value);
}
else
{
idb.AddParameter("@EL_ClientIP", sys_OpLog.EL_ClientIP);
}
}
if (sys_OpLog.EL_RequireURL_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_RequireURL))
{
idb.AddParameter("@EL_RequireURL", DBNull.Value);
}
else
{
idb.AddParameter("@EL_RequireURL", sys_OpLog.EL_RequireURL);
}
}
if (sys_OpLog.EL_Message_IsChanged)
{
if (string.IsNullOrEmpty(sys_OpLog.EL_Message))
{
idb.AddParameter("@EL_Message", DBNull.Value);
}
else
{
idb.AddParameter("@EL_Message", sys_OpLog.EL_Message);
}
}
if (sys_OpLog.Stat_IsChanged)
{
if (sys_OpLog.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_OpLog.Stat);
}
}
idb.AddParameter("@EL_ID", sys_OpLog.EL_ID);
return(idb.ExeCmd(sql));
}
