采购退货.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
    {
        public 采购退货()
        {
            InitializeComponent();
        }

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

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

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

        private void button3_Click(object sender, EventArgs e)
        {
            整单退货 yushuman = new 整单退货();
            yushuman.Show();
            this.Hide();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            添加退货商品 wangling = new 添加退货商品();
            wangling.Show();
        }
        private void button6_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void 采购退货_Load(object sender, EventArgs e)
        {

            wang selectm = new wang();
           DataSet ds= selectm.SelectMand("select *from NewTianjsp");
           this.dbgpaner.DataSource = ds.Tables[0].DefaultView;


        }

        private void button4_Click(object sender, EventArgs e)
        { 
            
            
            
            if (this.txt1.Text == "")
            {
                MessageBox.Show("请选择调出仓库","系统信息");
            }
            else
            {
                MessageBox.Show("添加一行记录成功！");
            }

            wang tianjiatuihou = new wang();
            tianjiatuihou.insertmand("insert into Zhengdantuihou values('"+this.txt1.Text+"','"+this.txt2.Text+"','"+this.comboBox1.Text+"','"+this.dateTimePicker1.Text+"',"+this.txt3.Text+","+this.txt4.Text+",'"+this.comboBox2.Text+"')");

           

        }

        private void button1_Click(object sender, EventArgs e)
        {
            销售客户查找 chazhao = new 销售客户查找();
            chazhao.Show();
        }

        private void button8_Click(object sender, EventArgs e)
        {
            wang zhengdantuihou = new wang();
            DataSet ds = zhengdantuihou.SelectMand("SELECT *, Zhengdantuihou.单号, Zhengdantuihou.供货商 ,Zhengdantuihou.仓库名称 , Zhengdantuihou.退货时间 ,Zhengdantuihou.应退金额 , Zhengdantuihou.实退金额 ,   Zhengdantuihou.经办人, Tuihousp.数量 , Tuihousp.备注 ,Tuihousp.退货单价, Tuihousp.颜色 ,Tuihousp.生产厂商, Tuihousp.单位, Tuihousp.规格型号, Tuihousp.商品名称,Tuihousp.商品编号 FROM Zhengdantuihou INNER JOIN  Tuihousp ON Zhengdantuihou.id = Tuihousp.id where 供货商='"+this.textBox2.Text+"'");
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;



        }
    }
}