frmpactmanage.cs

基于SQLSERVER C#2.0的企业ERP管理系统

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

namespace HRP.Personnel
{
    public partial class frmPactManage : Form
    {
        public frmPactManage()
        {
            InitializeComponent();
        }

        BaseClass.SqlClass sqlclass = new HRP.BaseClass.SqlClass();
        BaseClass.PersonnelClass personnelclass = new HRP.BaseClass.PersonnelClass();
        private void frmPactManage_Load(object sender, EventArgs e)
        {
            this.Bind();
        }
        public void Bind()
        {
            this.dgvPactManage.DataSource = sqlclass.SqlDaAd("select * from tb_Pact", "tb_Pact").Tables["tb_Pact"];
        }

        private void tlbtnAdd_Click(object sender, EventArgs e)
        {
            frmPactAdd frm_pactadd = new frmPactAdd();
            frm_pactadd.frmpactmanage = this;
            frm_pactadd.ShowDialog();
        }

        private void tlbtnEdit_Click(object sender, EventArgs e)
        {
            string strEmployeeID = Convert.ToString(dgvPactManage[0, dgvPactManage.CurrentCell.RowIndex].Value);
            if (strEmployeeID != "")
            {
                frmPactEdit frm_pactedit = new frmPactEdit();
                frm_pactedit.txtEmployeeID.Text = strEmployeeID;
                frm_pactedit.txtEmployeeName.Text = Convert.ToString(dgvPactManage[1, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtPactID.Text = Convert.ToString(dgvPactManage[2, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.cbbPactType.Text = Convert.ToString(dgvPactManage[3, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.dtpPactStartTime.Text = Convert.ToString(dgvPactManage[4, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.dtpPactEndTime.Text = Convert.ToString(dgvPactManage[5, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtProbation.Text = Convert.ToString(dgvPactManage[6, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtRemark.Text = Convert.ToString(dgvPactManage[7, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.strState = Convert.ToString(dgvPactManage[8, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.frmpactmanage = this;
                frm_pactedit.ShowDialog();
            }
        }

        private void tlbtnDelete_Click(object sender, EventArgs e)
        {
            string strPactID = Convert.ToString(dgvPactManage[2, dgvPactManage.CurrentCell.RowIndex].Value);
            if (strPactID != "")
            {
                sqlclass.sqlcmd("delete from tb_Pact where PactID="+strPactID);
                this.Bind();
            }
        }

        private void tlbtnAll_Click(object sender, EventArgs e)
        {
            this.Bind();
        }

        private void tlbtnSearch_Click(object sender, EventArgs e)
        {
            string strData="";
            switch(this.tlcmbData.Text)
            {
                case "合同编号":
                    strData = "PactID";
                    break;
                case "员工编号":
                    strData = "EmployeeID";
                    break;
                case "员工姓名":
                    strData = "EmployeeName";
                    break;
                default:
                    MessageBox.Show("请选择一个要查询的字段！");
                    return;
            }
            if(tltxtKeyword.Text=="")
            {
                MessageBox.Show("请输入关键字！");
            }
            this.dgvPactManage.DataSource=personnelclass.pactSearch(strData,this.tltxtKeyword.Text).Tables["tb_Pact"];
        }

        private void tlbtnAtTerm_Click(object sender, EventArgs e)
        {
            string strPactID = Convert.ToString(dgvPactManage[2, dgvPactManage.CurrentCell.RowIndex].Value);
            sqlclass.sqlcmd("update  tb_Pact set State='到期' where PactID="+strPactID);
            this.Bind();
        }

        private void tlbtnGoOn_Click(object sender, EventArgs e)
        {
            string strEmployeeID = Convert.ToString(dgvPactManage[0, dgvPactManage.CurrentCell.RowIndex].Value);
            if (strEmployeeID != "")
            {
                frmPactEdit frm_pactedit = new frmPactEdit();
                frm_pactedit.txtEmployeeID.Text = strEmployeeID;
                frm_pactedit.txtEmployeeName.Text = Convert.ToString(dgvPactManage[1, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtPactID.Text = Convert.ToString(dgvPactManage[2, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.cbbPactType.Text = Convert.ToString(dgvPactManage[3, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.dtpPactStartTime.Text = Convert.ToString(dgvPactManage[4, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.dtpPactEndTime.Text = Convert.ToString(dgvPactManage[5, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtProbation.Text = Convert.ToString(dgvPactManage[6, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.txtRemark.Text = Convert.ToString(dgvPactManage[7, dgvPactManage.CurrentCell.RowIndex].Value);
                frm_pactedit.strState = "续约";
                frm_pactedit.frmpactmanage = this;
                frm_pactedit.ShowDialog();
            }
        }
    }
}