frmdayreport.cs

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

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 frmDayReport : Form
    {
        public frmDayReport()
        {
            InitializeComponent();
        }
        private DataSet ds = new DataSet();
        private DataView dv = null;
        private void frmDayReport_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            SqlConnection Conn = new SqlConnection("server=" + CLoad.ReadServer() + ";pwd=" + CLoad.ReadPwd() + ";uid=sa;database=YYJXC");
            SqlDataAdapter da = new SqlDataAdapter("select 销售单据号,品种数,数量,金额,折扣,税率,应收,实收,未收,收款方式,经手人,日期 from tb_sell_main", Conn);
            da.Fill(ds, "tb_sell_main");
            dv = new DataView(ds.Tables["tb_sell_main"]);
            dv.RowFilter = "日期='" + dateTimePicker1.Value.ToShortDateString() + "'";
            dataGridView1.DataSource = dv;
            dataGridView1.Columns[11].Visible = false;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            dv.RowFilter = "日期='" + dateTimePicker1.Value.ToShortDateString() + "'";
            dataGridView1.DataSource = dv;
            dataGridView1.Columns[11].Visible = false;
        }

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