using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;


namespace?WindowsFormsApplication2
{
????public?partial?class?frmLogin?:?Form
????{
????????public?frmLogin（）
????????{
????????????InitializeComponent（）;
????????????this.Opacity?=?0;//切換效果
????????????TimeInitForm（）;
?????????//this.skinEngine1.SkinFile?=?“G:\\DiamondGreen.ssk“;

????????????this.skinEngine1.SkinFile?=?“D:\\MP10.ssk“;
????????}???
????????private?void?btnSumbit_Click（object?sender?EventArgs?e）
????????{
????????????if?（txtName.Text?==?““）//如果用戶名輸入為空，彈出窗口給出警告
????????????{
????????????????MessageBox.Show（“請輸入用戶名“?“警告“?MessageBoxButtons.OK?MessageBoxIcon.Warning）;
????????????????txtPwd.Clear（）;//將密碼清空
????????????????txtName.Focus（）;//光標落在用戶名輸入框
????????????}
????????????else
????????????{
????????????????if?（txtPwd.Text?==?““）//如果密碼輸入為空，彈出窗口給出警告
????????????????{
????????????????????MessageBox.Show（“請輸入密碼“?“警告“?MessageBoxButtons.OK?MessageBoxIcon.Warning）;
?????????????????
????????????????}
????????????????else
????????????????{

????????????????????SqlConnection?myconn;//連接數據庫
????????????????????SqlCommand?mycomd;
????????????????????//SqlDataReader?sRead;

????????????????????string?connString?=?“Server=（local）;Integrated?Security=SSPI;Database=db_MrCy;Max?Pool?Size=75;Min?Pool?Size=5;“;//用windows身份登錄
????????????????????myconn?=?new?SqlConnection（connString）;

????????????????????if?（myconn.State?==?System.Data.ConnectionState.Closed）
????????????????????{
????????????????????????try
????????????????????????{
????????????????????????????myconn.Open（）;
????????????????????????}

????????????????????????catch?（Exception?a）
????????????????????????{
????????????????????????????MessageBox.Show（“數據庫連接失敗“?+?a.Message）;
????????????????????????????return;
????????????????????????}
????????????????????}
????????????????????//將輸入的用戶名與密碼與數據庫中數據比較
????????????????????SqlCommand?cmd?=?new?SqlCommand（“select?*?from?tb_User?where?UserName=‘“?+?txtName.Text.Trim（）?+?“‘?and?UserPwd=‘“?+?txtPwd.Text.Trim（）?+?“‘“?myconn）;
????????????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;
????????????????????sdr.Read（）;
????????????????????if?（sdr.HasRows）
????????????????????{
????????????????????????sdr.Close（）;
????????????????????????mycomd?=?new?SqlCommand（“select?*?from?tb_User?where?UserName=‘“?+?txtName.Text?+?“‘“?myconn）;
????????????????????????SqlDataReader?sdr1=mycomd.ExecuteReader（）;
????????????????????????sdr1.Read（）;
????????????????????????string?UserPower?=?sdr1[“power“].ToString（）.Trim（）;//取出此用戶名的權限power
????????????????????????sdr1.Close（）;
????????????????????????frmMain?main?=?new?frmMain（UserPower?txtName.Text?DateTime.Now.ToShortDateString（））;//實例新的窗口，傳遞用戶名，權限，登錄時間
????????????????????????main.Show（）;
????????????????????????this.Hide（）;
????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????2228224??2011-07-14?10:24??課程設計\課程設計\db_MrCy.MDF

?????文件????1048576??2011-07-14?10:24??課程設計\課程設計\db_MrCy_Log.LDF

?????文件?????516096??2006-08-18?11:50??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\Application?Files\WindowsFormsApplication2_1_0_0_2\IrisSkin2.dll.deploy

?????文件?????210432??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\Application?Files\WindowsFormsApplication2_1_0_0_2\WindowsFormsApplication2.exe.deploy

?????文件???????7929??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\Application?Files\WindowsFormsApplication2_1_0_0_2\WindowsFormsApplication2.exe.manifest

?????文件??????20480??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\Application?Files\WindowsFormsApplication2_1_0_0_2\皮膚.exe.deploy

?????文件?????494976??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\setup.exe

?????文件???????5385??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\app.publish\WindowsFormsApplication2.application

?????文件?????516096??2006-08-18?11:50??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\IrisSkin2.dll

?????文件???????1701??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.application

?????文件?????210432??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.exe

?????文件???????4332??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.exe.manifest

?????文件?????206336??2011-07-11?13:28??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.pdb

?????文件???????1701??2011-07-10?19:39??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.vshost.application

?????文件??????11608??2011-07-11?13:26??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.vshost.exe

?????文件???????4332??2011-07-10?19:39??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\WindowsFormsApplication2.vshost.exe.manifest

?????文件??????20480??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\皮膚.exe

?????文件??????22016??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\Debug\皮膚.pdb

?????文件???????5032??2007-12-22?09:44??課程設計\課程設計\WindowsFormsApplication2\bin\DeepCyan.ssk

?????文件??????12261??2007-12-22?09:45??課程設計\課程設計\WindowsFormsApplication2\bin\EmeraldColor1.ssk

?????文件?????516096??2006-08-18?11:50??課程設計\課程設計\WindowsFormsApplication2\bin\IrisSkin2.dll

?????文件??????15899??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\MP10.ssk

?????文件??????31443??2006-03-21?14:19??課程設計\課程設計\WindowsFormsApplication2\bin\msn.gif

?????文件??????16292??2006-03-22?05:55??課程設計\課程設計\WindowsFormsApplication2\bin\MSN.ssk

?????文件??????15928??2007-12-22?09:10??課程設計\課程設計\WindowsFormsApplication2\bin\Vista2_color7.ssk

?????文件??????20480??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\皮膚.exe

?????文件??????22016??2007-12-22?09:46??課程設計\課程設計\WindowsFormsApplication2\bin\皮膚.pdb

?????文件???????5632??2005-11-11?22:25??課程設計\課程設計\WindowsFormsApplication2\bin\皮膚.vshost.exe

?????文件???????6204??2011-07-10?19:29??課程設計\課程設計\WindowsFormsApplication2\Form1.cs

?????文件???????8256??2011-07-09?15:19??課程設計\課程設計\WindowsFormsApplication2\Form1.Designer.cs

............此處省略210個文件信息