详单查找.cs

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

CS
42
字号
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
    {
        private 整单退货 info;
        public 详单查找(整单退货 obj)
        {
            InitializeComponent();
            this.info = obj;
        }

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

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

        private void button1_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.txt1.Text + "'");
            this.info.dataGridView1.DataSource = ds.Tables[0].DefaultView;

            this.Hide();

        }
    }
}

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?