enterstock.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 EnterStock : Form
    {
        //判断编号是否唯一
        private bool temp = false;
        public EnterStock()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string temp_sql = "select * from  stock where stockId='"+textBox1.Text.Trim()+"'";
            //判断进货编号是否唯一
            temp=DataBaseConnection.find(temp_sql);
            if (temp==true)
            {
                MessageBox.Show("进货编号不唯一,请重新输入");
                return;
            }

           // MessageBox.Show(dateTimePicker1.Value.ToUniversalTime().ToString());
           // return;

            string sql = "insert into stock values('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','";
            sql += textBox4.Text.Trim() + "','" + textBox5.Text.Trim() + "','" + dateTimePicker1.Value.ToUniversalTime() + "','" + textBox6.Text.Trim() + "','" + comboBox1.Text.Trim() + "','";
            sql += textBox7.Text.Trim() + "')";
            //插入数据
            //DataBaseConnection.insert(sql);
            SqlConnection con1 = DataBaseConnection.connection();
            SqlCommand com = new SqlCommand(sql, con1);
            con1.Open();
            com.ExecuteNonQuery();

            //向DataGrid1添加数据
            DataRow row = dataSet11.Tables["stock1"].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]= dateTimePicker1.Value.ToLongDateString();
            row[6]= textBox6.Text.Trim();
            row[7]= comboBox1.Text.Trim();
            row[8]=textBox7.Text.Trim() ;
            dataSet11.Tables["stock1"].Rows.Add(row);
            MessageBox.Show("添加进货表成功");
        }
    }
}