Пример #1
0
 private void SetSampleCell(ExcelRange range, string value, ShiftType?type)
 {
     range.Value = value;
     SetColor(range, Shift.GetColor(type));
 }
Пример #2
0
        public void WritetoFile()
        {
            var name = OutputPath == string.Empty ?
                       string.Format(OutputName, CurrentDate.ToString().Replace("/", "-")) :
                       string.Format(OutputPath + "/" + OutputName, CurrentDate.ToString().Replace("/", "-"));
            FileInfo       output = new FileInfo(name);
            ExcelWorksheet worksheet;

            if (output.Exists)
            {
                output.Delete();
            }

            using (ExcelPackage package = new ExcelPackage(output))
            {
                try
                {
                    int startI = 1; int startJ = 2;
                    worksheet = package.Workbook.Worksheets.Add("تعداد تماسهای خارجی");
                    var start = StartObservation;
                    var end   = EndObservation;
                    int j     = startJ;
                    while (start < end)
                    {
                        worksheet.Cells[startI, j].Value = start.ToString(@"hh\:mm");
                        j++;
                        start = start.Add(Duration);
                    }

                    int i = startI + 1;

                    foreach (var employee in Employees)
                    {
                        j = startJ;
                        var list = OutboundCountList[employee.Number];
                        worksheet.Cells[i, j - 1].Value = employee.Number;
                        foreach (var item in list)
                        {
                            if (item.Count != 0)
                            {
                                worksheet.Cells[i, j].Value = item.Count;
                                SetColor(worksheet.Cells[i, j], Shift.GetColor(item.Type));
                            }
                            j++;
                        }
                        i++;
                    }

                    //worksheet.Cells[2, 3, 2, 5].Merge = true;
                    //worksheet.Cells[2, 3, 2, 5].Value = string.Format("روز: {0}", CurrentDate.ToString());
                    SetColor(worksheet.Cells[startI, startJ - 1, startI, j - 1], Color.LightGray);
                    SetColor(worksheet.Cells[startI, startJ - 1, startI + Employees.Count, startJ - 1], Color.LightGray);

                    SetBorder(worksheet.Cells[startI + Employees.Count + 2, startJ - 1, startI + Employees.Count + 4, startJ - 1]);
                    SetSampleCell(worksheet.Cells[startI + Employees.Count + 2, startJ - 1], "Reyhoon", ShiftType.D);
                    SetSampleCell(worksheet.Cells[startI + Employees.Count + 3, startJ - 1], "Other Shifts", ShiftType.None);
                    SetSampleCell(worksheet.Cells[startI + Employees.Count + 4, startJ - 1], "None", null);

                    SetBorder(worksheet.Cells[startI, startJ - 1, startI + Employees.Count, j - 1]);
                    //SetBorder(worksheet.Cells[2, 3, 2, 5]);
                    worksheet.View.RightToLeft                = true;
                    worksheet.Cells.Style.ReadingOrder        = ExcelReadingOrder.RightToLeft;
                    worksheet.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
                    worksheet.Cells.Style.VerticalAlignment   = ExcelVerticalAlignment.Center;
                    package.Save();
                }
                catch (Exception e)
                {
                    throw new Exception("Error in writing output File\n" + e.Message);
                }
            }
        }