/// <summary>
/// 提取公共条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetWhere(QueryBlackWhiteListOperLog query)
{
StringBuilder whereStr = new StringBuilder();
if (!string.IsNullOrEmpty(query.PhoneNum))
{
if (query.PhoneNum.IndexOf(',') > 0)
{
whereStr.Append(" and PhoneNum in (");
string[] phoneS = query.PhoneNum.Split(',');
for (int i = 0; i < phoneS.Length; i++)
{
whereStr.Append("'" + SqlFilter(phoneS[i]) + "'");
if (i != phoneS.Length - 1)
{
whereStr.Append(",");
}
}
whereStr.Append(")");
}
else
{
whereStr.Append(" and PhoneNum='" + SqlFilter(query.PhoneNum) + "'");
}
}
if (query.BWType != Constant.INT_INVALID_VALUE)
{
whereStr.Append(" and BWType=" + query.BWType);
}
return(whereStr.ToString());
}
/// <summary>
/// 根据条件取黑白名单操作日志
/// </summary>
public DataTable GetBlackWhiteListOperLog(QueryBlackWhiteListOperLog query, string order, int currentPage, int pageSize, out int totalCount)
{
string whereStr = GetWhere(query);
SqlParameter[] parameters =
{
new SqlParameter("@where", SqlDbType.NVarChar, 40000),
new SqlParameter("@order", SqlDbType.NVarChar, 200),
new SqlParameter("@pagesize", SqlDbType.Int, 4),
new SqlParameter("@indexpage", SqlDbType.Int, 4),
new SqlParameter("@totalRecorder", SqlDbType.Int, 4)
};
parameters[0].Value = whereStr;
parameters[1].Value = order;
parameters[2].Value = pageSize;
parameters[3].Value = currentPage;
parameters[4].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_BlackWhiteListOperLog_Select", parameters);
totalCount = (int)(parameters[4].Value);
return(ds.Tables[0]);
}
/// <summary>
/// 根据条件取黑白名单操作日志
/// </summary>
/// <returns></returns>
public DataTable GetBlackWhiteListOperLog(QueryBlackWhiteListOperLog query, string order, int currentPage, int pageSize, out int totalCount)
{
return(Dal.BlackWhiteListOperLog.Instance.GetBlackWhiteListOperLog(query, order, currentPage, pageSize, out totalCount));
}
