整单退货.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 button9_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            详单查找 henfei = new 详单查找(this);
            henfei.Show();
        }

        private void 整单退货_Load(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");
            
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (this.txt1.Text == "")
            {
                MessageBox.Show("你的单号没有输入，请输入单号。。");
            }
            else
            {

               
                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.txt1.Text + "'");

                this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

            }
        }

     
    }
}