private void Sheet_Info_Sheet_Data(DataTable tTempData, string ORDER_ID) //추가 { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); // _pMaterialInspectRegisterEntity.ORDER_ID = _luORDER_ID.Text.ToString(); IWorkbook workbook = _sdMAIN.Document; string _pPART_CODE = tTempData.Rows[0]["PART_CODE"].ToString(); using (DBManager pDBManager = new DBManager()) { _pucWorkOrderInfoPopup_T50Entity.PRODUCTION_ORDER_ID = ORDER_ID; _pucWorkOrderInfoPopup_T50Entity.PART_CODE = _pPART_CODE; _dsList = new ucWorkOrderInfoPopup_T50Provider(pDBManager).ucWorkOrderPopup_info_ExcelBinding(_pucWorkOrderInfoPopup_T50Entity); ////생산지시정보 및 제품정보 _dtList2 = _dsList.Tables[0]; //자재정보 _dtList3 = _dsList.Tables[1]; if (_dtList2 != null && _dtList2.Rows.Count > 0) { Worksheet sheet_1 = workbook.Worksheets[1]; Worksheet sheet_0 = workbook.Worksheets[0]; Range data_range = sheet_1.GetDataRange(); sheet_1.Clear(data_range); ExternalDataSourceOptions dsOptions = new ExternalDataSourceOptions(); dsOptions.ImportHeaders = false; //당일 날짜, 로그인명 sheet_0.Cells["G1"].Value = DateTime.Today.ToString("yyyy.MM.dd"); sheet_0.Cells["G3"].Value = _pUSER_CODE; //바코드정보 sheet_0.Cells["C5"].Value = "*" + ORDER_ID + "*";//"*WO190131000001*"; int i = 0; int j = 0; //라우팅정보 for 엑셀은 0부터 시작 for (i = 0; i < _dtList2.Rows.Count; i++) { string seq = ""; seq = _dtList2.Rows[i]["SEQ"].ToString(); sheet_0.Rows[6][2].Value = " " + _dtList2.Rows[i]["PART_CODE"].ToString(); sheet_0.Rows[7][2].Value = " " + _dtList2.Rows[i]["PART_NAME"].ToString(); sheet_0.Rows[11][i].Value = seq; sheet_0.Rows[12][i].Value = _dtList2.Rows[i]["PROCESS_CODE"].ToString(); sheet_0.Rows[13][i].Value = _dtList2.Rows[i]["PROCESS_GUBUN"].ToString(); sheet_0.Rows[14][i].Value = _dtList2.Rows[i]["PROCESS_NAME"].ToString(); sheet_0.Rows[16][0].Value = _dtList2.Rows[0]["CARVE"].ToString(); sheet_0.Rows[22][0].Value = _dtList2.Rows[0]["MESSAGE"].ToString(); } if (_dtList3 != null && _dtList3.Rows.Count > 0) { for (j = 0; j < _dtList3.Rows.Count; j++) { sheet_0.Rows[8][2].Value = " " + _dtList3.Rows[j]["PART_CODE"].ToString(); sheet_0.Rows[9][2].Value = " " + _dtList3.Rows[j]["PART_NAME"].ToString(); } } else { CoFAS_DevExpressManager.ShowInformationMessage("BOM 정보를 불러오지 못했습니다."); } } else { CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); } } workbook.Worksheets.ActiveWorksheet = workbook.Worksheets[0]; _sdMAIN.ShowPrintPreview(); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }