/// <summary>
/// 分页查询域
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public PagingModel<Domain> GetPagingDomain(DomainParam parameter)
{
IDomainDal domainDal = new DomainDal();
var paging = domainDal.GetPaging(parameter);
return paging;
}
/// <summary>
/// 根据参数查询所有的域
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public List<Domain> GetListDomain(DomainParam parameter)
{
List<Domain> domainList = new List<Domain>();
IDomainDal domainDal = new DomainDal();
//过滤参数
parameter.DomainName = DotNet.Utils.Untility.StringHelper.FilterHtml(parameter.DomainName);
domainList = domainDal.GetList(parameter);
return domainList;
}
/// <summary>
/// 域的分页
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public PagingModel<Domain> GetPaging(DomainParam parameter)
{
PagingModel<Domain> pagingModel = new PagingModel<Domain>()
{
PageIndex = parameter.PageIndex,
PageSize = parameter.PageSize
};
using (var connection = ConnectionFactory.GetMasterSql())
{
//跳过的页数
int skip = (parameter.PageIndex - 1) * parameter.PageSize;
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@" and DelFlag=@DelFlag");
#region where条件和参数
DynamicParameters param = new DynamicParameters();
param.Add("@DelFlag", (int)DelFlagEnum.Noraml);
//按照域代码进行搜索
if (!string.IsNullOrEmpty(parameter.DomainCode))
{
sb.AppendFormat(" and DomainCode=@DomainCode");
param.Add("@DomainCode", parameter.DomainCode);
}
//按照域级别进行搜索
if (parameter.DomainLevel > 0)
{
sb.AppendFormat(" and DomainLevel=@DomainLevel");
param.Add("@DomainLevel", parameter.DomainLevel);
}
//根据池子Id查询出所有的域
if (parameter.SSOPoolPoolId > 0)
{
sb.AppendFormat(" and SSOPoolPoolId=@SSOPoolPoolId");
param.Add("@SSOPoolPoolId", parameter.SSOPoolPoolId);
}
//按照域的名称来搜索
if (!string.IsNullOrEmpty(parameter.DomainName))
{
sb.AppendFormat(" and DomainName like @DomainName");
param.Add("@DomainName", string.Format("%{0}%", parameter.DomainName));
}
//域网址
if (!string.IsNullOrEmpty(parameter.DomainUrl))
{
sb.AppendFormat(" and DomainUrl like @DomainUrl");
param.Add("@DomainUrl", string.Format("%{0}%", parameter.DomainUrl));
}
//是否启用
if (Enum.IsDefined(typeof(IsEnabledEnum), parameter.IsEnabled))
{
sb.AppendFormat(" and IsEnabled=@IsEnabled");
param.Add("@IsEnabled", parameter.IsEnabled);
}
//是否单点登录
if (Enum.IsDefined(typeof(IsSSOEnum), parameter.IsSSO))
{
sb.AppendFormat(" and IsSSO=@IsSSO");
param.Add("@IsSSO", parameter.IsSSO);
}
//按上一级的Id
if (parameter.ParentDomainId > 0)
{
sb.AppendFormat(" and ParentDomainId=@ParentDomainId");
param.Add("@ParentDomainId", parameter.ParentDomainId);
}
//按上一级的域代码
//if (!string.IsNullOrEmpty(parameter.ParentDomainCode))
//{
// sb.AppendFormat("and ParentDomainCode=@ParentDomainCode");
// param.Add("@ParentDomainCode", parameter.ParentDomainCode);
//}
#endregion
string countSql = string.Format("Select count(*) from B_Domain where 1=1 {0}", sb.ToString());
var totalCount = connection.ExecuteScalar<int>(countSql, param);
pagingModel.TotalRecord = totalCount;
string sql = string.Format("Select top {0} * from (Select row_number() over (order by DomainLevel) AS RowNumber,* from B_Domain ) as tb where RowNumber>{1} {2}", parameter.PageSize, skip, sb.ToString());
var query = connection.Query<Domain>(sql, param);
pagingModel.Data = query.ToList();
}
return pagingModel;
}
public ActionResult DomainAccountList()
{
IDomainService domainService = new DomainService();
DomainParam parameter = new DomainParam()
{
PageIndex = DotNet.Utils.Untility.ConvertFactory.ToInt32(HttpUtility.UrlEncode(Request["page"]), 1),
PageSize = 12,
IsEnabled = DotNet.Utils.Untility.ConvertFactory.ToInt32(HttpUtility.UrlEncode(Request["isEnabled"]), 0),
DomainName = HttpUtility.HtmlEncode(Request["domainName"]),
IsPaging = true,
DomainCode = HttpUtility.HtmlEncode(Request["domainCode"]),
DomainLevel = DotNet.Utils.Untility.ConvertFactory.ToInt32(HttpUtility.UrlEncode(Request["domainLevel"]), 0),
IsSSO = DotNet.Utils.Untility.ConvertFactory.ToInt32(HttpUtility.UrlEncode(Request["isSSO"]), 0),
DomainUrl = HttpUtility.UrlEncode(Request["domainUrl"])
};
var pagingModel = domainService.GetPagingDomain(parameter);
return View(pagingModel);
}
/// <summary>
/// 按照某个条件查询出所有的域
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public List<Domain> GetList(DomainParam parameter)
{
using (var connection = ConnectionFactory.GetMasterSql())
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@" and DelFlag=@DelFlag");
#region where条件和参数
DynamicParameters param = new DynamicParameters();
param.Add("@DelFlag", (int)DelFlagEnum.Noraml);
//按照域代码进行搜索
if (!string.IsNullOrEmpty(parameter.DomainCode))
{
sb.AppendFormat(" and DomainCode=@DomainCode");
param.Add("@DomainCode", parameter.DomainCode);
}
//按照域级别进行搜索
if (parameter.DomainLevel > 0)
{
sb.AppendFormat(" and DomainLevel=@DomainLevel");
param.Add("@DomainLevel", parameter.DomainLevel);
}
//根据池子Id查询出所有的域
if (parameter.SSOPoolPoolId > 0)
{
sb.AppendFormat(" and SSOPoolPoolId=@SSOPoolPoolId");
param.Add("@SSOPoolPoolId", parameter.SSOPoolPoolId);
}
//按照域的名称来搜索
if (!string.IsNullOrEmpty(parameter.DomainName))
{
sb.AppendFormat(" and DomainName like @DomainName");
param.Add("@DomainName", string.Format("%{0}%", parameter.DomainName));
}
//域网址
if (!string.IsNullOrEmpty(parameter.DomainUrl))
{
sb.AppendFormat(" and DomainUrl like @DomainUrl");
param.Add("@DomainUrl", string.Format("%{0}%", parameter.DomainUrl));
}
//是否启用
if (Enum.IsDefined(typeof(IsEnabledEnum), parameter.IsEnabled))
{
sb.AppendFormat(" and IsEnabled=@IsEnabled");
param.Add("@IsEnabled", parameter.IsEnabled);
}
//是否单点登录
if (Enum.IsDefined(typeof(IsSSOEnum), parameter.IsSSO))
{
sb.AppendFormat(" and IsSSO=@IsSSO");
param.Add("@IsSSO", parameter.IsSSO);
}
//按上一级的Id
if (parameter.ParentDomainId > 0)
{
sb.AppendFormat(" and ParentDomainId=@ParentDomainId");
param.Add("@ParentDomainId", parameter.ParentDomainId);
}
#endregion
string sql = string.Format("Select * from B_Domain where 1=1 {0}", sb.ToString());
var query = connection.Query<Domain>(sql, param);
return query.ToList();
}
}
