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