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