public bool UpdateInfo(Model.EmployeeTurnover EmployeeTurnover) { const string sql = @"update EmployeeTurnover set Name=@Name,Sex=@Sex,Birthday=@Birthday,SubordinateSector=@SubordinateSector,Post=@Post,PostTitle=@PostTitle,InductionTime=@InductionTime, StartTimeOfProbation=@StartTimeOfProbation,EndOfProbationPeriod=@EndOfProbationPeriod,WorkRepor=@WorkRepor,SuperiorOpinion=@SuperiorOpinion,AdministrationPersonnelDepartmentOpinion=@AdministrationPersonnelDepartmentOpinion, GeneralManagerOpinion=@GeneralManagerOpinion where Number=@Number"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { EmployeeTurnover.Name, EmployeeTurnover.Sex, EmployeeTurnover.Birthday, EmployeeTurnover.SubordinateSector, EmployeeTurnover.Post, EmployeeTurnover.PostTitle, EmployeeTurnover.InductionTime, EmployeeTurnover.StartTimeOfProbation, EmployeeTurnover.EndOfProbationPeriod, EmployeeTurnover.WorkRepor, EmployeeTurnover.SuperiorOpinion, EmployeeTurnover.AdministrationPersonnelDepartmentOpinion, EmployeeTurnover.GeneralManagerOpinion, EmployeeTurnover.Number, }))); }
/// <summary> /// 写入一条记录 /// </summary> /// <param name="EmployeeTurnover"></param> /// <returns></returns> public bool InsertEmployeeTurnover(Model.EmployeeTurnover EmployeeTurnover) { const string sql = @"INSERT INTO EmployeeTurnover(Number,CreateTime,Name,Sex,Birthday,SubordinateSector,Post,PostTitle,InductionTime, StartTimeOfProbation,EndOfProbationPeriod,WorkRepor,SuperiorOpinion,AdministrationPersonnelDepartmentOpinion,GeneralManagerOpinion) VALUES(@Number,@CreateTime,@Name,@Sex,@Birthday,@SubordinateSector,@Post,@PostTitle,@InductionTime, @StartTimeOfProbation,@EndOfProbationPeriod,@WorkRepor,@SuperiorOpinion,@AdministrationPersonnelDepartmentOpinion,@GeneralManagerOpinion)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { EmployeeTurnover.Number, EmployeeTurnover.CreateTime, EmployeeTurnover.Name, EmployeeTurnover.Sex, EmployeeTurnover.Birthday, EmployeeTurnover.SubordinateSector, EmployeeTurnover.Post, EmployeeTurnover.PostTitle, EmployeeTurnover.InductionTime, EmployeeTurnover.StartTimeOfProbation, EmployeeTurnover.EndOfProbationPeriod, EmployeeTurnover.WorkRepor, EmployeeTurnover.SuperiorOpinion, EmployeeTurnover.AdministrationPersonnelDepartmentOpinion, EmployeeTurnover.GeneralManagerOpinion, }))); }
/// <summary> /// 员工转正 /// </summary> /// <returns></returns> public ActionResult EmployeeTurnover() { ViewData["add"] = "true"; if (Request["Number"] != null) { ViewData["add"] = "false"; if (Request["IsShowInfo"] != null)//查看详情 { ViewData["IsShowInfo"] = "True"; } Business.Sys_EmployeeTurnover Sys_EmployeeTurnover = new Business.Sys_EmployeeTurnover(); Model.EmployeeTurnover EmployeeTurnover = Sys_EmployeeTurnover.GetInfoByNumber(Request["Number"]); return(View(EmployeeTurnover)); } return(View()); }
public ActionResult EmployeeTurnover(Model.EmployeeTurnover EmployeeTurnover) { Business.Sys_EmployeeTurnover Sys_EmployeeTurnover = new Business.Sys_EmployeeTurnover(); if (!string.IsNullOrEmpty(EmployeeTurnover.Number)) { Sys_EmployeeTurnover.UpdateInfo(EmployeeTurnover); Response.Write("<script>parent.layer.alert('修改成功');</script>"); } else { EmployeeTurnover.CreateTime = DateTime.Now; EmployeeTurnover.Number = Utility.ChangeText.OrderIdCreate(); if (Sys_EmployeeTurnover.InsertEmployeeTurnover(EmployeeTurnover)) { Response.Write("<script>parent.layer.alert('添加成功!');</script>"); } } //页面待定 调往订单详情页面 return(View()); }