private void BindTypesSource()
{
_ItsView.WorkTypeSource = WorkType.GetAll();
_ItsView.WorkType = WorkType.Contract.Id.ToString();
_ItsView.SocialSecurityTypeSource = SocialSecurityTypeEnum.GetAll();
_ItsView.SocialSecurityType = SocialSecurityTypeEnum.Null;
}
private static SocialSecurityTypeEnum ConvertToSocialSecurityTypeEnum(string s)
{
if (!string.IsNullOrEmpty(s))
{
if (SocialSecurityTypeEnum.GetByName(s) == null)
{
throw new ApplicationException(string.Format("数据：{0} 不是有效的社保类型", s));
}
}
return(SocialSecurityTypeEnum.GetByName(s));
}
private void SetGridViewRowddSocialSecurityTypeDisplay(int rowIndex)
{
DropDownList ddSocialSecurityType =
(DropDownList)gvEmployeeWelfare.Rows[rowIndex].FindControl("ddSocialSecurityType");
if (ddSocialSecurityType != null)
{
ddSocialSecurityType.DataSource = SocialSecurityTypeEnum.GetAll();
ddSocialSecurityType.DataValueField = "Id";
ddSocialSecurityType.DataTextField = "Name";
ddSocialSecurityType.DataBind();
ddSocialSecurityType.SelectedValue =
EmployeeWelfareList[rowIndex + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.Type.Id.ToString
();
}
}
/// <summary>
/// 保存员工福利，有则更新，没有则新增
/// </summary>
/// <param name="employeeID">员工ID</param>
/// <param name="socialSecurityType">社保类型</param>
/// <param name="socialSecurityBase">社保基数</param>
/// <param name="socialSecurityEffectiveYearMonth">社保有效年月</param>
/// <param name="accumulationFundAccount">公积金帐号</param>
/// <param name="accumulationFundEffectiveYearMonth">公积金有效年月</param>
/// <param name="accumulationFundBase">公积金基数</param>
/// <param name="operationName">操作人姓名</param>
/// <param name="accumulationFundSupplyAccount"></param>
/// <returns>pkid</returns>
/// <param name="accumulationFundSupplyBase">补充公积金基数</param>
/// <param name="yangLaoBase">养老缴费基数</param>
/// <param name="shiYeBase">失业缴费基数</param>
/// <param name="yiLiaoBase">医疗缴费基数</param>
public int SaveEmployeeWelfare(int employeeID, SocialSecurityTypeEnum socialSecurityType,
decimal?socialSecurityBase, DateTime?socialSecurityEffectiveYearMonth,
string accumulationFundAccount, DateTime?accumulationFundEffectiveYearMonth,
decimal?accumulationFundBase, string operationName,
string accumulationFundSupplyAccount, decimal?accumulationFundSupplyBase,
decimal?yangLaoBase, decimal?shiYeBase, decimal?yiLiaoBase)
{
SaveEmployeeWelfare saveEmployeeWelfare =
new SaveEmployeeWelfare(employeeID, socialSecurityType, socialSecurityBase,
socialSecurityEffectiveYearMonth, accumulationFundAccount,
accumulationFundEffectiveYearMonth, accumulationFundBase, operationName,
accumulationFundSupplyAccount, accumulationFundSupplyBase,
yangLaoBase, shiYeBase, yiLiaoBase);
saveEmployeeWelfare.Excute();
return(saveEmployeeWelfare.EmployeeWelfareID);
}
/// <summary>
/// 保存员工福利信息构造函数
/// </summary>
public SaveEmployeeWelfare(int employeeID, SocialSecurityTypeEnum socialSecurityType,
decimal?socialSecurityBase, DateTime?socialSecurityEffectiveYearMonth,
string accumulationFundAccount, DateTime?accumulationFundEffectiveYearMonth,
decimal?accumulationFundBase, string operationName,
string accumulationFundSupplyAccount, decimal?accumulationFundSupplyBase,
decimal?yangLaoBase, decimal?shiYeBase, decimal?yiLiaoBase)
{
_EmployeeID = employeeID;
EmployeeSocialSecurity employeeSocialSecurity =
new EmployeeSocialSecurity(socialSecurityType, socialSecurityBase, socialSecurityEffectiveYearMonth,
yangLaoBase, shiYeBase, yiLiaoBase);
EmployeeAccumulationFund employeeAccumulationFund =
new EmployeeAccumulationFund(accumulationFundAccount, accumulationFundBase,
accumulationFundEffectiveYearMonth, accumulationFundSupplyAccount,
accumulationFundSupplyBase);
_EmployeeWelfare = new EmployeeWelfare(employeeSocialSecurity, employeeAccumulationFund);
_OperationName = operationName;
}
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();
}
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 void GetValueFromGridView()
{
for (int i = 0; i < gvEmployeeWelfare.Rows.Count; i++)
{
DropDownList ddSocialSecurityType =
(DropDownList)gvEmployeeWelfare.Rows[i].FindControl("ddSocialSecurityType");
if (ddSocialSecurityType != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.Type =
SocialSecurityTypeEnum.GetById(Convert.ToInt32(ddSocialSecurityType.SelectedValue));
}
TextBox txtSocialSecurityYear =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtSocialSecurityYear");
TextBox txtSocialSecurityMonth =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtSocialSecurityMonth");
TextBox txtAccumulationFundYear =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtAccumulationFundYear");
TextBox txtAccumulationFundMonth =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtAccumulationFundMonth");
TextBox txtSocialSecurityBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtSocialSecurityBase");
TextBox txtAccumulationFundAccount =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtAccumulationFundAccount");
TextBox txtAccumulationFundBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtAccumulationFundBase");
TextBox txtSupplyAccount =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtSupplyAccount");
TextBox txtSupplyBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtSupplyBase");
TextBox txtYangLaoBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtYangLaoBase");
TextBox txtShiYeBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtShiYeBase");
TextBox txtYiLiaoBase =
(TextBox)gvEmployeeWelfare.Rows[i].FindControl("txtYiLiaoBase");
if (txtSocialSecurityYear != null && txtSocialSecurityMonth != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.
EffectiveYearMonthTemp =
new List <string>(
new string[2] {
txtSocialSecurityYear.Text.Trim(), txtSocialSecurityMonth.Text.Trim()
});
}
if (txtAccumulationFundYear != null && txtAccumulationFundMonth != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].AccumulationFund.
EffectiveYearMonthTemp =
new List <string>(
new string[2] {
txtAccumulationFundYear.Text.Trim(), txtAccumulationFundMonth.Text.Trim()
});
}
if (txtSocialSecurityBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.BaseTemp =
txtSocialSecurityBase.Text.Trim();
}
if (txtAccumulationFundAccount != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].AccumulationFund.Account =
txtAccumulationFundAccount.Text.Trim();
}
if (txtAccumulationFundBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].AccumulationFund.BaseTemp =
txtAccumulationFundBase.Text.Trim();
}
if (txtSupplyAccount != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].AccumulationFund.
SupplyAccount =
txtSupplyAccount.Text.Trim();
}
if (txtSupplyBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].AccumulationFund.
SupplyBaseTemp =
txtSupplyBase.Text.Trim();
}
if (txtYangLaoBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.
YangLaoBaseTemp =
txtYangLaoBase.Text.Trim();
}
if (txtShiYeBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.ShiYeBaseTemp
=
txtShiYeBase.Text.Trim();
}
if (txtYiLiaoBase != null)
{
EmployeeWelfareListViewState[i + PageIndex * gvEmployeeWelfare.PageSize].SocialSecurity.YiLiaoBaseTemp
=
txtYiLiaoBase.Text.Trim();
}
}
}
