factorymanage.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 FactoryManage : Form
    {
        public FactoryManage()
        {
            InitializeComponent();
        }

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

        /// <summary>
        /// 更改厂商信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            string update_Sql = "update factory set factoryName='" + textBox2.Text.Trim() + "',ContactName='"+textBox3.Text.Trim()+"',";
            update_Sql += "phone='" + textBox4.Text.Trim() + "',address='" + textBox5.Text.Trim() + "',bank='"+textBox6.Text.Trim()+"',";
            update_Sql += "accountID='" + textBox7.Text.Trim() + "',factoryText='" + textBox8.Text.Trim() + "' where factoryID='" + textBox1.Text.Trim() + "'";
            //更新厂商信息的方法
            DataBaseConnection.update(update_Sql);
            UpdateFactory();
        }
        /// <summary>
        /// 删除厂商信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            string delete_Sql = "delete from factory where factoryID='"+textBox1.Text.Trim()+"'";
            //删除厂商信息的方法
            DataBaseConnection.delete(delete_Sql);
            //更新数据集
            UpdateFactory();
            
        }

        //更新数据集
        private void UpdateFactory()
        {
            string sql = "select * from factory";
            sqlConnection1.Open();
            sqlDataAdapter1.SelectCommand = new SqlCommand(sql, sqlConnection1);
            dataSet11.Clear();
            sqlDataAdapter1.Fill(dataSet11);
            sqlConnection1.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string insert_Sql = "insert into factory values('"+textBox9.Text.Trim()+"','"+textBox10.Text.Trim()+"','";
            insert_Sql += textBox11.Text.Trim() + "','" + textBox12.Text.Trim() + "','" + textBox13.Text.Trim() + "','" + textBox14.Text.Trim() + "','";
            insert_Sql += textBox15.Text.Trim() + "','" + textBox16.Text.Trim() + "')";
            DataBaseConnection.insert(insert_Sql);

            DataRow row = dataSet11.Tables["factoryAdd"].NewRow();
            row[0]= textBox9.Text.Trim();
            row[1]= textBox10.Text.Trim();
            row[2]= textBox11.Text.Trim();
            row[3]= textBox12.Text.Trim();
            row[4]= textBox13.Text.Trim();
            row[5]= textBox14.Text.Trim();
            row[6]= textBox15.Text.Trim();
            row[7]= textBox16.Text.Trim();
            dataSet11.Tables["factoryAdd"].Rows.Add(row);

            UpdateFactory();
            setNull();
        }

        private void setNull()
        {
            textBox9.Text="";
            textBox10.Text="";
            textBox11.Text = "";
            textBox12.Text = "";
            textBox13.Text = "";
            textBox14.Text="";
            textBox15.Text="";
            textBox16.Text="";
        }

       
    }
}