Пример #1
0
 /// <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();
     }
 }
Пример #2
0
 /// <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;
 }