📄 系统亮点展示.htm
字号:
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'>Menu mainmenu =
((MainForm)(this.MdiParent)).getMainMenu();<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>for
( int i=0; i<mainmenu.MenuItems.Count;i++)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>((MainForm)(this.MdiParent)).setMenuItemAccess(mainmenu.MenuItems[i],"");<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>//</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-font-kerning:0pt'>设置主窗体菜单</span><span style='mso-font-kerning:
0pt'> </span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-font-kerning:0pt'>该用户能使用的模块的菜单</span><span
style='mso-font-kerning:0pt'> </span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-font-kerning:
0pt'>为可用</span><span lang=EN-US style='mso-font-kerning:0pt'><o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>for(int
i=0;i<mf.toolBar1.Buttons.Count;i++)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>mf.toolBar1.Buttons[i].Enabled=true;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>//</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-font-kerning:0pt'>设置主窗体</span><span style='mso-font-kerning:
0pt'> </span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-font-kerning:0pt'>工具条里面该用户能用的模块的</span><span
style='mso-font-kerning:0pt'> </span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-font-kerning:
0pt'>按钮为可用</span><span lang=EN-US style='mso-font-kerning:0pt'><o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>}<span
style='mso-tab-count:1'> </span></span><span
lang=EN-US style='mso-bidi-font-size:9.0pt;font-family:新宋体;mso-hansi-font-family:
"Times New Roman";mso-font-kerning:0pt'><span style='mso-tab-count:1'> </span></span><span
lang=EN-US><o:p></o:p></span></p>
<h4><span lang=EN-US>3</span><span style='font-family:黑体;mso-ascii-font-family:
"Times New Roman"'>、一次执行多个</span><span lang=EN-US>sql</span><span
style='font-family:黑体;mso-ascii-font-family:"Times New Roman"'>语句</span></h4>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>本章</span><span lang=EN-US>util</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>包下，实现一个一次执行多个</span><span lang=EN-US>sql</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句的方法，可以一次执行多个保存在</span><span lang=EN-US style='mso-font-kerning:
0pt'>ArrayList</span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-font-kerning:0pt'>数组的</span><span
lang=EN-US style='mso-font-kerning:0pt'>sql </span><span style='font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman";
mso-font-kerning:0pt'>语句，并且是事务方式。也就是说需要这些</span><span lang=EN-US
style='mso-font-kerning:0pt'>sql</span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-font-kerning:
0pt'>语句都执行正确，才会最后提交。</span></p>
<p class=a8><span lang=EN-US style='color:blue;mso-font-kerning:0pt'>public</span><span
lang=EN-US style='mso-font-kerning:0pt'> <span style='color:blue'>static</span>
<span style='color:blue'>bool</span> ExecuteNonQuery(SqlConnection<span
style='mso-spacerun:yes'> </span>conn, ArrayList list) <o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:2'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span><span
style='color:blue'>string</span>[] sqls = <span style='color:blue'>new</span> <span
style='color:blue'>string</span>[list.Count];<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span><span
style='color:blue'>for</span>(<span style='color:blue'>int</span>
i=0;i<list.Count;i++)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>sqls[i]
= list[i].ToString();<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><o:p> </o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span><span
style='color:blue'>using</span>(SqlCommand cmd =<span
style='mso-spacerun:yes'> </span>conn.CreateCommand())<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span><span
style='color:blue'>using</span>(SqlTransaction trans = conn.BeginTransaction())<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>cmd.Transaction
= trans;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span><span
style='color:blue'>bool</span> onError = <span style='color:blue'>false</span>;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span><span
style='color:blue'>for</span>(<span style='color:blue'>int</span>
i=0;i<sqls.Length;i++)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>cmd.CommandText
= sqls[i];<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span><span
style='color:blue'>try<o:p></o:p></span></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span><span
style='color:blue'>int</span> result = cmd.ExecuteNonQuery();<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span><span
style='color:blue'>if</span>(result<=0)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:8'> </span>onError
= <span style='color:blue'>true</span>;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span><span
style='mso-tab-count:2'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span><span
style='color:blue'>catch</span>(Exception se)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span>onError
= <span style='color:blue'>true</span>;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:7'> </span>Console.WriteLine(se.ToString());<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span><span
style='color:blue'>if</span>(onError)<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>trans.Rollback();<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span><span
style='color:blue'>return</span> <span style='color:blue'>false</span>;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span><span
style='color:blue'>else<o:p></o:p></span></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>{<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span>trans.Commit();<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:6'> </span><span
style='color:blue'>return</span> <span style='color:blue'>true</span>;<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:5'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:4'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><o:p> </o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:3'> </span>}<o:p></o:p></span></p>
<p class=a8><span lang=EN-US style='mso-font-kerning:0pt'><span
style='mso-tab-count:2'> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<h4><span lang=EN-US>4</span><span style='font-family:黑体;mso-ascii-font-family:
"Times New Roman"'>、递归</span></h4>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>本章显示部门的时候，应用了递归的思想，树型结构显示部门。</span></p>
<h4><span lang=EN-US>5</span><span style='font-family:黑体;mso-ascii-font-family:
"Times New Roman"'>、邮件发送</span></h4>
<p class=MsoNormal><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>本章应用</span><span lang=EN-US>jmail</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>组件实现了邮件发送的功能。</span><span lang=EN-US><o:p></o:p></span></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -