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