frmselectmoney.cs

来自「关于医院进销存的系统」· CS 代码 · 共 56 行

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

namespace YYJXC
{
    public partial class frmSelectMoney : Form
    {
        public frmSelectMoney()
        {
            InitializeComponent();
        }
        DataSet ds = new DataSet();
        private void frmSelectMoney_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            SqlConnection Conn = new SqlConnection("server=" + CLoad.ReadServer() + ";pwd=" + CLoad.ReadPwd() + ";uid=sa;database=YYJXC");
            Conn.Open();
            SqlCommand Comm = new SqlCommand("select 客户名称 from tb_client", Conn);
            SqlDataReader dr = Comm.ExecuteReader();
            while (dr.Read())
            {
                comboBox1.Items.Add(dr.GetString(0));
            }
            Conn.Close();
            SqlDataAdapter da = new SqlDataAdapter("select * from tb_client_arrerage", Conn);
            da.Fill(ds);
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds.Tables[0]);
            dv.RowFilter = "客户名称 ='" + comboBox1.Text.Trim() + "' and 摘要 like '*收款：收*'";
            dv.Sort = "日期,时间";
            dataGridView1.DataSource = dv;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds.Tables[0]);
            dv.RowFilter = "客户名称 ='" + comboBox1.Text.Trim() + "' and 摘要 like '*收款：收*' and 日期 >= '" + dateTimePicker1.Value + "' and 日期<='" + dateTimePicker2.Value + "'";
            dv.Sort = "日期,时间";
            dataGridView1.DataSource = dv;
        }

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