dataclass.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.OleDb;
using System.Data.SqlClient;

namespace renshiguanli
{
    public class dataClass
    { 
        private static string strConnecton = "Server=NUAA\\SQLEXPRESS;Integrated Security=SSPI;DataBase=aaa";
        private  SqlConnection thisConnection = new SqlConnection(strConnecton);
        private  string dp = department.dp;
        private int EmployeeID = salarycharge.empl;





        public void historydata(System.Windows.Forms.DataGridView dataGridView1)
        {
            string strTable = "dbo.tblSalary";
            SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM dbo.tblSalary", thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            DataSet thisDataSet = new DataSet();
            thisConnection.Open();
            thisAdapter.Fill(thisDataSet, strTable);
            int row = 0;
            int k = 0;
            for (; k < thisDataSet.Tables[strTable].Rows.Count; k++)
            {
                if (EmployeeID == (int)thisDataSet.Tables[strTable].Rows[k]["EmployeeID"])
                {
                    dataGridView1.Rows.Add();
                    dataGridView1["SalaryID", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["SalaryID"];
                    dataGridView1["EmployeeID", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["EmployeeID"];
                    dataGridView1["SalaryTime", row].Value = thisDataSet.Tables[strTable].Rows[k]["SalaryTime"].ToString();
                    dataGridView1["BasicSalary", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["BasicSalary"];
                    dataGridView1["OvertimeSalary", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["BasicSalary"];
                    dataGridView1["AbsenceSalary", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["AbsenceSalary"];
                    dataGridView1["OtherSalary", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["OtherSalary"];
                    row++;
                }
            }
            thisConnection.Close();
        }





        public void dpttotal(System.Windows.Forms.DataGridView dataGridView1)
        {
            string strTable = "dbo.tblEmployee";
            SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM dbo.tblEmployee", thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            DataSet thisDataSet = new DataSet();
            thisConnection.Open();
            thisAdapter.Fill(thisDataSet, strTable);

            string strTable1 = "dbo.tblDepartment";
            SqlDataAdapter thisAdapter1 = new SqlDataAdapter("SELECT * FROM dbo.tblDepartment", thisConnection);
            SqlCommandBuilder thisBuilder1 = new SqlCommandBuilder(thisAdapter1);
            DataSet thisDataSet1 = new DataSet();
            thisAdapter1.Fill(thisDataSet1, strTable1);


            int deptId = -1;
            if (department.dp != "")
                for (int k = 0 /*, f = 0*/; k < thisDataSet1.Tables[strTable1].Rows.Count /*&& f == 0*/; k++)
                {
                    if (department.dp == thisDataSet1.Tables[strTable1].Rows[k]["DeptName"].ToString())
                    {
                        //f = 1;
                        deptId = (int)thisDataSet1.Tables[strTable1].Rows[k]["DeptID"];
                    }
                }
            int row = 0;
            dataGridView1.Rows.Clear();
            if (department.dp == "")
                MessageBox.Show("请输入查询条件！");
            else
            {
                for (int k = 0; k < thisDataSet.Tables[strTable].Rows.Count; k++)
                {
                    if (deptId == (int)thisDataSet.Tables["dbo.tblEmployee"].Rows[k]["DeptID"])
                    {
                        dataGridView1.Rows.Add();
                        dataGridView1["EmployeeID", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["EmployeeID"];
                        dataGridView1["name", row].Value = thisDataSet.Tables[strTable].Rows[k]["Name"];
                        dataGridView1["BasicSalary", row].Value = (int)thisDataSet.Tables[strTable].Rows[k]["BasicSalary"];
                        row++;
                    }
                }
            }
                thisConnection.Close();
        }





        public void fresh(System.Windows.Forms.DataGridView dataGridView1)
        {
            string strTable = "dbo.tblEmployee";
            SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM dbo.tblEmployee", thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            DataSet thisDataSet = new DataSet();
            thisConnection.Open();
            thisAdapter.Fill(thisDataSet, strTable);
           
            dataGridView1.Rows.Clear();

            for (int k = 0; k < thisDataSet.Tables[strTable].Rows.Count; k++)
            {
                    dataGridView1.Rows.Add();
                    dataGridView1["EmployeeID", k].Value = (int)thisDataSet.Tables[strTable].Rows[k]["EmployeeID"];
                    dataGridView1["name", k].Value = thisDataSet.Tables[strTable].Rows[k]["Name"];
                    dataGridView1["BasicSalary", k].Value = (int)thisDataSet.Tables[strTable].Rows[k]["BasicSalary"];
            }
            thisConnection.Close();
        }


        public int presalary()
        {
            int BS=0;
            string strTable = "dbo.tblEmployee";
            SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM dbo.tblEmployee", thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            DataSet thisDataSet = new DataSet();
            thisConnection.Open();
            thisAdapter.Fill(thisDataSet, strTable);
            int k = 0;
            //dataGridView1.Rows.Clear();
            for (; k < thisDataSet.Tables[strTable].Rows.Count; )
            {
                if (EmployeeID == (int)thisDataSet.Tables["dbo.tblEmployee"].Rows[k]["EmployeeID"])
                    BS = (int)thisDataSet.Tables[strTable].Rows[k]["BasicSalary"];
                k++;
            }
            
            thisConnection.Close();
            return BS;
        }





        public void BSmodify(string text)
        {
            string strTable = "dbo.tblEmployee";
            SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM dbo.tblEmployee", thisConnection);
            SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
            DataSet thisDataSet = new DataSet();
            thisConnection.Open();
            thisAdapter.Fill(thisDataSet, strTable);
            //dataGridView1.Rows.Clear();
            for (int k = 0; k < thisDataSet.Tables[strTable].Rows.Count;k++)
            {
                if (EmployeeID == (int)thisDataSet.Tables["dbo.tblEmployee"].Rows[k]["EmployeeID"])
                thisDataSet.Tables[strTable].Rows[k]["BasicSalary"]=text;
            }
            thisAdapter.Update(thisDataSet,strTable);
            thisConnection.Close();
        }
    }
}