/// <summary> /// 更新角色 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(SeatManage.ClassModel.SysRolesDicInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SysRolesDic set ROLENAME=@ROLENAME, IsLock=@IsLock"); strSql.Append(" where ROLEID=@ROLEID"); SqlParameter[] parameters = new SqlParameter[3]; parameters[0] = new SqlParameter("@ROLEID", model.RoleID); parameters[1] = new SqlParameter("@RoleName", model.RoleName); parameters[2] = new SqlParameter("@IsLock", model.IsLock); try { int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 删除角色 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Delete(SeatManage.ClassModel.SysRolesDicInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete SysRolesDic"); strSql.Append(" where ROLEID=@ROLEID"); SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@ROLEID", model.RoleID); try { int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 添加角色 /// </summary> /// <returns></returns> public int Add(SeatManage.ClassModel.SysRolesDicInfo model) { SqlParameter[] parameters = new SqlParameter[3]; parameters[0] = new SqlParameter("@RoleID", SqlDbType.Int); parameters[0].Direction = ParameterDirection.Output; parameters[1] = new SqlParameter("@RoleName", model.RoleName); parameters[2] = new SqlParameter("@IsLock", model.IsLock); try { DbHelperSQL.Execute_Proc("Proc_AddRole", parameters); return(int.Parse(parameters[0].Value.ToString())); } catch (Exception e) { throw e; } }