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;
using?System.Security;
using?System.Security.Cryptography;
using?System.Configuration;

namespace?System_Manage
{
????public?partial?class?Frm_Login?:?Form
????{
????????SqlConnection?conn?=?new?SqlConnection（ConfigurationManager.ConnectionStrings[“conn“].ConnectionString）;
????????public?static?string?userid?=?““;
????????public?static?string?usertruename?=?““;
????????public?static?string?roleid?=?““;

????????public?Frm_Login（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?User_Login（string?username?string?userpass）
????????{
????????????try
????????????{
????????????????string?sql?=?“select?su.user_namesu.user_truenamesu.user_keysu.user_idsu.is_adminsrr.role_id?from?system_users?susystem_users_roles?srr?where?su.user_id=srr.user_id?and?su.user_name=‘“?+?username?+?“‘?and?su.user_pass=‘“?+?userpass?+?“‘?and?su.isvalid=1“;
????????????????//?string?sql?=?“select?user_nameuser_truenameuser_keyuser_idis_admin?from?system_users?where?user_name=‘“?+?username?+?“‘?and?user_pass=‘“?+?userpass?+?“‘“;
????????????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????????????conn.Open（）;
????????????????SqlDataReader?dr?=?cmd.ExecuteReader（）;
????????????????//用戶名和密碼都正確
????????????????if?（dr.Read（））
????????????????{
????????????????????string?keyid?=?““;
????????????????????userid?=?dr[“user_id“].ToString（）;
????????????????????usertruename?=?dr[“user_truename“].ToString（）;
????????????????????#region?dsaf
????????????????????roleid?=?dr[5].ToString（）.Trim（）;
????????????????????//判斷是否是管理員
????????????????????if?（（bool.Parse（dr[4].ToString（）））?==?false）
????????????????????{
????????????????????????//如果是，不驗證鑰匙盤
????????????????????????#region?鑰匙盤校驗
????????????????????????////如果不是驗讓鑰匙盤
????????????????????????EPASSMDLibFull.SePass?epass?=?new?EPASSMDLibFull.SePass（）;
????????????????????????try
????????????????????????{
????????????????????????????//校驗目錄結構，檢測鑰匙盤是否插入
????????????????????????????epass.OpenDevice（1?“0x200“）;
????????????????????????????keyid?=?epass.GetStrProperty（7?0?“0x200“）.ToString（）;
????????????????????????}
????????????????????????catch?（Exception?ex）
????????????????????????{

????????????????????????????MessageBox.Show（“請插入鑰匙盤！“）;
????????????????????????????return;
????????????????????????}
????????????????????????finally
????????????????????????{
????????????????????????????epass.CloseDevice（）;
????????????????????????}
????????????????????????//校驗鑰匙盤是否為與用戶相對應
????????????????????????if?（keyid?!=?dr[“user_key“].ToString（））
????????????????????????{
????????????????????????????MessageBox.Show（“請插入正確的鑰匙盤！“）;
????????????????????????????return;
????????????????????????}
????????????????????????#endregion
???????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-20?18:14??LangPowerMS\
?????文件?????????222??2014-12-04?22:40??LangPowerMS\App.config
?????目錄???????????0??2018-03-20?18:14??LangPowerMS\bin\
?????目錄???????????0??2018-03-20?18:14??LangPowerMS\bin\Debug\
?????文件????????9216??2014-11-27?13:26??LangPowerMS\bin\Debug\Interop.EPASSMDLibFull.dll
?????文件??????240640??2017-08-18?09:29??LangPowerMS\bin\Debug\System_Manage.exe
?????文件?????????222??2014-12-04?22:40??LangPowerMS\bin\Debug\System_Manage.exe.config
?????文件??????140800??2017-08-18?09:29??LangPowerMS\bin\Debug\System_Manage.pdb
?????文件???????14328??2017-08-24?14:37??LangPowerMS\bin\Debug\System_Manage.vshost.exe
?????文件?????????222??2014-12-04?22:40??LangPowerMS\bin\Debug\System_Manage.vshost.exe.config
?????文件?????????490??2009-06-11?05:14??LangPowerMS\bin\Debug\System_Manage.vshost.exe.manifest
?????目錄???????????0??2018-03-20?18:14??LangPowerMS\DB\
?????文件?????2031616??2014-12-04?22:43??LangPowerMS\DB\system_manage_Data.MDF
?????文件?????3932160??2014-12-04?22:43??LangPowerMS\DB\system_manage_Log.LDF
?????文件????????4501??2014-11-03?13:39??LangPowerMS\Frm_Login.cs
?????文件????????8003??2014-11-03?13:39??LangPowerMS\Frm_Login.Designer.cs
?????文件??????135654??2014-11-03?13:39??LangPowerMS\Frm_Login.resx
?????文件????????6034??2014-12-04?10:01??LangPowerMS\Frm_Main.cs
?????文件????????8227??2014-12-04?10:01??LangPowerMS\Frm_Main.Designer.cs
?????文件????????6607??2014-12-04?10:01??LangPowerMS\Frm_Main.resx
?????文件???????29097??2014-12-04?10:00??LangPowerMS\Frm_Resources.cs
?????文件???????20223??2014-11-03?13:39??LangPowerMS\Frm_Resources.Designer.cs
?????文件????????6012??2014-11-03?13:39??LangPowerMS\Frm_Resources.resx
?????文件????????8064??2014-12-04?10:00??LangPowerMS\Frm_Roles.cs
?????文件???????13169??2014-11-03?13:39??LangPowerMS\Frm_Roles.Designer.cs
?????文件????????6368??2014-11-03?13:39??LangPowerMS\Frm_Roles.resx
?????文件????????9359??2014-11-03?13:39??LangPowerMS\Frm_Role_Resources.cs
?????文件????????6362??2014-11-03?13:39??LangPowerMS\Frm_Role_Resources.Designer.cs
?????文件????????5814??2014-11-03?13:39??LangPowerMS\Frm_Role_Resources.resx
?????文件???????11306??2014-12-04?10:00??LangPowerMS\Frm_Users.cs
?????文件???????21061??2014-11-03?13:39??LangPowerMS\Frm_Users.Designer.cs
............此處省略41個文件信息