// 修改人员的奖惩
public int Update_HRRewardsPublishment(HRDDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRRewardsPublishment",
new SqlParameter("@HRRewards_ID", hr.HRRewards_ID), new SqlParameter("@HRRewards_Type ", hr.HRRewards_Type),
new SqlParameter("@HRRewards_Time ", hr.HRRewards_Time), new SqlParameter("@HRRewards_Content ", hr.HRRewards_Content),
new SqlParameter("@HRRewards_Note", hr.HRRewards_Note), new SqlParameter("@HRRewards_Money ", hr.HRRewards_Money),
new SqlParameter("@HRRewards_Agree ", hr.HRRewards_Agree), new SqlParameter("@HRRewards_OkTime ", hr.HRRewards_OkTime)));
}
public int Insert_HRPersonnelChangesRecord(HRDDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_HRPersonnelChangesRecord",
new SqlParameter("@HRPCR_ID ", hr.HRPCR_ID), new SqlParameter("@HRDD_ID", hr.HRDD_ID),
new SqlParameter("@HRPCR_FormerDep ", hr.HRPCR_FormerDep), new SqlParameter("@HRPCR_FormerPost ", hr.HRPCR_FormerPost),
new SqlParameter("@HRPCR_Dep", hr.HRPCR_Dep), new SqlParameter("@HRPCR_Post ", hr.HRPCR_Post),
new SqlParameter("@HRPCR_Administrator", hr.HRPCR_Administrator), new SqlParameter("@HRPCR_Remarks", hr.HRPCR_Remarks),
new SqlParameter("@HRP_ID", hr.HRP_ID)));
}
public int Insert_HRSalaryRecord(HRDDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_I_HRSalaryRecord",
new SqlParameter("@HRSR_ID ", hr.HRSR_ID), new SqlParameter("@HRDD_ID", hr.HRDD_ID),
new SqlParameter("@HRSR_AdjBasicWage ", hr.HRSR_AdjBasicWage), new SqlParameter("@HRSR_AdjFTWage", hr.HRSR_AdjFTWage),
new SqlParameter("@HRSR_AdjPWage", hr.HRSR_AdjPWage), new SqlParameter("@HRSR_AdjOTWage ", hr.HRSR_AdjOTWage),
new SqlParameter("@HRSR_ChargePer", hr.HRSR_ChargePer), new SqlParameter("@HRSR_Reason", hr.HRSR_Reason),
new SqlParameter("@HRSR_BasicWage", hr.HRSR_BasicWage), new SqlParameter("@HRSR_PWage ", hr.HRSR_PWage),
new SqlParameter("@HRSR_FTWage", hr.HRSR_FTWage), new SqlParameter("@HRSR_OTWage", hr.HRSR_OTWage)));
}
public int Update_HRDDetail(HRDDetailInfo hr)
{
return((int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Proc_U_HRDDetail",
new SqlParameter("@HRDD_ID", hr.HRDD_ID), new SqlParameter("@HRP_ID ", hr.HRP_ID),
new SqlParameter("@HRDD_StaffNO ", hr.HRDD_StaffNO), new SqlParameter("@HRET_ID ", hr.HRET_ID),
new SqlParameter("@HRDD_Name", hr.HRDD_Name), new SqlParameter("@HRDD_Registration ", hr.HRDD_Registration),
new SqlParameter("@HRDD_BasicWage", hr.HRDD_BasicWage), new SqlParameter("@HRDD_FullTimeWage ", hr.HRDD_FullTimeWage),
new SqlParameter("@HRDD_PerformWage", hr.HRDD_PerformWage), new SqlParameter("@HRDD_OverTimeWage ", hr.HRDD_OverTimeWage),
new SqlParameter("@HRDD_ConverseDate", hr.HRDD_ConverseDate), new SqlParameter("@HRDD_ContactSDate ", hr.HRDD_ContactSDate),
new SqlParameter("@HRDD_ContactEDate", hr.HRDD_ContactEDate), new SqlParameter("@HRDD_Worklength ", hr.HRDD_Worklength),
new SqlParameter("@HRDD_EntryDate", hr.HRDD_EntryDate), new SqlParameter("@HRDD_IDCard ", hr.HRDD_IDCard),
new SqlParameter("@HRDD_Nationality", hr.HRDD_Nationality), new SqlParameter("@HRDD_IsMarried ", hr.HRDD_IsMarried),
new SqlParameter("@HRDD_EduBackg", hr.HRDD_EduBackg), new SqlParameter("@HRDD_Major ", hr.HRDD_Major),
new SqlParameter("@HRDD_GSchool", hr.HRDD_GSchool), new SqlParameter("@HRDD_HAddress ", hr.HRDD_HAddress),
new SqlParameter("@HRDD_Tel", hr.HRDD_Tel), new SqlParameter("@HRDD_HasSocial ", hr.HRDD_HasSocial),
new SqlParameter("@HRDD_HasAccumulation", hr.HRDD_HasAccumulation), new SqlParameter("@HRDD_CertificateComplete ", hr.HRDD_CertificateComplete),
new SqlParameter("@HRDD_EmergencyPer ", hr.HRDD_EmergencyPer), new SqlParameter("@HRDD_EmergencyNo ", hr.HRDD_EmergencyNo)));
}
//离职相关
public int Update_HRDDetail_Quit(HRDDetailInfo hr)
{
return(iHR.Update_HRDDetail_Quit(hr));
}
public int Insert_HRSalaryRecord(HRDDetailInfo hr)
{
return(iHR.Insert_HRSalaryRecord(hr));
}
public int Insert_HRPersonnelChangesRecord(HRDDetailInfo hr)
{
return(iHR.Insert_HRPersonnelChangesRecord(hr));
}
public int Insert_HRDDetail(HRDDetailInfo hr)
{
return(iHR.Insert_HRDDetail(hr));
}
public int Update_HRRewardsPublishment(HRDDetailInfo hr)
{
return(iHR.Update_HRRewardsPublishment(hr));
}
//奖惩相关
public int Insert_HRRewardsPublishment(HRDDetailInfo hr)
{
return(iHR.Insert_HRRewardsPublishment(hr));
}