public bool Update(Model.EmployeeSalary EmployeeSalary)
{
const string sql =
@"UPDATE EmployeeSalary SET Name=@Name,Sex=@Sex,age=@age,InductionTime=@InductionTime,Basicsalary=@Basicsalary,
Commission=@Commission,Reward=@Reward,Punishment=@Punishment,salary=@salary,Month=@Month,Remark=@Remark WHERE ID=@ID";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
EmployeeSalary.Name,
EmployeeSalary.Sex,
EmployeeSalary.age,
EmployeeSalary.InductionTime,
EmployeeSalary.Basicsalary,
EmployeeSalary.Commission,
EmployeeSalary.Reward,
EmployeeSalary.Punishment,
EmployeeSalary.salary,
EmployeeSalary.Month,
EmployeeSalary.Remark,
EmployeeSalary.ID,
})));
}
public ActionResult Edit()
{
Business.Sys_EmployeeSalary Sys_EmployeeSalary = new Business.Sys_EmployeeSalary();
Model.EmployeeSalary EmployeeSalary = Sys_EmployeeSalary.GetModel(Request["id"]);
ViewData["SexListItems"] = GetSex(EmployeeSalary.Sex);
ViewData["GetMonthItems"] = GetMonthItems(EmployeeSalary.Month.ToString());
return(View(EmployeeSalary));
}
public ActionResult Edit(Model.EmployeeSalary EmployeeSalary)
{
Business.Sys_EmployeeSalary Sys_EmployeeSalary = new Business.Sys_EmployeeSalary();
Sys_EmployeeSalary.Update(EmployeeSalary);
ViewData["SexListItems"] = GetSex(EmployeeSalary.Sex);
ViewData["GetMonthItems"] = GetMonthItems(EmployeeSalary.Month.ToString());
Response.Write("<script>parent.layer.closeAll();</script>");
return(View());
}
public ActionResult Add(Model.EmployeeSalary EmployeeSalary)
{
ViewData["SexListItems"] = GetSex();
ViewData["GetMonthItems"] = GetMonthItems();
Business.Sys_EmployeeSalary Sys_EmployeeSalary = new Business.Sys_EmployeeSalary();
Sys_EmployeeSalary.Add(EmployeeSalary);
Response.Write("<script>parent.layer.closeAll();</script>");
return(View());
}
public bool Add(Model.EmployeeSalary EmployeeSalary)
{
const string sql =
@"INSERT INTO EmployeeSalary(Name,Sex,age,InductionTime,Basicsalary,Commission,Reward,Punishment,salary,Month,Remark)
VALUES(@Name,@Sex,@age,@InductionTime,@Basicsalary,@Commission,@Reward,@Punishment,@salary,@Month,@Remark)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
EmployeeSalary.Name,
EmployeeSalary.Sex,
EmployeeSalary.age,
EmployeeSalary.InductionTime,
EmployeeSalary.Basicsalary,
EmployeeSalary.Commission,
EmployeeSalary.Reward,
EmployeeSalary.Punishment,
EmployeeSalary.salary,
EmployeeSalary.Month,
EmployeeSalary.Remark,
})));
}
