/// <summary> /// 获取操作日志信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MCaoZuoLogInfo> GetLogs(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaoZuoLogChaXunInfo chaXun) { IList <EyouSoft.Model.MCaoZuoLogInfo> items = new List <EyouSoft.Model.MCaoZuoLogInfo>(); string fields = "*,(SELECT A1.Name FROM tbl_YongHu AS A1 WHERE A1.YongHuId=tbl_CaoZuoLog.CaoZuoRenId) AS CaoZuoRenName"; StringBuilder sql = new StringBuilder(); string tableName = "tbl_CaoZuoLog"; string orderByString = " IssueTime DESC "; string heJiString = ""; #region sql sql.Append(" 1=1 "); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.GongSiId)) { sql.AppendFormat(" AND GongSiId='{0}' ", chaXun.GongSiId); } } #endregion using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString)) { while (rdr.Read()) { var info = new EyouSoft.Model.MCaoZuoLogInfo(); info.BiaoTi = rdr["BiaoTi"].ToString(); info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString(); info.CaoZuoRenName = rdr["CaoZuoRenName"].ToString(); info.GongSiId = rdr["GongSiId"].ToString(); info.GuanLianId = rdr["GuanLianId"].ToString(); info.IP = rdr["IP"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.LeiXing = (EyouSoft.Model.CaoZuoLogLeiXing)rdr.GetInt32(rdr.GetOrdinal("LeiXing")); info.LogId = rdr["LogId"].ToString(); info.NeiRong = rdr["NeiRong"].ToString(); items.Add(info); } } return(items); }
/// <summary> /// 获取操作日志信息集合 /// </summary> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.MCaoZuoLogInfo> GetLogs(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MCaoZuoLogChaXunInfo chaXun) { if (pageSize <= 0) { pageSize = 1; } if (pageIndex <= 0) { pageIndex = 1; } var items = dal.GetLogs(pageSize, pageIndex, ref recordCount, chaXun); return(items); }