/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_staffsalary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_staffsalary set "); strSql.Append("Sal_absenteeismDay=@Sal_absenteeismDay,"); strSql.Append("sal_bonusM=@sal_bonusM,"); strSql.Append("sal_describe=@sal_describe,"); strSql.Append("sal_deductM=@sal_deductM,"); strSql.Append("sal_totalM=@sal_totalM,"); strSql.Append("sal_incrementM=@sal_incrementM,"); strSql.Append("sal_month=@sal_month,"); strSql.Append("sal_year=@sal_year,"); strSql.Append("sal_date=@sal_date,"); strSql.Append("sal_sta_id=@sal_sta_id,"); strSql.Append("Sal_leaveDay=@Sal_leaveDay"); strSql.Append(" where sal_ID=@sal_ID"); MySqlParameter[] parameters = { new MySqlParameter("@Sal_absenteeismDay", MySqlDbType.Int32, 10), new MySqlParameter("@sal_bonusM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_describe", MySqlDbType.Text), new MySqlParameter("@sal_deductM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_totalM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_incrementM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_month", MySqlDbType.Int32, 10), new MySqlParameter("@sal_year", MySqlDbType.Int32, 10), new MySqlParameter("@sal_date", MySqlDbType.DateTime), new MySqlParameter("@sal_sta_id", MySqlDbType.Int32, 10), new MySqlParameter("@Sal_leaveDay", MySqlDbType.Int32, 10), new MySqlParameter("@sal_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.Sal_absenteeismDay; parameters[1].Value = model.sal_bonusM; parameters[2].Value = model.sal_describe; parameters[3].Value = model.sal_deductM; parameters[4].Value = model.sal_totalM; parameters[5].Value = model.sal_incrementM; parameters[6].Value = model.sal_month; parameters[7].Value = model.sal_year; parameters[8].Value = model.sal_date; parameters[9].Value = model.sal_sta_id; parameters[10].Value = model.Sal_leaveDay; parameters[11].Value = model.sal_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staffsalary DataRowToModel(DataRow row) { WalleProject.Model.t_staffsalary model = new WalleProject.Model.t_staffsalary(); if (row != null) { if (row["Sal_absenteeismDay"] != null && row["Sal_absenteeismDay"].ToString() != "") { model.Sal_absenteeismDay = int.Parse(row["Sal_absenteeismDay"].ToString()); } if (row["sal_ID"] != null && row["sal_ID"].ToString() != "") { model.sal_ID = int.Parse(row["sal_ID"].ToString()); } if (row["sal_bonusM"] != null && row["sal_bonusM"].ToString() != "") { model.sal_bonusM = decimal.Parse(row["sal_bonusM"].ToString()); } if (row["sal_describe"] != null) { model.sal_describe = row["sal_describe"].ToString(); } if (row["sal_deductM"] != null && row["sal_deductM"].ToString() != "") { model.sal_deductM = decimal.Parse(row["sal_deductM"].ToString()); } if (row["sal_totalM"] != null && row["sal_totalM"].ToString() != "") { model.sal_totalM = decimal.Parse(row["sal_totalM"].ToString()); } if (row["sal_incrementM"] != null && row["sal_incrementM"].ToString() != "") { model.sal_incrementM = decimal.Parse(row["sal_incrementM"].ToString()); } if (row["sal_month"] != null && row["sal_month"].ToString() != "") { model.sal_month = int.Parse(row["sal_month"].ToString()); } if (row["sal_year"] != null && row["sal_year"].ToString() != "") { model.sal_year = int.Parse(row["sal_year"].ToString()); } if (row["sal_date"] != null && row["sal_date"].ToString() != "") { model.sal_date = DateTime.Parse(row["sal_date"].ToString()); } if (row["sal_sta_id"] != null && row["sal_sta_id"].ToString() != "") { model.sal_sta_id = int.Parse(row["sal_sta_id"].ToString()); } if (row["Sal_leaveDay"] != null && row["Sal_leaveDay"].ToString() != "") { model.Sal_leaveDay = int.Parse(row["Sal_leaveDay"].ToString()); } } return(model); }
private void ShowInfo(int sal_ID) { WalleProject.BLL.t_staffsalary bll = new WalleProject.BLL.t_staffsalary(); WalleProject.Model.t_staffsalary model = bll.GetModel(sal_ID); this.lblSal_absenteeismDay.Text = model.Sal_absenteeismDay.ToString(); this.lblsal_ID.Text = model.sal_ID.ToString(); this.lblsal_bonusM.Text = model.sal_bonusM.ToString(); this.lblsal_describe.Text = model.sal_describe; this.lblsal_deductM.Text = model.sal_deductM.ToString(); this.lblsal_totalM.Text = model.sal_totalM.ToString(); this.lblsal_incrementM.Text = model.sal_incrementM.ToString(); this.lblsal_month.Text = model.sal_month.ToString(); this.lblsal_year.Text = model.sal_year.ToString(); this.lblsal_date.Text = model.sal_date.ToString(); this.lblsal_sta_id.Text = model.sal_sta_id.ToString(); this.lblSal_leaveDay.Text = model.Sal_leaveDay.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_staffsalary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_staffsalary("); strSql.Append("Sal_absenteeismDay,sal_bonusM,sal_describe,sal_deductM,sal_totalM,sal_incrementM,sal_month,sal_year,sal_date,sal_sta_id,Sal_leaveDay)"); strSql.Append(" values ("); strSql.Append("@Sal_absenteeismDay,@sal_bonusM,@sal_describe,@sal_deductM,@sal_totalM,@sal_incrementM,@sal_month,@sal_year,@sal_date,@sal_sta_id,@Sal_leaveDay)"); MySqlParameter[] parameters = { new MySqlParameter("@Sal_absenteeismDay", MySqlDbType.Int32, 10), new MySqlParameter("@sal_bonusM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_describe", MySqlDbType.Text), new MySqlParameter("@sal_deductM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_totalM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_incrementM", MySqlDbType.Decimal, 10), new MySqlParameter("@sal_month", MySqlDbType.Int32, 10), new MySqlParameter("@sal_year", MySqlDbType.Int32, 10), new MySqlParameter("@sal_date", MySqlDbType.DateTime), new MySqlParameter("@sal_sta_id", MySqlDbType.Int32, 10), new MySqlParameter("@Sal_leaveDay", MySqlDbType.Int32, 10) }; parameters[0].Value = model.Sal_absenteeismDay; parameters[1].Value = model.sal_bonusM; parameters[2].Value = model.sal_describe; parameters[3].Value = model.sal_deductM; parameters[4].Value = model.sal_totalM; parameters[5].Value = model.sal_incrementM; parameters[6].Value = model.sal_month; parameters[7].Value = model.sal_year; parameters[8].Value = model.sal_date; parameters[9].Value = model.sal_sta_id; parameters[10].Value = model.Sal_leaveDay; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_staffsalary GetModel(int sal_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Sal_absenteeismDay,sal_ID,sal_bonusM,sal_describe,sal_deductM,sal_totalM,sal_incrementM,sal_month,sal_year,sal_date,sal_sta_id,Sal_leaveDay from t_staffsalary "); strSql.Append(" where sal_ID=@sal_ID"); MySqlParameter[] parameters = { new MySqlParameter("@sal_ID", MySqlDbType.Int32) }; parameters[0].Value = sal_ID; WalleProject.Model.t_staffsalary model = new WalleProject.Model.t_staffsalary(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_staffsalary model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_staffsalary model) { return(dal.Add(model)); }
public void btnSave_Click(object sender, EventArgs e) { WalleProject.BLL.t_staffsalary bll = new WalleProject.BLL.t_staffsalary(); WalleProject.Model.t_staffsalary model = new WalleProject.BLL.t_staffsalary().GetModel(int.Parse(lblsal_ID.Text)); string strErr = ""; if (!PageValidate.IsNumber(txtSal_absenteeismDay.Text)) { strErr += "旷工天数格式错误!\\n"; } if (!PageValidate.IsNumber(txtSal_leaveDay.Text)) { strErr += "请假天数格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Sal_absenteeismDay = int.Parse(this.txtSal_absenteeismDay.Text); int sal_ID = int.Parse(this.lblsal_ID.Text); decimal sal_bonusM = decimal.Parse(this.txtsal_bonusM.Text); decimal sal_deductM = decimal.Parse(this.txtsal_deductM.Text); decimal sal_total = decimal.Parse(this.txtsal_totalM.Text); decimal sal_incrementM = decimal.Parse(this.txtsal_incrementM.Text); int Sal_leaveDay = int.Parse(this.txtSal_leaveDay.Text); int sta_id = int.Parse(lblsal_staff.Text); string sal_describe = " 奖金:" + sal_bonusM + "扣除:" + sal_deductM + " 基本工资增长:" + sal_incrementM + " 请假天数:" + Sal_leaveDay + " 旷工天数:" + Sal_absenteeismDay; Model.t_staff staff = new BLL.t_staff().GetModel(sta_id); Model.t_salarytaxrate salarytaxrate = new BLL.t_salarytaxrate().GetModel(new BLL.t_salarytaxrate().GetMaxId() - 1); model = new WalleProject.Model.t_staffsalary(); model.Sal_absenteeismDay = Sal_absenteeismDay; model.sal_ID = sal_ID; model.sal_bonusM = sal_bonusM; model.sal_describe = sal_describe; model.sal_deductM = sal_deductM; model.sal_totalM = decimal.Parse(staff.sta_salary.ToString()); model.sal_incrementM = sal_incrementM; model.Sal_leaveDay = Sal_leaveDay; model.sal_date = DateTime.Now; model.sal_year = DateTime.Now.Year; model.sal_month = DateTime.Now.Month; model.sal_sta_id = sta_id; staff.sta_id = sta_id; decimal staffSal = decimal.Parse(staff.sta_salary.ToString()); //计算这个月所有工资 //奖金+其他扣除+工资基本增长+旷工罚金+请假扣除+旷工扣除 decimal totalSalary = model.sal_bonusM - model.sal_deductM + model.sal_incrementM - model.Sal_leaveDay * 50 - model.Sal_absenteeismDay * 100; staffSal += totalSalary; // 除开个人所得税的其他(养老保险,社会保险,住房公积金等) decimal taxLast = staffSal * (salarytaxrate.Sta_supplement + salarytaxrate.Str_aged + salarytaxrate.Str_housing + salarytaxrate.Str_medical + salarytaxrate.Str_unemployment); //个人所得税 model.sal_totalM = staffSal + totalSalary + ((staffSal - salarytaxrate.Sta_threshold) * salarytaxrate.Sta_individualTax) - taxLast; if (model != null && model.sal_year == DateTime.Now.Year && model.sal_month == DateTime.Now.Month) { bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "SalaryAdd.aspx"); } else { model.sal_describe += " 操作:修改"; bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "SalaryAdd.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtSal_absenteeismDay.Text)) { strErr += "Sal_absenteeismDay格式错误!\\n"; } if (!PageValidate.IsDecimal(txtsal_bonusM.Text)) { strErr += "sal_bonusM格式错误!\\n"; } if (this.txtsal_describe.Text.Trim().Length == 0) { strErr += "sal_describe不能为空!\\n"; } if (!PageValidate.IsDecimal(txtsal_deductM.Text)) { strErr += "sal_deductM格式错误!\\n"; } if (!PageValidate.IsDecimal(txtsal_totalM.Text)) { strErr += "sal_totalM格式错误!\\n"; } if (!PageValidate.IsDecimal(txtsal_incrementM.Text)) { strErr += "sal_incrementM格式错误!\\n"; } if (!PageValidate.IsNumber(txtsal_month.Text)) { strErr += "sal_month格式错误!\\n"; } if (!PageValidate.IsNumber(txtsal_year.Text)) { strErr += "sal_year格式错误!\\n"; } if (!PageValidate.IsDateTime(txtsal_date.Text)) { strErr += "sal_date格式错误!\\n"; } if (!PageValidate.IsNumber(txtsal_sta_id.Text)) { strErr += "sal_sta_id格式错误!\\n"; } if (!PageValidate.IsNumber(txtSal_leaveDay.Text)) { strErr += "Sal_leaveDay格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Sal_absenteeismDay = int.Parse(this.txtSal_absenteeismDay.Text); decimal sal_bonusM = decimal.Parse(this.txtsal_bonusM.Text); string sal_describe = this.txtsal_describe.Text; decimal sal_deductM = decimal.Parse(this.txtsal_deductM.Text); decimal sal_totalM = decimal.Parse(this.txtsal_totalM.Text); decimal sal_incrementM = decimal.Parse(this.txtsal_incrementM.Text); int sal_month = int.Parse(this.txtsal_month.Text); int sal_year = int.Parse(this.txtsal_year.Text); DateTime sal_date = DateTime.Parse(this.txtsal_date.Text); int sal_sta_id = int.Parse(this.txtsal_sta_id.Text); int Sal_leaveDay = int.Parse(this.txtSal_leaveDay.Text); WalleProject.Model.t_staffsalary model = new WalleProject.Model.t_staffsalary(); model.Sal_absenteeismDay = Sal_absenteeismDay; model.sal_bonusM = sal_bonusM; model.sal_describe = sal_describe; model.sal_deductM = sal_deductM; model.sal_totalM = sal_totalM; model.sal_incrementM = sal_incrementM; model.sal_month = sal_month; model.sal_year = sal_year; model.sal_date = sal_date; model.sal_sta_id = sal_sta_id; model.Sal_leaveDay = Sal_leaveDay; WalleProject.BLL.t_staffsalary bll = new WalleProject.BLL.t_staffsalary(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }