/// <summary>
/// 统计日志数量
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetLogDataCount(HCQ2_Model.BaneUser.BaneLogParam param)
{
sb?.Clear();
sb.AppendFormat(@"SELECT COUNT(*) FROM Bane_LogDetail WHERE 1=1 ");
if (param.user_id > 0)
{
sb.AppendFormat(" AND user_id={0} ", param.user_id);
}
if (!string.IsNullOrEmpty(param.log_title))
{
sb.AppendFormat(" AND log_title LIKE '%{0}%' ", param.log_title);
}
if (!string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23) BETWEEN '{0}' AND '{1}' ", param.log_date_start, param.log_date_end);
}
else if (!string.IsNullOrEmpty(param.log_date_start) && string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)>='{0}' ", param.log_date_start);
}
else if (string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)<='{0}' ", param.log_date_end);
}
return(HCQ2_Common.Helper.ToInt(HCQ2_Common.SQL.SqlHelper.ExecuteScalar(sb.ToString())));
}
/// <summary>
/// 根据参数获取禁毒日志记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <HCQ2_Model.Bane_LogDetail> GetLogDataByParams(HCQ2_Model.BaneUser.BaneLogParam param)
{
sb?.Clear();
sb.AppendFormat(@"SELECT TOP {0} * FROM (SELECT ROW_NUMBER() OVER(ORDER BY log_id ASC) rowNUmber,* FROM Bane_LogDetail WHERE 1=1 ", param.rows);
if (param.user_id > 0)
{
sb.AppendFormat(" AND user_id={0} ", param.user_id);
}
if (!string.IsNullOrEmpty(param.log_title))
{
sb.AppendFormat(" AND log_title LIKE '%{0}%' ", param.log_title);
}
if (!string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23) BETWEEN '{0}' AND '{1}' ", param.log_date_start, param.log_date_end);
}
else if (!string.IsNullOrEmpty(param.log_date_start) && string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)>='{0}' ", param.log_date_start);
}
else if (string.IsNullOrEmpty(param.log_date_start) && !string.IsNullOrEmpty(param.log_date_end))
{
sb.AppendFormat(" AND CONVERT(NVARCHAR(20),log_date,23)<='{0}' ", param.log_date_end);
}
sb.AppendFormat(") logs WHERE logs.rowNUmber>{0};", (param.page - 1) * param.rows);
DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text);
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.Bane_LogDetail>(dt));
}
/// <summary>
/// 统计日志数量
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetLogDataCount(HCQ2_Model.BaneUser.BaneLogParam param)
{
return(DBSession.IBane_LogDetailDAL.GetLogDataCount(param));
}
/// <summary>
/// 根据参数获取禁毒日志记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <HCQ2_Model.Bane_LogDetail> GetLogDataByParams(HCQ2_Model.BaneUser.BaneLogParam param)
{
return(DBSession.IBane_LogDetailDAL.GetLogDataByParams(param));
}