private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucShipmentInfoPopupEntity.CRUD = "R";
_pucShipmentInfoPopupEntity.LOT_ID = "";
_pucShipmentInfoPopupEntity.LOT_NO = "";
_pucShipmentInfoPopupEntity.ORDER_NUMBER = _luTORDER_NUMBER.Text.ToString();
_pucShipmentInfoPopupEntity.PART_CODE = "";
_pucShipmentInfoPopupEntity.VEND_PART_CODE = _luTPART_CODE.CodeText.ToString();
_pucShipmentInfoPopupEntity.PART_HIGH = _luTPART_HIGH.Text.ToString();
_pucShipmentInfoPopupEntity.PART_MIDDLE = _luTPART_MIDDLE.Text.ToString();
_pucShipmentInfoPopupEntity.PART_LOW = _luTPART_LOW.Text.ToString();
_dtList = new ucShipmentInfoPopupBusiness().ucShipmentInfoPopup_Mst(_pucShipmentInfoPopupEntity);
if (_pucShipmentInfoPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucShipmentInfoPopupEntity.CRUD == ""))
{
//데이터 필드에 맞춰 자동 바인딩
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
}
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);
}
}
private void InitializeControl()
{
try
{
//조회조건 영역
//_luT_REG_DATE.FromDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //조회 시작일, 매월 초 날짜로 설정
//데이터가 너무 많은 관계로 당일로
_luT_REG_DATE.FromDateTime = DateTime.Today; //조회 시작일, 매월 초 날짜로 설정
_luT_REG_DATE.ToDateTime = DateTime.Today; //조회 종료일, 당일 설정
_luT_PROCESS.CodeText = "";
_luT_PROCESS.NameText = "";
//데이터 영역
// 컨트롤러 유효성 검증 처리 기본 컨트롤러 에서만 사용
dxValidationProvider.ValidationMode = DevExpress.XtraEditors.DXErrorProvider.ValidationMode.Manual;
dxValidationProvider.Validate();
//dxValidationProvider.SetValidationRule(_luGRID_NAME, NotEmptyValidationRule);
//dxValidationProvider.SetValidationRule(_luGRIDVIEW_NAME, NotEmptyValidationRule);
// 컨트롤러 유효성 검증 처리
//그리드 초기화
//여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화
if (_pFirstYN)
{
//_gdMAIN.DataSource = null;
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
}
}
// 메인 버튼 처리영역
#region ○ 조회 버튼 클릭시 처리하기
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pProcessTempManagementEntity.CRUD = "R";
_pProcessTempManagementEntity.PROCESS_CODE = _luT_PROCESS.NameText.ToString();
Dashboard_DisplayData();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucMatInspectDocumentListPopupEntity.CRUD = "R";
_pucMatInspectDocumentListPopupEntity.MATSTOCK_ID = _luMATSTOCK_ID.Text.ToString();
_pucMatInspectDocumentListPopupEntity.MATSTOCK_DETAIL_SEQ = _luMATSTOCK_DETAIL_SEQ.Text.ToString();
_pucMatInspectDocumentListPopupEntity.INSPECT_ID = _luINSPECT_ID.Text.ToString();
_pucMatInspectDocumentListPopupEntity.USE_YN = _luUSE_YN.GetValue();
_dtList = new ucMatInspectDocumentListPopupBusiness().ucMatInspectDocumentListPopup_Info_Main(_pucMatInspectDocumentListPopupEntity);
if (_pucMatInspectDocumentListPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucMatInspectDocumentListPopupEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
_gdMAIN_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _btSAVE_Click(object sender, EventArgs e)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes)
{
_pucProcessDocumentListPopupEntity.PROCESS_CODE = _luPROCESS_CODE.Text.ToString();
InputDataMain_Save(_gdMAIN_VIEW.GridControl.DataSource as DataTable);
}
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string FromDATE = _luTORDER_DATE.FromDateTime.ToString("yyyyMMdd");
string ToDATE = _luTORDER_DATE.ToDateTime.ToString("yyyyMMdd");
string strCODE = _luPART_NAME.Text.ToString(); //자재명
string strPART_TYPE = _pucInspectRequestInfoPopupEntity.PART_TYPE;
_pCRUD = "R";
_dtList = new ucInspectRequestInfoPopupBusiness().ucInspectRequestInfo_Return(_pCRUD, FromDATE, ToDATE, strCODE, strPART_TYPE).Tables[0];
if (_pCRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
_gdMAIN_VIEW.Columns["CRUD"].AppearanceCell.BackColor = Color.Red;
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
_gdMAIN_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void InputData_Save(DataTable pDataTable)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
_pWorkOrderInfoPopupEntity.CRUD = "C";
_pWorkOrderInfoPopupEntity.USER_CODE = _pUSER_CODE;
_pWorkOrderInfoPopupEntity.REFERENCE_ID = _luPLAN_ORDER_ID.Text; //계획정보를 레퍼런스에 담음
isError = new WorkOrderInfoPopupBusiness().WorkOrderInfoPopup_Save(_pWorkOrderInfoPopupEntity, pDataTable);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_gdMAIN.DataSource = null;
//팝업 닫기
_btCancle_Click(null, null);
}
}
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);
}
}
private void Form_Closing(object pSender, FormClosingEventArgs pFormClosingEventArgs)
{
try
{
////그리드 작업 정보 확인 하기
//if ((_gdMAIN_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")) ||
// (_gdSUB_DETAIL_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_DETAIL_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")))
//{
// if (CoFAS_DevExpressManager.ShowQuestionMessage("작업중인 자료가 있습니다.\n종료 하겠습니까?") == DialogResult.No)
// {
// pFormClosingEventArgs.Cancel = true;
// return;
// }
//}
pFormClosingEventArgs.Cancel = false;
isRESULT = true;
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
}
// DB 처리
#region ○ 화면에 따른 시트 조회 - SheetMainFind_DisplayData()
private void SheetMainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new WindowSheetSettingBusiness().SheetMainFind_DisplayData(_pWindowSheetSettingEntity);
if (_pWindowSheetSettingEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pWindowSheetSettingEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
//throw pExceptionManager;
}
//catch (Exception pException)
//{
// throw new ExceptionManager(this, "InputData_Save(DataTable dtSave)", pException);
//}
finally
{
_gdMAIN_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void ChangeValues(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView g = sender as GridView;
int selectedRowNum = g.FocusedRowHandle;
int selectedCellNum = g.FocusedColumn.VisibleIndex;
if (g.GetRowCellDisplayText(selectedRowNum, "PRODUCTION_ORDER_QTY").Equals(""))
{
return;
}
decimal production_order_qty = Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "PRODUCTION_ORDER_QTY") == "" ? "0" : g.GetRowCellDisplayText(selectedRowNum, "PRODUCTION_ORDER_QTY"));
decimal order_qty = Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "ORDER_QTY") == "" ? "0" : g.GetRowCellDisplayText(selectedRowNum, "ORDER_QTY"));
if (production_order_qty > order_qty)
{
CoFAS_DevExpressManager.ShowErrorMessage(_pMSG_PLAN_LARGE_THAN_ORDER);
g.SetFocusedRowCellValue("PRODUCTION_ORDER_QTY", order_qty);
}
}
private void Form_InitialButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//확인
//if (_gdSUB_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""))
//{
// if (CoFAS_DevExpressManager.ShowQuestionMessage("작업 초기화 하겠습니까?") == DialogResult.No)
// {
// return;
// }
// else
// {
// InitializeSetting();
// GridView gv = _gdMAIN_VIEW; //바인딩 되는 데이터 마스터 그리드 설정
// CoFAS_ControlManager.Controls_Binding(gv, true, this);
// DisplayMessage("초기화했습니다.");
// }
//}
//else
//{
// InitializeSetting();
// GridView gv = _gdMAIN_VIEW; //바인딩 되는 데이터 마스터 그리드 설정
// CoFAS_ControlManager.Controls_Binding(gv, true, this);
// DisplayMessage("초기화했습니다.");
//}
}
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);
}
}
private void _btSAVE_GRID_Click(object sender, EventArgs e)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
DataTable dtTemp = null;
bool isChack = CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_DETAIL_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "");
if (isChack)
{
dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdSUB_DETAIL_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "");
}
else
{
return;
}
// DataTable dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdSUB_DETAIL_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화
if (dtTemp.Rows.Count > 0)
{
Grid_InputData_Save(dtTemp);
}
else
{
// CoFAS_DevExpressManager.ShowInformationMessage("입력 된 저장 항목이 없습니다.");
}
}
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);
}
}
private void Form_Closing(object pSender, FormClosingEventArgs pFormClosingEventArgs)
{
try
{
//그리드 작업 정보 확인 하기
if ((_gdMAIN_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")) ||
(_gdSUB_DETAIL_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_DETAIL_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")))
{
if (CoFAS_DevExpressManager.ShowQuestionMessage(string.Format("{0}. {1}", _pMSG_WORKING, _pMSG_EXIT_QUESTION)) == DialogResult.No)
{
pFormClosingEventArgs.Cancel = true;
return;
}
}
pFormClosingEventArgs.Cancel = false;
isRESULT = true;
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void InputData_Save(DataTable dtSave)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new ucPartDocumentListPopup_T02Business().Document_Info_Save(_pucPartDocumentListPopup_T02Entity, dtSave);
if (isError)
{
//오류 발생.
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_INPUT_DATA);
//화면 표시.
}
else
{
//정상 처리
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_pucPartDocumentListPopup_T02Entity.CRUD = "R";
_pucPartDocumentListPopup_T02Entity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.GetValue().ToString();// _luDOCUMENT_TYPE.Text.ToString();
_pucPartDocumentListPopup_T02Entity.PART_CODE = _luPART_CODE2.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_NAME = _luDOCUMENT_NAME.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_VER = _luDOCUMENT_VER.Text.ToString();
_pucPartDocumentListPopup_T02Entity.USE_YN = _luUSE_YN.GetValue();
SubFind_DisplayData();
}
}
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);
}
}
private void _gdSUB_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
{
// 메인그리드 (작업지시)
try
{
GridView gv = sender as GridView;
CoFAS_ControlManager.Controls_Binding(gv, false, this); //
//string strWINDOW_NAME = gv.GetFocusedRowCellValue("WINDOW_NAME").ToString();
//string strGRID_NAME = gv.GetFocusedRowCellValue("GRID_NAME").ToString();
_pScheduling_T50Entity.ORDER_ID = gv.GetFocusedRowCellValue("PRODUCTION_ORDER_ID").ToString();
_pScheduling_T50Entity.CRUD = "R";
//SetEqui();
SUBFind_DisplayData();
Cleartlp();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
}
private void Form_FormClosed(object sender, FormClosedEventArgs pFormClosedEventArgs)
{
//throw new NotImplementedException();
try
{
//화면 레이아웃 저장 ?
//이벤트 해제
_gdMAIN_VIEW.RowCellClick -= _gdMAIN_VIEW_RowCellClick;
_gdMAIN_VIEW.InitNewRow -= _gdMAIN_VIEW_InitNewRow;
_gdSUB_VIEW.InitNewRow -= _gdSUB_VIEW_InitNewRow;
_luT_BAD_INFO._OnOpenClick -= _luT_BAD_INFO_OnOpenClick;
_gdMAIN_VIEW.FocusedRowChanged -= new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(_gdMAIN_VIEW_RowChange);
//_gdSUB_VIEW.InitNewRow -= _gdSUB_VIEW_InitNewRow;
//CoFAS_DevExpressManager._OnButtonPressed -= CoFAS_DevExpressManager__OnButtonPressed;
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void _ucbtSYS_SAVE_Click(object sender, EventArgs e)
{
//FPD 저장
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string SYSVALUE = "PD030003";
InputData_Save(_gdMAIN_VIEW3.GridControl.DataSource as DataTable, SYSVALUE);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
catch (Exception pException)
{
DisplayMessage(string.Format("{0}", pException));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// 메인 버튼 처리영역
#region ○ 조회 버튼 클릭시 처리하기
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pBadCodeMstRegisterEntity.CRUD = "R";
MainFind_DisplayData();
//DisplayMessage("조회 되었습니다.");
DisplayMessage(_pMSG_SEARCH);
}
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);
}
}
private void ucQCMaterialPartListPopup_Load(object sender, EventArgs e)
{
try
{
_pMessageEntity = new MessageEntity();
DataTable dtMessage = new MessageBusiness().MessageValue_Info(_pLANGUAGE_TYPE);
if (dtMessage != null)
{
_pMessageEntity.MSG_SEARCH = dtMessage.Rows[0]["MSG_SEARCH"].ToString();
_pMessageEntity.MSG_SEARCH_EMPT = dtMessage.Rows[0]["MSG_SEARCH_EMPT"].ToString();
_pMessageEntity.MSG_SAVE_QUESTION = dtMessage.Rows[0]["MSG_SAVE_QUESTION"].ToString();
_pMessageEntity.MSG_SAVE = dtMessage.Rows[0]["MSG_SAVE"].ToString();
_pMessageEntity.MSG_SAVE_ERROR = dtMessage.Rows[0]["MSG_SAVE_ERROR"].ToString();
_pMessageEntity.MSG_DELETE_QUESTION = dtMessage.Rows[0]["MSG_DELETE_QUESTION"].ToString();
_pMessageEntity.MSG_DELETE = dtMessage.Rows[0]["MSG_DELETE"].ToString();
_pMessageEntity.MSG_DELETE_ERROR = dtMessage.Rows[0]["MSG_DELETE_ERROR"].ToString();
_pMessageEntity.MSG_DELETE_COMPLETE = dtMessage.Rows[0]["MSG_DELETE_COMPLETE"].ToString();
_pMessageEntity.MSG_INPUT_DATA = dtMessage.Rows[0]["MSG_INPUT_DATA"].ToString();
_pMessageEntity.MSG_INPUT_DATA_ERROR = dtMessage.Rows[0]["MSG_INPUT_DATA_ERROR"].ToString();
_pMessageEntity.MSG_WORKING = dtMessage.Rows[0]["MSG_WORKING"].ToString();
_pMessageEntity.MSG_RESET_QUESTION = dtMessage.Rows[0]["MSG_RESET_QUESTION"].ToString();
_pMessageEntity.MSG_EXIT_QUESTION = dtMessage.Rows[0]["MSG_EXIT_QUESTION"].ToString();
_pMessageEntity.MSG_SELECT = dtMessage.Rows[0]["MSG_SELECT"].ToString();
_pMessageEntity.MSG_RESET_COMPLETE = dtMessage.Rows[0]["MSG_RESET_COMPLETE"].ToString();
}
_TempGridView = new CoFAS_DevGridManager();
InitializeSetting();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
DevExpress.Utils.AppearanceObject.DefaultFont = fntPARENT_FONT;//화면에 모든 항목 폰트 재설정
}
}
private void _gdMAIN_VIEW_RowChange(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
if (CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""))
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_WORKING);
return;
}
GridView gv = sender as GridView;
if ((gv.DataSource as DataTable) == null)
{
return;
}
if (e.FocusedRowHandle < 0)
{
return;
}
if (gv.GetFocusedRowCellValue("BAD_GROUP_CODE") == null)
{
return;
}
string strPROCESS_CODE = gv.GetFocusedRowCellValue("BAD_GROUP_CODE").ToString();
_pBadCodeMstRegisterEntity.CRUD = "R";
_pBadCodeMstRegisterEntity.BAD_GROUP_CODE = gv.GetFocusedRowCellValue("BAD_GROUP_CODE").ToString();
MainBindingFind_DisplayData();
SubFind_DisplayData();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void _btSELECT_Click(object sender, EventArgs e)
{
try
{
frmCommonPopup.USER_CODE = _pUSER_CODE;
frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmCommonPopup.FONT_TYPE = fntPARENT_FONT;
frmCommonPopup.ARRAY = new object[2] {
"Product_Code", _luTPART_NAME.Text
}; //넘기는 파라메터 에 따라 설정, 제품/조회할때 품목명을 던지기
frmCommonPopup.ARRAY_CODE = new object[2] {
_luTPART_CODE.Text, _luTPART_NAME.Text
};
frmCommonPopup xfrmCommonPopup = new CORE.UserForm.frmCommonPopup("PartCodeInfo"); //유저컨트롤러 설정 부분
xfrmCommonPopup.ShowDialog();
if (xfrmCommonPopup.dtReturn == null)
{
xfrmCommonPopup.Dispose();
return;
}
if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0)
{
_luTPART_CODE.Text = xfrmCommonPopup.dtReturn.Rows[0]["PART_CODE"].ToString();
_luTPART_NAME.Text = xfrmCommonPopup.dtReturn.Rows[0]["PART_NAME"].ToString();
// BOM 조회하기
MainFind_DisplayData();
}
xfrmCommonPopup.Dispose();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void InputData_Save(DataTable dtSave) //(ContractMstRegisterEntity _pContractMstRegisterEntity)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new WorkResultRegister_T07Business().WorkResultMst_Save_T02(_pWorkResultRegister_T07Entity, dtSave);
if (!isError)
{
//정상처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
//_pLocation_Code = _pContractMstRegisterEntity.RTN_KEY; //저장 위치
MainFind_DisplayData();
//InitializeControl();
//Form_SearchButtonClicked(null, null);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
}
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);
}
}
private void InitializeControl()
{
try
{
_pCRUD = "";
//_luTORDER_NUMBER.Text = "";
//_luTORDER_NUMBER.ReadOnly = true;
//그리드 초기화
//여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화
//_gdMAIN.DataSource = null;
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
}
}
private void MainBindingFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new InspectCodeMstRegisterBusiness().Inspect_Info_Mst_Binding(_pInspectCodeMstRegisterEntity);
if ((_dtList != null && _dtList.Rows.Count > 0))
{
CoFAS_ControlManager.Controls_Binding(_dtList, false, this);
}
}
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);
}
}
private void InputData_Save(DataTable dtSave)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new SensorDataSearchBusiness().Sample_Info_Save(_pSensorDataSearchEntity, dtSave);
if (isError)
{
//오류 발생.
CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
//화면 표시.
}
else
{
//정상 처리
CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
// 화면 갱신
_pSensorDataSearchEntity.CRUD = "R";
MainFind_DisplayData();
// SubFind_DisplayData(_pSampleRegisterEntity.WINDOW_NAME, _pSampleRegisterEntity.GRID_NAME);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void Form_SaveButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
if (!dxValidationProvider.Validate())
{
return;
}
if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.No)
{
return;
}
else
{
InputData_Save(_gdMAIN_VIEW.GridControl.DataSource as DataTable);
//_pWorkResultRegisterEntity.CRUD = "U";
//_pWorkResultRegisterEntity.PRODUCTION_ORDER_ID = "";
//_pWorkResultRegisterEntity.COMPLETE_YN = "";
//InputData_Save(_pWorkResultRegisterEntity);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
catch (Exception pException)
{
DisplayMessage(string.Format("{0}", pException));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _luT_PROCESS_OnOpenClick(object sender, EventArgs e)
{
try
{
frmCommonPopup.CRUD = "R";
frmCommonPopup.USER_CODE = _pUSER_CODE;
frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmCommonPopup.FONT_TYPE = _pFONT_SETTING;
// 0 서비스네임 1 공통코드경우 CODE_TYPE 으로구분자 올린다.
frmCommonPopup.ARRAY = new object[2] {
"Process_Code", ""
};
frmCommonPopup.ARRAY_CODE = new object[2] {
_luT_PROCESS.CodeText.ToString(), _luT_PROCESS.NameText.ToString()
};
frmCommonPopup xfrmCommonPopup = new CORE.UserForm.frmCommonPopup("CommonCode"); //유저컨트롤러 설정 부분
xfrmCommonPopup.ShowDialog();
if (xfrmCommonPopup.dtReturn == null)
{
xfrmCommonPopup.Dispose();
return;
}
if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0)
{
_luT_PROCESS.CodeText = xfrmCommonPopup.dtReturn.Rows[0]["CD"].ToString();
_luT_PROCESS.NameText = xfrmCommonPopup.dtReturn.Rows[0]["CD_NM"].ToString();
}
xfrmCommonPopup.Dispose();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void Form_SaveButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//if (CoFAS_DevExpressManager.ShowQuestionMessage("저장 하시겠습니까?") == DialogResult.No)
if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.No)
{
return;
}
else
{
//DataTable dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화
//if (dtTemp.Rows.Count > 0)
//{
InputData_Save(_gdSUB_VIEW.GridControl.DataSource as DataTable);
//}
//else
//{
// CoFAS_DevExpressManager.ShowInformationMessage("입력 된 저장 항목이 없습니다.");
//}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
//throw pExceptionManager;
}
//catch (Exception pException)
//{
// throw new ExceptionManager(this, "InputData_Save(DataTable dtSave)", pException);
//}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _ucbtPLAN_SAVE_Click(object sender, EventArgs e)
{
try
{
if (_gdMAIN_VIEW.RowCount > 0)
{
_pProductPlanInfoPopup_T01Entity.CRUD = "C";
InputData_Save(_gdMAIN_VIEW.GridControl.DataSource as DataTable);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("BOM 정보가 없습니다. ");
CoFAS_DevExpressManager.ShowInformationMessage("BOM" + _pMSG_SEARCH_EMPT);
}
_btCancle_Click(sender, e);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void Form_ImportButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
OpenFileDialog opd = new OpenFileDialog();
opd.FileName = "";
opd.Filter = "xls파일(*.xls)|*.xls|xlsx파일(*.xlsx)|*.xlsx";
opd.Title = "엑셀 저장";
if (opd.ShowDialog() == DialogResult.OK)
{
fileName = opd.SafeFileName;
fileFullName = opd.FileName;
filePath = fileFullName.Replace(fileName, "");
dt_MTemp = new System.Data.DataTable();
dt_MTemp = init_M_DataTable(dt_MTemp);
dt_STemp = new System.Data.DataTable();
dt_STemp = init_S_DataTable(dt_STemp);
spreadsheetControl1.LoadDocument(fileFullName);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
catch (Exception ex)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", ex.Message.ToString(), ex.TargetSite.ToString()));
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
