資源簡介
該系統工作流程:超市工作人員在管理商品時,用戶對商品的價格,折扣等進行管理,并進行增刪改。(1)該管理軟件將對商品進行管理和統計,對產品的價格進行錄入管理和統計;(2)根據需要對商品名稱、價格、是否打折等進行查詢,并能顯示詳細信息;(3)為用戶提供賬號管理工具,以便用戶對賬號進行管理,具體為登錄修改用戶密碼;(4)提供商品的增加,刪除,修改,對商品進行管理,還可以分類查看打折商品和原價商品。數據庫中需要存儲的數據:用戶登錄名、密碼、商品名稱、價格、是否打折、商品類別、打折價格等。
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
namespace?supermarket
{
????public?class?DBHelper
????{
????????private?string?connString?=?@“Data?Source=(local);Initial?Catalog=SuperMarket;User?ID=sa;Password=123456“;
????????private?SqlConnection?connection;
????????//連接對象
????????public?SqlConnection?Connection
????????{
????????????get?
????????????{
????????????????if?(connection==null)
????????????????{
????????????????????connection?=?new?SqlConnection(connString);
????????????????}
????????????????return?connection;
????????????}
????????}
????????//打開數據連接
????????public?void?OpenConnection()
????????{
????????????if?(Connection.State?==?ConnectionState.Closed)
????????????{
????????????????Connection.Open();
????????????}
????????????else?if?(Connection.State==ConnectionState.Broken)
????????????{
????????????????Connection.Close();
????????????????Connection.Open();
????????????}
????????}
????????//關閉數據庫
????????public?void?CloseConnection()
????????{
????????????if?(Connection.State?==ConnectionState.Open?||?Connection.State==ConnectionState.Broken)
????????????{
????????????????Connection.Close();
????????????}
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
????..A..H.?????64512??2020-12-14?19:39??sm\supermarket\.vs\supermarket\v16\.suo
?????文件??????????0??2020-12-14?18:47??sm\supermarket\.vs\supermarket\v16\Server\sqlite3\db.lock
?????文件?????577536??2020-12-14?19:17??sm\supermarket\.vs\supermarket\v16\Server\sqlite3\storage.ide
?????文件?????186880??2020-12-16?21:51??sm\supermarket\supermarket\bin\Debug\supermarket.exe
?????文件??????83456??2020-12-16?21:51??sm\supermarket\supermarket\bin\Debug\supermarket.pdb
?????文件??????11600??2020-12-19?12:38??sm\supermarket\supermarket\bin\Debug\supermarket.vshost.exe
?????文件????????490??2019-03-19?12:46??sm\supermarket\supermarket\bin\Debug\supermarket.vshost.exe.manifest
?????文件???????1363??2020-12-15?18:02??sm\supermarket\supermarket\DBHelper.cs
?????文件????????367??2020-12-11?23:26??sm\supermarket\supermarket\frmAbout.cs
?????文件???????3249??2020-12-11?23:26??sm\supermarket\supermarket\frmAbout.Designer.cs
?????文件???????5817??2020-12-11?23:26??sm\supermarket\supermarket\frmAbout.resx
?????文件???????3779??2020-12-15?19:26??sm\supermarket\supermarket\frmChangePwd.cs
?????文件???????6110??2020-12-11?23:26??sm\supermarket\supermarket\frmChangePwd.Designer.cs
?????文件???????5817??2020-12-11?23:26??sm\supermarket\supermarket\frmChangePwd.resx
?????文件???????7882??2020-12-16?19:01??sm\supermarket\supermarket\frmEditCommodity.cs
?????文件???????9789??2020-12-13?19:04??sm\supermarket\supermarket\frmEditCommodity.Designer.cs
?????文件???????5817??2020-12-13?19:04??sm\supermarket\supermarket\frmEditCommodity.resx
?????文件???????3014??2020-12-15?18:36??sm\supermarket\supermarket\frmLogin.cs
?????文件???????6330??2020-12-11?22:43??sm\supermarket\supermarket\frmLogin.Designer.cs
?????文件???????5817??2020-12-11?22:43??sm\supermarket\supermarket\frmLogin.resx
?????文件???????6136??2020-12-15?17:59??sm\supermarket\supermarket\frmSuperMarket.cs
?????文件??????10107??2020-12-14?19:13??sm\supermarket\supermarket\frmSuperMarket.Designer.cs
?????文件???????6212??2020-12-14?19:13??sm\supermarket\supermarket\frmSuperMarket.resx
?????文件???????1454??2020-12-16?19:30??sm\supermarket\supermarket\frmSuperMarketMain.cs
?????文件???????6759??2020-12-16?19:30??sm\supermarket\supermarket\frmSuperMarketMain.Designer.cs
?????文件???????6015??2020-12-16?19:30??sm\supermarket\supermarket\frmSuperMarketMain.resx
?????文件???????5420??2020-12-15?18:00??sm\supermarket\supermarket\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????7135??2020-12-17?23:43??sm\supermarket\supermarket\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????4420??2020-12-19?12:38??sm\supermarket\supermarket\obj\x86\Debug\supermarket.csproj.FileListAbsolute.txt
?????文件???????1676??2020-12-16?19:30??sm\supermarket\supermarket\obj\x86\Debug\supermarket.csproj.GenerateResource.Cache
............此處省略52個文件信息
- 上一篇:C# 調用攝像頭拍照(基于AForge)
- 下一篇:C# 計算機配置管理系統
評論
共有 條評論