public void moveRole(roleModel role) { if (role.isOnBoat()) // from boat to land { landModel land; if (boat.getBoatFlag() == 1) { land = startLand; } else { land = endLand; } role.getOnLand(land); } else if (!role.isOnBoat()) //from land to boat { landModel land = role.getLand(); if (boat.getEmptyPosIndex() == -1 || boat.getBoatFlag() != land.getLandFlag()) { return; } role.getOnBoat(boat); } }
public async Task <IActionResult> XG(string dt, string bh, string sm, string zt) { String[] arr = dt.Split(","); string sql = $@"delete dbo.Quanjs where Qid={HttpContext.Session.GetString("Tj")}"; int aa = tesc.Database.ExecuteSqlCommand(sql); int a = 0; roleModel r = new roleModel() { r_id = int.Parse(bh), r_sm = sm, r_status = int.Parse(zt) }; int result = await irb.Update(r); string sql1 = ""; for (int i = 0; i < arr.Length; i++) { sql1 = $@"insert into dbo.Quanjs VALUES({HttpContext.Session.GetString("Tj")},{arr[i]})"; a = tesc.Database.ExecuteSqlCommand(sql1); } if (a > 0) { return(Ok(a)); } else { return(Ok(a)); } }
public async Task <IActionResult> right_adds() { string JSMC = HttpContext.Request.Form["sysRole.roleName"]; string SFKY = HttpContext.Request.Form["sysRole.roleFlag"]; string SM = HttpContext.Request.Form["sysRole.roleDesc"]; roleModel a = new roleModel() { user_identity = JSMC, r_status = Convert.ToInt32(SFKY), r_sm = SM }; if (ModelState.IsValid) { if (await irb.ADD(a) > 0) { return(RedirectToAction("right_list")); } else { return(RedirectToAction("right_add")); } } else { return(RedirectToAction("right_add")); } }
public void loadResources() { GameObject river = GameObject.Instantiate(Resources.Load("Prefabs/river"), Vector3.zero, Quaternion.identity) as GameObject; river.name = "river"; startLand = new landModel(1); endLand = new landModel(-1); boat = new boatModel(); roles = new roleModel[6]; for (int i = 0; i < 3; ++i) { roleModel role = new roleModel(0); //priest role.setName("priest" + i); role.getOnLand(startLand); role.lastPosition = role.getPosition(); roles[i] = role; } for (int i = 0; i < 3; ++i) { roleModel role = new roleModel(1); //devil role.setName("devil" + i); role.getOnLand(startLand); role.lastPosition = role.getPosition(); roles[i + 3] = role; } }
public string updateRoleById(roleModel rm) { string res = ""; try { connection(); using (SqlCommand cmd = new SqlCommand("Prc_UpdateRoleById", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@roleId", rm.ROLE_ID); cmd.Parameters.AddWithValue("@roleName", rm.ROLE_NAME); cmd.Parameters.AddWithValue("@status", rm.STATUS); cmd.Parameters.Add("@LoginValue", SqlDbType.Structured).Value = cm; SqlParameter param = new SqlParameter(); param.ParameterName = "@message"; param.SqlDbType = SqlDbType.NVarChar; param.Size = 100; param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } catch (Exception ex) { res = ex.Message; } return(res); }
public async Task <IActionResult> right_list_information(int id) { HttpContext.Session.SetString("Tj", id.ToString()); roleModel Lb = await irb.Select(id); ViewData.Model = Lb; return(View()); }
public IActionResult AddRole() { var role = new roleModel(); SeedPermissions(role); return(View(role)); }
///Update Procedure Data Controller public bool UpdateRole(roleModel currentRole) { DbCommand sp_updatect2Roles = db.GetStoredProcCommand("sp_updatect2Roles"); db.AddInParameter(sp_updatect2Roles, "@roleID", SqlDbType.Int, currentRole.roleID); db.AddInParameter(sp_updatect2Roles, "@roleDescription", SqlDbType.VarChar, currentRole.roleDescription); return(false); }
/// Delete Procedure Data Controller public bool DeleteRole(roleModel removingRole) { DbCommand sp_deletect2Roles = db.GetStoredProcCommand("sp_deletect2Roles"); db.AddInParameter(sp_deletect2Roles, "@roleID", SqlDbType.Int, removingRole.roleID); return(false); }
public async Task <int> ADD(roleModel bjm) { role a = new role() { user_identity = bjm.user_identity, r_status = bjm.r_status, r_sm = bjm.r_sm }; qx.Roles.Add(a); return(await qx.SaveChangesAsync()); }
private void SeedPermissions(roleModel viewModel) { var root = new JsTreeNode(); var allList = GetAllPermissions(); var tree = new JsTree { SelectedIds = viewModel.Permissions.SelectedIds, Nodes = ToTree(allList.ToList()) }; viewModel.Permissions = tree; }
public List <roleModel> FenYe(FenYeModel fen) { List <roleModel> list = new List <roleModel>(); SqlParameter[] ps = { new SqlParameter() { ParameterName = "@pageSize", Value = fen.PageSize }, new SqlParameter() { ParameterName = "@keyName", Value = fen.KeyName }, new SqlParameter() { ParameterName = "@tableName", Value = fen.TableName }, new SqlParameter() { ParameterName = "@where", Value = fen.Where }, new SqlParameter() { ParameterName = "@currentPage", Value = fen.CurrentPage }, new SqlParameter() { ParameterName = "@rows", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@pages", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int } }; var sql = qx.Roles.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList(); foreach (var ad in sql) { roleModel h = new roleModel() { r_id = ad.r_id, r_sm = ad.r_sm, r_status = ad.r_status, user_identity = ad.user_identity }; list.Add(h); } fen.Pages = (int)ps[6].Value; fen.Rows = (int)ps[5].Value; return(list); }
public IActionResult EditRole(roleModel role) { var rolePer = role.Permissions; if (!ModelState.IsValid) { SeedPermissions(role); ShowTipMessage(LayerIconType.Sigh, "", false); return(View(role)); } var selectIds = role.Permissions.SelectedIds; SeedPermissions(role); try { List <roleprivilege> roles = new List <roleprivilege>(); _database.RunInTransaction(() => { //更新角色信息 DapperExtensions.DapperExtensions.DefaultMapper = typeof(roleMapper); var reUpdate = _database.Update( new roleModel { name = role.name, defaulturl = role.defaulturl, remark = role.remark }, Predicates.Field <roleModel>(t => t.id, Operator.Eq, role.id)); //删除老权限 var result = _database.Delete <roleprivilege>(Predicates.Field <roleprivilege>(t => t.roleid, Operator.Eq, role.id)); //重新添加权限点 foreach (var item in selectIds) { roles.Add(new roleprivilege { roleid = role.id, privilegeid = item }); } _database.Insert <roleprivilege>(roles); }); ShowTipMessage(LayerIconType.Success); _authorization.Refresh(role.id.ToString()); _cache.Remove(_cacheRoleList); } catch (Exception e) { ShowTipMessage(LayerIconType.Erro, "", false); } return(View(role)); }
public async Task <roleModel> Select(int id) { role a = await qx.Roles.FindAsync(id); roleModel b = new roleModel() { r_id = a.r_id, user_identity = a.user_identity, r_sm = a.r_sm, r_status = a.r_status }; return(b); }
public async Task <int> Update(roleModel rb) { role us = new role() { r_id = rb.r_id, r_sm = rb.r_sm, user_identity = rb.user_identity, r_status = rb.r_status }; qx.Roles.Attach(us); qx.Entry(us).Property(p => p.r_sm).IsModified = true; qx.Entry(us).Property(p => p.r_status).IsModified = true; return(await qx.SaveChangesAsync()); }
///Create Procedure Data Controller public int createRole(roleModel currentRole) { int success; DbCommand sp_createct2Roles = db.GetStoredProcCommand("sp_createct2Roles"); sp_createct2Roles.Connection = db.CreateConnection(); sp_createct2Roles.Connection.Open(); db.AddInParameter(sp_createct2Roles, "@roleDescription", SqlDbType.VarChar, currentRole.roleDescription); success = sp_createct2Roles.ExecuteNonQuery(); return(success); }
public roleModel getUserRole(string username) { using (server = new serverEntity()) { var userRole = server.user_info.Where(x => x.username.Equals(username, StringComparison.CurrentCulture)) .FirstOrDefault(); var roleMod = new roleModel() { role = userRole.role, user_id = userRole.user_id, username = userRole.username, }; return(roleMod); } }
public async Task <List <roleModel> > RoleSelect() { List <roleModel> list = new List <roleModel>(); List <role> list1 = await Task.Run(() => { return(qx.Roles.ToList()); }); foreach (role item in list1) { roleModel um = new roleModel() { r_id = item.r_id, user_identity = item.user_identity, r_sm = item.r_sm }; list.Add(um); } return(list); }
//change in v2 public void moveRole(roleModel role) { if (role.isOnBoat()) // from boat to land { landModel land; if (boat.getBoatFlag() == 1) { land = startLand; } else { land = endLand; } boat.deleteRole(role.getName()); //action Vector3 startPos = role.getPosition(); Vector3 endPos = land.getEmptyPosition(); Vector3 middlePos = new Vector3(startPos.x, endPos.y, startPos.z); actionManager.moveRole(role.getRole(), middlePos, endPos, 100 * Time.deltaTime); land.addRole(role); role.getOnLand(land); } else if (!role.isOnBoat()) //from land to boat { landModel land = role.getLand(); if (boat.getEmptyPosIndex() == -1 || boat.getBoatFlag() != land.getLandFlag()) { return; } land.deleteRole(role.getName()); //action Vector3 startPos = role.getPosition(); Vector3 endPos = boat.getEmptyPosition(); Vector3 middlePos = new Vector3(endPos.x, startPos.y, startPos.z); actionManager.moveRole(role.getRole(), middlePos, endPos, 100 * Time.deltaTime); boat.addRole(role); role.getOnBoat(boat); } }
public IActionResult AddRole(roleModel role) { if (!ModelState.IsValid) { SeedPermissions(role); ShowTipMessage(LayerIconType.Sigh, "", false); return(View(role)); } //事务操作 var selectIds = role.Permissions.SelectedIds; SeedPermissions(role); int roleId = 0; try { DapperExtensions.DapperExtensions.DefaultMapper = typeof(roleMapper); List <roleprivilege> roles = new List <roleprivilege>(); roleId = _database.Insert <roleModel>(role); foreach (var item in selectIds) { roles.Add(new roleprivilege { roleid = roleId, privilegeid = item }); } _database.Insert <roleprivilege>(roles); ShowTipMessage(LayerIconType.Success); _authorization.Refresh(ez.Core.Helpers.Convert.ToString(roleId)); _cache.Remove(_cacheRoleList); } catch (Exception e) { ShowTipMessage(LayerIconType.Erro, "", false); } return(View(role)); }
public JsonResult UpdateRole(roleModel rm) { SystemUser system = new SystemUser(); try { string res = db_layer.updateRoleById(rm); string[] response = res.Split(','); if (response[0] == "Success") { system.success_msg = response[1]; } else { system.error_msg = response[1]; } } catch (Exception ex) { system.error_msg = ex.Message; } return(Json(system, JsonRequestBehavior.AllowGet)); }
public JsonResult GetRoleById(int role_id) { List <roleModel> rm_list = new List <roleModel>(); try { DataTable dt = dblayer.getRoleById(role_id); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { roleModel rm = new roleModel(); rm.ROLE_ID = Convert.ToInt32(dr["ROLE_ID"].ToString()); rm.ROLE_NAME = dr["ROLE_NAME"].ToString(); rm.STATUS = dr["STATUS"].ToString(); rm_list.Add(rm); } } } catch (Exception ex) { } return(Json(rm_list, JsonRequestBehavior.AllowGet)); }
public Task <int> ADD(roleModel bjm) { return(rd.ADD(bjm)); }
public Task <int> Update(roleModel rb) { return(rd.Update(rb)); }