public int Save_MenuRole(int menuid, List <int> roleids)
{
try
{
int ret = 0;
List <dynamic> mr = new List <dynamic>();
foreach (var item in roleids)
{
mr.Add(new { menuid = menuid, roleid = item });
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_role_menu(id,roleid,menuid) \r\n");
sql.Append("values \r\n");
//sql.Append
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
conn.Execute("delete from sys_role_menu where menuid=:menuid", new { menuid = menuid }, trans);
conn.Execute(sql.ToString(), mr.ToArray(), trans);
trans.Commit();
}
}
return(ret);
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public bool Delete(int id)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from sys_role where id=:id");
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
var p = new { id = id };
using (var trans = conn.BeginTransaction())
{
int r1 = conn.Execute(sql.ToString(), p, transaction: trans);
int r2 = conn.Execute("delete from sys_user_role where roleid = :id", p, transaction: trans);
int r3 = conn.Execute("delete from sys_role_menu where roleid = :id", p, transaction: trans);
trans.Commit();
return(r1 > 0 ? true : false);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public int Save_RoleMenus(int roleid, List <int> menuids)
{
try
{
int ret = 0;
List <dynamic> vals = new List <dynamic>();
foreach (var item in menuids)
{
vals.Add(new { roleid = roleid, menuid = item });
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_role_menu(id,roleid,menuid) \r\n");
sql.Append("values \r\n");
sql.Append(" (SEQ_ROLEMENU_ID.nextval,:roleid,:menuid) \r\n");
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
conn.Execute("delete from sys_role_menu where roleid =:roleid", new { roleid = roleid }, trans);
ret = conn.Execute(sql.ToString(), vals.ToArray(), trans);
trans.Commit();
return(ret);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public int SaveUserRoles(int userid, List <int> roleids)
{
try
{
int ret = 0;
List <dynamic> ur = new List <dynamic>();
foreach (var item in roleids)
{
ur.Add(new { userid = userid, roleid = item });
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_user_role \r\n");
sql.Append("(id,");
sql.Append("userid,");
sql.Append("roleid)");
sql.Append("values");
sql.Append("(seq_userrole_id.nextval,");
sql.Append(" :userid,");
sql.Append(" :roleid");
sql.Append(")\r\n");
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var transaction = conn.BeginTransaction())
{
conn.Execute("delete from sys_user_role where userid=:userid", new { userid = userid }, transaction);
ret = conn.Execute(sql.ToString(), ur.ToArray(), transaction);
transaction.Commit();
}
}
return(ret);
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public int Save_RolePermis(List <sys_menu_permission> list)
{
try
{
var roleids = list.Select(t => t.roleid).ToList();
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_role_permis(id,roleid,menuid,permis) ");
sql.Append(" values ");
sql.Append(" (seq_rolepromis_id.nextval,:roleid,:menuid,:permis)");
List <dynamic> p = new List <dynamic>();
foreach (var item in list)
{
var json = JsonConvert.SerializeObject(item.permission);
p.Add(new
{
roleid = item.roleid,
menuid = item.menuid,
permis = json
});
}
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var tran = conn.BeginTransaction())
{
conn.Execute("delete from sys_role_permis where roleid in :roleid", new { roleid = roleids }, transaction: tran);
int cnt = conn.Execute(sql.ToString(), p, transaction: tran);
tran.Commit();
return(cnt);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public int Save_RoleMenus(List <sys_menu_permission> list)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_role_menu(id,roleid,menuid,permis) \r\n");
sql.Append("values \r\n");
sql.Append(" (SEQ_ROLEMENU_ID.nextval,:roleid,:menuid,:permis) \r\n");
List <int> roleid = list.Select(t => t.roleid).ToList();
List <dynamic> p = new List <dynamic>();
foreach (var item in list)
{
var json = JsonConvert.SerializeObject(item.permission);
p.Add(new
{
roleid = item.roleid,
menuid = item.menuid,
permis = json
});
}
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
conn.Execute("delete from sys_role_menu where roleid in :roleid", new { roleid = roleid }, trans);
int ret = conn.Execute(sql.ToString(), p, trans);
trans.Commit();
return(ret);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public int Save_RoleUsers(int roleid, List <int> userids)
{
try
{
List <dynamic> p = new List <dynamic>();
foreach (var item in userids)
{
p.Add(new { roleid = roleid, userid = item });
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into sys_user_role \r\n");
sql.Append("(id,");
sql.Append("userid,");
sql.Append("roleid)");
sql.Append("values");
sql.Append("(seq_userrole_id.nextval,");
sql.Append(" :userid,");
sql.Append(" :roleid");
sql.Append(")\r\n");
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
conn.Execute("delete FROM sys_user_role where roleid = :roleid", new { roleid = roleid }, transaction: trans);
int res = conn.Execute(sql.ToString(), p.ToArray());
trans.Commit();
return(res);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
public bool Delete(int id)
{
try
{
StringBuilder sql = new StringBuilder();
sql.Append("delete from sys_menu where id =:id ");
using (var conn = new OraDBHelper().Conn)
{
conn.Open();
using (var tran = conn.BeginTransaction())
{
int cnt = conn.Execute(sql.ToString(), new { id = id }, transaction: tran);
int cnt2 = conn.Execute("delete from sys_role_menu where menuid=:id", new { id = id }, transaction: tran);
tran.Commit();
return(cnt > 0 ? true : false);
}
}
}
catch (Exception e)
{
log.Error(e.Message);
throw;
}
}
