private void btnExport_Click(object sender, RoutedEventArgs e)
{
// ispaging = false;
dialog.DefaultExt = ".xls";
dialog.Filter = "MS Excel Files|*.xls";
dialog.FilterIndex = 1;
result = dialog.ShowDialog();
if (result.Value == true)
{
string filter = "";
System.Collections.ObjectModel.ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>();
if (StrCompanyIDsList.Count() > 0)
{
StrCompanyIDsList.ForEach(item =>
{
if (!string.IsNullOrEmpty(filter))
{
filter += " or ";
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
else
{
filter += " OWNERCOMPANYID==@" + paras.Count().ToString();
paras.Add(item);
}
});
}
DateTime dtLandStart = new DateTime();
DateTime dtLandEnd = new DateTime();
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandStart);
DateTime.TryParse(nuYear.Value.ToString() + "-" + nuMonth.Value.ToString() + "-1", out dtLandEnd);
dtLandEnd = dtLandEnd.AddMonths(1);
//if (string.IsNullOrEmpty(filter))
//{
// filter += " CREATEDATE >= @" + paras.Count().ToString();
// paras.Add(dtLandStart);
//}
//else
//{
// filter += " and CREATEDATE >= @" + paras.Count().ToString();
// paras.Add(dtLandStart);
//}
//filter += " and CREATEDATE < @" + paras.Count().ToString();
//paras.Add(dtLandEnd);
loadbar.Start();
switch (ReportsType)
{
case "1":
break;
case "2":
personClient.ExportEmployeeTructReportsAsync(StrCompanyIDsList, "CREATEDATE", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
break;
case "3":
personClient.ExportEmployeeCollectsReportsAsync("", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart, dtLandEnd);
break;
case "4":
sValue = StrCompanyIDsList.FirstOrDefault();
client.ExportEmployeePensionReportsAsync("COMPANYNAME", filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sValue, dtLandStart);
break;
default:
//personClient.GetEmployeeBasicInfosByCompanyAsync(dataPager.PageIndex, dataPager.PageSize, "POSTNAME", filter, paras, pageCount, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType, sValue);
//personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(StrCompanyIDsList, "CREATEDATE",filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, sType);
if (ListInfos != null)
{
personClient.ExportEmployeeBasicInfosNoGetReportsAsync(ListInfos, dtLandStart, StrCompanyIDsList);
}
else
{
//personClient.ExportEmployeeBasicInfosByCompanyReportsAsync(
}
break;
}
//personClient.ExportEmployeesIntimeAsync(dataPager.PageIndex, dataPager.PageSize, "DepartmentName",
// filter, paras, pageCount, sType, sValue, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
}
}