/// <summary> /// 新增角色 /// </summary> /// <param name="roleinfo">角色实体类</param> /// <returns>是否成功</returns> public bool AddRoleMain(ROLEINFO roleinfo) { var strSql = new StringBuilder(); var dbHelper = new DbAPI(); strSql.Append("INSERT INTO ROLEINFO(F_ROLECODE, F_NAME, F_DESCRIPTION)VALUES(SYS_GUID(),:F_NAME,:F_DESCRIPTION)"); OracleParameter[] parms = { new OracleParameter("F_NAME", roleinfo.F_NAME), new OracleParameter("F_DESCRIPTION", roleinfo.F_DESCRIPTION ?? "") }; try { dbHelper.OpenConn(""); var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms); dbHelper.CloseConn(); return(rstInt > 0); } catch (Exception ex) { LogBN.WriteLog(typeof(ROLEINFO_BN), "新增角色AddRoleMain 程序段的异常" + ex); return(false); } }
/// <summary> /// 修改角色 /// </summary> /// <param name="roleinfo">角色实体类</param> /// <returns>是否成功</returns> public bool EditRoleMain(ROLEINFO roleinfo) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("UPDATE ROLEINFO SET F_NAME=:F_NAME,F_DESCRIPTION=:F_DESCRIPTION WHERE F_ROLECODE=:F_ROLECODE"); OracleParameter[] parms = { new OracleParameter("F_NAME", roleinfo.F_NAME), new OracleParameter("F_DESCRIPTION", roleinfo.F_DESCRIPTION), new OracleParameter("F_ROLECODE", roleinfo.F_ROLECODE) }; try { dbHelper.OpenConn(""); var rstInt = dbHelper.ExecuteNonQuery(strSql.ToString(), parms); dbHelper.CloseConn(); return(rstInt > 0); } catch (Exception ex) { LogBN.WriteLog(typeof(ROLEINFO_BN), "修改角色EditRoleMain 程序段的异常" + ex); return(false); } }
public ActionResult AddRoleInfo(ROLEINFO roleInfo) { roleInfo.MODIFIEDON = DateTime.Now; roleInfo.SUBTIME = DateTime.Now; roleInfo.DELFLAG = 0; RoleInfoService.AddEntity(roleInfo); return(Content("ok")); }
public ReturnResult SaveRole(string roleName, string funList) { ROLEINFO role = new ROLEINFO(); role.F_NAME = roleName; string[] funs = funList.Split(','); ROLEINFO_BN role_bn = new ROLEINFO_BN(); return(role_bn.AddRole(role, funs)); }
/// <summary> /// 增加一条数据 /// </summary> public ReturnResult AddRole(ROLEINFO model, string[] rolefunlist) { ReturnResult result = new ReturnResult(); StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); try { dbHelper.OpenConn(""); dbHelper.OpenTrans(); model.F_ROLECODE = dbHelper.GUID(); strSql.Append("insert into ROLEINFO("); strSql.Append("F_ROLECODE,F_NAME,F_DESCRIPTION"); strSql.Append(") values ("); strSql.Append(":F_ROLECODE,:F_NAME,:F_DESCRIPTION"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(model.F_ROLECODE)), new OracleParameter(":F_NAME", dbHelper.CheckDBNull(model.F_NAME)), new OracleParameter(":F_DESCRIPTION", dbHelper.CheckDBNull(model.F_DESCRIPTION)) }; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { for (int i = 0; i < rolefunlist.Length; i++) { strSql.Clear(); strSql.Append("insert into ROLEFUNCTION("); strSql.Append("F_ID,F_ROLECODE,F_FUNCTIONCODE"); strSql.Append(") values ("); strSql.Append(":F_ID,:F_ROLECODE,:F_FUNCTIONCODE"); strSql.Append(") "); OracleParameter[] parameters1 = { new OracleParameter(":F_ID", dbHelper.CheckDBNull(dbHelper.GUID())), new OracleParameter(":F_ROLECODE", dbHelper.CheckDBNull(model.F_ROLECODE)), new OracleParameter(":F_FUNCTIONCODE", dbHelper.CheckDBNull(rolefunlist[i])) }; int rows1 = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters1); if (rows1 <= 0) { goto Over; } } result.success = true; result.Message = "操作成功"; dbHelper.CommitTrans(); dbHelper.CloseConn(); return(result); } else { goto Over; } } catch (Exception ex) { LogBN.WriteLog(typeof(ROLEINFO_BN), "SaveRole 程序段的异常" + ex); goto Over; } Over: result.success = false; result.Message = "操作失败"; dbHelper.RollBack(); dbHelper.CloseConn(); return(result); }