private void TemplateBuildStringWriter(Application excel)
{
excel.Cells[1, 1] = EmployeeWelfare.ConstParemeter.Name;
excel.Cells[1, 2] = EmployeeWelfare.ConstParemeter.SocialType;
excel.Cells[1, 3] = EmployeeWelfare.ConstParemeter.SocialBase;
excel.Cells[1, 4] = EmployeeWelfare.ConstParemeter.SocialYM;
excel.Cells[1, 5] = EmployeeWelfare.ConstParemeter.FundAccount;
excel.Cells[1, 6] = EmployeeWelfare.ConstParemeter.FundBase;
excel.Cells[1, 7] = EmployeeWelfare.ConstParemeter.FundYM;
excel.Cells[1, 8] = EmployeeWelfare.ConstParemeter.SupplyAccount;
excel.Cells[1, 9] = EmployeeWelfare.ConstParemeter.SupplyBase;
excel.Cells[1, 10] = EmployeeWelfare.ConstParemeter.YangLaoBase;
excel.Cells[1, 11] = EmployeeWelfare.ConstParemeter.ShiYeBase;
excel.Cells[1, 12] = EmployeeWelfare.ConstParemeter.YiLiaoBase;
for (int i = 0; i < EmployeeWelfareListViewState.Count; i++)
{
int j = i + 2;
excel.Cells[j, 1] = EmployeeWelfareListViewState[i].Owner.Name;
excel.Cells[j, 2] = EmployeeWelfareListViewState[i].SocialSecurity.Type.Name;
excel.Cells[j, 3] = EmployeeWelfareListViewState[i].SocialSecurity.Base;
if (EmployeeWelfareListViewState[i].SocialSecurity.EffectiveYearMonth != null)
{
List <string> SocialSecurityYearMonth =
EmployeeWelfare.YearAndMonth(EmployeeWelfareListViewState[i].SocialSecurity.EffectiveYearMonth);
excel.Cells[j, 4] =
string.Format("{0}年{1}月", SocialSecurityYearMonth[0], SocialSecurityYearMonth[1]);
}
excel.Cells[j, 5] = "'" + EmployeeWelfareListViewState[i].AccumulationFund.Account;
excel.Cells[j, 6] = EmployeeWelfareListViewState[i].AccumulationFund.Base;
if (EmployeeWelfareListViewState[i].AccumulationFund.EffectiveYearMonth != null)
{
List <string> AccumulationFundYearMonth =
EmployeeWelfare.YearAndMonth(EmployeeWelfareListViewState[i].AccumulationFund.EffectiveYearMonth);
excel.Cells[j, 7] =
string.Format("{0}年{1}月", AccumulationFundYearMonth[0], AccumulationFundYearMonth[1]);
}
excel.Cells[j, 8] = "'" + EmployeeWelfareListViewState[i].AccumulationFund.SupplyAccount;
excel.Cells[j, 9] = EmployeeWelfareListViewState[i].AccumulationFund.SupplyBase;
excel.Cells[j, 10] = EmployeeWelfareListViewState[i].SocialSecurity.YangLaoBase;
excel.Cells[j, 11] = EmployeeWelfareListViewState[i].SocialSecurity.ShiYeBase;
excel.Cells[j, 12] = EmployeeWelfareListViewState[i].SocialSecurity.YiLiaoBase;
}
}
private bool HandleWelfare()
{
if (_TheDataToBind.EmployeeWelfare != null)
{
_ItsView.AccumulationFundBase = _TheDataToBind.EmployeeWelfare.AccumulationFund.Base.ToString();
_ItsView.AccumulationFundAccount = _TheDataToBind.EmployeeWelfare.AccumulationFund.Account;
_ItsView.AccumulationFundSupplyAccount = _TheDataToBind.EmployeeWelfare.AccumulationFund.SupplyAccount;
_ItsView.AccumulationFundSupplyBase = _TheDataToBind.EmployeeWelfare.AccumulationFund.SupplyBase.ToString();
_ItsView.AccumulationFundYearMonth =
EmployeeWelfare.YearAndMonth(_TheDataToBind.EmployeeWelfare.AccumulationFund.EffectiveYearMonth);
_ItsView.SocialSecurityBase = _TheDataToBind.EmployeeWelfare.SocialSecurity.Base.ToString();
_ItsView.YangLaoBase = _TheDataToBind.EmployeeWelfare.SocialSecurity.YangLaoBase.ToString();
_ItsView.ShiYeBase = _TheDataToBind.EmployeeWelfare.SocialSecurity.ShiYeBase.ToString();
_ItsView.YiLiaoBase = _TheDataToBind.EmployeeWelfare.SocialSecurity.YiLiaoBase.ToString();
_ItsView.SocialSecurityType = _TheDataToBind.EmployeeWelfare.SocialSecurity.Type;
_ItsView.SocialSecurityYearMonth =
EmployeeWelfare.YearAndMonth(_TheDataToBind.EmployeeWelfare.SocialSecurity.EffectiveYearMonth);
}
_ItsView.EmployeeWelfareHistory = _TheDataToBind.EmployeeWelfareHistory;
return(true);
}
protected void btnExport_Click(object sender, EventArgs e)
{
var workbook = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
HSSFSheet sheet = workbook.CreateSheet() as HSSFSheet;
HSSFRow headerRow = sheet.CreateRow(0) as HSSFRow;
headerRow.CreateCell(0).SetCellValue(EmployeeWelfare.ConstParemeter.Name);
headerRow.CreateCell(1).SetCellValue(EmployeeWelfare.ConstParemeter.SocialType);
headerRow.CreateCell(2).SetCellValue(EmployeeWelfare.ConstParemeter.SocialBase);
headerRow.CreateCell(3).SetCellValue(EmployeeWelfare.ConstParemeter.SocialYM);
headerRow.CreateCell(4).SetCellValue(EmployeeWelfare.ConstParemeter.FundAccount);
headerRow.CreateCell(5).SetCellValue(EmployeeWelfare.ConstParemeter.FundBase);
headerRow.CreateCell(6).SetCellValue(EmployeeWelfare.ConstParemeter.FundYM);
headerRow.CreateCell(7).SetCellValue(EmployeeWelfare.ConstParemeter.SupplyAccount);
headerRow.CreateCell(8).SetCellValue(EmployeeWelfare.ConstParemeter.SupplyBase);
headerRow.CreateCell(9).SetCellValue(EmployeeWelfare.ConstParemeter.YangLaoBase);
headerRow.CreateCell(10).SetCellValue(EmployeeWelfare.ConstParemeter.ShiYeBase);
headerRow.CreateCell(11).SetCellValue(EmployeeWelfare.ConstParemeter.YiLiaoBase);
// handling value.
int rowIndex = 1;
for (int i = 0; i < EmployeeWelfareListViewState.Count; i++)
{
HSSFRow dataRow = sheet.CreateRow(rowIndex) as HSSFRow;
dataRow.CreateCell(0).SetCellValue(EmployeeWelfareListViewState[i].Owner.Name);
dataRow.CreateCell(1).SetCellValue(EmployeeWelfareListViewState[i].SocialSecurity.Type.Name);
dataRow.CreateCell(2).SetCellValue(EmployeeWelfareListViewState[i].SocialSecurity.Base.ToString());
if (EmployeeWelfareListViewState[i].SocialSecurity.EffectiveYearMonth != null)
{
List <string> SocialSecurityYearMonth =
EmployeeWelfare.YearAndMonth(EmployeeWelfareListViewState[i].SocialSecurity.EffectiveYearMonth);
dataRow.CreateCell(3).SetCellValue(string.Format("{0}年{1}月", SocialSecurityYearMonth[0], SocialSecurityYearMonth[1]));
}
dataRow.CreateCell(4).SetCellValue(EmployeeWelfareListViewState[i].AccumulationFund.Account);
dataRow.CreateCell(5).SetCellValue(EmployeeWelfareListViewState[i].AccumulationFund.Base.ToString());
if (EmployeeWelfareListViewState[i].AccumulationFund.EffectiveYearMonth != null)
{
List <string> AccumulationFundYearMonth =
EmployeeWelfare.YearAndMonth(EmployeeWelfareListViewState[i].AccumulationFund.EffectiveYearMonth);
dataRow.CreateCell(6).SetCellValue(string.Format("{0}年{1}月", AccumulationFundYearMonth[0], AccumulationFundYearMonth[1]));
}
dataRow.CreateCell(7).SetCellValue(EmployeeWelfareListViewState[i].AccumulationFund.SupplyAccount);
dataRow.CreateCell(8).SetCellValue(EmployeeWelfareListViewState[i].AccumulationFund.SupplyBase.ToString());
dataRow.CreateCell(9).SetCellValue(EmployeeWelfareListViewState[i].SocialSecurity.YangLaoBase.ToString());
dataRow.CreateCell(10).SetCellValue(EmployeeWelfareListViewState[i].SocialSecurity.ShiYeBase.ToString());
dataRow.CreateCell(11).SetCellValue(EmployeeWelfareListViewState[i].SocialSecurity.YiLiaoBase.ToString());
rowIndex++;
}
workbook.Write(ms);
ms.Flush();
ms.Position = 0;
sheet = null;
headerRow = null;
workbook = null;
ExcelExportUtility.OutputExcel(Server, Response, "员工福利表", ms);
// Export("员工福利表.xls");
}
private void SearchEmployeeWelfare()
{
try
{
List <EmployeeWelfare> employeeWelfarelist = new List <EmployeeWelfare>();
//List<Employee> employeeList =
// _IEmployeeFacade.GetEmployeeBasicInfoByBasicCondition(_View.EmployeeName, _View.EmployeeType,
// _View.PositionId, _View.DepartmentId,
// _View.RecursionDepartment,
// Convert.ToInt32(_View.EmployeeStatusId),
// _View.CompanyId);
//employeeList =
// HrmisUtility.RemoteUnAuthEmployee(employeeList, AuthType.HRMIS, _Operator, HrmisPowers.A605);
List <Employee> employeeList =
EmployeeLogic.GetEmployeeBasicInfoByBasicConditionRetModel(_View.EmployeeName, _View.EmployeeType,
_View.PositionId, null,
_View.DepartmentId, _View.CompanyId, _View.RecursionDepartment, HrmisPowers.A605, _Operator.Id,
Convert.ToInt32(_View.EmployeeStatusId), null);
if (employeeList != null)
{
foreach (Employee employee in employeeList)
{
EmployeeWelfare welfare =
_IEmployeeWelfareFacade.GetEmployeeWelfareByAccountID(employee.Account.Id);
if (welfare == null)
{
welfare = EmployeeWelfare.EmptyWelfare();
}
welfare.AccumulationFund.BaseTemp = welfare.AccumulationFund.Base == null
? ""
: welfare.AccumulationFund.Base.ToString();
welfare.AccumulationFund.SupplyBaseTemp = welfare.AccumulationFund.SupplyBase == null
? ""
: welfare.AccumulationFund.SupplyBase.ToString();
welfare.SocialSecurity.BaseTemp = welfare.SocialSecurity.Base == null
? ""
: welfare.SocialSecurity.Base.ToString();
welfare.SocialSecurity.YangLaoBaseTemp = welfare.SocialSecurity.YangLaoBase == null
? ""
: welfare.SocialSecurity.YangLaoBase.ToString();
welfare.SocialSecurity.ShiYeBaseTemp = welfare.SocialSecurity.ShiYeBase == null
? ""
: welfare.SocialSecurity.ShiYeBase.ToString();
welfare.SocialSecurity.YiLiaoBaseTemp = welfare.SocialSecurity.YiLiaoBase == null
? ""
: welfare.SocialSecurity.YiLiaoBase.ToString();
welfare.AccumulationFund.EffectiveYearMonthTemp =
EmployeeWelfare.YearAndMonth(welfare.AccumulationFund.EffectiveYearMonth);
welfare.SocialSecurity.EffectiveYearMonthTemp =
EmployeeWelfare.YearAndMonth(welfare.SocialSecurity.EffectiveYearMonth);
welfare.Owner = employee.Account;
employeeWelfarelist.Add(welfare);
}
}
_View.EmployeeWelfareList = employeeWelfarelist;
_View.Message =
string.Format(
"<span class='font14b'>共查到 </span><span class='fontred'>{0}</span><span class='font14b'> 条信息</span>",
employeeList == null ? 0 : employeeList.Count);
}
catch (Exception ex)
{
_View.Message = string.Format("<span class='fontred'>{0}</span>", ex.Message);
}
}