protected void PageInit()
{
//部门编号
int?DepartId = Utils.GetIntNull(Utils.GetQueryStringValue("departId"));
//操作员
string Operator = Utils.GetQueryStringValue("operator");
//操作开始时间
string BeginDate = Utils.GetQueryStringValue("txtBeginDate");
//操作结束时间
string EndDate = Utils.GetQueryStringValue("txtEndDate");
//当前页
pageIndex = UtilsCommons.GetPadingIndex();
IList <EyouSoft.Model.ComStructure.MComDepartment> list1 = new EyouSoft.BLL.ComStructure.BComDepartment().GetList(SiteUserInfo.CompanyId);
this.ddlDepart.DataTextField = "DepartName";
this.ddlDepart.DataValueField = "DepartId";
this.ddlDepart.DataSource = list1;
this.ddlDepart.DataBind();
this.ddlDepart.Items.Insert(0, new ListItem("请选择", "0"));
IList <EyouSoft.Model.SysStructure.MSysLogHandleInfo> list = null;
EyouSoft.Model.SysStructure.MSysLogHandleSearch search = new EyouSoft.Model.SysStructure.MSysLogHandleSearch();
search.DeptId = DepartId == 0 ? null : DepartId;
search.Operator = Operator;
if (BeginDate != "")
{
search.SDate = Utils.GetDateTime(BeginDate);
}
if (EndDate != "")
{
search.EDate = Utils.GetDateTime(EndDate);
}
list = new EyouSoft.BLL.SysStructure.BSysLogHandle().GetLogs(SiteUserInfo.CompanyId, pageSize, pageIndex, ref recordCount, search);
this.ddlDepart.SelectedValue = DepartId.ToString();
this.txtOperator.Value = Operator;
this.txtBeginDate.Value = BeginDate;
this.txtEndDate.Value = EndDate;
if (list != null && list.Count > 0)
{
this.repList.DataSource = list;
this.repList.DataBind();
BindPage();
}
else
{
this.repList.EmptyText = "<tr><td colspan=\"6\" align=\"center\">未找到相关记录!</td></tr>";
}
}
/// <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);
}
