/// <summary>
/// 分页获取操作日志列表
/// </summary>
/// <param name="pageSize">每页现实条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="model">系统操作日志查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.SysHandleLogs> GetList(int pageSize, int pageIndex, ref int RecordCount, EyouSoft.Model.CompanyStructure.QueryHandleLog model)
{
IList <EyouSoft.Model.CompanyStructure.SysHandleLogs> totals = new List <EyouSoft.Model.CompanyStructure.SysHandleLogs>();
string tableName = "View_SysHandleLogs";
string primaryKey = "ID";
string orderByString = "EventTime DESC";
string fields = " Id, OperatorId, DepatId, CompanyId, ModuleId,EventCode,EventMessage,EventTitle,EventTime,EventIp,UserName,DepartName";
StringBuilder cmdQuery = new StringBuilder();
cmdQuery.AppendFormat(" CompanyId = {0}", model.CompanyId);
if (model.DepartId > 0)
{
cmdQuery.AppendFormat(" and DepatId={0}", model.DepartId);
}
if (model.OperatorId > 0)
{
cmdQuery.AppendFormat(" and OperatorId={0}", model.OperatorId);
}
if (model.HandStartTime != null)
{
cmdQuery.AppendFormat(" and EventTime >= '{0}'", model.HandStartTime);
}
if (model.HandEndTime != null)
{
cmdQuery.AppendFormat(" and EventTime <= '{0}' ", model.HandEndTime);
}
using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
EyouSoft.Model.CompanyStructure.SysHandleLogs sysHandleLogsInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs();
sysHandleLogsInfo.ID = rdr.GetString(rdr.GetOrdinal("ID"));
sysHandleLogsInfo.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
sysHandleLogsInfo.DepatId = rdr.GetInt32(rdr.GetOrdinal("DepatId"));
sysHandleLogsInfo.CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId"));
sysHandleLogsInfo.ModuleId = (EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass)rdr.GetInt32(rdr.GetOrdinal("ModuleId"));
sysHandleLogsInfo.EventCode = rdr.GetInt32(rdr.GetOrdinal("EventCode"));
sysHandleLogsInfo.EventMessage = rdr.GetString(rdr.GetOrdinal("EventMessage"));
sysHandleLogsInfo.EventTitle = rdr.GetString(rdr.GetOrdinal("EventTitle"));
sysHandleLogsInfo.EventTime = rdr.GetDateTime(rdr.GetOrdinal("EventTime"));
sysHandleLogsInfo.EventIp = rdr.GetString(rdr.GetOrdinal("EventIp"));
sysHandleLogsInfo.OperatorName = rdr.GetString(rdr.GetOrdinal("UserName"));
sysHandleLogsInfo.DepartName = rdr.GetString(rdr.GetOrdinal("DepartName"));
totals.Add(sysHandleLogsInfo);
}
}
return(totals);
}
/// <summary>
/// 分页获取操作日志列表
/// </summary>
/// <param name="pageSize">每页现实条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="model">系统操作日志查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.SysHandleLogs> GetList(int pageSize, int pageIndex, ref int RecordCount, EyouSoft.Model.CompanyStructure.QueryHandleLog model)
{
return(Dal.GetList(pageSize, pageIndex, ref RecordCount, model));
}
protected int itemIndex;//序号
protected void Page_Load(object sender, EventArgs e)
{
//判断权限
if (!CheckGrant(global::Common.Enum.TravelPermission.系统设置_系统日志_系统日志栏目))
{
Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.系统设置_系统日志_系统日志栏目, true);
return;
}
pageIndex = Utils.GetInt(Utils.GetQueryStringValue("Page"), 1);
itemIndex = (pageIndex - 1) * pageSize + 1;
EyouSoft.BLL.CompanyStructure.SysHandleLogs logBll = new EyouSoft.BLL.CompanyStructure.SysHandleLogs();//日志bll
//获取查询条件
string operatorId = Utils.GetQueryStringValue("operator");
string startDate = Utils.GetQueryStringValue("startDate");
string endDate = Utils.GetQueryStringValue("endDate");
string departId = Utils.GetQueryStringValue("departId");
EyouSoft.BLL.CompanyStructure.Department departBll = new EyouSoft.BLL.CompanyStructure.Department();//部门bll
//绑定部门列表
IList <EyouSoft.Model.CompanyStructure.Department> departList = departBll.GetAllDept(CurrentUserCompanyID);
if (departList != null && departList.Count > 0)
{
selDeaprt.DataTextField = "DepartName";
selDeaprt.DataValueField = "Id";
selDeaprt.DataSource = departList;
selDeaprt.DataBind();
}
selDeaprt.Items.Insert(0, new ListItem("请选择", "0"));
//绑定操作员列表
EyouSoft.BLL.CompanyStructure.CompanyUser userBll = new EyouSoft.BLL.CompanyStructure.CompanyUser(SiteUserInfo);//初始化bll
IList <EyouSoft.Model.CompanyStructure.CompanyUser> userlist = userBll.GetCompanyUser(CurrentUserCompanyID);
if (userlist != null && userlist.Count > 0)
{
foreach (EyouSoft.Model.CompanyStructure.CompanyUser user in userlist)
{
selOperator.Items.Add(new ListItem(user.PersonInfo.ContactName, user.ID.ToString()));
}
}
selOperator.Items.Insert(0, new ListItem("请选择", "0"));
//日志查询试实体
EyouSoft.Model.CompanyStructure.QueryHandleLog queryLog = new EyouSoft.Model.CompanyStructure.QueryHandleLog();
queryLog.CompanyId = CurrentUserCompanyID; //公司编号
queryLog.DepartId = Utils.GetInt(departId); //部门编号
queryLog.HandEndTime = Utils.GetDateTimeNullable(endDate); //操作结束时间
queryLog.HandStartTime = Utils.GetDateTimeNullable(startDate); //操作开始时间
queryLog.OperatorId = Utils.GetInt(operatorId); //操作员
//绑定日志列表
IList <EyouSoft.Model.CompanyStructure.SysHandleLogs> list = logBll.GetList(pageSize, pageIndex, ref recordCount, queryLog);
if (list != null && list.Count > 0)
{
rptLog.DataSource = list;
rptLog.DataBind();
BindExportPage();
}
else
{
rptLog.EmptyText = "<tr><td colspan='10' align='center'>对不起，暂无日志信息！</td></tr>";
ExportPageInfo1.Visible = false;
}
//恢复查询关键字
txtEndDate.Value = endDate; //操作结束时间
selOperator.Value = operatorId; //操作员
txtStartDate.Value = startDate; //操作开始时间
selDeaprt.Value = departId; //部门编号
}
