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

        private void button1_Click(object sender, EventArgs e)
        {
            string strSql = "";
            /*
            if (dateTimePicker1.Value.ToString() == dateTimePicker2.Value.ToString())
            {
                dateTimePicker1.Text = "";
                dateTimePicker2.Text = "";
                //MessageBox.Show("相等");
            }
             * */
            //判断文本框是否为空
            if (textBox1.Text.Trim() == string.Empty || textBox2.Text.Trim() == string.Empty || textBox3.Text.Trim() == string.Empty || textBox4.Text.Trim() == string.Empty || textBox6.Text.Trim() == string.Empty || comboBox2.Text.Trim() == string.Empty || textBox8.Text.Trim() == string.Empty)
            {
                MessageBox.Show("商品编号，商品名称，商品价格，商品库存量，库存警告量，允许出售，厂商编号都不能全为全","警告");
                return;
            }
            //当没有更改日期时,不会插入促销起,止日期
            if (dateTimePicker1.Value.ToString() == dateTimePicker2.Value.ToString())
            {
                strSql = "insert into merch (MerchId,merchName,merchPrice,merchNumber,memberPrice,warningNum,ProsalePrice,allowaBate,allowSale,factoryId)  values('";
                strSql += textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "','";
                strSql += textBox5.Text.Trim() + "','" + textBox6.Text.Trim() + "','" + textBox7.Text.Trim() + "','" + comboBox1.Text.Trim() + "','" + comboBox2.Text.Trim() + "','" + textBox8.Text.Trim() + "')";

                //MessageBox.Show("是");
            }
                //当更改日期后,会插入促销起,止日期
            else
            {
                strSql = "insert into merch values('";
                strSql += textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "','";
                strSql += textBox5.Text.Trim() + "','" + textBox6.Text.Trim() + "','" + textBox7.Text.Trim() + "','" + dateTimePicker1.Value.ToLongDateString() + "','" + dateTimePicker2.Value.ToLongDateString() + "','";
                strSql+= comboBox1.Text.Trim() + "','" + comboBox2.Text.Trim() + "','" + textBox8.Text.Trim() + "')";
            }
            //向数量库插入数量

            DataBaseConnection.insert(strSql);
            
            //向DataGrid添加数据
            if (dateTimePicker1.Value.ToString() == dateTimePicker2.Value.ToString())
            {
                DataRow row = dataSet11.Tables["merch1"].NewRow();
                row[0] = textBox1.Text.Trim();
                row[1] = textBox2.Text.Trim();
                row[2] = textBox3.Text.Trim();
                row[3] = textBox4.Text.Trim();
                row[4] = textBox5.Text.Trim();
                row[5] = textBox6.Text.Trim();
                row[6] = textBox7.Text.Trim();
                //row[7] = ;
                //row[8] = ;
                row[9] = comboBox1.Text.Trim();
                row[10] = comboBox2.Text.Trim();
                row[11] = textBox8.Text.Trim();
                dataSet11.Tables["merch1"].Rows.Add(row);
            }
            else
            {
                DataRow row = dataSet11.Tables["merch1"].NewRow();
                row[0] = textBox1.Text.Trim();
                row[1] = textBox2.Text.Trim();
                row[2] = textBox3.Text.Trim();
                row[3] = textBox4.Text.Trim();
                row[4] = textBox5.Text.Trim();
                row[5] = textBox6.Text.Trim();
                row[6] = textBox7.Text.Trim();
                row[7] = dateTimePicker1.Value;
                row[8] = dateTimePicker2.Value;
                row[9] = comboBox1.Text.Trim();
                row[10] = comboBox2.Text.Trim();
                row[11] = textBox8.Text.Trim();
                dataSet11.Tables["merch1"].Rows.Add(row);
            }
            MessageBox.Show("插入数量成功");
        }

       

    }
}