2.操作界面:

代码如下:
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;
namespace 梦之翼小组项目
{
public partial class caozuoyemain : Form
{
public caozuoyemain()
{
InitializeComponent();
}
public double totalPrice;//每种商品的总价
public double total; //所有商品的总价
public double shijijin;//顾客给的钱数
public double yingzhao;// 找给顾客的钱数
public string mingcheng;//每件商品的名称
public double shuliang;//每件商品的数量
public double jiage;//每件商品的价格
public int i = 0; //商品收费的id
model db = new model(); //实例化数据库对象
public void fanli() //单件物品的返利方法
{
if (jiage * shuliang < 600 && jiage * shuliang > 300)
{
totalPrice = jiage * shuliang - 100;
}
else
{
totalPrice = jiage * shuliang;
}
}
private void confirm_Click(object sender, EventArgs e) //单击确定按钮的事件
{
totalPrice = 0; //每一次商品的单个金额
jiage = Convert.ToDouble(price.Text);
shuliang = Convert.ToDouble(number.Text); //数据类型的转换
switch (jisuanfangshi.SelectedIndex)
{
case 0:
totalPrice = jiage * shuliang;
break;
case 1:
totalPrice = jiage * shuliang*0.8;
break;
case 2:
fanli(); //调用单个物品的返利方法
break;
}
total = totalPrice + total; //所有商品的总金额
zongjine.Text = total.ToString();//总金额转换数据类型,显示到文本框里面
i++; //每一次的商品id加1,为了调出所有商品的最后一个数据
db.dbcon();
try
{
string insertInfo = "insert wupin values('" + i.ToString() + "','" + tradeName.Text + "','" + price.Text + "','" +
number.Text + "','" + jisuanfangshi.Text + "','" + totalPrice.ToString() + "')";
db.dbInsert(insertInfo);
string selstr = "select top "+i+" * from wupin order by 物品ID desc";
db.dbFill(selstr);
dataGridView1.DataSource = db.dt;
}
catch (Exception)
{
MessageBox.Show("不好意思,信息有误,注册失败");
}
}
private void caozuoyemain_Load(object sender, EventArgs e)
{
db.dbcon();
string qingkong = "TRUNCATE TABLE wupin";
db.dbInsert(qingkong);
jisuanfangshi.SelectedIndex = 0;
}
private void jiesuan_Click(object sender, EventArgs e)
{
shijijin = Convert.ToDouble(shishoujine.Text);
yingzhao=Convert.ToDouble(zongjine.Text) ;
yingzhao = shijijin - total;
zhaojine.Text = yingzhao.ToString()+"元";
}
private void resetting_Click(object sender, EventArgs e)
{
tradeName.Text = "";
price.Text = "";
number.Text = "";
}
}
}










