血狼 - 博客园

开机按 “F1” 进入BPOS

“F1 。。。 F12” 不要设置为默认（Default）

posted @ 2011-12-02 17:01 血狼阅读(20) 评论(0) 编辑

window.event.keycode值大全

event.keycode值大全

1 keycode 8 = BackSpace BackSpace

2 keycode 9 = Tab Tab

3 keycode 12 = Clear

4 keycode 13 = Enter

5 keycode 16 = Shift_L

6 keycode 17 = Control_L

7 keycode 18 = Alt_L

8 keycode 19 = Pause

9 keycode 20 = Caps_Lock

10 keycode 27 = Escape Escape

11 keycode 32 = space space

12 keycode 33 = Prior

13 keycode 34 = Next

14 keycode 35 = End

15 keycode 36 = Home

16 keycode 37 = Left

17 keycode 38 = Up

18 keycode 39 = Right

19 keycode 40 = Down

20 keycode 41 = Select

21 keycode 42 = Print

22 keycode 43 = Execute

23 keycode 45 = Insert

24 keycode 46 = Delete

25 keycode 47 = Help

26 keycode 48 = 0 equal braceright

27 keycode 49 = 1 exclam onesuperior

28 keycode 50 = 2 quotedbl twosuperior

29 keycode 51 = 3 section threesuperior

30 keycode 52 = 4 dollar

31 keycode 53 = 5 percent

32 keycode 54 = 6 ampersand

33 keycode 55 = 7 slash braceleft

34 keycode 56 = 8 parenleft bracketleft

35 keycode 57 = 9 parenright bracketright

36 keycode 65 = a A

37 keycode 66 = b B

38 keycode 67 = c C

39 keycode 68 = d D

40 keycode 69 = e E EuroSign

41 keycode 70 = f F

42

43 keycode 71 = g G

44 keycode 72 = h H

45 keycode 73 = i I

46 keycode 74 = j J

47 keycode 75 = k K

48 keycode 76 = l L

49 keycode 77 = m M mu

50 keycode 78 = n N

51 keycode 79 = o O

52 keycode 80 = p P

53 keycode 81 = q Q at

54 keycode 82 = r R

55 keycode 83 = s S

56 keycode 84 = t T

57 keycode 85 = u U

58 keycode 86 = v V

59 keycode 87 = w W

60 keycode 88 = x X

61 keycode 89 = y Y

62 keycode 90 = z Z

63 keycode 96 = KP_0 KP_0

64 keycode 97 = KP_1 KP_1

65 keycode 98 = KP_2 KP_2

66 keycode 99 = KP_3 KP_3

67 keycode 100 = KP_4 KP_4

68 keycode 101 = KP_5 KP_5

69 keycode 102 = KP_6 KP_6

70 keycode 103 = KP_7 KP_7

71 keycode 104 = KP_8 KP_8

72 keycode 105 = KP_9 KP_9

73 keycode 106 = KP_Multiply KP_Multiply

74 keycode 107 = KP_Add KP_Add

75

76 keycode 108 = KP_Separator KP_Separator

77 keycode 109 = KP_Subtract KP_Subtract

78 keycode 110 = KP_Decimal KP_Decimal

79 keycode 111 = KP_Divide KP_Divide

80 keycode 112 = F1

81 keycode 113 = F2

82 keycode 114 = F3

83 keycode 115 = F4

84

85

86 keycode 116 = F5

87 keycode 117 = F6

88 keycode 118 = F7

89 keycode 119 = F8

90 keycode 120 = F9

91 keycode 121 = F10

92 keycode 122 = F11

93 keycode 123 = F12

94 keycode 124 = F13

95 keycode 125 = F14

96 keycode 126 = F15

97 keycode 127 = F16

98 keycode 128 = F17

99 keycode 129 = F18

100 keycode 130 = F19

101 keycode 131 = F20

102 keycode 132 = F21

103 keycode 133 = F22

104 keycode 134 = F23

105 keycode 135 = F24

106 keycode 136 = Num_Lock

107 keycode 137 = Scroll_Lock

108 keycode 187 = acute grave

109 keycode 188 = comma semicolon

110 keycode 189 = minus underscore

111 keycode 190 = period colon

112 keycode 192 = numbersign apostrophe

113 keycode 210 = plusminus hyphen macron

114 keycode 211 =

115 keycode 212 = copyright registered

116 keycode 213 = guillemotleft guillemotright

117 keycode 214 = masculine ordfeminine

118 keycode 215 = ae AE

119 keycode 216 = cent yen

120 keycode 217 = questiondown exclamdown

121 keycode 218 = onequarter onehalf threequarters

