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