public bool UpdateEmployeeEntry(Model.EmployeeEntry EmployeeEntry)
{
const string sql =
@"update EmployeeEntry set Name=@Name,Sex=@Sex,Birthday=@Birthday,Nation=@Nation,Marriage=@Marriage,
Education=@Education,Major=@Major,WhatLanguage=@WhatLanguage,PlaceOfOrigin=@PlaceOfOrigin,RegisteredResidence=@RegisteredResidence,
PresentAddressTelephoneNumber=@PresentAddressTelephoneNumber,IDCard=@IDCard,TemporaryResidencePermitNumber=@TemporaryResidencePermitNumber,
EmergencyContact=@EmergencyContact,EmergencyContactTelephone=@EmergencyContactTelephone,ContactUnit=@ContactUnit,
ApplyForPosition=@ApplyForPosition,MonthlySalary=@MonthlySalary,NameOfFamilyMember=@NameOfFamilyMember,FamilyMembersAndMyself=@FamilyMembersAndMyself,
BeginningTimeOfWork=@BeginningTimeOfWork,EndingTimeOfWork=@EndingTimeOfWork,WorkUnit=@WorkUnit,FamilyMembersUnitAndPosition=@FamilyMembersUnitAndPosition,
NameOfFamilyMember1=@NameOfFamilyMember1,FamilyMembersAndMyself1=@FamilyMembersAndMyself1,FamilyMembersUnitAndPosition1=@FamilyMembersUnitAndPosition1,
NameOfFamilyMember2=@NameOfFamilyMember2,FamilyMembersAndMyself2=@FamilyMembersAndMyself2,FamilyMembersUnitAndPosition2=@FamilyMembersUnitAndPosition2,
BeginningTimeOfWork1=@BeginningTimeOfWork1,EndingTimeOfWork1=@EndingTimeOfWork1,WorkUnit1=@WorkUnit1,BeginningTimeOfWork2=@BeginningTimeOfWork2,
EndingTimeOfWork2=@EndingTimeOfWork2,WorkUnit2=@WorkUnit2 where Number=@Number";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
EmployeeEntry.Name,
EmployeeEntry.Sex,
EmployeeEntry.Birthday,
EmployeeEntry.Nation,
EmployeeEntry.Marriage,
EmployeeEntry.Education,
EmployeeEntry.Major,
EmployeeEntry.WhatLanguage,
EmployeeEntry.PlaceOfOrigin,
EmployeeEntry.RegisteredResidence,
EmployeeEntry.PresentAddressTelephoneNumber,
EmployeeEntry.IDCard,
EmployeeEntry.TemporaryResidencePermitNumber,
EmployeeEntry.EmergencyContact,
EmployeeEntry.EmergencyContactTelephone,
EmployeeEntry.ContactUnit,
EmployeeEntry.ApplyForPosition,
EmployeeEntry.MonthlySalary,
EmployeeEntry.NameOfFamilyMember,
EmployeeEntry.FamilyMembersAndMyself,
EmployeeEntry.BeginningTimeOfWork,
EmployeeEntry.EndingTimeOfWork,
EmployeeEntry.WorkUnit,
EmployeeEntry.FamilyMembersUnitAndPosition,
EmployeeEntry.NameOfFamilyMember1,
EmployeeEntry.FamilyMembersAndMyself1,
EmployeeEntry.FamilyMembersUnitAndPosition1,
EmployeeEntry.NameOfFamilyMember2,
EmployeeEntry.FamilyMembersAndMyself2,
EmployeeEntry.FamilyMembersUnitAndPosition2,
EmployeeEntry.BeginningTimeOfWork1,
EmployeeEntry.EndingTimeOfWork1,
EmployeeEntry.WorkUnit1,
EmployeeEntry.BeginningTimeOfWork2,
EmployeeEntry.EndingTimeOfWork2,
EmployeeEntry.WorkUnit2,
EmployeeEntry.Number,
})));
}
/// <summary>
/// 写入员工入职表信息
/// </summary>
/// <param name="EmployeeEntry"></param>
/// <returns></returns>
public bool InsertEmployeeEntry(Model.EmployeeEntry EmployeeEntry)
{
const string sql =
@"INSERT INTO EmployeeEntry(Name,Sex,Birthday,Nation,Marriage,Education,Major,WhatLanguage,PlaceOfOrigin,RegisteredResidence,
PresentAddressTelephoneNumber,IDCard,TemporaryResidencePermitNumber,EmergencyContact,EmergencyContactTelephone,ContactUnit,
ApplyForPosition,MonthlySalary,NameOfFamilyMember,FamilyMembersAndMyself,BeginningTimeOfWork,EndingTimeOfWork,WorkUnit,FamilyMembersUnitAndPosition,Number,
NameOfFamilyMember1,FamilyMembersAndMyself1,FamilyMembersUnitAndPosition1,NameOfFamilyMember2,FamilyMembersAndMyself2,FamilyMembersUnitAndPosition2,
BeginningTimeOfWork1,EndingTimeOfWork1,WorkUnit1,BeginningTimeOfWork2,EndingTimeOfWork2,WorkUnit2)
VALUES(@Name,@Sex,@Birthday,@Nation,@Marriage,@Education,@Major,@WhatLanguage,@PlaceOfOrigin,@RegisteredResidence,
@PresentAddressTelephoneNumber,@IDCard,@TemporaryResidencePermitNumber,@EmergencyContact,@EmergencyContactTelephone,@ContactUnit,
@ApplyForPosition,@MonthlySalary,@NameOfFamilyMember,@FamilyMembersAndMyself,@BeginningTimeOfWork,@EndingTimeOfWork,@WorkUnit,@FamilyMembersUnitAndPosition,@Number,
@NameOfFamilyMember1,@FamilyMembersAndMyself1,@FamilyMembersUnitAndPosition1,@NameOfFamilyMember2,@FamilyMembersAndMyself2,@FamilyMembersUnitAndPosition2,
@BeginningTimeOfWork1,@EndingTimeOfWork1,@WorkUnit1,@BeginningTimeOfWork2,@EndingTimeOfWork2,@WorkUnit2)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
EmployeeEntry.Name,
EmployeeEntry.Sex,
EmployeeEntry.Birthday,
EmployeeEntry.Nation,
EmployeeEntry.Marriage,
EmployeeEntry.Education,
EmployeeEntry.Major,
EmployeeEntry.WhatLanguage,
EmployeeEntry.PlaceOfOrigin,
EmployeeEntry.RegisteredResidence,
EmployeeEntry.PresentAddressTelephoneNumber,
EmployeeEntry.IDCard,
EmployeeEntry.TemporaryResidencePermitNumber,
EmployeeEntry.EmergencyContact,
EmployeeEntry.EmergencyContactTelephone,
EmployeeEntry.ContactUnit,
EmployeeEntry.ApplyForPosition,
EmployeeEntry.MonthlySalary,
EmployeeEntry.NameOfFamilyMember,
EmployeeEntry.FamilyMembersAndMyself,
EmployeeEntry.BeginningTimeOfWork,
EmployeeEntry.EndingTimeOfWork,
EmployeeEntry.WorkUnit,
EmployeeEntry.FamilyMembersUnitAndPosition,
EmployeeEntry.Number,
EmployeeEntry.NameOfFamilyMember1,
EmployeeEntry.FamilyMembersAndMyself1,
EmployeeEntry.FamilyMembersUnitAndPosition1,
EmployeeEntry.NameOfFamilyMember2,
EmployeeEntry.FamilyMembersAndMyself2,
EmployeeEntry.FamilyMembersUnitAndPosition2,
EmployeeEntry.BeginningTimeOfWork1,
EmployeeEntry.EndingTimeOfWork1,
EmployeeEntry.WorkUnit1,
EmployeeEntry.BeginningTimeOfWork2,
EmployeeEntry.EndingTimeOfWork2,
EmployeeEntry.WorkUnit2,
})));
}
public ActionResult EmployeeEntry(Model.EmployeeEntry EmployeeEntry)
{
Business.Sys_EmployeeEntry Sys_EmployeeEntry = new Business.Sys_EmployeeEntry();
if (!string.IsNullOrEmpty(EmployeeEntry.Number))
{
Sys_EmployeeEntry.UpdateEmployeeEntry(EmployeeEntry);
Response.Write("<script>parent.layer.alert('修改成功!');</script>");
}
else
{
EmployeeEntry.Number = Utility.ChangeText.OrderIdCreate();
if (Sys_EmployeeEntry.InsertEmployeeEntry(EmployeeEntry))
{
Response.Write("<script>parent.layer.alert('添加成功!');</script>");
}
}
//页面待定 调往订单详情页面
return(View());
}
