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

namespace HRP.Wage
{
    public partial class frmWage : Form
    {
        public frmWage()
        {
            InitializeComponent();
        }
        SqlDataAdapter sda;
        DataSet ds;
        string strMonth;
        BaseClass.SqlClass sqlclass = new HRP.BaseClass.SqlClass();
        string strsql = "select * from tb_Wage ";
        private void frmWage_Load(object sender, EventArgs e)
        {
            this.Bind(strsql);
            if (DateTime.Now.Month.ToString().Length < 2)
            {
                strMonth = "0" + DateTime.Now.Month.ToString();
            }
            else
            {
                strMonth = DateTime.Now.Month.ToString();
            }
        }
        public void Bind(string strsql)
        {
            sda = sqlclass.sqlsda(strsql);
            ds = new DataSet();
            SqlCommandBuilder sb = new SqlCommandBuilder(sda);
            sda.Fill(ds, "tb_Wage");
            dgvWage.AutoGenerateColumns = false;
            this.dgvWage.DataSource = ds.Tables["tb_Wage"];
        }

        private void t1btnAll_Click(object sender, EventArgs e)
        {
            if (this.t1btnAll.Text == "当前月份")
            {
                strsql = "select * from tb_Wage where MonthWage='" + DateTime.Now.Year + "-" + strMonth + "'";
                this.t1btnAll.Text = "全部月份";
            }
            else
            {
                strsql = "select * from tb_Wage ";
                this.t1btnAll.Text = "当前月份";
            }
            this.Bind(strsql);
        }

        private void tlbtnEdit_Click(object sender, EventArgs e)
        {
            if (ds.Tables["tb_Wage"].GetChanges() != null)
            {
                sda.Update(ds, "tb_Wage");
                sda.Dispose();
            }
        }

        private void dgvWage_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                this.dgvWage["Deal", dgvWage.CurrentCell.RowIndex].Value = Convert.ToString(Convert.ToInt32(dgvWage[3, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[4, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[5, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[6, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[7, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[8, dgvWage.CurrentCell.RowIndex].Value));
                this.dgvWage["Deduct", dgvWage.CurrentCell.RowIndex].Value = Convert.ToString(Convert.ToInt32(dgvWage[9, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[10, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[11, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[12, dgvWage.CurrentCell.RowIndex].Value) + Convert.ToInt32(dgvWage[13, dgvWage.CurrentCell.RowIndex].Value));
                this.dgvWage["FactWage", dgvWage.CurrentCell.RowIndex].Value = Convert.ToString(Convert.ToInt32(dgvWage["Deal", dgvWage.CurrentCell.RowIndex].Value) - Convert.ToInt32(dgvWage["Deduct", dgvWage.CurrentCell.RowIndex].Value));
            }
            catch
            {
                MessageBox.Show("操作失败！");
            }
        }

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

        private void tlbtnPrint_Click(object sender, EventArgs e)
        {
            frmWagePrint frm_wageprint = new frmWagePrint();
            frm_wageprint.ds = this.ds;
            frm_wageprint.ShowDialog();
        }

        private void dgvWage_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {
            MessageBox.Show("输入信息错误！");
        }
    }
}