/// <summary>
/// 角色添加
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int AddRole(MODEL.Role role)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
conn.Open();
string sql1 = @"select * from T_Role where Name=:Name";
var Roles = conn.Query <MODEL.Role>(sql1, role);
int result = -1;
if (Roles.Count() == 0)
{
//添加角色
string sql = @"insert into T_role(Name,Description,Pid) values (:Name,:Description,:Pid)";
int result2 = conn.Execute(sql, role);
//获取角色id
string sql2 = ("select id from T_Role where Name=:Name");
var id = conn.Query <int>(sql2, role).FirstOrDefault();
var roles = role.Pid.Split(',');
for (int i = 0; i < roles.Length; i++)
{
MODEL.RolePermission rolePermission = new RolePermission();
rolePermission.Role_Id = id;
rolePermission.Permission_Id = Convert.ToInt32(roles[i]);
string sql3 = @"insert into Role_Permission (Role_Id,Permission_Id) values (:Role_Id,:Permission_Id) ";
result = conn.Execute(sql3, rolePermission);
}
}
return(result);
}
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int UpdateRole(MODEL.Role role)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
conn.Open();
string sql1 = @"select * from T_Role where Name=:Name";
var Roles = conn.Query <MODEL.Role>(sql1, role);
int result = -1;
if (Roles.Count() == 0 || Roles.Count() == 1)
{
//修改角色
string sql = @"update T_role set Name=:Name,Description=:Description where id=:id";
int result2 = conn.Execute(sql, role);
string sql2 = ("delete from role_permission where role_id=:role_id");
conn.Execute(sql2, new { role_id = role.ID });
var roles = role.Pid.Split(',');
for (int i = 0; i < roles.Length; i++)
{
MODEL.RolePermission rolePermission = new RolePermission();
rolePermission.Role_Id = role.ID;
rolePermission.Permission_Id = Convert.ToInt32(roles[i]);
string sql3 = @"insert into Role_Permission (role_id,Permission_Id) values (:role_id,:Permission_Id)";
result = conn.Execute(sql3, rolePermission);
}
}
return(result);
}
}
public frmRole()
{
InitializeComponent();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.SelectionChanged += (e, ee) =>
{
if (dataGridView1.SelectedRows.Count > 0)
{
curentObject = (dataGridView1.SelectedRows[0].DataBoundItem as MODEL.Role);
txtNom.Text = curentObject.Nom;
txtRemarque.Text = curentObject.Remarque;
}
};
}
private void btnNew_Click(object sender, EventArgs e)
{
btnNew.Enabled = !(NewObject = true);
curentObject = new MODEL.Role();
txtRemarque.Text = txtNom.Text = "";
}
