stockmanage.cs

用于超市信息管理的系统

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

namespace 超市信息管理系统.MarketSystem
{
    public partial class StockManage : Form
    {
        public StockManage()
        {
            InitializeComponent();
        }

        private void StockManage_Load(object sender, EventArgs e)
        {
            sqlDataAdapter1.Fill(dataSet11);
        }

        private void button1_Click(object sender, EventArgs e)
        {
           string str="";
            if (radioButton1.Checked ==true)
            {
                str = "select StockId,factory.factoryName,merch.merchName,staff.staffName,StockNumber,totalPrice,Stockdate,stockState,StockText ";
                str+=" FROM   Stock INNER JOIN factory ON Stock.factoryID = factory.factoryID INNER JOIN merch ON Stock.merchID = merch.MerchId INNER JOIN  staff ON Stock.staffId = staff.staffId  ";
                str += " where StockId='"+textBox1.Text.Trim()+"'";
            }
            if (radioButton2.Checked == true)
            {
                str = "select StockId,factory.factoryName,merch.merchName,staff.staffName,StockNumber,totalPrice,Stockdate,stockState,StockText ";
                str += " FROM   Stock INNER JOIN factory ON Stock.factoryID = factory.factoryID INNER JOIN merch ON Stock.merchID = merch.MerchId INNER JOIN  staff ON Stock.staffId = staff.staffId  ";
                str += " where factoryName='"+textBox1.Text.Trim()+"'";
            }
            if (radioButton3.Checked == true)
            {
                str = "select StockId,factory.factoryName,merch.merchName,staff.staffName,StockNumber,totalPrice,Stockdate,stockState,StockText ";
                str += " FROM   Stock INNER JOIN factory ON Stock.factoryID = factory.factoryID INNER JOIN merch ON Stock.merchID = merch.MerchId INNER JOIN  staff ON Stock.staffId = staff.staffId  ";
                str += " where staffName='"+textBox1.Text.Trim()+"'";
            }
            SqlCommand com = new SqlCommand(str,sqlConnection1);
            sqlDataAdapter1.SelectCommand = com;
            dataSet11.Clear();
            sqlDataAdapter1.Fill(dataSet11);
        }
    }
}