using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.Configuration;

namespace?WindowsFormsApplication6
{
????public?partial?class?AddUserForm?:?Form
????{
????????public?AddUserForm（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?sql?=?“select?Name?from?StaffAccount?where?Name=‘“?+?txtUserName?+?“‘“;
????????????string?connstr?=?ConfigurationManager.ConnectionStrings[“WindowsFormsApplication6.Properties.Settings.staffConnectionString1“].ConnectionString;
????????????SqlConnection?conn?=?new?SqlConnection（connstr）;
????????????SqlCommand?cmd?=?new?SqlCommand（sql?conn）;
????????????conn.Open（）;
????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;
????????????if?（sdr.Read（））
????????????{
????????????????lblUserMsg.Text?=?“用戶名已存在請重新輸入!“;
????????????}
????????????else?if?（txtUserName.Text.Trim（）?==?““）
????????????{
????????????????lblUserMsg.Text?=?“用戶名不能為空!“;
????????????}

????????????else?if?（txtPassword.Text.Trim（）?==?““）
????????????{
????????????????lblPwd.Text?=?“密碼不能為空!“;
????????????????lblPwd.Text?=?““;
????????????}
????????????else?if?（txtPwdConfirm.Text.Trim（）?==?““）
????????????{
????????????????lblPswConfirm.Text?=?“驗證密碼不能為空!“;
????????????????lblUserMsg.Text?=?““;
????????????????lblPwd.Text?=?““;
????????????}
????????????else?if?（txtPassword.Text.Trim（）?!=?txtPwdConfirm.Text.Trim（））
????????????{
????????????????lblPwd.Text?=?“2次密碼必須一樣!“;
????????????????lblPswConfirm.Text?=?“請重新輸入!“;
????????????}
????????????else?if?（txtName.Text.Trim（）?==?““?|?txtAge.Text.Trim（）?==?““?|?cmboxSex.Text?==?““?|?cmboxOffice.Text?==?““）
????????????{
????????????????lblbaseInfo.Text?=?“基本信息不完整！“;
????????????}
????????????else?
????????????{
????????????????lblUserMsg.Text?=?““;
????????????????lblPwd.Text?=?““;
????????????????lblPswConfirm.Text?=?““;
????????????????lblbaseInfo.Text?=?““;
????????????????string?uType?=?““;
????????????????if?（rbtAdmin.Checked）
????????????????????uType?=?“Administrator“;
????????????????else?if?（rbtNormalUser.Checked）
????????????????????uType?=?“NormalUser“;
????????????????else
????????????????????uType?=?“NormalUser“;
????????????????conn.Close（）;
????????????????string?sqlInsert?=?“insert?into?StaffAccount（NamePasswordUserType）?values（@UserName@UserPwd@UserType）“;
????????????????string?sqlInsertInfo?=?“insert?into?StaffInfo（NameSexAgeOffice）?values（@Name@Sex@Age@Office）“;
????????????????SqlParameter[]?param?=?{
????????????????????????????????????????new?SqlParameter（“@UserName“txtUserName.Text）
????????????????????????????????????????new?SqlParameter（“@UserPwd“txtPassword.Text）
????????????????????????????????????????new?SqlParameter（“@UserType“uType）
????????????????????????????????????};

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\.vs\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\.vs\staff\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\
?????文件???????74240??2018-01-17?22:42??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\.suo
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\Server\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\Server\sqlite3\
?????文件???????????0??2018-01-17?16:22??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\Server\sqlite3\db.lock
?????文件??????733184??2018-01-17?20:37??Staff-System-master\WindowsFormsApplication6\.vs\staff\v15\Server\sqlite3\storage.ide
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\WindowsFormsApplication6\
?????目錄???????????0??2018-01-23?19:27??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\WindowsFormsApplication6\v15\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\staff\
?????目錄???????????0??2018-01-23?19:23??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\staff\v15\
?????文件???????43008??2018-01-17?15:53??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\.vs\staff\v15\.suo
?????文件???????15720??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\AddUserForm.Designer.cs
?????文件????????4604??2018-01-17?14:33??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\AddUserForm.cs
?????文件???????12549??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\AddUserForm.resx
?????文件?????????773??2018-01-17?14:34??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\App.config
?????文件????????6355??2018-01-17?14:33??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\Form1.Designer.cs
?????文件????????2749??2018-01-17?14:33??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\Form1.cs
?????文件??????133736??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\Form1.resx
?????文件???????10379??2018-01-17?19:45??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\MainForm.Designer.cs
?????文件????????2011??2018-01-17?19:45??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\MainForm.cs
?????文件???????42449??2018-01-17?19:45??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\MainForm.resx
?????文件???????18266??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\ManagerForm.Designer.cs
?????文件????????4692??2018-01-17?14:32??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\ManagerForm.cs
?????文件???????14359??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\ManagerForm.resx
?????文件????????7630??2018-01-17?14:36??Staff-System-master\WindowsFormsApplication6\WindowsFormsApplication6\PasswordChange.Designer.cs
............此處省略102個文件信息