/// <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");
}
