/// <summary> /// 修改规则 /// </summary> public override void Modify() { object id = gvData.GetFocusedRowCellValue("Id"); if (id != null) { var BlackIPId = clsPublic.GetObjGUID(id); Models.ACL_BlackIP md = lsSource.FirstOrDefault(a => a.Id == BlackIPId); FBlackIP_User sub = new FBlackIP_User(md); if (sub.ShowDialog() == DialogResult.OK) { Query(); } } }
/// <summary> /// 带参数数的构造函数 /// </summary> /// <param name="md">实体</param> public FBlackIP_User(Models.ACL_BlackIP md) { InitializeComponent(); model = md; this.Text = "编辑--" + this.Text; if (model != null) { txtName.Text = model.BlackIPName; cboxType.SelectedItem = model.AuthorizeType; txtStartIP.Text = model.StartIP; txtEndIP.Text = model.EndIP; txtRemark.Text = model.Description; IsEnabled.Checked = model.IsRemoved; gcUser.DataSource = manager.GetUserByBlackIP(model.Id); } else { clsPublic.ShowMessage("[规则]=" + model.BlackIPName + "的记录不存在", Text); base.DialogResult = DialogResult.Cancel; } }
/// <summary> /// 修改防火墙规则 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ACL_BlackIP model) { return(Sev.Modify(model)); }
/// <summary> /// 新增防火墙规则 /// </summary> /// <param name="model">实体</param> /// <param name="userlist">用户列表</param> /// <returns></returns> public bool AddNew(Models.ACL_BlackIP model) { return(Sev.AddNew(model)); }
/// <summary> /// 修改防火墙规则 /// </summary> /// <param name="model">实体</param> /// <returns></returns> public bool Modify(Models.ACL_BlackIP model) { Dictionary <SqlParameter[], string> sqlDic = new Dictionary <SqlParameter[], string>(); string sqlText1 = @"UPDATE [RightingSys].[dbo].[ACL_BlackIP] SET [BlackIPName] = @BlackIPName ,[AuthorizeType] = @AuthorizeType ,[StartIP] = @StartIP ,[EndIP] = @EndIP ,[OperatorId] = @OperatorId ,[OperatorName] = @OperatorName ,[Description] = @Description ,[SystemId] = @SystemId ,[SystemName] = @SystemName ,[IsRemoved]=@IsRemoved WHERE[Id] = @Id"; SqlParameter[] Params1 = new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@BlackIPName", model.BlackIPName), new SqlParameter("@AuthorizeType", model.AuthorizeType), new SqlParameter("@StartIP", model.StartIP), new SqlParameter("@EndIP", model.EndIP), new SqlParameter("@OperatorId", model.OperatorId), new SqlParameter("@OperatorName", model.OperatorName), new SqlParameter("@Description", model.Description), new SqlParameter("@SystemId", model.SystemId), new SqlParameter("@SystemName", model.SystemName), new SqlParameter("@IsRemoved", model.IsRemoved) }; sqlDic.Add(Params1, sqlText1); string sqlText3 = "DELETE FROM [RightingSys].[dbo].[ACL_BlackIP_User] WHERE BlackIPId=@BlackIPId"; SqlParameter[] Params3 = new SqlParameter[] { new SqlParameter("@BlackIPId", model.Id) }; sqlDic.Add(Params3, sqlText3); foreach (Models.ACL_User s in model.Details) { string SqlText2 = @"INSERT INTO [RightingSys].[dbo].[ACL_BlackIP_User] ([Id] ,[BlackIPId] ,[UserId] ,[LoginName] ,[UserName] ,[UserSimpleCode] ,[DepartmentName]) VALUES (@Id ,@BlackIPId ,@UserId ,@LoginName ,@UserName ,@UserSimpleCode ,@DepartmentName)"; SqlParameter[] Params2 = new SqlParameter[] { new SqlParameter("@Id", Guid.NewGuid()), new SqlParameter(@"BlackIPId", model.Id), new SqlParameter(@"UserId", s.Id), new SqlParameter("@LoginName", s.LoginName), new SqlParameter("@UserName", s.FullName), new SqlParameter(@"UserSimpleCode", s.SimpleCode), new SqlParameter(@"DepartmentName", s.DepartmentName) }; sqlDic.Add(Params2, SqlText2); } Models.SqlHelper.AddNewOperatorLog("修改黑白名单", "ACL_BlackIP,ACL_BlackIP_User", "修改", string.Join(" # ", sqlDic)); return(Models.SqlHelper.ExecuteTransaction1(sqlDic) > 0); }