社会保障管理系统

用c#和sql数据库做的课设，涉及了reportViewer控件的使用和一些sql的复杂查询，有兴趣的朋友可以下载看看

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

namespace SsmanageSystem
{
    public partial class addEinsurance : Form
    {
        SqlTools sql = new SqlTools（）;
        public addEinsurance（）
        {
            InitializeComponent（）;
        }

        private void button1_Click（object sender EventArgs e）
        {
            if （textBox1.Text.Trim（） == ““）
            {
                toolStripStatusLabel1.Text = “用户编号不能为空！“;
                textBox1.Focus（）;
            }            
            else
            {
                if （sql.UserInfoCheck（textBox1.Text.Trim（）））
                {
                    if （sql.AddUIInfo（textBox1.Text.Trim（） “1“ dateTimePicker1.Value dateTimePicker2.Value Convert.ToInt32（textBox3.Text.Trim（）） Convert.ToInt32（textBox4.Text.Trim（）） textBox5.Text textBox6.Text textBox7.Text））
                    {
                        toolStripStatusLabel1.ForeColor = Color.Black;
                        toolStripStatusLabel1.Text = “添加成功！“;
                        DataTable ds = new DataTable（）;
                        sql.EinsurancePrint（ds）;
                        Einsurance.frm.DataGridView1.DataSource = Einsurance.frm.BindingSource1;
                        Einsurance.frm.BindingSource1.DataSource = ds;
                    }
                    else
                    {
                        toolStripStatusLabel1.Text = “添加失败！“;
                        toolStripStatusLabel1.ForeColor = Color.Red;
                    }
                }
                else
                {
                    toolStripStatusLabel1.Text = “该用户不存在，请先添加用户！“;
                    toolStripStatusLabel1.ForeColor = Color.Red;
                }
            }
        }

        private void addEinsurance_Load（object sender EventArgs e）
        {
                      
        }

        private void button2_Click（object sender EventArgs e）
        {
            this.Close（）;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       2259  2016-06-26 15:35  sql数据库课设\SsmanageSystem\SsmanageSystem\addEinsurance.cs

     文件      14522  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addEinsurance.Designer.cs

     文件       6190  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addEinsurance.resx

     文件       2066  2016-06-23 11:52  sql数据库课设\SsmanageSystem\SsmanageSystem\addInsuranceInfo.cs

     文件       8153  2016-06-23 11:52  sql数据库课设\SsmanageSystem\SsmanageSystem\addInsuranceInfo.Designer.cs

     文件       6220  2016-06-23 11:52  sql数据库课设\SsmanageSystem\SsmanageSystem\addInsuranceInfo.resx

     文件       2259  2016-06-26 15:40  sql数据库课设\SsmanageSystem\SsmanageSystem\addMinsurance.cs

     文件      14522  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addMinsurance.Designer.cs

     文件       6190  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addMinsurance.resx

     文件       2259  2016-06-26 15:40  sql数据库课设\SsmanageSystem\SsmanageSystem\addUinsurance.cs

     文件      14522  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addUinsurance.Designer.cs

     文件       6190  2016-06-26 15:14  sql数据库课设\SsmanageSystem\SsmanageSystem\addUinsurance.resx

     文件       2235  2016-06-23 11:51  sql数据库课设\SsmanageSystem\SsmanageSystem\AddUserInfo.cs

     文件      12887  2016-06-23 11:51  sql数据库课设\SsmanageSystem\SsmanageSystem\AddUserInfo.Designer.cs

     文件       6393  2016-06-23 11:51  sql数据库课设\SsmanageSystem\SsmanageSystem\AddUserInfo.resx

     文件        530  2016-06-26 10:42  sql数据库课设\SsmanageSystem\SsmanageSystem\App.config

     文件     208384  2016-07-10 13:50  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.exe

     文件        530  2016-06-26 10:42  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.exe.config

     文件     529920  2016-07-10 13:50  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.pdb

     文件      22984  2016-07-13 10:10  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.vshost.exe

     文件        530  2016-06-26 10:42  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.vshost.exe.config

     文件        490  2012-06-06 02:06  sql数据库课设\SsmanageSystem\SsmanageSystem\bin\Debug\SsmanageSystem.vshost.exe.manifest

     文件       2372  2016-06-23 11:17  sql数据库课设\SsmanageSystem\SsmanageSystem\changeUserInfo.cs

     文件      11426  2016-06-23 11:17  sql数据库课设\SsmanageSystem\SsmanageSystem\changeUserInfo.Designer.cs

     文件       6017  2016-06-23 11:17  sql数据库课设\SsmanageSystem\SsmanageSystem\changeUserInfo.resx

     文件      69489  2016-07-08 16:57  sql数据库课设\SsmanageSystem\SsmanageSystem\DataSet1.Designer.cs

     文件        361  2016-07-08 16:57  sql数据库课设\SsmanageSystem\SsmanageSystem\DataSet1.xsc

     文件       7047  2016-06-26 14:20  sql数据库课设\SsmanageSystem\SsmanageSystem\DataSet1.xsd

     文件          3  2016-07-08 16:57  sql数据库课设\SsmanageSystem\SsmanageSystem\DataSet1.xss

     文件       1660  2016-06-26 15:12  sql数据库课设\SsmanageSystem\SsmanageSystem\delete.cs

............此处省略151个文件信息