/// <summary> /// 导出员工档案 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnOutExcel_Click(object sender, RoutedEventArgs e) { //Form.Personnel.OutExcelEmployeeForm form = new Form.Personnel.OutExcelEmployeeForm(); //form.Show<string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => { }); dialog.Filter = "MS Excel Files|*.xls"; dialog.FilterIndex = 1; result = dialog.ShowDialog(); string sType = "", sValue = ""; sType = treeOrganization.sType; sValue = treeOrganization.sValue; if (sType != "Company") { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("SELECTCOMPANY"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } string companyID = sValue; client.ExportEmployeeAsync(companyID); }
/// <summary> /// 导出员工档案 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnOutExcel_Click(object sender, RoutedEventArgs e) { //Form.Personnel.OutExcelEmployeeForm form = new Form.Personnel.OutExcelEmployeeForm(); //form.Show<string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => { }); dialog.Filter = "MS Excel Files|*.xls"; dialog.FilterIndex = 1; result = dialog.ShowDialog(); string sType = "", sValue = ""; sType = treeOrganization.sType; sValue = treeOrganization.sValue; if (sType != "Company") { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("SELECTCOMPANY"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } string filter = ""; System.Collections.ObjectModel.ObservableCollection <string> paras = new System.Collections.ObjectModel.ObservableCollection <string>(); TextBox txtEmpName = Utility.FindChildControl <TextBox>(expander, "txtEmpName"); TextBox txtEmpCode = Utility.FindChildControl <TextBox>(expander, "txtEmpCode"); ComboBox cbxstate = Utility.FindChildControl <ComboBox>(expander, "cbxEmployeeState"); if (txtEmpCode != null) { if (!string.IsNullOrEmpty(txtEmpCode.Text.Trim())) { //filter += "EMPLOYEECODE==@" + paras.Count().ToString(); filter += " @" + paras.Count().ToString() + ".Contains(EmployeeCode)"; paras.Add(txtEmpCode.Text.Trim()); } } if (txtEmpName != null) { if (!string.IsNullOrEmpty(txtEmpName.Text.Trim())) { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += " @" + paras.Count().ToString() + ".Contains(EmployeeName)"; paras.Add(txtEmpName.Text.Trim()); } } Employeestate statetmp = cbxstate.SelectedItem as Employeestate; if (statetmp.Value == "0") { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += " @EmployeeState!=\"2\" "; } else { if (!string.IsNullOrEmpty(filter)) { filter += " and "; } filter += " @EmployeeState==\"2\" "; } string companyID = sValue; client.ExportEmployeeAsync(companyID, filter, paras, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); }