frmhortationedit.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.Wage
{
    public partial class frmHortationEdit : Form
    {
        public frmHortationEdit()
        {
            InitializeComponent();
        }
        Personnel.frmPactEmployee frm_pactemployee = new HRP.Personnel.frmPactEmployee();
        BaseClass.SqlClass sqlclass = new HRP.BaseClass.SqlClass();
        BaseClass.WageClass wageclass = new HRP.BaseClass.WageClass();
        public frmHortation frmhortation;
        public string strid;
        public string strtype,strtypeitem;
        private void frmHortationEdit_Load(object sender, EventArgs e)
        {
            if (strtype == "tb_Hortation")
            {
                strtypeitem = "tb_HortationItem";
            }
            else
            {
                strtypeitem = "tb_ChastisementItem";
            }
            this.cmbHortationItem.DataSource = sqlclass.SqlDaAd("select * from " + strtypeitem, strtypeitem).Tables[strtypeitem];
            this.cmbHortationItem.DisplayMember = "Name";
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            string strMonth = this.txtMonthWage.Text;
            string strSub = "";
            if (strMonth.Length == 7)
            {
                for (int i = 0; i < strMonth.Length; i++)
                {
                    if (i < 4)
                    {
                        strSub = this.txtMonthWage.Text.Substring(i, 1);
                        if (Char.IsNumber(strSub, 0) != true)
                        {
                            MessageBox.Show("年份书写错误！");
                            return;
                        }
                    }
                    if (i == 4)
                    {
                        strSub = this.txtMonthWage.Text.Substring(i, 1);
                        if (strSub != "-")
                        {
                            MessageBox.Show("年份后必须输入-");
                            return;
                        }
                    }
                    if (i > 4 && i < 7)
                    {
                        strSub = this.txtMonthWage.Text.Substring(i, 1);
                        if (Char.IsNumber(strSub, 0) != true)
                        {
                            MessageBox.Show("月份必须是数字！");
                            return;
                        }
                    }
                }

                if (Convert.ToInt32(this.txtMonthWage.Text.Substring(5, 2)) > 12)
                {
                    MessageBox.Show("月份书写错误！");
                    return;
                }
            }
            else
            {
                MessageBox.Show("格式书写错误！");
                return;
            }
            try
            {
                wageclass.HortationEdit(strtype, strid, this.txtMonthWage.Text, this.txtEmployeeID.Text, this.txtEmployeeName.Text, cmbHortationItem.Text, Convert.ToDouble(txtHortationNumber.Text), txtRemark.Text, Convert.ToDateTime(dtpHortationDate.Text));
                frmhortation.dgvHortation.DataSource = sqlclass.SqlDaAd("select * from " + strtype, strtype).Tables[strtype];
                this.Close();
            }
            catch
            {
                MessageBox.Show("操作失败！", "失败");
            }
        }

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