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);
}
}