122 keycode 220 = less greater bar

123 keycode 221 = plus asterisk asciitilde

124 keycode 227 = multiply division

125

126 keycode 228 = acircumflex Acircumflex

127 keycode 229 = ecircumflex Ecircumflex

128 keycode 230 = icircumflex Icircumflex

129 keycode 231 = ocircumflex Ocircumflex

130 keycode 232 = ucircumflex Ucircumflex

131 keycode 233 = ntilde Ntilde

132 keycode 234 = yacute Yacute

133 keycode 235 = oslash Ooblique

134 keycode 236 = aring Aring

135 keycode 237 = ccedilla Ccedilla

136 keycode 238 = thorn THORN

137 keycode 239 = eth ETH

138 keycode 240 = diaeresis cedilla currency

139 keycode 241 = agrave Agrave atilde Atilde

140 keycode 242 = egrave Egrave

141 keycode 243 = igrave Igrave

142 keycode 244 = ograve Ograve otilde Otilde

143 keycode 245 = ugrave Ugrave

144 keycode 246 = adiaeresis Adiaeresis

145 keycode 247 = ediaeresis Ediaeresis

146 keycode 248 = idiaeresis Idiaeresis

147 keycode 249 = odiaeresis Odiaeresis

148 keycode 250 = udiaeresis Udiaeresis

149 keycode 251 = ssharp question backslash

150 keycode 252 = asciicircum degree

151 keycode 253 = 3 sterling

152 keycode 254 = Mode_switch

153

154 使用event对象的keyCode属性判断输入的键值

155 eg：if(event.keyCode==13)alert(“enter!”);

156 键值对应表

157 A　　0X65 　U 　　0X85

158 B　　0X66　 V　　 0X86

159 C　　0X67　 W　　 0X87

160 D　　0X68　 X 　　0X88

161 E　　0X69　 Y　　 0X89

162 F　　0X70　 Z　　 0X90

163 G　　0X71　 0　　 0X48

164 H　　0X72　 1　　 0X49

165 I 　　0X73　 2　　 0X50

166 J 　　0X74　 3 　　0X51

167 K　　0X75　 4 　　0X52

168 L　　0X76　 5 　　0X53

169 M　　0X77　 6　　 0X54

170 N　　0X78 　7 　　0X55

171 O　　0X79 　8 　　0X56

172 P　　0X80 　9 　　0X57

173 Q　　0X81　ESC　　0X1B

174 R　　0X82　CTRL 　0X11

175 S　　0X83　SHIFT　0X10

176 T　　0X84　ENTER　0XD

如果要使用组合键，则可以利用event.ctrlKey，event.shiftKey，event .altKey判断是否按下了ctrl键、shift键以及alt键

posted @ 2011-12-02 09:08 血狼阅读(10) 评论(0) 编辑

通用分页存储过程

/*通用分页存储过程*/
USE HotelManagementSystem
GO
IF EXISTS(SELECT * FROM sys.objects WHERE NAME='cndoup_GetPageOfRecords')
  DROP PROCEDURE cndoup_GetPageOfRecords
GO
--创建存储过程
CREATE PROCEDURE cndoup_GetPageOfRecords
  @pageSize int = 20,                                                --分页大小
  @currentPage int ,                                                 --第几页
  @columns varchar(1000) = '*',                            --需要得到的字段
  @tableName varchar(100),                                     --需要查询的表
  @condition varchar(1000) = '',                         --查询条件, 不用加where关键字
  @ascColumn varchar(100) = '',                            --排序的字段名 (即 order by column asc/desc)
  @bitOrderType bit = 0,                                         --排序的类型 (0为升序,1为降序)
  @pkColumn varchar(50) = ''                                 --主键名称

