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