MedicineJXC/采购登记查询.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace MedicineJXC
{
    public partial class 采购登记查询 : Form
    {
        public 采购登记查询()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if ((Convert.ToDateTime(dateTimePicker1开始日期.Text)) > (Convert.ToDateTime(dateTimePicker2结束日期.Text)))
            {
                MessageBox.Show("开始日期不能大于结束日期!", "提示");
                errorProvider1.SetError(dateTimePicker1开始日期, "提示");
                dateTimePicker1开始日期.Focus();
                return;

            }
            else
            {

                errorProvider1.SetError(dateTimePicker1开始日期, "");


            }

            Maticsoft.BLL.sqlall bll = new Maticsoft.BLL.sqlall();
            DataSet ds = bll.GetList("  select * from pj_wz_rk  where  between  # " + this.dateTimePicker1开始日期.Value + "#   and   # " + this.dateTimePicker2结束日期.Value + "#");
            dataGridView1.DataSource = ds.Tables[0];
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Maticsoft.BLL.pj_wz_rk bll = new Maticsoft.BLL.pj_wz_rk();
            DataSet ds = bll.GetList("药品编号= '" + txt药品编号.Text.ToString() + "'");
            dataGridView1.DataSource = ds.Tables[0];

        }

        private void button3_Click(object sender, EventArgs e)
        {
            Maticsoft.BLL.pj_wz_rk bll = new Maticsoft.BLL.pj_wz_rk();
            DataSet ds = bll.GetList("客户编号 = '" + txt客户编号.Text.ToString() + "'");
            dataGridView1.DataSource = ds.Tables[0];
        }

        private void button4_Click(object sender, EventArgs e)
        {
            Maticsoft.BLL.pj_wz_rk bll = new Maticsoft.BLL.pj_wz_rk();
            DataSet ds = bll.GetList("产地 = '" + txt产地.Text.ToString() + "'");