/// <summary>
/// 角色添加
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int AddRoles(Roles role)
{
using (OracleConnection conn = DapperHelper.GetConnectionString())
{
string sql = string.Format("insert into Roles(RoleName,RoleDescribe) values(:RoleName,:RoleDescribe)");
var add = conn.Execute(sql, role);
string sql1 = string.Format("select RoleID from Roles where RoleName=:RoleName");
var id = conn.Query <int>(sql1, role).FirstOrDefault();
var roles = role.PerMissionID.Split(',');
for (int i = 0; i < roles.Length; i++)
{
RolePerMission rolePerMission = new RolePerMission();
rolePerMission.RoleID = id;
rolePerMission.PerMissionID = roles[i];
string sql2 = string.Format("insert into RolePerMission (PerMissionID,RoleID) values(:PerMissionID,:RoleID)");
var addrole = conn.Execute(sql2, rolePerMission);
}
return(add);
}
}
public int UpdateRoles(Roles role)
{
using (OracleConnection conn = DapperHelper.GetConnectionString())
{
string sql = string.Format("update roles set RoleName=:RoleName,RoleDescribe=:RoleDescribe where RoleID=:RoleID");
var add = conn.Execute(sql, role);
var roles = role.PerMissionID.Split(',');
string sql1 = string.Format("DELETE FROM RolePerMission where RoleID=:RoleID");
var id = conn.Query <int>(sql1, new { RoleID = role.RoleID });
for (int i = 0; i < roles.Length; i++)
{
RolePerMission rolePerMission = new RolePerMission();
rolePerMission.RoleID = role.RoleID;
rolePerMission.PerMissionID = roles[i];
string sql2 = string.Format("insert into RolePerMission (PerMissionID,RoleID) values(:PerMissionID,:RoleID)");
var addrole = conn.Execute(sql2, rolePerMission);
}
return(add);
}
}
