销售单据查找.cs

来自「用C#实现超市的管理」· CS 代码 · 共 61 行

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)
        {



        }

        private void 销售单据查找_Load(object sender, EventArgs e)
        {
          wang xiaoshouchazhao=new wang();
          DataSet ds= xiaoshouchazhao.SelectMand("SELECT SouXuanshanp.商品名称,SouXuanshanp.规格型号,SouXuanshanp.商品编号,SouXuanshanp.单位,SouXuanshanp.生产厂商,SouXuanshanp.颜色,SouXuanshanp.当前库存, SouXuanshanp.备注, SouXuanshanp.上次进价,SouXuanshanp.参考进价, SouXuanshanp.数量, XiaoShouShangPing.备注,XiaoShouShangPing.原始单号, XiaoShouShangPing.经办人,XiaoShouShangPing.实付金额, XiaoShouShangPing.应付金额,XiaoShouShangPing.销售日期, XiaoShouShangPing.出货仓库,XiaoShouShangPing.客户名称 FROM SouXuanshanp CROSS JOIN XiaoShouShangPing");
          this.dbgname3.DataSource = ds.Tables[0].DefaultView;

        }

        private void button2_Click(object sender, EventArgs e)
        {
           

                if (this.txt1.Text != "")
                {
                    wang xiaoshouchazhao = new wang();
                    DataSet ds = xiaoshouchazhao.SelectMand("SELECT SouXuanshanp.商品名称,SouXuanshanp.规格型号,SouXuanshanp.商品编号,SouXuanshanp.单位,SouXuanshanp.生产厂商,SouXuanshanp.颜色,SouXuanshanp.当前库存, SouXuanshanp.备注, SouXuanshanp.上次进价,SouXuanshanp.参考进价, SouXuanshanp.数量, XiaoShouShangPing.备注,XiaoShouShangPing.原始单号, XiaoShouShangPing.经办人,XiaoShouShangPing.实付金额, XiaoShouShangPing.应付金额,XiaoShouShangPing.销售日期, XiaoShouShangPing.出货仓库,XiaoShouShangPing.客户名称 FROM SouXuanshanp CROSS JOIN XiaoShouShangPing where 原始单号='" + this.txt1.Text + "'");
                    this.dbgname3.DataSource = ds.Tables[0].DefaultView;
                }
                else
                {

                    MessageBox.Show("请输入你的原始单号进行查询");


                }
           
        }

       
    }
}