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