采购单据的查询.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.Hide();
        }

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

        private void 采购单据的查询_Load(object sender, EventArgs e)
        {

            wang caigoudanjucz = new wang();
            DataSet ds = caigoudanjucz.SelectMand("SELECT NewTianjsp.商品名称, NewTianjsp.单位,NewTianjsp.规格型号,NewTianjsp.颜色,NewTianjsp.单价, NewTianjsp.数量 ,NewTianjsp.总金额 ,NewTianjsp.商品编号,NewTianjsp.生产厂商 ,Jinhoushping.单号,Jinhoushping.供货商 ,Jinhoushping.仓库名称,Jinhoushping.进货时间,Jinhoushping.应付金额,Jinhoushping.实收金额 ,Jinhoushping.经办人,Jinhoushping.原始单号 FROM NewTianjsp CROSS JOIN Jinhoushping");
            this.dbgname3.DataSource = ds.Tables[0].DefaultView;


        }

        private void button2_Click(object sender, EventArgs e)
        {
            wang caigoudanjucz = new wang();
            DataSet ds = caigoudanjucz.SelectMand("SELECT  NewTianjsp.商品名称, NewTianjsp.单位,NewTianjsp.规格型号,NewTianjsp.颜色,NewTianjsp.单价, NewTianjsp.数量 ,NewTianjsp.总金额 ,NewTianjsp.商品编号,NewTianjsp.生产厂商 ,Jinhoushping.单号,Jinhoushping.供货商 ,Jinhoushping.仓库名称,Jinhoushping.进货时间,Jinhoushping.应付金额,Jinhoushping.实收金额 ,Jinhoushping.经办人,Jinhoushping.原始单号 FROM NewTianjsp CROSS JOIN Jinhoushping where 商品名称='"+this.txt1.Text+"'");
            this.dbgname3.DataSource = ds.Tables[0].DefaultView;

        }
    }
}