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, }))); }