private static DateTime?ConvertToDateTime(string s)
{
if (!string.IsNullOrEmpty(s))
{
DateTime temp;
if (!DateTime.TryParse(s, out temp))
{
throw new ApplicationException(string.Format("数据：{0} 格式错误", s));
}
}
return(EmployeeWelfare.ConvertToDateTime(s));
}
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);
}
private bool Vaildate(EmployeeWelfare welfare)
{
bool valid = true;
decimal dctemp;
if (!string.IsNullOrEmpty(welfare.AccumulationFund.BaseTemp) &&
!decimal.TryParse(welfare.AccumulationFund.BaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.AccumulationFund.BaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.AccumulationFund.BaseTemp))
{
welfare.AccumulationFund.Base = null;
}
else
{
welfare.AccumulationFund.Base = Convert.ToDecimal(welfare.AccumulationFund.BaseTemp);
}
}
if (!string.IsNullOrEmpty(welfare.AccumulationFund.SupplyBaseTemp) &&
!decimal.TryParse(welfare.AccumulationFund.SupplyBaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.AccumulationFund.SupplyBaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.AccumulationFund.SupplyBaseTemp))
{
welfare.AccumulationFund.SupplyBase = null;
}
else
{
welfare.AccumulationFund.SupplyBase = Convert.ToDecimal(welfare.AccumulationFund.SupplyBaseTemp);
}
}
if (!string.IsNullOrEmpty(welfare.SocialSecurity.BaseTemp) &&
!decimal.TryParse(welfare.SocialSecurity.BaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.SocialSecurity.BaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.SocialSecurity.BaseTemp))
{
welfare.SocialSecurity.Base = null;
}
else
{
welfare.SocialSecurity.Base = Convert.ToDecimal(welfare.SocialSecurity.BaseTemp);
}
}
if (!string.IsNullOrEmpty(welfare.SocialSecurity.YangLaoBaseTemp) &&
!decimal.TryParse(welfare.SocialSecurity.YangLaoBaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.SocialSecurity.YangLaoBaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.SocialSecurity.YangLaoBaseTemp))
{
welfare.SocialSecurity.YangLaoBase = null;
}
else
{
welfare.SocialSecurity.YangLaoBase = Convert.ToDecimal(welfare.SocialSecurity.YangLaoBaseTemp);
}
}
if (!string.IsNullOrEmpty(welfare.SocialSecurity.ShiYeBaseTemp) &&
!decimal.TryParse(welfare.SocialSecurity.ShiYeBaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.SocialSecurity.ShiYeBaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.SocialSecurity.ShiYeBaseTemp))
{
welfare.SocialSecurity.ShiYeBase = null;
}
else
{
welfare.SocialSecurity.ShiYeBase = Convert.ToDecimal(welfare.SocialSecurity.ShiYeBaseTemp);
}
}
if (!string.IsNullOrEmpty(welfare.SocialSecurity.YiLiaoBaseTemp) &&
!decimal.TryParse(welfare.SocialSecurity.YiLiaoBaseTemp, out dctemp))
{
_ValideMessage = string.Format("{0}{1};", _ValideMessage, welfare.SocialSecurity.YiLiaoBaseTemp);
valid = false;
}
else
{
if (string.IsNullOrEmpty(welfare.SocialSecurity.YiLiaoBaseTemp))
{
welfare.SocialSecurity.YiLiaoBase = null;
}
else
{
welfare.SocialSecurity.YiLiaoBase = Convert.ToDecimal(welfare.SocialSecurity.YiLiaoBaseTemp);
}
}
if (!WelfareInfoVaildater.YearMonthOK(welfare.AccumulationFund.EffectiveYearMonthTemp))
{
_ValideMessage =
string.Format("{0}{1}年-{2}月;", _ValideMessage, welfare.AccumulationFund.EffectiveYearMonthTemp[0],
welfare.AccumulationFund.EffectiveYearMonthTemp[1]);
valid = false;
}
else
{
welfare.AccumulationFund.EffectiveYearMonth =
EmployeeWelfare.ConvertToDateTime(welfare.AccumulationFund.EffectiveYearMonthTemp);
}
if (!WelfareInfoVaildater.YearMonthOK(welfare.SocialSecurity.EffectiveYearMonthTemp))
{
_ValideMessage =
string.Format("{0}{1}年-{2}月;", _ValideMessage, welfare.SocialSecurity.EffectiveYearMonthTemp[0],
welfare.SocialSecurity.EffectiveYearMonthTemp[1]);
valid = false;
}
else
{
welfare.SocialSecurity.EffectiveYearMonth =
EmployeeWelfare.ConvertToDateTime(welfare.SocialSecurity.EffectiveYearMonthTemp);
}
return(valid);
}
