private void _sdMAIN_CellBeginEdit(object sender, SpreadsheetCellCancelEventArgs e) { try { //제조 if ((_pucWorkOrderDocRegPopupEntity.PROCESS_CODE_MST == "PC01") || _pucWorkOrderDocRegPopupEntity.PROCESS_CODE_MST == "PT040001") { //제조년월일 //if (((e.RowIndex == 4)) && ((7 < e.ColumnIndex) && (e.ColumnIndex < 11))) if (((5 < e.RowIndex) && (e.RowIndex < 8)) && ((9 < e.ColumnIndex) && (e.ColumnIndex < 13))) { IWorkbook workbook = _sdMAIN.Document; Worksheet sheet_0 = workbook.Worksheets[0]; // 팝업에 파라미터 전송 CoFAS_MES.UI.IM.UserForm.frmCommonPopup.USER_CODE = _pUSER_CODE; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.FONT_TYPE = fntPARENT_FONT; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.ARRAY_CODE = new object[4] { "", "", "", "" }; CoFAS_MES.UI.IM.UserForm.frmCommonPopup xfrmCommonPopup = new CoFAS_MES.UI.IM.UserForm.frmCommonPopup("Calendar_T01"); //유저컨트롤러 설정 부분 xfrmCommonPopup.ShowDialog(); if (xfrmCommonPopup.dtReturn == null) { xfrmCommonPopup.Dispose(); return; } if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0) { sheet_0.Cells[6, 10].SetValue(xfrmCommonPopup.dtReturn.Rows[0]["DATE"].ToString()); } xfrmCommonPopup.Dispose(); } //계량년월일 if (((5 < e.RowIndex) && (e.RowIndex < 8)) && ((7 < e.ColumnIndex) && (e.ColumnIndex < 10))) { IWorkbook workbook = _sdMAIN.Document; Worksheet sheet_0 = workbook.Worksheets[0]; // 팝업에 파라미터 전송 CoFAS_MES.UI.IM.UserForm.frmCommonPopup.USER_CODE = _pUSER_CODE; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.FONT_TYPE = fntPARENT_FONT; CoFAS_MES.UI.IM.UserForm.frmCommonPopup.ARRAY_CODE = new object[4] { "", "", "", "" }; CoFAS_MES.UI.IM.UserForm.frmCommonPopup xfrmCommonPopup = new CoFAS_MES.UI.IM.UserForm.frmCommonPopup("Calendar_T01"); //유저컨트롤러 설정 부분 xfrmCommonPopup.ShowDialog(); if (xfrmCommonPopup.dtReturn == null) { xfrmCommonPopup.Dispose(); return; } if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0) { sheet_0.Cells[6, 8].SetValue(xfrmCommonPopup.dtReturn.Rows[0]["DATE"].ToString()); } xfrmCommonPopup.Dispose(); } } //포장 else { } } catch (Exception ex) { } }
private void spreadsheetMain_CellBeginEdit(object sender, SpreadsheetCellCancelEventArgs e) { //control.EventCall(SysEvent.Btn_Edit, 0); }