/// <summary> /// 根据唯一条件查询域 /// </summary> /// <param name="parameter"></param> /// <returns></returns> public Domain GetEntity(DomainSingleParam parameter) { using (var connection = ConnectionFactory.GetMasterSql()) { StringBuilder sb = new StringBuilder(); DynamicParameters param = new DynamicParameters(); param.Add("@DelFlag", (int)DelFlagEnum.Noraml); //根据Id查询 if (parameter.DomainId > 0) { sb.AppendFormat(" and DomainId=@DomainId"); param.Add("@DomainId", parameter.DomainId); } //域标识查询 if (!string.IsNullOrEmpty(parameter.DomainCode)) { sb.AppendFormat(" and DomainCode=@DomainCode"); param.Add("@DomainCode", parameter.DomainCode); } string sql = string.Format(@"Select * from B_Domain where DelFlag=@DelFlag {0}", sb.ToString()); var query = connection.Query<Domain>(sql, param); return query.FirstOrDefault(); } }
/// <summary> /// 根据唯一参数查询域 /// </summary> /// <param name="domainId"></param> /// <returns></returns> public Domain GetDomain(DomainSingleParam parameter) { IDomainDal domainDal = new DomainDal(); //过滤 parameter.DomainCode = DotNet.Utils.Untility.StringHelper.FilterHtml(parameter.DomainCode); var domain = domainDal.GetEntity(parameter); return domain; }