public IEnumerator StartGameCoroutine(RolesInfo role) { yield return(null); /* * yield return StartCoroutine (ListBranchinges()); * * KBEngine.PacketHolder packet = new KBEngine.PacketHolder (); * CGSelectCharacter.Builder selChar = CGSelectCharacter.CreateBuilder (); * selChar.Username = SaveGame.saveGame.GetDefaultUserName (); * selChar.Password = SaveGame.saveGame.GetDefaultPassword (); * selChar.PlayerId = role.PlayerId; * * Debug.Log ("LoginInit:: StartGameCoroutine BranchNumb "+branches.BranchingCount); * * selChar.Branching = branches.GetBranching (0).Line; * yield return StartCoroutine (KBEngine.Bundle.sendSimple(this, selChar, packet)); * * if (packet.packet.responseFlag == 0) { * var selCharRes = packet.packet.protoBody as GCSelectCharacter; * SaveGame.saveGame.loginCharData = selCharRes; * * SaveGame.saveGame.SetSelectChar(role); * * StartCoroutine(BindSession()); * } else { * } */ }
/// <summary> /// 增加一条数据 /// Author 2015-08-11 /// </summary> public bool Add(object tran, RolesInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Roles("); strSql.Append("RoleName,IsDefault,Sort,Remark"); strSql.Append(") values ("); strSql.Append("@RoleName,@IsDefault,@Sort,@Remark"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@IsDefault", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.RoleName; parameters[1].Value = model.IsDefault; parameters[2].Value = model.Sort; parameters[3].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public async Task <ActionResult <UserRoles> > EditarUsuario([FromBody] RolesInfo model, string id) { try { var response = await _roleManager.FindByIdAsync(id); if (response == null) { return(NotFound()); } response.Name = model.Name; var result = await _roleManager.UpdateAsync(response); if (result.Succeeded) { return(Ok()); } else { return(BadRequest()); } } catch (Exception ex) { return(Json(new { token = ex.Message })); } }
/* * 4 Job Start From 0 */ public static GameObject ConstructChar(RolesInfo roleInfo) { Log.Sys("SelectChar::ConstructChar " + roleInfo); GameObject player = null; if (fakeObj.TryGetValue(roleInfo.PlayerId, out player)) { return(player); } var udata = Util.GetUnitData(true, (int)Job.WARRIOR, 0); Log.Sys("udata " + udata + " " + udata.name + " " + udata.ModelName); player = Instantiate(Resources.Load <GameObject>(udata.ModelName)) as GameObject; var oldScale = player.transform.localScale; NGUITools.AddMissingComponent <NpcAttribute>(player); var selChar = NGUITools.AddMissingComponent <SelectChar>(player); player.GetComponent <NpcAttribute>().SetObjUnitData(udata); player.GetComponent <NpcEquipment>().InitDefaultEquip(); selChar.name = roleInfo.Name; selChar.playerId = roleInfo.PlayerId; selChar.level = roleInfo.Level; selChar.roleInfo = roleInfo; player.transform.localScale = oldScale; return(player); }
public ActionResult ViewAllRoles() { var roles = context.Roles.ToList(); var model = new ListOfRoles(); int counter = 1; foreach (var role in roles) { var modelitem = new RolesInfo(); modelitem.RoleName = role.Name; modelitem.RoleId = counter; IdentityRole myRole = context.Roles.First(r => r.Name == role.Name); Int32 count = context.Set <IdentityUserRole>().Count(r => r.RoleId == myRole.Id); modelitem.CountUsersInRole = count; model.ListRoles.Add(modelitem); counter++; } if (model.ListRoles.Count > 0) { return(View(model)); } else { TempData["ResultError"] = "There is no roles defined!"; return(View()); } }
void UpdateFrame() { var charInfo = GameInterface_Login.loginInterface.GetCharInfo(); if (charInfo != null) { if (charInfo.RolesInfosList.Count > 0) { enterBut.SetActive(true); createBut.SetActive(false); var charI = charInfo.RolesInfosList[0]; selectRoleInfo = charI; namelevel.text = string.Format("[d2691e]姓名:{0}[-]\n[a0522d]等级:{1}[-]", charI.Name, charI.Level); namelevel.gameObject.SetActive(true); SelChar.SetActive(true); var evt = new MyEvent(MyEvent.EventType.MeshShown); evt.intArg = -1; evt.rolesInfo = charI; MyEventSystem.myEventSystem.PushEvent(evt); } else { SelChar.SetActive(false); enterBut.SetActive(false); createBut.SetActive(true); namelevel.gameObject.SetActive(false); } } }
/* * 4 Job Start From 0 */ public static GameObject ConstructChar(RolesInfo roleInfo) { Log.Sys("SelectChar::ConstructChar " + roleInfo); GameObject player = null; if (fakeObj.TryGetValue(roleInfo.PlayerId, out player)) { return(player); } //var res = Util.GetUnitData (true, (int)roleInfo.Job, 0); //var modName = res.ModelName.Replace ("player/", "models/player/"); //var modName = "DialogPlayer/" + roleInfo.Job.ToString (); var udata = Util.GetUnitData(true, (int)roleInfo.Job, 0); Log.Sys("udata " + udata + " " + udata.name + " " + udata.ModelName); player = Instantiate(Resources.Load <GameObject> (udata.ModelName)) as GameObject; NGUITools.AddMissingComponent <NpcAttribute>(player); var selChar = NGUITools.AddMissingComponent <SelectChar> (player); player.GetComponent <NpcAttribute> ().SetObjUnitData(udata); player.GetComponent <NpcEquipment> ().InitDefaultEquip(); selChar.name = roleInfo.Name; selChar.playerId = roleInfo.PlayerId; selChar.level = roleInfo.Level; selChar.roleInfo = roleInfo; return(player); }
//查询 根据条件返回实体类 public RolesInfo Select(string sql) { RolesInfo RolesInfo = new RolesInfo(); string sqlCmd = "select *from rolesinfo_a " + sql; //查的表明一定是类的名称 var r = MySqlHelper.SelectCMD(ConnectType.GAME, sqlCmd); if (r.HasRows == false) { return(null); } else { if (r.Read()) { RolesInfo.ID = r.GetInt32("ID"); RolesInfo.RolesID = r.GetInt32("RolesID"); RolesInfo.NickName = r.GetString("NickName"); RolesInfo.Level = r.GetInt32("Level"); RolesInfo.State = r.GetInt32("State"); RolesInfo.VictoryPoint = r.GetInt32("VictoryPoint"); RolesInfo.GoldCoin = r.GetInt32("GoldCoin"); RolesInfo.Diamonds = r.GetInt32("Diamonds"); RolesInfo.RoomID = r.GetInt32("RoomID"); RolesInfo.SeatID = r.GetInt32("SeatID"); //"RolesInfo"."字段名称" = r.Get"数据类型("字段名称")"; } } return(RolesInfo); }
public static RolesInfo GetItemByName(string Name) { if (Name == null) { return(null); } if (itemCacheTimeout <= 0) { return(dal.GetItemByName(Name)); } string key = string.Concat("cnodejs_BLL_RolesByName_", Name); string value = RedisHelper.Get(key); if (!string.IsNullOrEmpty(value)) { try { return(new RolesInfo(value)); } catch { } } RolesInfo item = dal.GetItemByName(Name); if (item == null) { return(null); } RedisHelper.Set(key, item.Stringify(), itemCacheTimeout); return(item); }
public bool IsUserInRole(Guid applicationId, string username, string roleName) { UsersInfo userInfo = _db.Users.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(username, StringComparison.OrdinalIgnoreCase)); RolesInfo roleInfo = _db.Roles.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(username, StringComparison.OrdinalIgnoreCase)); return(_db.UsersInRoles.FindOne(m => m.UserId.Equals(userInfo.Id) && m.RoleId.Equals(roleInfo.Id)) != null); }
public string[] FindUsersInRole(Guid applicationId, string roleName, string usernameToMatch) { RolesInfo roleInfo = _db.Roles.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(roleName, StringComparison.OrdinalIgnoreCase)); if (roleInfo == null) { return(null); } Guid[] userids = _db.UsersInRoles.Find(m => m.RoleId.Equals(roleInfo.Id)).Select(m => m.UserId).Distinct().ToArray(); if (userids == null || !userids.Any()) { return(null); } string[] usernames = _db.Users.Find(m => userids.Contains(m.Id)).Select(m => m.Name).ToArray(); if (!string.IsNullOrEmpty(usernameToMatch)) { string name = usernames.FirstOrDefault(m => m.Contains(usernameToMatch)); if (!string.IsNullOrEmpty(name)) { return(new string[] { name }); } } return(usernames); }
protected static MySqlParameter[] GetParameters(RolesInfo item) { return(new MySqlParameter[] { GetParameter("?id", MySqlDbType.UInt32, 10, item.Id), GetParameter("?name", MySqlDbType.VarChar, 64, item.Name) }); }
/// <summary> /// 更新一条数据 /// Author 2015-08-11 /// </summary> public bool Update(object tran, RolesInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Roles set "); strSql.Append("RoleName=@RoleName,"); strSql.Append("Sort=@Sort,"); strSql.Append("Remark=@Remark"); strSql.Append(" where RoleID=@RoleID "); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@RoleName", SqlDbType.NVarChar, 50), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.RoleID; parameters[1].Value = model.RoleName; parameters[2].Value = model.Sort; parameters[3].Value = model.Remark; int rows = SQLHelper.ExecuteNonQuery((SqlTransaction)tran, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public static cnodejs.DAL.Roles.SqlUpdateBuild UpdateDiy(RolesInfo item, uint?Id) { if (itemCacheTimeout > 0) { RemoveCache(item != null ? item : GetItem(Id)); } return(new cnodejs.DAL.Roles.SqlUpdateBuild(item, Id)); }
public static int Update(RolesInfo item) { if (itemCacheTimeout > 0) { RemoveCache(item); } return(dal.Update(item)); }
public static RolesInfo Insert(RolesInfo item) { item = dal.Insert(item); if (itemCacheTimeout > 0) { RemoveCache(item); } return(item); }
private static void RemoveCache(RolesInfo item) { if (item == null) { return; } RedisHelper.Remove(string.Concat("cnodejs_BLL_Roles_", item.Id)); RedisHelper.Remove(string.Concat("cnodejs_BLL_RolesByName_", item.Name)); }
/// <summary> /// Saves a record to the roles table. /// </summary> public virtual void Insert(RolesInfo rolesInfo) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@name", rolesInfo.Name) }; rolesInfo.Roleid = (int) SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "roles_Insert", parameters); }
/// <summary> /// 测试的时候设置人物数据 /// </summary> public void TestSetRole() { var role = RolesInfo.CreateBuilder(); role.Name = "战士"; role.PlayerId = 103; role.Level = 1; role.Job = (Job)1; selectChar = role.Build(); }
public APIReturn Get_item(uint?Id) { RolesInfo item = Roles.GetItem(Id); if (item == null) { return(new APIReturn(98, "记录不存在,或者没有权限")); } return(new APIReturn(0, "成功", "item", item.ToBson())); }
public RolesInfo Insert(RolesInfo item) { uint loc1; if (uint.TryParse(string.Concat(SqlHelper.ExecuteScalar(TSQL.Insert, GetParameters(item))), out loc1)) { item.Id = loc1; } return(item); }
public ActionResult Edit(string id) { RolesInfo model = new RolesInfo(); if (!string.IsNullOrEmpty(id)) { model = rolesbll.GetModel(null, Convert.ToInt32(id)); } return(View(model)); }
public static void CreateCharacter(KBEngine.Packet packet) { var inpb = packet.protoBody as CGCreateCharacter; var au = GCCreateCharacter.CreateBuilder(); var role = RolesInfo.CreateBuilder(); role.Name = inpb.PlayerName; role.PlayerId = 100; //playerId++; role.Level = 1; role.Job = inpb.Job; var msg = role.Build(); ServerData.Instance.playerInfo.Roles = RolesInfo.CreateBuilder(msg).Build(); var dress = new int[] { 97, 68, 69, 70, 71, 72, }; int id = 1; var pinfo = ServerData.Instance.playerInfo; foreach (var d in dress) { var pkinfo = PackInfo.CreateBuilder(); var pkEntry = PackEntry.CreateBuilder(); pkEntry.Id = id++; pkEntry.BaseId = d; pkEntry.GoodsType = 1; pkEntry.Level = 1; pkinfo.PackEntry = pkEntry.Build(); pinfo.AddDressInfo(pkinfo); } var cinfo = GCCopyInfo.CreateBuilder(); var cin = CopyInfo.CreateBuilder(); cin.Id = 209; cin.IsPass = true; cinfo.AddCopyInfo(cin); var msg2 = cinfo.Build(); pinfo.CopyInfos = msg2; au.AddRolesInfos(msg); ServerBundle.SendImmediate(au, packet.flowId); //投掷 跳跃 pinfo.Roles.Level = 10; AddSkillPoint(10); LevelUpSkill(3); LevelUpSkill(4); }
public string[] GetUsersInRole(Guid applicationId, string roleName) { RolesInfo roleInfo = _db.Roles.FindOne(m => m.ApplicationId.Equals(applicationId) && m.Name.Equals(roleName, StringComparison.OrdinalIgnoreCase)); Guid[] userids = _db.UsersInRoles.Find(m => m.RoleId.Equals(roleInfo.Id)).Select(m => m.UserId).ToArray(); if (userids == null || !userids.Any()) { return(null); } return(_db.Users.Find(m => userids.Contains(m.Id)).Select(m => m.Name).ToArray()); }
/// <summary> /// Saves a record to the roles table. /// </summary> public virtual void Update(RolesInfo rolesInfo) { try { new RolesTFM().Update(rolesInfo); } catch (Exception ex) { //Provider.Log.Error(ex, "TFM.Biz.Implements.Roles - Update" + ex.Message); throw; } }
protected override void OnEnable() { base.OnEnable(); //获取到角色信息 然后进行更新 RolesInfo roles = RolesCtrl.Instance.GetRolesInfo(); //RolesName, Duan, GoldCount, DiamondsCount RolesName.text = roles.NickName; Duan.text = roles.VictoryPoint.ToString();//胜点 GoldCount.text = roles.GoldCoin.ToString(); DiamondsCount.text = roles.Diamonds.ToString(); }
public APIReturn Post_insert([FromForm] string Name, [FromForm] ulong[] mn_Users) { RolesInfo item = new RolesInfo(); item.Name = Name; item = Roles.Insert(item); //关联 Users foreach (ulong mn_Users_in in mn_Users) { item.FlagUsers(mn_Users_in); } return(new APIReturn(0, "成功", "item", item.ToBson())); }
/// <summary> /// 删除角色 /// pxd 2015-10-15 /// </summary> /// <param name="roleID"></param> /// <returns></returns> public string DeleteRole(int roleID) { string strReturn = ""; Transaction transaction = new Transaction(); object tran = transaction.CreatTransaction(); try { RolesInfo model = GetModel(tran, roleID); if (model.IsDefault == 1) { throw new Exception("不允许删除系统默认角色!"); } //判断是否已经被引用 if (new UsersRole().ExistsByRoleID(null, roleID)) { throw new Exception(ErrorPrompt.RelateError); } //先判断角色菜单权限 if (new RoleModule().ExistsByRoleID(tran, roleID)) { //删除角色菜单权限 if (!new RoleModule().DeleteByRoleID(tran, roleID)) { throw new Exception("删除角色菜单权限失败!"); } } //先判断角色按钮权限 if (new RoleModButton().ExistsByRoleID(tran, roleID)) { //删除角色按钮权限 if (!new RoleModButton().DeleteByRoleID(tran, roleID)) { throw new Exception("删除角色按钮权限失败!"); } } //删除角色 if (!Delete(tran, roleID)) { strReturn = ErrorPrompt.DeleError; } transaction.Commit(tran); } catch (Exception ex) { transaction.Rollback(tran); strReturn = new Tools().GetErrorInfo(ex); } return(strReturn); }
//何时删除FakeObject对象 //UI显示FakeObject public void OnUIShown(int localId, RolesInfo roleInfo, int job = -1) { Log.GUI("UI Show Local ID" + localId); if (dialogPlayer != null) { dialogPlayer.SetActive(false); dialogPlayer = null; } //选择人物界面显示的人物模型 if (roleInfo != null) { dialogPlayer = SelectChar.ConstructChar(roleInfo); dialogPlayer.SetActive(true); dialogPlayer.transform.parent = rotPlayer.transform; dialogPlayer.transform.localPosition = Vector3.zero; dialogPlayer.transform.localRotation = Quaternion.Euler(new Vector3(0, 180, 0)); dialogPlayer.transform.localScale = Vector3.one; Util.SetLayer(dialogPlayer, GameLayer.PlayerCamera); playerWindow.SetActive(true); //创建人物界面显示的模型 } else if (job != -1) { dialogPlayer = SelectChar.ConstructChar((Job)job); dialogPlayer.SetActive(true); dialogPlayer.transform.parent = rotPlayer.transform; dialogPlayer.transform.localPosition = Vector3.zero; dialogPlayer.transform.localRotation = Quaternion.Euler(new Vector3(0, 180, 0)); dialogPlayer.transform.localScale = Vector3.one; Util.SetLayer(dialogPlayer, GameLayer.PlayerCamera); playerWindow.SetActive(true); //背包UI界面显示的人物模型 } else { Log.GUI("UI Show Object " + localId); dialogPlayer = ObjectManager.objectManager.NewFakeObject(localId); dialogPlayer.SetActive(true); dialogPlayer.transform.parent = rotPlayer.transform; dialogPlayer.transform.localPosition = Vector3.zero; dialogPlayer.transform.localRotation = Quaternion.Euler(new Vector3(0, 180, 0)); dialogPlayer.transform.localScale = Vector3.one; playerWindow.SetActive(true); } }
/// <summary> /// 登录功能 /// </summary> /// <param name="request"></param> private void HandleUserLoginC2S(BufferEntity request) { //反序列化 得到客户端 发送的数据 UserLoginC2S c2sMSG = ProtobufHelper.FromBytes <UserLoginC2S>(request.proto); //主要是看反序列化的功能 是否正常 //Debug.Log("登录:"+ JsonHelper.SerializeObject(c2sMSG)); //匹配记录:相同的账号 相同的密码 string sqlCMD = MySqlCMD.Where("Account", c2sMSG.UserInfo.Account) + MySqlCMD.And("Password", c2sMSG.UserInfo.Password); UserLoginS2C s2cMSG = new UserLoginS2C(); UserInfo userInfo = DBUserInfo.Instance.Select(sqlCMD); if (userInfo != null) { s2cMSG.UserInfo = userInfo; s2cMSG.Result = 0;//登录成功 //保存角色信息到服务器本地 PlayerManager.Add(request.session, s2cMSG.UserInfo.ID, new PlayerEntity() { userInfo = s2cMSG.UserInfo, session = request.session, }); RolesInfo rolesInfo = DBRolesInfo.Instance.Select(MySqlCMD.Where("ID", s2cMSG.UserInfo.ID)); if (rolesInfo != null) { s2cMSG.RolesInfo = rolesInfo; //获取到了角色信息 缓存起来 PlayerEntity playerEntity = PlayerManager.GetPlayerEntityFromSession(request.session); playerEntity.rolesInfo = rolesInfo; } } else { s2cMSG.Result = 2;//帐号和密码不匹配 } //返回结果 BufferFactory.CreqateAndSendPackage(request, s2cMSG); }
/// <summary> /// 添加/编辑角色 /// pxd 2015-10-15 /// </summary> /// <param name="model"></param> /// <returns></returns> public string AddOrEditRoles(RolesInfo model) { string strReturn = ""; try { if (model.RoleID == 0)//添加 { if (!Exists(null, model.RoleName)) { if (!Add(null, model)) { strReturn = ErrorPrompt.AddError; } } else { strReturn = "角色[" + model.RoleName + "]已存在,请重新输入!"; } } else //编辑 { RolesInfo rolesinfo = GetModel(null, model.RoleID); //判断登录名是否重复 if (rolesinfo.RoleName.ToLower() == model.RoleName.ToLower() || !Exists(null, model.RoleName)) { if (!Update(null, model)) { strReturn = ErrorPrompt.UpdateError; } } else { strReturn = "角色[" + model.RoleName + "]已存在,请重新输入!"; } } } catch (Exception ex) { strReturn = new Tools().GetErrorInfo(ex); } return(strReturn); }
//插入->添加的是一整条的数据 如果有主键 先判断主键是否存在了 返回插入结果 isSingle是否保持唯一性 public bool Insert(RolesInfo RolesInfo) { //ikey需要通过运算获得 //ivalue需要通过append //string sqlCmd = "insert into rolesinfo_a("+ikey+") values("+ivalues+")"; string sqlCmd = "insert into rolesinfo_a(ID,RolesID,NickName,Level,State,VictoryPoint,GoldCoin,Diamonds,RoomID,SeatID) values(" + RolesInfo.ID + "," + RolesInfo.RolesID + "," + "\"" + RolesInfo.NickName + "\"" + "," + RolesInfo.Level + "," + RolesInfo.State + "," + RolesInfo.VictoryPoint + "," + RolesInfo.GoldCoin + "," + RolesInfo.Diamonds + "," + RolesInfo.RoomID + "," + RolesInfo.SeatID + ")"; bool b = MySqlHelper.AddCMD(ConnectType.GAME, sqlCmd); return(b); }
/// <summary> /// Creates a new instance of the roles class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual RolesInfo MakeRolesInfo(SqlDataReader dataReader) { RolesInfo rolesInfo = new RolesInfo(); rolesInfo.Roleid = SqlClientUtility.GetInt32(dataReader,DbConstants.ROLES.ROLEID, 0); rolesInfo.Name = SqlClientUtility.GetString(dataReader,DbConstants.ROLES.NAME, String.Empty); return rolesInfo; }
/// <summary> /// Updates a record in the roles table. /// </summary> public virtual void Update(RolesInfo rolesInfo) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@roleid", rolesInfo.Roleid), new SqlParameter("@name", rolesInfo.Name) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "roles_Update", parameters); }