private static decimal?GetDecimal(DataTable dt, int rowindex, decimal?ret, string columnname)
{
string SD = ImportUtility.GetItem(dt, rowindex, columnname);
if (SD != ImportUtility.EmptyNull)
{
ret = ConvertToDecimal(SD);
}
return(ret);
}
private static string GetString(DataTable dt, int rowindex, string ret, string columnnanme)
{
string SS = ImportUtility.GetItem(dt, rowindex, columnnanme);
if (SS != ImportUtility.EmptyNull)
{
ret = SS;
}
return(ret);
}
private static DateTime?GetYM(DataTable dt, int rowindex, DateTime?ret, string columnname)
{
string SYM = ImportUtility.GetItem(dt, rowindex, columnname);
if (SYM != ImportUtility.EmptyNull)
{
ret = ConvertToDateTime(SYM);
}
return(ret);
}
private void ValueItemInOneRow(int rowindex, DataTable dt, EmployeeWelfare welfare)
{
SocialSecurityTypeEnum socialSecurityType = welfare.SocialSecurity.Type;
decimal? socialBase = welfare.SocialSecurity.Base;
decimal? yangLaoBase = welfare.SocialSecurity.YangLaoBase;
decimal? shiYeBase = welfare.SocialSecurity.ShiYeBase;
decimal? yiLiaoBase = welfare.SocialSecurity.YiLiaoBase;
DateTime?socialYM = welfare.SocialSecurity.EffectiveYearMonth;
string fundAccount = welfare.AccumulationFund.Account;
DateTime?fundYM = welfare.AccumulationFund.EffectiveYearMonth;
decimal? fundBase = welfare.AccumulationFund.Base;
string operationName = _Operator.Name;
string supplyAccount = welfare.AccumulationFund.SupplyAccount;
decimal? supplyBase = welfare.AccumulationFund.SupplyBase;
string SsocialSecurityType = ImportUtility.GetItem(dt, rowindex, EmployeeWelfare.ConstParemeter.SocialType);
if (SsocialSecurityType != ImportUtility.EmptyNull)
{
socialSecurityType = ConvertToSocialSecurityTypeEnum(SsocialSecurityType);
}
socialBase = GetDecimal(dt, rowindex, socialBase, EmployeeWelfare.ConstParemeter.SocialBase);
yangLaoBase = GetDecimal(dt, rowindex, yangLaoBase, EmployeeWelfare.ConstParemeter.YangLaoBase);
shiYeBase = GetDecimal(dt, rowindex, shiYeBase, EmployeeWelfare.ConstParemeter.ShiYeBase);
yiLiaoBase = GetDecimal(dt, rowindex, yiLiaoBase, EmployeeWelfare.ConstParemeter.YiLiaoBase);
socialYM = GetYM(dt, rowindex, socialYM, EmployeeWelfare.ConstParemeter.SocialYM);
fundAccount = GetString(dt, rowindex, fundAccount, EmployeeWelfare.ConstParemeter.FundAccount);
fundYM = GetYM(dt, rowindex, fundYM, EmployeeWelfare.ConstParemeter.FundYM);
fundBase = GetDecimal(dt, rowindex, fundBase, EmployeeWelfare.ConstParemeter.FundBase);
supplyAccount = GetString(dt, rowindex, supplyAccount, EmployeeWelfare.ConstParemeter.SupplyAccount);
supplyBase = GetDecimal(dt, rowindex, supplyBase, EmployeeWelfare.ConstParemeter.SupplyBase);
SaveEmployeeWelfare saveEmployeeWelfare =
new SaveEmployeeWelfare(welfare.Owner.Id, socialSecurityType, socialBase, socialYM, fundAccount,
fundYM, fundBase, operationName,
supplyAccount, supplyBase, yangLaoBase, shiYeBase, yiLiaoBase);
saveEmployeeWelfare.Excute();
}