AS
BEGIN                                                                                    --存储过程开始
  DECLARE @strTemp varchar(300)
  DECLARE @strSql varchar(5000)                            --该存储过程最后执行的语句
  DECLARE @strOrderType varchar(1000)                --排序类型语句 (order by column asc或者order by column desc)

  BEGIN
    IF @bitOrderType = 1                --降序
      BEGIN
        SET @strOrderType = ' ORDER BY '+@ascColumn+' DESC'
        SET @strTemp = '<(SELECT min'
      END
    ELSE                  --升序
      BEGIN
        SET @strOrderType = ' ORDER BY '+@ascColumn+' ASC'
        SET @strTemp = '>(SELECT max'
      END

    IF @currentPage = 1            --第一页
      BEGIN
        IF @condition != ''
          SET @strSql = 'SELECT TOP '+STR(@pageSize)+' '+@columns+' FROM '+@tableName+
            ' WHERE '+@condition+@strOrderType
        ELSE
          SET @strSql = 'SELECT TOP '+STR(@pageSize)+' '+@columns+' FROM '+@tableName+@strOrderType
      END

    ELSE                  -- 其他页
      BEGIN
        IF @condition !=''
          SET @strSql = 'SELECT TOP '+STR(@pageSize)+' '+@columns+' FROM '+@tableName+
          ' WHERE '+@condition+' AND '+@pkColumn+@strTemp+'('+@pkColumn+')'+' FROM (SELECT TOP '+STR((@currentPage-1)*@pageSize)+
          ' '+@pkColumn+' FROM '+@tableName+'where'+@condition+@strOrderType+') AS TabTemp)'+@strOrderType
        ELSE
          SET @strSql = 'SELECT TOP '+STR(@pageSize)+' '+@columns+' FROM '+@tableName+
          ' WHERE '+@pkColumn+@strTemp+'('+@pkColumn+')'+' FROM (SELECT TOP '+STR((@currentPage-1)*@pageSize)+' '+@pkColumn+
          ' FROM '+@tableName+@strOrderType+') AS TabTemp)'+@strOrderType
      END

  END
  EXEC (@strSql)
END

                        --存储过程结束

--分页得到客房信息列表测试
EXEC cndoup_GetPageOfRecords 20,2,'房间号=RoomNum,
            房间状态=(SELECT RoomTypeDes FROM RoomType WHERE RoomTypeID=Room.RoomTypeID),
            房间状态=(SELECT RSDec FROM RoomStatus WHERE RoomStatusID=Room.RoomStatusID),
            床位数=BedNum,
            楼层=Floors,
            描述=RoomDes,
            备注=RoomRemark','Room','','RoomID',0,'RoomID'

--根据房间号得到客房信息测试
EXEC cndoup_GetPageOfRecords 1,1,'房间号=RoomNum,
            房间状态=(SELECT RoomTypeDes FROM RoomType WHERE RoomTypeID=Room.RoomTypeID),
            房间状态=(SELECT RSDec FROM RoomStatus WHERE RoomStatusID=Room.RoomStatusID),
            BedNum,
            Floors,
            RoomDes,
            RoomRemark','Room','RoomNum=304','RoomID',0,'RoomID'

--·  得到客房类型信息列表测试
EXEC cndoup_GetPageOfRecords 10,1,'RoomTypeDes,Price,Area,AddBed,MaxBedNum,BedPrice,HourRoom,HourPrice,Remark','RoomType','','RoomTypeID',0,'RoomTypeID'

本文出自 “cndo” 博客，出处http://51cndo.blog.51cto.com/491222/102320

posted @ 2011-11-15 10:14 血狼阅读(31) 评论(0) 编辑

Oracle中将密码有效期由默认的180天修改成“无限制”

将密码有效期由默认的180天修改成“无限制”：在系统管理员下执行如下语句即可

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

上海站、杭州站和合肥站我们已经执行完毕。

修改之后不需要重启动数据库，会立即生效。

下面是参考文档：

登陆数据库，
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 11月 4 16:34:06 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28001: the password has expired
google下，参考以下修改：
【原因/触发因素】
确定是由于oracle11g中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”所导致。

【影响和风险】

影响：密码过期后，业务进程连接数据库异常，影响业务使用。

问题发生频率：数据库密码过期后，业务进程一旦重启会提示连接失败。

【解决方案】

按照如下步骤进行操作：

1、查看用户的proifle是哪个，一般是default：

sql>SELECT username,PROFILE FROM dba_users;

2、查看指定概要文件（如default）的密码有效期设置：

sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

3、将密码有效期由默认的180天修改成“无限制”：

sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

修改之后不需要重启动数据库，会立即生效。

4、修改后，还没有被提示ORA-28002警告的帐户不会再碰到同样的提示；

已经被提示的帐户必须再改一次密码，举例如下：

$sqlplus / as sysdba

sql> alter user 用户名 identified by <原来的密码> ----不用换新密码

oracle11g启动参数resource_limit无论设置为false还是true，密码有效期都是生效的，所以必须通过以上方式进行修改。以上的帐户名请根据实际使用的帐户名更改。

posted @ 2011-07-25 17:51 血狼阅读(86) 评论(0) 编辑

C#中动态编译某C#文件

using System;

using System.CodeDom.Compiler;

using System.Collections;

using System.IO;

using System.Reflection;

using System.Text;

namespace news.newsscript.impl

