/// <summary> /// 添加一个域 /// </summary> /// <param name="entity"></param> /// <returns></returns> public Domain AddEntity(Domain entity) { try { using (var connection = ConnectionFactory.GetMasterSql()) { string sql = @"Insert into B_Domain (DomainName,DomainCode,DomainKey,DomainPassword,DomainUrl,DomainLevel,ParentDomainId,IsEnabled,IsSSO,SSOUrl,CookieDomain,DelFlag,ReMark,SSOPoolPoolId) values(@DomainName,@DomainCode,@DomainKey,@DomainPassword,@DomainUrl,@DomainLevel,@ParentDomainId,@IsEnabled,@IsSSO,@SSOUrl,@CookieDomain,@DelFlag,@ReMark,@SSOPoolPoolId); select @@identity;"; var id = connection.ExecuteScalar<int>(sql, new { DomainName = entity.DomainName, DomainCode = entity.DomainCode, DomainUrl = entity.DomainUrl, DomainLevel = entity.DomainLevel, ParentDomainId = entity.ParentDomainId, IsEnabled = entity.IsEnabled, IsSSO = entity.IsSSO, SSOUrl = entity.SSOUrl, DomainKey = entity.DomainKey, DomainPassword = entity.DomainPassword, CookieDomain = entity.CookieDomain, DelFlag = (int)DelFlagEnum.Noraml, ReMark = entity.ReMark, SSOPoolPoolId = entity.SSOPoolPoolId }); var domain = connection.Query<Domain>(@"Select * from B_Domain where DomainId=@DomainId", new { DomainId = id }).FirstOrDefault(); return domain; } } catch { return null; } }
/// <summary> /// 添加域的实体 /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonModel<Domain> AddDomain(DomainAddModel model) { JsonModel<Domain> jsonModel = new JsonModel<Domain>() { Success = false, ErrMsg = "添加失败", SuccessMsg = "添加成功" }; try { //对实体进行验证 var validate = DotNet.Utils.DataValidate.ValidateHelper<DomainAddModel>.ValidateModel(model); if (!validate.Pass) { jsonModel.ErrMsg = validate.ResultList.FirstOrDefault().ErrorMessage; return jsonModel; } //过滤 model.DomainName = DotNet.Utils.Untility.StringHelper.FilterHtml(model.DomainName); model.ReMark = DotNet.Utils.Untility.StringHelper.FilterHtml(model.ReMark); //生成当前域的级别 int domainLevel = model.DomainLevel; int parentDomainId = model.ParentDomainId; BllUtility.DomainHandler.GetDomainLevel(ref domainLevel, ref parentDomainId); string domainKey = BllUtility.DomainHandler.GetDomainKey(); string domainCode = BllUtility.DomainHandler.GetDomainCode(); string domainPassword = BllUtility.DomainHandler.EncryptDomainPassword(model.DomainPassword, domainCode, domainKey); //构造实体 Domain domain = new Domain() { DomainName = model.DomainName, DomainCode = domainCode, DomainUrl = model.DomainUrl, DomainLevel = domainLevel, ParentDomainId = parentDomainId, IsEnabled = model.IsEnabled, IsSSO = model.IsSSO, SSOUrl = model.SSOUrl, DomainKey = domainKey, DomainPassword = domainPassword, CookieDomain = model.CookieDomain, DelFlag = (int)DelFlagEnum.Noraml, ReMark = model.ReMark, SSOPoolPoolId = model.SSOPoolPoolId }; IDomainDal domainDal = new DomainDal(); var r = domainDal.AddEntity(domain); if (r != null) { jsonModel.Success = true; jsonModel.Data = r; } else { jsonModel.ErrMsg = "数据插入失败"; } } catch (Exception ex) { jsonModel.ErrMsg = ex.Message; } return jsonModel; }
/// <summary> /// 修改域的数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public Domain UpdateEntity(Domain entity) { try { using (var connection = ConnectionFactory.GetMasterSql()) { var dbDomain = connection.Query<Domain>(@"Select * from B_Domain where DomainId=@DomainId", new { DomainId = @entity.DomainId }).FirstOrDefault(); if (dbDomain == null) { return null; } string sql = @"Update B_Domain set DomainName=@DomainName,DomainUrl=@DomainUrl,DomainLevel=@DomainLevel,ParentDomainId=@ParentDomainId,IsEnabled=@IsEnabled,IsSSO=@IsSSO,SSOUrl=@SSOUrl,DomainKey=@DomainKey,DomainPassword=@DomainPassword,CookieDomain=@CookieDomain,DelFlag=@DelFlag,ReMark=@ReMark,SSOPoolPoolId=@SSOPoolPoolId where DomainId=@DomainId"; var r = connection.Execute(sql, new { DomainName = entity.DomainName, DomainUrl = entity.DomainUrl, DomainLevel = entity.DomainLevel, ParentDomainId = entity.ParentDomainId, IsEnabled = entity.IsEnabled, IsSSO = entity.IsSSO, SSOUrl = entity.SSOUrl, DomainKey = entity.DomainKey,DomainPassword=entity.DomainPassword, CookieDomain = entity.CookieDomain, DelFlag = entity.DelFlag, ReMark = entity.ReMark, SSOPoolPoolId = entity.SSOPoolPoolId, DomainId = entity.DomainId }); if (r > 0) { var model = connection.Query<Domain>(@"Select * from B_Domain where DomainId=@DomainId", new { DomainId = @entity.DomainId }).FirstOrDefault(); return model; } else { return null; } } } catch { return null; } }