tjxm.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;
using cwgl.yjxm;
namespace cwgl.yjxm
{
    public partial class tjxm : Form
    {
      
      
        public string str;
        public string strp;
        public string strpp;
        public tjxm(string str,string strp,string strpp)
        {
            InitializeComponent();


            this.str = str;
            this.strp = strp;
            this.strpp = strpp;
            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
           
        }
        SqlConnection con = new SqlConnection(global::cwgl.Properties.Settings.Default.cwglCon);
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            string st1 = this.textBox1.Text;
            string st2 = this.textBox2.Text;
            if (this.textBox2.Text == "")
            {
                MessageBox.Show("请填写项目名称","错误");
                con.Close();
                return;
            }
            SqlCommand com00 = new SqlCommand("select * from v_xmsz", con);
            SqlDataReader dr = com00.ExecuteReader();
            while (dr.Read())
            {
                if (dr[2].ToString() == st2)
                {
                    MessageBox.Show("请勿添加相同的项目名字(如果为填入，请正确填写)", "错误 ");
                    this.textBox1.Text = "";
                    this.textBox2.Text = "";
                    this.Close();

                }
            }
            dr.Close();
            if (this.textBox2.Text != "")
            {
                switch (str)
                {
                    case "财政项目":
                        SqlCommand com10 = new SqlCommand("insert into v_xmsz(序列号,项目类型,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "' ,'" + st2 + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                        com10.ExecuteNonQuery();
                        break;
                    case "基础设施项目":
                    case "安置房建设项目":
                        SqlCommand com4 = new SqlCommand("insert into v_xmsz(序列号,分类,项目类型,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '" + st2 + "','" + str + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                        com4.ExecuteNonQuery();
                        break;

                    default:
                        if (strp == "财政项目")
                        {
                            SqlCommand com1 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '" + st2 + "','" + str + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                            com1.ExecuteNonQuery();
                            break;
                        }
                        else
                        {
                            break;
                        }
                }
                switch (strp)
                {
                    case "基础设施项目":
                    case "安置房建设项目":
                        SqlCommand com3 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,分类,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '" + st2 + "','" + strp + "','" + str + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                        com3.ExecuteNonQuery();
                        strpp = null;
                        break;
                    default:
                        if (strpp == "财政项目")
                        {
                            SqlCommand com6 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计,分类) values( '" + st1 + "', '" + st2 + "','" + strp + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','')", con);
                            com6.ExecuteNonQuery();
                            strpp = null;
                            break;
                        }
                        else
                        {
                            break;
                        }
                }
                switch (strpp)
                {
                    case "财政项目":
                        if (strp != "基础设施项目" || strp != "安置房建设项目")
                        {
                            SqlCommand com31 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,分类,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '" + str + "','" + strp + "','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                            com31.ExecuteNonQuery();
                        }
                        else if (strp == "基础设施项目" || strp == "安置房建设项目")
                        {
                            SqlCommand com32 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,分类,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '0','" + strp + "','" + str + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                            com32.ExecuteNonQuery();
                        }
                        break;
                    case "基础设施项目":
                    case "安置房建设项目":
                        SqlCommand com8 = new SqlCommand("insert into v_xmsz(序列号,项目名称,项目类型,分类,土地面积,土地单价, 已缴市级数, 市级统筹数, 开发区实收数, 项目借款, 借款转收入, 实际支付村组征地补偿支出, 拆迁支出, 土地报批支出, 土地出让支出, 工程成本支出, 其他支出 ,总合计,应缴市级数,开发区应收数,合计) values( '" + st1 + "', '" + st2 + "','" + strpp + "','" + strp + "','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')", con);
                        com8.ExecuteNonQuery();
                        break;
                    default: break;
                }
            
               this.Close();
            }
            xm_tree.tr.
            xm_tree.tr.TV_Refresh();

         }
       private void tjxm_Load(object sender, EventArgs e)
        {
           
        }
    }
}