91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 781KB
    文件類型: .rar
    金幣: 2
    下載: 1 次
    發布日期: 2021-06-23
  • 語言: C#
  • 標簽: C#+SQL??

資源簡介

基于C#和SQL Server開發的超市管理系統，含文檔，數據庫，程序。

資源截圖

代碼片段和文件信息 

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

namespace?SuperMarketSystem
{
????public?partial?class?Administrator?:?Form
????{
????????public?Administrator（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?btnExit_Click（object?sender?EventArgs?e）
????????{
????????????Application.Exit（）;
????????}

????????private?void?btnBack_Click（object?sender?EventArgs?e）
????????{
????????????this.DestroyHandle（）;
????????}

????????private?void?btnAdd_Click（object?sender?EventArgs?e）
????????{
????????????StaffBillTable?staff?=?new?StaffBillTable（）;
????????????staff.Sex?=?this.textBoxStaffSex.Text;
????????????staff.StaffID?=?this.textBoxStaffID.Text;
????????????staff.StaffName?=?this.textBoxStaffName.Text;
????????????if?（this.textBoxStaffID.Text?==?““?||?this.textBoxStaffName.Text?==?““?||?this.textBoxStaffSex.Text?==?““）
????????????{
????????????????MessageBox.Show（“不能有空項，請重新輸入！“）;
????????????????return;
????????????}
????????????if?（this.textBoxStaffSex.Text?!=?“男“?&&?this.textBoxStaffSex.Text?!=?“女“）
????????????{
????????????????MessageBox.Show（“性別有誤，只能為‘男’和‘女’請重新輸入！“）;
????????????????return;
????????????}
????????????try
????????????{
????????????????this.InsertStaff（staff）;
????????????}
????????????catch?（SqlException?sqle）
????????????{
????????????????MessageBox.Show（sqle.Message）;
????????????}
????????}

????????private?void?InsertStaff（StaffBillTable?staff）
????????{
????????????using?（SqlConnection?cn?=?new?SqlConnection（“server=.\\SQLEXPRESS;database=SMMS;uid=sa;pwd=zhu“））
????????????{
????????????????string?sql?=?string.Format（“insert?into?StaffBill?values（‘{0}‘‘{1}‘‘{2}‘）“?staff.StaffID
????????????????????staff.StaffName?staff.Sex）;
????????????????cn.Open（）;
????????????????SqlCommand?cmd?=?new?SqlCommand（sql?cn）;
????????????????cmd.ExecuteNonQuery（）;
????????????}
????????????MessageBox.Show（“添加成功！“）;
????????}

????????private?void?Administrator_Load（object?sender?EventArgs?e）
????????{

????????}

????????private?void?btnEmplSearch_Click（object?sender?EventArgs?e）
????????{
????????????DataTable?dt?=?new?DataTable（“Employee“）;
????????????string?sql?=?“select?*?from?StaffBill“;
????????????string?connect?=?“server=.\\SQLEXPRESS;database=SMMS;uid=sa;pwd=zhu“;
????????????using?（SqlConnection?cn?=?new?SqlConnection（connect））
????????????{
????????????????try
????????????????{
????????????????????SqlDataAdapter?dp?=?new?SqlDataAdapter（sql?cn）;
????????????????????dp.Fill（dt）;
????????????????????this.dataGridView1.DataSource?=?dt;
????????????????}
????????????????catch?（SqlException?sqle）
????????????????{
????????????????????MessageBox.Show（sqle.Message）;
????????????????}
????????????}
????????}

????????private?void?btnDel_Click（

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

?????文件????3145728??2011-05-31?22:22??超市管理系統\SMMS.mdf

?????文件????1048576??2011-05-31?22:22??超市管理系統\SMMS_log.ldf

?????文件?????159651??2011-05-30?17:05??超市管理系統\新建文件夾\DatabaseSystemTest2.zip

?????文件???????3753??2011-05-29?15:44??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Administrator.cs

?????文件???????9675??2011-05-29?15:34??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Administrator.Designer.cs

?????文件???????5814??2011-05-29?15:34??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Administrator.resx

?????文件??????33280??2011-05-29?15:44??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Debug\SuperMarketSystem.exe

?????文件??????91648??2011-05-29?15:44??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Debug\SuperMarketSystem.pdb

?????文件??????14328??2011-05-29?15:55??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Debug\SuperMarketSystem.vshost.exe

?????文件????????490??2009-06-11?05:14??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Debug\SuperMarketSystem.vshost.exe.manifest

?????文件??????31744??2011-05-29?16:01??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Release\SuperMarketSystem.exe

?????文件??????73216??2011-05-29?16:01??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\bin\Release\SuperMarketSystem.pdb

?????文件???????3172??2011-05-29?14:56??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\BuyersForm.cs

?????文件??????13910??2011-05-29?14:49??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\BuyersForm.Designer.cs

?????文件???????5814??2011-05-29?14:49??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\BuyersForm.resx

?????文件???????1119??2011-05-29?10:07??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\BuyTable.cs

?????文件???????2094??2011-05-29?14:30??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Form1.cs

?????文件???????6018??2011-05-29?14:30??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Form1.Designer.cs

?????文件???????5814??2011-05-29?14:30??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Form1.resx

?????文件???????1027??2011-05-25?22:23??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\Goods_InfoTable.cs

?????文件????????180??2011-05-29?15:34??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.Administrator.resources

?????文件????????180??2011-05-29?15:20??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.BuyersForm.resources

?????文件???????2000??2011-05-29?15:55??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.csproj.FileListAbsolute.txt

?????文件???????1111??2011-05-29?15:34??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.csproj.GenerateResource.Cache

?????文件??????33280??2011-05-29?15:44??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.exe

?????文件????????180??2011-05-29?15:20??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.Form1.resources

?????文件??????91648??2011-05-29?15:44??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.pdb

?????文件????????180??2011-05-29?15:20??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.Properties.Resources.resources

?????文件????????180??2011-05-29?15:20??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.SellerOperationForm.resources

?????文件????????180??2011-05-29?15:20??超市管理系統\新建文件夾\SuperMarketSystem\SuperMarketSystem\obj\Debug\SuperMarketSystem.UersStatus.resources

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

評論

共有 條評論