querydepartmentform.cs

c# 人事工资管理系统平台,很好用嘎..你们看看参考

//文件名：QueryDepartmentForm.cs
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 Microsoft.Office.Interop.Excel;
using System.Reflection;
//using Microsoft.Office.Core;

namespace MyPersonnel
{
    public partial class QueryDepartmentForm : Form
    {
        public QueryDepartmentForm()
        {
            InitializeComponent();
        }
        private System.Data.DataTable MyQueryTable;
        public string MyCompany;
        private void QueryDepartmentForm_Load(object sender, EventArgs e)
        {
            //获取公司的部门信息            
            String MySQLConnectionString = global::MyPersonnel.Properties.Settings.Default.MyPersonnelConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            System.Data.DataTable MyDepartmentTable = new System.Data.DataTable();
            string MySQL = "Select 部门名称 From 公司部门";
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyDepartmentTable);
            foreach (DataRow MyRow in MyDepartmentTable.Rows)
            {
                this.部门ToolStripComboBox.Items.Add(MyRow[0].ToString());
            }
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        }
        private void 查询部门员工人事档案ToolStripButton_Click(object sender, EventArgs e)
        {
            String MySQLConnectionString = global::MyPersonnel.Properties.Settings.Default.MyPersonnelConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            MyQueryTable = new System.Data.DataTable();
            string MySQL = "Select 员工编号, 姓名, 性别, 出生年月, 身份证号码, 民族, 政治面貌, 婚姻状况, 文化程度, 专业, 毕业院校, 职称, 职务, 进入本单位时间, 合同服务年限, 基本工资, 银行帐号, 养老保险帐号, 医疗保险帐号, 住房基金帐号, 联系电话, 手机号码, 电子信箱, 家庭住址, 邮政编码, 籍贯  From 基本档案 WHERE (部门='" + this.部门ToolStripComboBox.Text + " ' AND 员工编号 NOT IN (SELECT 员工编号 FROM 离职管理))";
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyQueryTable);
            this.基本档案DataGridView.DataSource = MyQueryTable;
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        }

        private void 打印部门员工人事档案ToolStripButton_Click(object sender, EventArgs e)
        {
        //    if (MyQueryTable.Rows.Count < 1)
        //    {
        //        return;
        //    }
        //    //导出Excel表格数据文件
        //    ApplicationClass MyExcel;
        //    Workbooks MyWorkBooks;
        //    Workbook MyWorkBook;
        //    Worksheet MyWorkSheet;
        //    char MyColumns;
        //    Range MyRange;
        //    Object[,] MyData = new Object[5000, 30];
        //    int Count, i, j;
        //    MyExcel = new ApplicationClass();
        //    MyExcel.Visible = true;
        //    if (MyExcel == null)
        //    {
        //        MessageBox.Show("Excel程序无法启动！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        //        return;
        //    }
        //    MyWorkBooks = MyExcel.Workbooks;
        //    MyWorkBook = MyWorkBooks.Add(Missing.Value);
        //    MyWorkSheet = (Worksheet)MyWorkBook.Worksheets[1];
        //    MyColumns = (char)(MyQueryTable.Columns.Count + 64);
        //    MyRange = MyWorkSheet.get_Range("A5", MyColumns.ToString() + "5");
        //    Count = 0;
        //    foreach (DataColumn MyNewColumn in MyQueryTable.Columns)
        //    {
        //        MyData[0, Count] = MyNewColumn.ColumnName;
        //        Count = Count + 1;
        //    }
        //    j = 1;
        //    //输出数据库记录
        //    foreach (DataRow MyRow in MyQueryTable.Rows)
        //    {
        //        for (i = 0; i < MyQueryTable.Columns.Count; i++)
        //        {
        //            MyData[j, i] = MyRow[i].ToString();
        //            if (i == 3 || i==13)
        //            {
        //                MyData[j, i] = ((DateTime)MyRow[i]).ToShortDateString();
        //            }
        //        }
        //        j++;
        //    }
        //    MyRange = MyRange.get_Resize(MyQueryTable.Rows.Count + 1, MyQueryTable.Columns.Count);
        //    MyRange.Value2 = MyData;
        //    MyRange.EntireColumn.AutoFit();
        //    MyWorkSheet.Cells[1, 2] = this.MyCompany +this.部门ToolStripComboBox.Text+ "员工人事档案";
        //    MyWorkSheet.Cells[4, 1] = "制表日期：" + DateTime.Now.ToShortDateString();            
        }

       
    }
}