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