/// <summary>
/// 导出员工薪资档案变更新记录
/// </summary>
/// <param name="sender">sender</param>
/// <param name="e">e</param>
void btnExportArchive_Click(object sender, RoutedEventArgs e)
{
dialog.DefaultExt = ".xls";
dialog.Filter = "MS Excel Files|*.xls";
dialog.FilterIndex = 1;
result = dialog.ShowDialog();
if (result.Value == true)
{
string strEmployeeName = string.Empty, strSortKey = string.Empty, strOwnerID = string.Empty, strCheckState = string.Empty;
//当前登录人ID
strOwnerID = Common.CurrentLoginUserInfo.EmployeeID;
//排序字段
strSortKey = "EMPLOYEENAME,OTHERSUBJOIN,OTHERADDDEDUCT";
loadbar.Start();
string filter = string.Empty;
int sType = 0;
string sValue = string.Empty;
System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>();
string selectedType = treeOrganization.sType;
if (!string.IsNullOrEmpty(selectedType))
{
switch (selectedType)
{
case "Company":
sType = 0;
break;
case "Department":
sType = 1;
break;
case "Post":
sType = 2;
break;
}
sValue = treeOrganization.sValue;
}
else
{
loadbar.Stop();
return;
}
TextBox txtName = Utility.FindChildControl <TextBox>(expander, "txtName");
if (txtName != null && !string.IsNullOrWhiteSpace(txtName.Text))
{
filter += " @" + paras.Count().ToString() + ".Contains(EMPLOYEENAME)";
paras.Add(txtName.Text);
}
ComboBox cmbUsable = Utility.FindChildControl <ComboBox>(expander, "cmbUsable");
//查询码0:有效 1：历史
int queryCode = 0;
string companyID = null;
if (cmbUsable != null && (string)cmbUsable.SelectionBoxItem == "有效")
{
queryCode = 0;
if (treeOrganization != null)
{
companyID = treeOrganization.sValue;
}
}
else
{
queryCode = 1;
companyID = null;
}
client.ExportSalaryArchiveAsync(strSortKey, filter, paras, userID, Checkstate, sType, sValue, queryCode, companyID);
}
}