private static void RechieveItsPaper(AssessActivity assessActivity)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_AssessActivityID, SqlDbType.Int).Value =
assessActivity.AssessActivityID;
using (
SqlDataReader sdr =
SqlHelper.ExecuteReader("GetAssessActivityPaperById", cmd))
{
while (sdr.Read())
{
SubmitInfo submitInfo = new SubmitInfo();
submitInfo.Choose = sdr[_DbChoseIntention].ToString();
submitInfo.Comment = sdr[_DbContent].ToString();
submitInfo.FillPerson = sdr[_DbFillPerson].ToString();
submitInfo.StepIndex = Convert.ToInt32(sdr[_DbStepIndex]);
submitInfo.SubmitTime = Convert.ToDateTime(sdr[_DbSubmitTime]);
submitInfo.SalaryNow = EmployeeWelfare.ConvertToDecimal(sdr[_DbSalaryNow]);
submitInfo.SalaryChange = EmployeeWelfare.ConvertToDecimal(sdr[_DbSalaryChange]);
submitInfo.SubmitInfoType =
SubmitInfoType.RechieveSubmitInfoTypeByID(Convert.ToInt32(sdr[_DbType]));
assessActivity.ItsAssessActivityPaper.SubmitInfoes.Add(submitInfo);
int paperID = Convert.ToInt32(sdr[_DbPKID]);
submitInfo.SubmitInfoID = paperID;
RechieveItsSubmitInfo(paperID, submitInfo);
}
}
}
private static decimal?ConvertToDecimal(string s)
{
if (!string.IsNullOrEmpty(s))
{
decimal temp;
if (!decimal.TryParse(s, out temp))
{
throw new ApplicationException(string.Format("数据：{0} 格式错误", s));
}
}
return(EmployeeWelfare.ConvertToDecimal(s));
}
public static SubmitInfo Convert(AssessActivityPaperEntity entity)
{
return(new SubmitInfo
{
Choose = entity.ChoseIntention,
Comment = entity.Content,
FillPerson = entity.FillPerson,
StepIndex = entity.StepIndex.GetValueOrDefault(),
SubmitTime = entity.SubmitTime,
SalaryNow = EmployeeWelfare.ConvertToDecimal(entity.SalaryNow),
SalaryChange = EmployeeWelfare.ConvertToDecimal(entity.SalaryChange),
SubmitInfoType = SubmitInfoType.RechieveSubmitInfoTypeByID(entity.Type),
SubmitInfoID = entity.PKID,
AssessActivityID = entity.AssessActivityID
});
}
private void CollectWelfareInfo()
{
EmployeeSocialSecurity employeeSocialSecurity =
new EmployeeSocialSecurity(_ItsView.SocialSecurityType,
EmployeeWelfare.ConvertToDecimal(_ItsView.SocialSecurityBase),
EmployeeWelfare.ConvertToDateTime(_ItsView.SocialSecurityYearMonth),
EmployeeWelfare.ConvertToDecimal(_ItsView.YangLaoBase),
EmployeeWelfare.ConvertToDecimal(_ItsView.ShiYeBase),
EmployeeWelfare.ConvertToDecimal(_ItsView.YiLiaoBase));
EmployeeAccumulationFund employeeAccumulationFund =
new EmployeeAccumulationFund(_ItsView.AccumulationFundAccount,
EmployeeWelfare.ConvertToDecimal(_ItsView.AccumulationFundBase),
EmployeeWelfare.ConvertToDateTime(_ItsView.AccumulationFundYearMonth),
_ItsView.AccumulationFundSupplyAccount,
EmployeeWelfare.ConvertToDecimal(_ItsView.AccumulationFundSupplyBase));
_TheEmployeeToComplete.EmployeeWelfare =
new EmployeeWelfare(employeeSocialSecurity, employeeAccumulationFund);
}
public List <EmployeeWelfareHistory> GetEmployeeWelfareHistoryByAccountID(int employeeID)
{
List <EmployeeWelfareHistory> employeeWelfareHistoryList = new List <EmployeeWelfareHistory>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_AccountID, SqlDbType.Int).Value = employeeID;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetEmployeeWelfareHistoryByAccountID", cmd))
{
while (sdr.Read())
{
EmployeeSocialSecurity employeeSocialSecurity =
new EmployeeSocialSecurity(
SocialSecurityTypeEnum.GetById(Convert.ToInt32(sdr[_DbSocialSecurityType] ?? 0)),
EmployeeWelfare.ConvertToDecimal(sdr[_DbSocialSecurityBase]),
EmployeeWelfare.ConvertToDateTime(sdr[_DbSocialSecurityEffectiveYearMonth]),
EmployeeWelfare.ConvertToDecimal(sdr[_DbYangLaoBase]),
EmployeeWelfare.ConvertToDecimal(sdr[_DbShiYeBase]),
EmployeeWelfare.ConvertToDecimal(sdr[_DbYiLiaoBase]));
EmployeeAccumulationFund employeeAccumulationFund =
new EmployeeAccumulationFund(EmployeeWelfare.ConvertToString(sdr[_DbAccumulationFundAccount]),
EmployeeWelfare.ConvertToDecimal(sdr[_DbAccumulationFundBase]),
EmployeeWelfare.ConvertToDateTime(
sdr[_DbAccumulationFundEffectiveMonthYear]),
EmployeeWelfare.ConvertToString(
sdr[_DbAccumulationFundSupplyAccount]),
EmployeeWelfare.ConvertToDecimal(
sdr[_DbAccumulationFundSupplyBase]));
EmployeeWelfare employeeWelfare =
new EmployeeWelfare(employeeSocialSecurity, employeeAccumulationFund);
EmployeeWelfareHistory employeeWelfareHistory =
new EmployeeWelfareHistory(Convert.ToInt32(sdr[_DbPKID]), employeeWelfare,
Convert.ToDateTime(sdr[_DbOperationTime]),
sdr[_DbAccountsBackName].ToString());
employeeWelfareHistoryList.Add(employeeWelfareHistory);
}
}
return(employeeWelfareHistoryList);
}
