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

namespace?網(wǎng)吧管理系統(tǒng)
{
????public?partial?class?CZ?:?Form
????{
????????public?CZ（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?CZ_Load（object?sender?EventArgs?e）
????????{
????????????//創(chuàng)建數(shù)據(jù)庫連接字符串
????????????string?conn1?=?“server=.;database=NetBarDB;uid=sa;pwd=123456“;
????????????//創(chuàng)建數(shù)據(jù)庫連接對象
????????????SqlConnection?con1?=?new?SqlConnection（conn1）;
????????????//創(chuàng)建要執(zhí)行的SQL語句
????????????string?sql1?=?“select?CardNumber?from?cardInfo“;
????????????//創(chuàng)建斷開式連接對象
????????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（sql1?con1）;
????????????//創(chuàng)建數(shù)據(jù)集對象
????????????DataSet?ds?=?new?DataSet（）;
????????????//填充數(shù)據(jù)集
????????????adapter.Fill（ds）;
????????????//綁定數(shù)據(jù)源
????????????cbo_1.DataSource?=?ds.Tables[0].DefaultView;
????????????//顯示字段
????????????cbo_1.DisplayMember?=?“CardNumber“;
????????}

????????private?void?but_1_Click（object?sender?EventArgs?e）
????????{
????????????//獲取文本
???????????string?_1=?cbo_1.Text;
???????????string?_2=numericUpDown1.Text;
????????????//創(chuàng)建數(shù)據(jù)庫連接字符串
???????????string?conn?=?“server=.;database=NetBarDB;uid=sa;pwd=123456“;
????????????//創(chuàng)建數(shù)據(jù)庫連接對象
????????????SqlConnection?con?=?new?SqlConnection（conn）;
????????????//打開數(shù)據(jù)庫連接
????????????con.Open（）;
????????????//創(chuàng)建要執(zhí)行的SQL語句
????????????string?sql?=?string.Format（“update?cardInfo?set?cardBalance+={0}?where?CardNumber=‘{1}‘“_2_1）;
????????????//創(chuàng)建SQL語句執(zhí)行對象
????????????SqlCommand?cmd?=?new?SqlCommand（sql?con）;

????????????if?（con.State?==?ConnectionState.Open）
????????????{
????????????????//判斷是否充值成功
????????????????int?i?=?cmd.ExecuteNonQuery（）;
????????????????if?（i?>?0）
????????????????{
????????????????????MessageBox.Show（“充值成功！“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????????this.Hide（）;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“充值失敗！“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????}
????????????}

????????????//關閉數(shù)據(jù)庫連接????????
????????????con.Close（）;
????????}

????????private?void?but_2_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????6628??2020-07-21?09:23??NetBarDB.sql
?????文件?????????896??2020-07-22?13:22??網(wǎng)吧管理系統(tǒng).sln
?????文件???????31744??2020-10-06?13:16??網(wǎng)吧管理系統(tǒng).suo
?????目錄???????????0??2020-10-12?14:38??網(wǎng)吧管理系統(tǒng)\
?????目錄???????????0??2020-10-12?14:38??網(wǎng)吧管理系統(tǒng)\bin\
?????目錄???????????0??2020-10-12?14:38??網(wǎng)吧管理系統(tǒng)\bin\Debug\
?????文件???????47104??2020-10-06?13:15??網(wǎng)吧管理系統(tǒng)\bin\Debug\網(wǎng)吧管理系統(tǒng).exe
?????文件??????177664??2020-10-06?13:15??網(wǎng)吧管理系統(tǒng)\bin\Debug\網(wǎng)吧管理系統(tǒng).pdb
?????文件???????11600??2020-10-06?13:15??網(wǎng)吧管理系統(tǒng)\bin\Debug\網(wǎng)吧管理系統(tǒng).vshost.exe
?????文件?????????490??2019-12-07?17:10??網(wǎng)吧管理系統(tǒng)\bin\Debug\網(wǎng)吧管理系統(tǒng).vshost.exe.manifest
?????目錄???????????0??2020-07-22?13:33??網(wǎng)吧管理系統(tǒng)\bin\Release\
?????文件????????2698??2020-02-05?14:37??網(wǎng)吧管理系統(tǒng)\CZ.cs
?????文件????????6842??2020-02-05?14:37??網(wǎng)吧管理系統(tǒng)\CZ.Designer.cs
?????文件????????5817??2020-02-05?14:37??網(wǎng)吧管理系統(tǒng)\CZ.resx
?????文件????????2123??2020-07-24?10:37??網(wǎng)吧管理系統(tǒng)\DL.cs
?????文件????????6418??2020-07-24?10:37??網(wǎng)吧管理系統(tǒng)\DL.Designer.cs
?????文件????????5817??2020-07-24?10:37??網(wǎng)吧管理系統(tǒng)\DL.resx
?????文件????????4174??2020-08-05?17:34??網(wǎng)吧管理系統(tǒng)\GLXT.cs
?????文件???????18136??2020-08-05?17:34??網(wǎng)吧管理系統(tǒng)\GLXT.Designer.cs
?????文件???????12359??2020-08-05?17:34??網(wǎng)吧管理系統(tǒng)\GLXT.resx
?????文件????????3671??2020-07-24?10:42??網(wǎng)吧管理系統(tǒng)\HJ.cs
?????文件????????5981??2020-07-24?10:42??網(wǎng)吧管理系統(tǒng)\HJ.Designer.cs
?????文件????????5817??2020-07-24?10:42??網(wǎng)吧管理系統(tǒng)\HJ.resx
?????文件????????1233??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\HYK.cs
?????文件????????3150??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\HYK.Designer.cs
?????文件????????5817??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\HYK.resx
?????文件????????1170??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\JSJ.cs
?????文件????????3150??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\JSJ.Designer.cs
?????文件????????5817??2020-07-22?22:13??網(wǎng)吧管理系統(tǒng)\JSJ.resx
?????目錄???????????0??2020-08-08?02:16??網(wǎng)吧管理系統(tǒng)\obj\
?????目錄???????????0??2020-08-08?02:16??網(wǎng)吧管理系統(tǒng)\obj\x86\
............此處省略47個文件信息