Esempio n. 1
0
        public bool UpdateToExcel(ESubmit ESubmit, ExcelPackage excelPackage, ref string Notes)
        {
            DateTime Time        = ESubmit.Date;
            int      currentHour = Time.Hour;
            int      Area_Id     = ESubmit.AreaId;
            int      Person_Id   = ESubmit.PersonId;

            try
            {
                var ECheckPerson = Data_Services.Get_CheckPerson(Person_Id);

                ExcelWorksheet currentSheet = excelPackage.Workbook.Worksheets[Area_Id];

                int        currentTime     = 0;
                bool       reset_note_text = false;
                ExcelRange NoteCell;

                for (int checkItem = 0; checkItem < ESubmit.ECheckingDailys.Count; checkItem++)
                {
                    bool add_note = false;
                    for (int timeLine = 0; timeLine < 12; timeLine++)
                    {
                        if (currentHour == 0 && timeLine == 0)
                        {
                            currentTime = 0;
                            if (!reset_note_text)
                            {
                                currentSheet.Cells[ESubmit.ECheckingDailys.Count + 6, currentTime].Value = "";
                            }


                            reset_note_text = true;
                            if (ESubmit.ECheckingDailys[checkItem].Status == 0xFF)
                            {
                                currentSheet.Cells[checkItem + 5, 1].Value           = "X";
                                currentSheet.Cells[checkItem + 5, 1].Style.Font.Bold = true;

                                currentSheet.Cells[checkItem + 5, 2].Value = string.Empty;
                            }
                            else
                            {
                                currentSheet.Cells[checkItem + 5, 1].Value = string.Empty;

                                currentSheet.Cells[checkItem + 5, 2].Value           = "X";
                                currentSheet.Cells[checkItem + 5, 2].Style.Font.Bold = true;
                                add_note = true;
                            }
                        }
                        else
                        {
                            bool update = false;
                            if (currentHour / 2 == timeLine)
                            {
                                currentTime = timeLine * 2 + 2;
                                update      = true;
                            }
                            else
                            if (currentHour == timeLine * 2 + 1)
                            {
                                currentTime = timeLine * 2 + 1;
                                update      = true;
                            }

                            if (update)
                            {
                                if (!reset_note_text)
                                {
                                    currentSheet.Cells[ESubmit.ECheckingDailys.Count + 6, currentTime].Value = "";
                                }
                                reset_note_text = true;

                                if (ESubmit.ECheckingDailys[checkItem].Status == 0xFF)
                                {
                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Value           = "X";
                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Style.Font.Bold = true;

                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Value = string.Empty;
                                }
                                else
                                {
                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 2].Value = string.Empty;

                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Value           = "X";
                                    currentSheet.Cells[checkItem + 5, timeLine * 2 + 1 + 2].Style.Font.Bold = true;
                                    add_note = true;
                                }
                            }
                        }
                    }

                    if (add_note)
                    {
                        add_note = false;
                        int?note = ESubmit.ECheckingDailys[checkItem].ECheckNotesId;
                        if (note != null)
                        {
                            var ENote = Data_Services.Get_ECheckNote((int)note);

                            NoteCell = currentSheet.Cells[ESubmit.ECheckingDailys.Count + 6, 2];

                            string text = Notes;

                            text           = $"{text}  [{ESubmit.Date.ToString("HH:mm")}->{ENote.NoteName}]";
                            NoteCell.Value = text;
                            Notes          = text;
                        }
                    }
                }


                if (ECheckPerson != null)
                {
                    currentSheet.Cells[ESubmit.ECheckingDailys.Count + 5, currentTime].Value = ECheckPerson.Name;
                }

                excelPackage.Save();
                return(true);
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
Esempio n. 2
0
        public string Update_Database(ECheckSubmit AreaData)
        {
            string        Excp          = string.Empty;
            Data_Services Data_Services = new Data_Services(DataContext);

            try
            {
                var area = Data_Services.Get_ECheckArea(AreaData.Area_Id);

                if (area == null)
                {
                    return($"Can not find aread with id {AreaData.Area_Id}");
                }

                if (area.ECheckings.Count != AreaData.CheckItems.Count)
                {
                    return($"Total items not equal");
                }

                var person = Data_Services.Get_CheckPerson(AreaData.CheckPerson_Id);
                if (person == null)
                {
                    return($"Can not find person Id: {AreaData.CheckPerson_Id}");
                }


                ESubmit ESubmit = new ESubmit
                {
                    AreaId     = area.id,
                    PersonId   = person.id,
                    Date       = DateTime.Now,
                    UpdateTime = DateTime.Now.ToString("hh:mm tt, dd/MM/yy"),
                };

                // update new esubmit
                Data_Services.Update_ESubmit(ESubmit);

                foreach (var item in AreaData.CheckItems)
                {
                    var CheckItem = Data_Services.Get_ECheckItem(item.Item);

                    var submit_data = new ECheckingDaily
                    {
                        ECheckAreaCode   = area.AreaCode,
                        ECheckAreaId     = area.id,
                        ECheckItemId     = CheckItem.id,
                        ECheckItemCode   = CheckItem.ECheckItemCode,
                        Status           = item.Status,
                        Time             = DateTime.Now,
                        CheckingPersonId = person.id,
                        ESubmitId        = ESubmit.Id,
                    };

                    if (item.Status == 0x00)
                    {
                        submit_data.ECheckNotesId = item.Note;
                    }

                    if (!Data_Services.Update_ECheckDaily(submit_data))
                    {
                        Excp = $"Error when add item {item.Item} to database";
                    }
                }

                return(Excp);
            }
            catch (Exception ex)
            { return(ex.ToString()); }
        }