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