employeeinfomanage_form.cs

人力管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using BusinessLayer;
using Entity;
using System.Text.RegularExpressions;
using System.IO;
using System.Data.SqlClient;

namespace rsMange
{
    public partial class EmployeeInfoManage_Form : Form
    {

        Operate_Xinxibiao op_xinxi = new Operate_Xinxibiao();


        public EmployeeInfoManage_Form()
        {
            InitializeComponent();
        }

        private void EmployeeInfoManage_Form_Load(object sender, EventArgs e)
        {
           
            
            FillListView();
        }
        private void FillListView(DataTable dt)
        {
            this.listView1.Items.Clear();
            
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                for (int j = 1; j < dt.Columns.Count; j++)
                {
                    lv.SubItems.Add(dt.Rows[i][j].ToString());
                }
                if (i % 2 == 0)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                this.listView1.Items.Add(lv);
            }
        }
        private void FillListView()
        {
            this.listView1.Items.Clear();
            DataTable dt = op_xinxi.SelectXinxibiao();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                for (int j = 1; j < dt.Columns.Count; j++)
                {
                    lv.SubItems.Add(dt.Rows[i][j].ToString());
                }
                if (i % 2 == 0)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                this.listView1.Items.Add(lv);
            }
        }
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            string condition=this.txtSreach.Text.Trim();
             bool   yn=Regex.IsMatch(condition,@"[\u4e00-\u9fa5]+");
             if (yn)
             {
                 DataTable dt = op_xinxi.SelectByChina(condition);
                 FillListView(dt);
             }
             else
             {
                 DataTable dt = op_xinxi.SelectByNumber(condition);
                 FillListView(dt); 
             }
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {

        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            AddEmployee_Form form = new AddEmployee_Form();
            form.ShowDialog();
            DataTable dt = op_xinxi.SelectXinxibiao();
            FillListView(dt);

        }

        private void toolStripButton7_Click(object sender, EventArgs e)
        {
            Gjcx_Form f = new Gjcx_Form();
            f.ShowDialog();
        }

        private void toolStripButton10_Click(object sender, EventArgs e)
        {
            this.Close();
        }

      
        private void listView1_MouseUp(object sender, MouseEventArgs e)
        {
            if (listView1.GetItemAt(e.X, e.Y) != null)
            {
                this.rtbReamk.Text = listView1.SelectedItems[0].SubItems[16].Text;
                this.rtbResume.Text = listView1.SelectedItems[0].SubItems[15].Text;
                this.ptbPhoto.Image = Output(listView1.SelectedItems[0].SubItems[0].Text);
                return;
            }

            this.rtbReamk.Text = "";
            this.rtbResume.Text = "";
            this.ptbPhoto.ImageLocation = null;
        }

        private Image Output(string myimage)
        {

            SqlConnection sqlcon = new SqlConnection("server=.;database=w14yz1;uid=sa;pwd=;");
            sqlcon.Open();
            SqlCommand sqlda = new SqlCommand("select yuanzhao from xinxibiao where yuanid="+myimage, sqlcon);
            SqlDataReader reader = sqlda.ExecuteReader();
            reader.Read();
            System.IO.MemoryStream buf = new System.IO.MemoryStream((byte[])reader[0]);
            Image img = Image.FromStream(buf, true);
            reader.Close();
            return img;
           
           
        }
       

        private void ptbPhoto_MouseClick(object sender, MouseEventArgs e)
        {
            Image i = this.ptbPhoto.Image;
            Photo_Form f = new Photo_Form(i);
            f.ShowDialog();
        }

        private void toolStripButton11_Click(object sender, EventArgs e)
        {
            DialogResult dr = openFileDialog1.ShowDialog();
            string filename = openFileDialog1.FileName;
            if (dr == DialogResult.OK)
            {
                DataTable dt = op_xinxi.SelectXinxibiao();
                dt.ReadXml(filename);
                FillListView(dt);
            }
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            Print_Form f = new Print_Form();
            f.ShowDialog();
        }

        private void toolStripButton8_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count == 0)
            {
                return;
            }
            else
            {
                MessageBox.Show("确认将员工[" + this.listView1.SelectedItems[0].SubItems[1].Text + "]转为正式员工吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);

            }
        }

        private void toolStripButton9_Click(object sender, EventArgs e)
        {
            this.contextMenuStrip2.Show(this.toolStrip1, new Point(643, 63));
        }

        private void 打印选中的员工资料YToolStripMenuItem_Click(object sender, EventArgs e)
        {

            if (listView1.SelectedItems.Count == 0)
            {
                return;
            }
            else
            {
                MessageBox.Show("确认将员工[" + this.listView1.SelectedItems[0].SubItems[1].Text + "]离职吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);

            }
        }

        private void 打印全部的员工资料ZToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count == 0)
            {
                return;
            }
            else
            {
                MessageBox.Show("确认将员工[" + this.listView1.SelectedItems[0].SubItems[1].Text + "]退休吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);

            }
        }

        private void 复职ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count == 0)
            {
                return;
            }
            else
            {
                MessageBox.Show("确认将员工[" + this.listView1.SelectedItems[0].SubItems[1].Text + "]复职吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);

            }
        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            if (listView1.SelectedItems.Count == 0)
            {
                return;
            }
            else
            {
               DialogResult dr= MessageBox.Show("删除员工资料将会删除所有与员工有关的人事记录!(包括员工的照片)请确认是否真的要删除[" + this.listView1.SelectedItems[0].SubItems[1].Text + "]的记录?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
               if (dr == DialogResult.Yes)
               {
                   int c = op_xinxi.DeleteByID(listView1.SelectedItems[0].SubItems[0].Text);
                   if (c > 0)
                       FillListView();
                   else
                       MessageBox.Show("删除失败!请查看帮助","出错了");
               }
            }
        }

        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            this.contextMenuStrip3.Show(this.toolStrip1, new Point(400, 63));
        }

        private void 导出全部的记录ZToolStripMenuItem_Click(object sender, EventArgs e)
        {
           DialogResult dr= saveFileDialog1.ShowDialog();
           string filename = saveFileDialog1.FileName;
           if (dr == DialogResult.OK)
           {
               DataTable dt = op_xinxi.SelectXinxibiao();
               dt.WriteXml(filename);
               
           }
        }



        /// <summary>
        /// 将DataTable中的列名及数据导出到Excel表中
        /// </summary>
        /// <param name="tmpDataTable">要导出的DataTable</param>
        /// <param name="strFileName">Excel的保存路径及名称</param>
        //public static void DataTabletoExcel(System.Data.DataTable tmpDataTable, string strFileName)
        //{
        //    if (tmpDataTable == null)
        //        return;
        //    int rowNum = tmpDataTable.Rows.Count;
        //    int columnNum = tmpDataTable.Columns.Count;
        //    int rowIndex = 1;
        //    int columnIndex = 0;

        //    Excel.Application xlApp = new Excel.ApplicationClass();
        //    xlApp.DefaultFilePath = "";
        //    xlApp.DisplayAlerts = true;
        //    xlApp.SheetsInNewWorkbook = 1;
        //    Excel.Workbook xlBook = xlApp.Workbooks.Add(true);

        //    //将DataTable的列名导入Excel表第一行
        //    foreach (DataColumn dc in tmpDataTable.Columns)
        //    {
        //        columnIndex++;
        //        xlApp.Cells[rowIndex, columnIndex] = dc.ColumnName;
        //    }

        //    //将DataTable中的数据导入Excel中
        //    for (int i = 0; i < rowNum; i++)
        //    {
        //        rowIndex++;
        //        columnIndex = 0;
        //        for (int j = 0; j < columnNum; j++)
        //        {
        //            columnIndex++;
        //            xlApp.Cells[rowIndex, columnIndex] = tmpDataTable.Rows[i][j].ToString();
        //        }
        //    }
        //    xlBook.SaveCopyAs(strFileName);
        //}


    }
}