/// <summary>
/// 获取操作日志信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="userId">数据级浏览权限控制-用户编号</param>
/// <param name="depts">数据级浏览权限控制-部门集合</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="recordCount">总记录数</param>
/// <param name="searchInfo">查询信息</param>
/// <returns></returns>
public IList <EyouSoft.Model.SysStructure.MSysLogHandleInfo> GetLogs(string companyId, string userId, int[] depts, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.SysStructure.MSysLogHandleSearch searchInfo)
{
IList <EyouSoft.Model.SysStructure.MSysLogHandleInfo> list = new List <EyouSoft.Model.SysStructure.MSysLogHandleInfo>();
EyouSoft.Model.SysStructure.MSysLogHandleInfo item = null;
StringBuilder cmdQuery = new StringBuilder();
string TableName = "view_SysLogHandle";
string OrderByString = "IssueTime DESC";
string fields = "*";
#region SQL
cmdQuery.AppendFormat(" CompanyId='{0}' ", companyId);
cmdQuery.AppendFormat(GetOrgCondition(userId, depts, "OperatorId", "DeptId"));
if (searchInfo != null)
{
if (!string.IsNullOrEmpty(searchInfo.OperatorId))
{
cmdQuery.AppendFormat(" and OperatorId='{0}'", searchInfo.OperatorId);
}
if (searchInfo.DeptId.HasValue)
{
cmdQuery.AppendFormat(" and DeptId={0}", searchInfo.DeptId.Value);
}
if (!string.IsNullOrEmpty(searchInfo.Operator))
{
cmdQuery.AppendFormat(" and Operator LIKE '%{0}%'", searchInfo.Operator);
}
if (searchInfo.EDate.HasValue)
{
cmdQuery.AppendFormat(" and datediff(day,'{0}',IssueTime)<=0", searchInfo.EDate.Value);
}
if (searchInfo.SDate.HasValue)
{
cmdQuery.AppendFormat(" and datediff(day,'{0}',IssueTime)>=0", searchInfo.SDate.Value);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, TableName, string.Empty, fields, cmdQuery.ToString(), OrderByString))
{
while (rdr.Read())
{
item = new EyouSoft.Model.SysStructure.MSysLogHandleInfo()
{
Operator = rdr["Operator"].ToString(),
DeptId = rdr.GetInt32(rdr.GetOrdinal("DeptId")),
DeptName = rdr["DepartName"].ToString(),
Menu2Name = rdr["Menu2Name"].ToString(),
RemoteIp = rdr["RemoteIp"].ToString(),
IssueTime = rdr.IsDBNull(rdr.GetOrdinal("IssueTime")) ? DateTime.MinValue : rdr.GetDateTime(rdr.GetOrdinal("IssueTime")),
Content = rdr["Content"].ToString(),
Menu1Name = rdr["Menu1Name"].ToString()
};
list.Add(item);
}
}
return(list);
}
/// <summary>
/// 记录操作日志
/// </summary>
/// <param name="item">操作日志信息业务实体</param>
/// <returns></returns>
public bool Insert(EyouSoft.Model.SysStructure.MSysLogHandleInfo info)
{
DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_Insert);
_db.AddInParameter(cmd, "LogId", DbType.AnsiStringFixedLength, info.LogId);
_db.AddInParameter(cmd, "CompanyId", DbType.AnsiStringFixedLength, info.CompanyId);
_db.AddInParameter(cmd, "DeptId", DbType.Int32, info.DeptId);
_db.AddInParameter(cmd, "OperatorId", DbType.AnsiStringFixedLength, info.OperatorId);
_db.AddInParameter(cmd, "Operator", DbType.String, info.Operator);
_db.AddInParameter(cmd, "Menu1Id", DbType.Int32, info.Menu1Id);
_db.AddInParameter(cmd, "Menu2Id", DbType.Int32, info.Menu2Id);
_db.AddInParameter(cmd, "Content", DbType.String, info.Content);
_db.AddInParameter(cmd, "RemoteIp", DbType.String, info.RemoteIp);
_db.AddInParameter(cmd, "IssueTime", DbType.DateTime, info.IssueTime);
return(DbHelper.ExecuteSql(cmd, _db) == 1 ? true : false);
}
