工资发放计算+ID选择输入

前面一直有遇到问题,工资没算对,在百分除的时候,用int型会变成0,所以在上面用了double型再导入比例

 

//工资发放
        private void button1_Click(object sender, EventArgs e)
        {
            SqlHelper sqlHelper = new SqlHelper();
            string YearmonthPresent = DateTime.Today.ToString("yyyy-MM");//当前年月
            bool button = sqlHelper.bPayoffBotton(YearmonthPresent);//本月是否发过工资
            if (button)//判断已发的话,提示消息
            {
                MessageBox.Show("本月工资已发");
            }
            else
            {
            DataTable dr = sqlHelper.workDays(YearmonthPresent);//根据年月与数据库中年月比对
            int c_workDays = Convert.ToInt32(dr.Rows[0].ItemArray[1]); ;//这个月应上班的天数
            int count = 0;//反馈信息
            UserInfo userinfo = new UserInfo();
            //遍历出datagridview表中的数据
            for (int i = 0; i < dataGridView1.Rows.Count; i++)//对datagridview中数据遍历
            {
                DataGridViewRow row = dataGridView1.Rows[i];
                gUserInfo.userNP.UserId = Convert.ToInt32(row.Cells["UserId"].Value);//id
                gUserInfo.userNP.BasicWage = Convert.ToDouble(row.Cells["BasicWage"].Value);//基本工资
                gUserInfo.userNP.PayOvertime = Convert.ToDouble(Convert.ToInt32(row.Cells["OvertimeNum"].Value) * 50);//加班工资(加班工资应该根据每个人月工资的比例来)
                gUserInfo.userNP.AmountPayable = gUserInfo.userNP.PayOvertime + gUserInfo.userNP.BasicWage;//应付金额=加班工资+基本工资
                
                //迟到次数
                int c_lateNum=0;
                int.TryParse(row.Cells["LateNum"].Value.ToString(), out c_lateNum);
                gUserInfo.userNP.NumberOfLate = c_lateNum;
                //请假次数
                int c_absentNum=0;
                int.TryParse(row.Cells["LeaveNum"].Value.ToString(), out c_absentNum);
                gUserInfo.userNP.Absenteeism = c_absentNum;
                //实际上班天数
                 int c_ondutyNum=0;
                 int.TryParse(row.Cells["OndutyDays"].Value.ToString(), out c_ondutyNum);
                //加班次数
                int c_overtimeNum=0;
                int.TryParse(row.Cells["OvertimeNum"].Value.ToString(), out c_overtimeNum);
                gUserInfo.userNP.OvertimeNum = c_overtimeNum;
                if (c_ondutyNum == 0)//如果上班天数为0的话,看他是否加班了,就算他加班的钱
                {
                    gUserInfo.userNP.NetPay = gUserInfo.userNP.PayOvertime - c_lateNum*10;//加班薪资-迟到薪资
                }
                else
                {
                     gUserInfo.userNP.Deduct = c_lateNum*10; //扣除薪资=迟到次数*10
                     double d_percent = Convert.ToDouble(c_ondutyNum) / Convert.ToDouble(c_workDays);
                     gUserInfo.userNP.NetPay = d_percent * gUserInfo.userNP.BasicWage - gUserInfo.userNP.Deduct + gUserInfo.userNP.PayOvertime; //实发工资=实际上班天数/当月应上班天数*基本工资-扣除薪资+加班薪资
                }
                bool bpayOff = sqlHelper.bPayoff(userinfo);
                if (bpayOff)
                {
                    count += 1;
                }
            }
            if (count==dataGridView1.Rows.Count)//对数据处理数量的判断
            {
                MessageBox.Show("录入成功");
            }
            else
            {
                MessageBox.Show("error");
                return;
            }
            }
        }

软件统计数据表

数据库

 

 //主界面设计
        private void Login_Load(object sender, EventArgs e)
        {
            //MessageBox.Show(System.DateTime.Now.ToString());
            SqlHelper sqlHelper = new SqlHelper();
            DataTable dt = sqlHelper.userIdName();
            this.comboBox1.DataSource = dt;//设置查询结果集为控件的数据源
            this.comboBox1.DisplayMember = dt.Columns[0].ColumnName.ToString();//显示相应列数据
            this.comboBox1.ValueMember = dt.Columns[0].ColumnName.ToString();//设置值
        }

//数据连接,显示数据库中的ID+用户名
        public DataTable userIdName()
        {
            string sql = string.Format("SELECT  CAST(UserId as varchar(50)) +' '+TrueName AS UserIdName FROM  Users");
            DataConn q = new DataConn(conStr);
            ArrayList paramlist = new ArrayList();
            IDataParameter[] param = (IDataParameter[])paramlist.ToArray(typeof(IDataParameter));
            return q.testDataTable(sql, param);
        }

private void button1_Click(object sender, EventArgs e)
        {
            //为了让用户记住自己ID,将其与姓名联系在一起,显示到combox控件中
            string c_checkId = this.comboBox1.Text.Substring(0, 4);//取得字符串中指定的几个字符,SubString(m, n) ;  m为需要截取的字符串索引位置， n为 截取长度
            //获得数据,验证用户输入
           // string c_checkId = textBox1.Text.Trim();
            string c_checkPwd = textBox2.Text.Trim();

            if (c_checkId == "" || c_checkPwd == "")
            {
                MessageBox.Show("请正确输入用户名或密码");
                return;
            }
            if (!ValidatorHelper.IsNumeric(c_checkId))
            {
                MessageBox.Show("用户名必须是数字");
                return;
            }

            try
            {
                //获得用户ID

                SqlHelper cs = new SqlHelper();
                bool it = cs.bIdPwd(c_checkId, c_checkPwd);
                gUserInfo.userNP = new UserInfo();
                gUserInfo.userNP.UserId = Convert.ToInt32(c_checkId);
                if (it)
                {
                    this.DialogResult = DialogResult.OK;
                }
                else
                {
                    MessageBox.Show("登录失败");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
           
            
        }