querymerch.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 QueryMerch : Form
    {
        private SqlConnection myConnection;
       // private SqlDataAdapter da;

        private DataSet ds = new DataSet();
        //private DataTable LogTable;
        //private DataRow LogRow;
        //private string StrSQL = "select * from SysUser";
        private string StrSQL = null;
        public QueryMerch()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //StrSQL = "select  MerchId,merchName,merchPrice,merchNumber,memberPrice,warningNum,ProsalePrice,ProsaleDateS,ProsaleDateE,allowaBate,allowSale,factoryName";
            //StrSQL+=" from merch join factory on merch.factoryId=factory.factoryid where merchID='0002'";
            

             try
              {

                  myConnection = DataBaseConnection.connection();
                  sqlDataAdapter1.SelectCommand = new SqlCommand(StrSQL, myConnection);
                  dataSet11.Clear();
                  sqlDataAdapter1.Fill(dataSet11);
              }
              catch (SqlException oe)
              {
                  MessageBox.Show(oe.Message);
              }
              finally
              {
                  myConnection.Close();
              }

                
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
                    
                StrSQL = " SELECT *  FROM  merch  where merchId='" + textBox1.Text.Trim().ToString() + "'";
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            StrSQL = "select * from merch where merchNumber<=warningNum";
        }

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

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            StrSQL = " SELECT *  FROM  merch  where merchId='" + textBox1.Text.Trim().ToString() + "'";
        }



    }
}