库存调拨.cs

用C#实现超市的管理

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Yewucheng;
namespace Myproject
{
    public partial class 库存调拨 : Form
    {
        wang tianjia = new wang();
        public 库存调拨()
        {
            InitializeComponent();
        }

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

        private void button1_Click(object sender, EventArgs e)
        {
            if (this.comboBox1.Text == "")
            {
                MessageBox.Show("请选择调出仓库","系统信息");
            }
            else
            {
                添加老商品 tianjialaoshangp = new 添加老商品();
                tianjialaoshangp.Show();
            }
        }

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

        private void but2_Click(object sender, EventArgs e)
        {
            高级查询 mer = new 高级查询();
            mer.Show();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (this.txt1.Text == "")
            {
                MessageBox.Show("请填写你的调拨单号");
            }
            else
            {
               
                tianjia.insertmand("insert into Cangkudiaoba values('" + this.txt1.Text + "','" + this.comboBox1.Text + "','" + this.comboBox2.Text + "','" + this.dateTimePicker1.Text + "','" + this.comboBox3.Text + "','" + this.txt2.Text + "')");
                MessageBox.Show("添加调拨记录行成功");
            }

        }

       

      

        private void 库存调拨_Load(object sender, EventArgs e)
        {
            
            
            DataSet ds= tianjia.SelectMand("select * from Cangkudiaoba");
           this.dbgname3.DataSource = ds.Tables[0].DefaultView;

           DataSet da = tianjia.SelectMand("select * from NewTianjsp");
           this.dbgname.DataSource = da.Tables[0].DefaultView;

           DataSet ma = tianjia.SelectMand("select * from NewTianjsp");
           this.dbgname4.DataSource = ma.Tables[0].DefaultView;


        }

     

        
    }
}