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