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);
}
