cx.cs

实习时候做的一个c#的财务管理系统

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 cwgl
{
    public partial class cx : Form
    {
        public cx()
        {
            InitializeComponent();
        }

        SqlConnection con = new SqlConnection(global::cwgl.Properties.Settings.Default.cwglCon);

        
        private void button1_Click(object sender, EventArgs e)
        {   string lx = groupBox1.Text.ToString().Trim();
            string xmmc = this.textBox1.Text;
            if(lx == "项目收支查询"){
                try
                {
                    con.Open();
                    if (xmmc != "")
                    {
                        SqlDataAdapter dap = new SqlDataAdapter("SELECT xm AS 项目名称, mj AS 土地面积,dj AS 土地单价, jsjs AS 应缴市级数, yjsjs AS 已缴市级数, wjsjs AS 未缴市级数,sjtc AS 市级统筹数, kfxys AS 开发区应收数, kfqss AS 开发区实收数,kfqws AS 开发区未收数, xmjk AS 项目借款, jkzsr AS 借款转收入, hj AS 合计,zdzc AS 实际支付村组征地补偿支出, cqzc AS 拆迁支出, tdbp AS 土地报批支出,tdcr AS 土地出让支出, cbzc AS 工程成本支出, qtzc AS 其他支出, zhj AS 总合计,jy AS 结余 FROM xmsz where  xm like '%" + xmmc + "%'", con);

                        DataSet ds = new DataSet();
                        dap.Fill(ds);
                        dataGridView1.DataSource = ds.Tables[0].DefaultView;
                       
                    }
                    else
                    {
                        MessageBox.Show("请输入查询内容！", "错误");
                    }
                }
                catch (SqlException e1)
                {
                    MessageBox.Show("所填项目不存在！", "错误");
                }
                finally
                {
                    con.Close();
                }
            }

        }

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

        private void button3_Click(object sender, EventArgs e)
        {
            string lx = groupBox1.Text.ToString().Trim();
            string xmmc = this.textBox1.Text;
            if (lx == "项目收支查询")
            {
                try
                {
             
                    if(xmmc!= "")
                    {
                    con.Open();
                    SqlDataAdapter dap = new SqlDataAdapter("SELECT xm AS 项目名称, mj AS 土地面积,dj AS 土地单价, jsjs AS 应缴市级数, yjsjs AS 已缴市级数, wjsjs AS 未缴市级数,sjtc AS 市级统筹数, kfxys AS 开发区应收数, kfqss AS 开发区实收数,kfqws AS 开发区未收数, xmjk AS 项目借款, jkzsr AS 借款转收入, hj AS 合计,zdzc AS 实际支付村组征地补偿支出, cqzc AS 拆迁支出, tdbp AS 土地报批支出,tdcr AS 土地出让支出, cbzc AS 工程成本支出, qtzc AS 其他支出, zhj AS 总合计,jy AS 结余 FROM xmsz where  xm='" + xmmc + "'", con);
                    DataSet ds = new DataSet();
                    dap.Fill(ds);
                    dataGridView1.DataSource = ds.Tables[0].DefaultView;
                   
                    }
                    else 
                    {
                        MessageBox.Show("请输入查询内容！", "错误");
                    }
                }
                catch (SqlException e1)
                {
                    MessageBox.Show("所填项目不存在！", "错误");
                }
                finally
                {
                    con.Close();
                }
            }
        }

       
    }
}