ComputeForm.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//文件名：ComputeForm.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 ComputeForm : Form
    {
        public ComputeForm()
        {
            InitializeComponent();
        }
        public string MyCompany;
        private void ComputeForm_Load(object sender, EventArgs e)
        {
            String MySQLConnectionString = global::MyPersonnel.Properties.Settings.Default.MyPersonnelConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();
            System.Data.DataTable MyQueryTable = new System.Data.DataTable();
            string MySQL = "Select * From 在职员工视图 WHERE 员工编号 NOT IN (SELECT 员工编号 FROM 工资核算表)";
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyQueryTable);
            foreach (DataRow MyRow in MyQueryTable.Rows)
            {
                string My自编号 = this.GetMyID();
                string My员工编号 = MyRow[1].ToString();
                string My员工姓名 = MyRow[3].ToString();
                float My基本工资 =(float)Convert.ToDouble(MyRow[17].ToString());
                MySQL = "INSERT INTO 工资核算表([自编号] ,[员工编号], [员工姓名], [基本工资]) VALUES (@自编号 ,@员工编号, @员工姓名, @基本工资)";
                MyConnection = new SqlConnection(MySQLConnectionString);
                MyConnection.Open();
                SqlCommand MyCommand = MyConnection.CreateCommand();
                MyCommand.CommandText = MySQL;
                MyCommand.Parameters.Add(new SqlParameter("@自编号", SqlDbType.VarChar));
                MyCommand.Parameters.Add(new SqlParameter("@员工编号", SqlDbType.VarChar));
                MyCommand.Parameters.Add(new SqlParameter("@员工姓名", SqlDbType.VarChar));
                MyCommand.Parameters.Add(new SqlParameter("@基本工资", SqlDbType.Float));

                MyCommand.Parameters["@自编号"].Value = My自编号;
                MyCommand.Parameters["@员工编号"].Value = My员工编号;
                MyCommand.Parameters["@员工姓名"].Value = My员工姓名;
                MyCommand.Parameters["@基本工资"].Value = My基本工资;
                MyCommand.ExecuteNonQuery();
            }       
            //获取公司的部门信息            
            System.Data.DataTable MyDepartmentTable = new System.Data.DataTable();
            MySQL = "Select 部门名称 From 公司部门";
            MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyDepartmentTable);
            foreach (DataRow MyRow in MyDepartmentTable.Rows)