{

/// <summary>

/// Summary description for NewsCSharpScriptExcuter.

/// </summary>

public class NewsCSharpScriptExcuter:AbstractNewsScriptExcuter

{

public NewsCSharpScriptExcuter()

{

//

// TODO: Add constructor logic here

//

}

private CodeDomProvider provider;

private ICodeCompiler compiler;

private CompilerResults results;

private CompilerParameters compilerparams;

public override object RunNewsScript(object param)

{

return RunCSharpScript(Path,param);

}

private object RunCSharpScript(string directory ,object param)

{

DirectoryInfo directoryInfo =new DirectoryInfo(directory);

provider = new Microsoft.CSharp.CSharpCodeProvider();

compiler= provider.CreateCompiler();

compilerparams = new CompilerParameters();

//compilerparams.GenerateInMemory = true;

compilerparams.ReferencedAssemblies.Add("System.dll");

compilerparams.ReferencedAssemblies.Add("System.Windows.Forms.Dll");

compilerparams.ReferencedAssemblies.Add("System.Configuration.Install.dll");

compilerparams.ReferencedAssemblies.Add("System.Data.dll");

compilerparams.ReferencedAssemblies.Add("System.Design.dll");

compilerparams.ReferencedAssemblies.Add("System.DirectoryServices.dll");

compilerparams.ReferencedAssemblies.Add("System.Drawing.Design.dll");

compilerparams.ReferencedAssemblies.Add("System.Drawing.dll");

compilerparams.ReferencedAssemblies.Add("System.EnterpriseServices.dll");

compilerparams.ReferencedAssemblies.Add("System.Management.dll");

compilerparams.ReferencedAssemblies.Add("System.Runtime.Remoting.dll");

compilerparams.ReferencedAssemblies.Add("System.Messaging.dll");

compilerparams.ReferencedAssemblies.Add("System.Security.dll");

compilerparams.ReferencedAssemblies.Add("System.ServiceProcess.dll");

compilerparams.ReferencedAssemblies.Add("System.XML.dll");

compilerparams.GenerateExecutable = true;

results = compiler.CompileAssemblyFromFileBatch(compilerparams,GetFileList(directoryInfo));

if (results.Errors.HasErrors)

{

StringBuilder errors = new StringBuilder();

foreach(System.CodeDom.Compiler.CompilerError error in results.Errors)

{

errors.Append(error.ErrorText + "\r\n");

}

throw new NewsScriptCompileException(errors.ToString());

}

else

{

try

{

Assembly generatedAssembly = results.CompiledAssembly;

object obj = null;

if (string.IsNullOrEmpty(this.ProcedureName)) {

obj = CallEntry(generatedAssembly, "NewsMainScript", param);

} else {

obj = CallEntry(generatedAssembly, ProcedureName, param);

}

return obj;

}

catch(Exception ex)

{

throw new NewsScriptRuntimeException(ex.Message,ex);

}

posted @ 2008-10-24 10:13 血狼阅读(76) 评论(0) 编辑

C#程序中执行script

VBScript

1

using MSScriptControl;
2

class Program
3

{
4

static void Main(string[] args)
5

{
6

ScriptControl scriptControl = new ScriptControl();
7

try {
8

scriptControl.Language = "VBScript";
9

scriptControl.AddCode(GetSouce(@"E:\projects\nexsolution-phase2\apps\news_editor\source\Libraries\NewsScriptXI\run_newsxml_test.vbs"));
10

11

string test = "test";
12

object[] parameters = new object[1] {test };
13

scriptControl.Run("Test", ref parameters);
14

} catch {
15

}
16

}
17

}
18

posted @ 2008-10-24 10:10 血狼阅读(114) 评论(0) 编辑

.Net Reactor 加密的简单例子

Mail Assembly:应用程序的入口，即主可执行文件。

Additional Files : 关联的.Net的DLL文件。

Project : 执行

posted @ 2008-09-19 18:21 血狼阅读(906) 评论(1) 编辑

MSBuild的相关操作

摘要: [代码][代码][代码]阅读全文

posted @ 2008-09-12 13:07 血狼阅读(66) 评论(0) 编辑

程序中执行cmd.exe

摘要: [代码]阅读全文

posted @ 2008-08-15 12:17 血狼阅读(110) 评论(0) 编辑

使用c#捕获Windows的关机事件

摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->usingSystem;usingSystem.Collections.Generic;usingSystem.Windows.Forms;usingMicrosoft.Win32;namespaceShutdown{staticclassProgram{/**//**//**////<summary>///应用程序的主入口点。///</summary>[STAThrea阅读全文

posted @ 2008-07-30 17:27 血狼阅读(179) 评论(0) 编辑

草原上的野狼

公告