Beispiel #1
0
 public static void SaveWorkScheduleTemplate(string targetFullPathFile)
 {
     try
     {
         WorkScheduleData.SaveWorkScheduleTemplate(targetFullPathFile);
         Data.WorkSchedule.ImportableWorkScheduleData.UpdateWorkScheduleSheets(targetFullPathFile, WorkScheduleBusiness.GetParameter(Properties.Settings.Default.PASSWORD_KEY_NAME));
     }
     catch (Exception exception)
     {
         logger.Error(exception);
         throw exception;
     }
 }
Beispiel #2
0
        private static void UpdateSheets(IExcelDataProvider appXlsProvider)
        {
            List <string> sheetNamesList = new List <string>()
            {
                Properties.Settings.Default.SHEET_NAME_STATION,
                Properties.Settings.Default.SHEET_NAME_UNIT,
                Properties.Settings.Default.SHEET_NAME_EMPLOYEE
            };

            foreach (string sheet in sheetNamesList)
            {
                DataTable dt = WorkScheduleData.GetDataTableToFillWorkScheduleSheet(sheet);
                appXlsProvider.WriteSheet(sheet, dt);
            }
        }