/// <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; //部门编号 }