Example #1
0
        private void btn_Search_Click(object sender, EventArgs e)
        {
            if (this.comboBoxEditYear.EditValue == null)
            {
                MessageBox.Show("年份不能為空!", "提示", MessageBoxButtons.OK);
                return;
            }
            this.helpLeaveList.Clear();
            foreach (var item in emplist)
            {
                this.helpLeave           = new HelpLeave();
                helpLeave.DepartmentName = item.Department.DepartmentName;
                helpLeave.EmployeeName   = item.EmployeeName;
                helpLeave.JoinDate       = item.EmployeeJoinDate.HasValue ? item.EmployeeJoinDate.Value.ToString("yyyy-MM-dd") : "";
                helpLeave.LeaveNote      = this.manager.SelectYearLeaveCount(item.EmployeeId, Convert.ToInt32(this.comboBoxEditYear.EditValue));
                if (helpLeave.LeaveNote != null)
                {
                    helpLeave.LeaveNote = helpLeave.LeaveNote.Substring(0, helpLeave.LeaveNote.Length - 1);
                    //helpLeave.LeaveNote = helpLeave.LeaveNote.Replace(",", "\r");
                }
                this.helpLeaveList.Add(this.helpLeave);
            }

            this.bindingSource1.DataSource = this.helpLeaveList;
            this.gridControl1.RefreshDataSource();
        }
Example #2
0
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (helpLeaveList != null && helpLeaveList.Count != 0)
            {
                //休假類別
                IList <string> leaveType = manager.SelectLeaveName();

                Type objClassType = null;
                objClassType = Type.GetTypeFromProgID("Excel.Application");
                if (objClassType == null)
                {
                    MessageBox.Show("本機沒有安裝Excel", "提示!", MessageBoxButtons.OK);
                    return;
                }

                Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
                excel.Application.Workbooks.Add(true);
                excel.Rows.RowHeight      = 15;
                excel.Columns.ColumnWidth = 8;
                ((Microsoft.Office.Interop.Excel.Range)excel.get_Range(excel.Cells[2, 1], excel.Cells[2, 2])).ColumnWidth = 20;
                ((Microsoft.Office.Interop.Excel.Range)excel.Cells[1, 1]).Value2 = "年份:" + this.comboBoxEditYear.Text;
                ((Microsoft.Office.Interop.Excel.Range)excel.get_Range(excel.Cells[1, 1], excel.Cells[1, 2])).MergeCells = true;

                ((Microsoft.Office.Interop.Excel.Range)excel.get_Range(excel.Cells[2, 1], excel.Cells[2, leaveType.Count + 2])).Interior.ColorIndex = 15;
                //((Microsoft.Office.Interop.Excel.Range)excel.get_Range(excel.Cells[2, 2], excel.Cells[helpLeaveList.Count + 2, 2])).WrapText = true;
                ((Microsoft.Office.Interop.Excel.Range)excel.get_Range(excel.Cells[1, 1], excel.Cells[helpLeaveList.Count + 2, leaveType.Count + 2])).Borders.LineStyle = XlLineStyle.xlContinuous;

                //for (int i = 0; i < helpLeaveList.Count; i++)
                //{
                //    ((Microsoft.Office.Interop.Excel.Range)excel.Cells[i + 3, 1]).Value2 = helpLeaveList[i].EmployeeName;
                //    ((Microsoft.Office.Interop.Excel.Range)excel.Cells[i + 3, 2]).Value2 = helpLeaveList[i].LeaveNote;
                //}

                //表头
                ((Microsoft.Office.Interop.Excel.Range)excel.Cells[2, 1]).Value2 = "部門";
                ((Microsoft.Office.Interop.Excel.Range)excel.Cells[2, 2]).Value2 = "員工姓名(到職日期)";
                for (int i = 0; i < leaveType.Count; i++)
                {
                    ((Microsoft.Office.Interop.Excel.Range)excel.Cells[2, i + 3]).Value2 = leaveType[i];
                }

                for (int i = 0; i < helpLeaveList.Count; i++)
                {
                    HelpLeave helpLeave = helpLeaveList[i];

                    //數據從第三行開始
                    ((Microsoft.Office.Interop.Excel.Range)excel.Cells[i + 3, 1]).Value2 = helpLeave.DepartmentName;
                    ((Microsoft.Office.Interop.Excel.Range)excel.Cells[i + 3, 2]).Value2 = helpLeave.EmployeeName + string.Format("({0})", helpLeave.JoinDate);

                    string[] leaveArray = helpLeave.LeaveNote.Split(',');
                    for (int j = 0; j < leaveType.Count; j++)
                    {
                        string leave = leaveArray.FirstOrDefault(l => l.StartsWith(leaveType[j]));
                        string days  = new string(leave.ToCharArray().Where(c => char.IsDigit(c) || c == '.').ToArray());
                        ((Microsoft.Office.Interop.Excel.Range)excel.Cells[i + 3, j + 3]).Value2 = days;
                    }
                }

                excel.Visible = true;
            }
            else
            {
                MessageBox.Show("請先進行查詢!", "提示", MessageBoxButtons.OK);
                return;
            }
        }