Пример #1
0
        /// <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);
        }
Пример #2
0
        /// <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);
        }