コード例 #1
0
        public void Export(string folderPath, string startDtts, string endDtts)
        {
            var exportStartedArgs = new ExportStartedEventHandlerArgs();

            exportStartedArgs.folderPath   = folderPath;
            exportStartedArgs.mainModelNum = this.spcModelDataExports.Count;
            exportStartedEvent(this, exportStartedArgs);

            string[] fileName = new string[spcModelDataExports.Count];

            //파일명 유효성 검사
            for (int i = 0; i < spcModelDataExports.Count; i++)
            {
                fileName[i] = spcModelDataExports[i].SPCModelName;
                foreach (char ch in System.IO.Path.GetInvalidFileNameChars())
                {
                    if (spcModelDataExports[i].SPCModelName.Contains(ch.ToString()))
                    {
                        string[] str = fileName[i].Split(ch);
                        fileName[i] = string.Join("", str);
                    }
                }

                //foreach (char ch in System.IO.Path.GetInvalidFileNameChars())
                //{
                //    this.controller.spcModelDataExports[i].SPCModelName = this.controller.spcModelDataExports[i].SPCModelName.Replace(ch, '_');
                //}
            }

            if (!folderPath.EndsWith(@"\"))
            {
                folderPath += @"\";
            }

            string dateTime  = DateTime.Now.ToString("yyyyMMddHHmmss");
            int    iTotalCnt = 0;

            for (int i = 0; i < spcModelDataExports.Count; i++)
            {
                spcModelDataExports[i].modelExportCompletedEvent    -= export_modelExportCompletedEvent;
                spcModelDataExports[i].subModelExportCompletedEvent -= export_subModelExportCompletedEvent;
                spcModelDataExports[i].modelExportStartedEvent      -= DataExportController_modelExportStartedEvent;

                spcModelDataExports[i].modelExportCompletedEvent    += export_modelExportCompletedEvent;
                spcModelDataExports[i].subModelExportCompletedEvent += export_subModelExportCompletedEvent;
                spcModelDataExports[i].modelExportStartedEvent      += DataExportController_modelExportStartedEvent;

                string filePath = folderPath + fileName[i] + "_" + dateTime + ".xls";
                iTotalCnt += spcModelDataExports[i].Export(filePath, startDtts, endDtts);
            }

            var exportCompletedArgs = new ExportCompletedEventHandlerArgs();

            exportCompletedArgs.exportedModelNum = iTotalCnt;
            exportCompletedEvent(this, exportCompletedArgs);
        }
コード例 #2
0
        void DataExportUC_exportCompletedEvent(object sender, ExportCompletedEventHandlerArgs e)
        {
            if (e.exportedModelNum == 0)
            {
                MSGHandler.DisplayMessage(MSGType.Information, "SPC_INFO_EXPORT_DATA_NOT_EXIST", null, null);
            }
            else
            {
                MSGHandler.DisplayMessage(MSGType.Information, "SPC_INFO_EXPORT_COMPLETE", null, null);
            }


            if (exportCompletedEventHandler != null)
            {
                exportCompletedEventHandler(sender, e);
            }
        }