/// <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);
}
