//新增
public static int insert(RoleFunctionDto model)
{
string fatherId = "";
using (IDbConnection conn = MySqlConnection())
{
int result = 0;
IDbTransaction transaction = conn.BeginTransaction();
try
{
if (!model.RoleId.IsNullOrEmpty())
{
delete(model.RoleId);
if (!string.IsNullOrWhiteSpace(model.FunctionID))
{
foreach (var rid in model.FunctionID.Split(','))
{
if (!string.IsNullOrWhiteSpace(rid))
{
if (rid.Length > 1)
{
if (SonFunction.GetById(rid).FatherId != fatherId)
{
conn.Execute(
"Insert into rolefunction values (@RoleId,@FunctionId)",
new RoleFunctionDto
{
RoleId = model.RoleId,
FunctionID = SonFunction.GetById(rid).FatherId
});
fatherId = SonFunction.GetById(rid).FatherId;
}
}
conn.Execute("Insert into rolefunction values (@RoleId,@FunctionId)",
new RoleFunctionDto
{
RoleId = model.RoleId,
FunctionID = rid
});
//RoleUser.Insert(});
}
}
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
return(result);
}
}
public ActionResult SetPermission(FormCollection coll)
{
OperationResult r = new OperationResult();
RoleFunctionDto model = new RoleFunctionDto();
try
{
model.RoleId = coll["role"].ToString().Split(',')[0].CastTo <Guid>().ToString();
model.FunctionID = coll["function"] == null ? "" : coll["function"].ToString();
RoleFunction.insert(model);
r.ResultType = OperationResultType.Success;
}
catch
{
r.Message = "新增失败，请检查所填数据是否正确。";
r.ResultType = OperationResultType.Error;
}
return(Json(r));
}
