// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); //_pGroupMenuAuthorityEntity.GROUP_ACCOUNT = _luGROUP_MAIL.Text.ToString(); _pGroupMenuAuthorityEntity.GROUP_NAME = _luGROUP_NAME.Text.ToString(); _dtList = new GroupMenuAuthorityBusiness().GroupMenuAuthority_R10(_pGroupMenuAuthorityEntity); if (_pGroupMenuAuthorityEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pGroupMenuAuthorityEntity.CRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); } else { //CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); _gdMAIN.DataSource = null; _gdSUB.DataSource = null; } } 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 { _gdSUB_VIEW.BestFitColumns(); CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pucProductionOrderInfoPopup_T08_Entity.CRUD = "R"; _pucProductionOrderInfoPopup_T08_Entity.DATE_FROM = _ucFROMDATE.FromDateTime.ToString("yyyyMMdd"); _pucProductionOrderInfoPopup_T08_Entity.DATE_TO = _ucFROMDATE.ToDateTime.ToString("yyyyMMdd"); _pucProductionOrderInfoPopup_T08_Entity.PART_CODE = _luPART_ALL.CodeText; _pucProductionOrderInfoPopup_T08_Entity.PART_NAME = _luPART_ALL.NameText; _pucProductionOrderInfoPopup_T08_Entity.PLAN_ORDER_ID = _luPLAN_ORDER.Text; _pucProductionOrderInfoPopup_T08_Entity.TERMINAL_CODE = _luTTERMINAL_LIST.GetValue(); _pucProductionOrderInfoPopup_T08_Entity.PROCESS_CODE = _luTPROCESS_NAME.GetValue(); //_pucProductionOrderInfoPopup_T08_Entity.VEND_NAME = _luPART_ALL.NameText; _dtList = new pucProductionOrderInfoPopup_T08Business().ucProductionOrderInfoPopup_T08_Select(_pucProductionOrderInfoPopup_T08_Entity).Tables[0]; if (_pucProductionOrderInfoPopup_T08_Entity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucProductionOrderInfoPopup_T08_Entity.CRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); } else { //CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); _dtList.Rows.Clear(); 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); } }
// 추가 이벤트 생성 // 메인 버튼 처리영역 #region ○ 조회 버튼 클릭시 처리하기 private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); MainFind_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); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() - 사용X private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); Dashboard_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 SubFind_DisplayData(string strWINDOW_NAME, string strGRID_NAME) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { // _gdSUB_VIEW.BestFitColumns(); CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void _ucbtDOCUMENT_SELECT_Click(object sender, EventArgs e) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); 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 Form_InitialButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); InitializeSetting(); //조회조건 영역 } 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 File_Download() { try { string strFTP_PATH = ""; if (_pMenuInfoRegisterEntity.CRUD == "") { _dtList.Rows.Clear(); } if (_gdSUB_VIEW.FocusedValue.ToString() == "") { return; } _pMenuInfoRegisterEntity.TEMPLETE_FILE_NAME = _gdSUB_VIEW.FocusedValue.ToString(); //ftp에서 local로 다운로드 SaveFileDialog saveFile = new SaveFileDialog(); saveFile.InitialDirectory = @"C:\"; saveFile.Filter = "ALL(*.*)|*.*"; saveFile.FileName = _pMenuInfoRegisterEntity.TEMPLETE_FILE_NAME; strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pMenuInfoRegisterEntity.FTP_IP_PORT, "PROGRAM_VIEW", _luMENU_CODE.Text.ToString()); if (saveFile.ShowDialog() == DialogResult.OK) { string _pDOWNLOAD_PATH = saveFile.FileName; CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, (saveFile.FileName.ToString().Split('\\')).Last(), _pFTP_ID, _pFTP_PW, _pDOWNLOAD_PATH, false); //DisplayMessage("선택한 파일이 지정한 폴더(" + _pFTP_DOWNLOAD_PATH + ")에 저장되었습니다."); DisplayMessage(_pMSG_SAVE + "(path:" + _pDOWNLOAD_PATH + ")"); } } 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_PrintButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); //_gdMAIN_VIEW.OptionsPrint.AllowMultilineHeaders = false; _gdMAIN_VIEW.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); } }
private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _dtList = new POPProductionOrder_T03Business().POPProductionOrder_Info(_pPOPProductionOrder_T03Entity); if (_pPOPProductionOrder_T03Entity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPProductionOrder_T03Entity.CRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩 _gdMAIN_VIEW.RowHeight = 80; _gdMAIN_VIEW.Appearance.Row.Font = new Font("굴림", 18); _gdMAIN_VIEW.RowStyle += new RowStyleEventHandler(gdMAIN_VIEW_RowStyle); RepositoryItemMemoEdit noteMemo = new RepositoryItemMemoEdit(); noteMemo.Appearance.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; _gdMAIN_VIEW.Columns["PART_NAME"].ColumnEdit = noteMemo; this._gdMAIN_VIEW.OptionsView.RowAutoHeight = true; _gdMAIN_VIEW.Appearance.FocusedRow.BackColor = Color.Red; } else { CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); } } 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 MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pfrmPOPPartStockCheckEntity.CRUD = "R"; _pfrmPOPPartStockCheckEntity.LANGUAGE_TYPE = _pUserEntity.LANGUAGE_TYPE; //_pfrmPOPPartStockCheckEntity.PROCESS_CODE = _pUserEntity.PROCESS_CODE; //_pfrmPOPPartStockCheckEntity.RESOURCE_CODE = _pUserEntity.RESOURCE_CODE; _pfrmPOPPartStockCheckEntity.BARCODE = _pBARCODE_NO; _dtList = new frmPOPPartStockCheckBusiness().frmPOPPartStockCheck_Info(_pfrmPOPPartStockCheckEntity); if (_pfrmPOPPartStockCheckEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pfrmPOPPartStockCheckEntity.CRUD == "")) { _luPART_NAME.Text = _dtList.Rows[0]["PART_NAME"].ToString(); _luPART_UNIT.Text = _dtList.Rows[0]["PART_UNIT"].ToString(); _luPART_CODE.Text = _dtList.Rows[0]["PART_CODE"].ToString(); _luVEND_PART_CODE.Text = _dtList.Rows[0]["VEND_PART_CODE"].ToString(); _luPART_STOCK.Text = _dtList.Rows[0]["PART_STOCK"].ToString(); } else { CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); } tmrDtNow = new System.Threading.Timer(new TimerCallback(UpdateDtNow), null, 0, 5000); } 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); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _dtList = new MenuInfoRegisterBusiness().MenuInfoRegister_Info_left(_pMenuInfoRegisterEntity); if (_pMenuInfoRegisterEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pMenuInfoRegisterEntity.CRUD == "")) { _TempGridView.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩 if (_pLocation_Code != "" && _pLocation_YN) { int rowHandle = _gdMAIN_VIEW.LocateByValue("MENU_CODE", Convert.ToInt32(_pLocation_Code)); if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { _gdMAIN_VIEW.FocusedRowHandle = rowHandle; } _pLocation_Code = ""; } } else { _TempGridView.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); } } 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 dtSave)//DataTable dtSave) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); bool isError = false; isError = new ResourceCodeMstRegisterBusiness().Resource_Info_Save(_pResourceCodeMstRegisterEntity, dtSave); if (isError) { //오류 발생. CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); //화면 표시. } else { //정상 처리 CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); _pResourceCodeMstRegisterEntity.CRUD = "R"; _pResourceCodeMstRegisterEntity.RESOURCE_MST_CODE = _luT_RESOURCE_MST_CODE.ToString(); _pResourceCodeMstRegisterEntity.RESOURCE_MST_NAME = _luT_RESOURCE_MST_NAME.ToString(); _pResourceCodeMstRegisterEntity.RESOURCE_TYPE = _luT_RESOURCE_TYPE.GetValue(); _pResourceCodeMstRegisterEntity.MST_USE_YN = _luT_USE_YN.GetValue(); MainFind_DisplayData(); //*******************수정 후*********************************************// InitializeControl2(); _pResourceCodeMstRegisterEntity.CRUD = ""; 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 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 // { //조회조건 영역 //_luT_USE_YN.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R",_pLANGUAGE_TYPE, "USE_YN", "", "", "").Tables[0], 0, 0, ""); //_luT_PROCESS_TYPE.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R",_pLANGUAGE_TYPE, "PROCESS_TYPE", "", "", "").Tables[0], 0, 0, "",true); _pProcessCodeMstRegisterEntity.CRUD = ""; SubFind_DisplayData(); //DisplayMessage("초기화했습니다."); DisplayMessage(_pMSG_RESET_COMPLETE); // } //} //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); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _dtList = new RuleGeneratorBusiness().Dictionary_Info(_pRuleGeneratorEntity); if (_pRuleGeneratorEntity.CRUD == "") { _dtList.Rows.Clear(); } if (_dtList != null && _dtList.Rows.Count > 0) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩 _gdMAIN_VIEW.OptionsBehavior.Editable = false; _gdMAIN_VIEW.OptionsBehavior.EditorShowMode = EditorShowMode.Default; _gdMAIN_VIEW.OptionsBehavior.ReadOnly = true; // 강제 ReadOnly true _gdMAIN_VIEW.OptionsCustomization.AllowColumnMoving = false; _gdMAIN_VIEW.OptionsCustomization.AllowColumnResizing = false; _gdMAIN_VIEW.OptionsCustomization.AllowFilter = false; _gdMAIN_VIEW.OptionsCustomization.AllowSort = false; _gdMAIN_VIEW.OptionsMenu.EnableColumnMenu = false; _gdMAIN_VIEW.OptionsSelection.MultiSelect = false; //_gdMAIN_VIEW.OptionsSelection.select = SelectionMode.One; } } 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; _pPOPFirstMiddleLastEntity.CRUD = "C"; _pPOPFirstMiddleLastEntity.USER_CODE = _pUSER_CODE; _pPOPFirstMiddleLastEntity.EQUIPMENT_CODE = _pTerminal_code; _pPOPFirstMiddleLastEntity.PART_CODE = _pPart_code2; _pPOPFirstMiddleLastEntity.COLLECTION_DATE = DateTime.Now.ToString("yyyy-MM-dd"); isError = new POPFirstMiddleLastBusiness().POPFirstMiddleLast_Save(_pPOPFirstMiddleLastEntity, pDataTable); if (isError) { //오류 발생. //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); } else { //정상 처리 //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); //_gdMAIN.DataSource = null; //MainFind_DisplayData(); //팝업 닫기 //_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); } }
// 메인 버튼 처리영역 #region ○ 조회 버튼 클릭시 처리하기 private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); if (CoFAS_ConvertManager.DataTable_FindCount(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")) { //if (CoFAS_DevExpressManager.ShowQuestionMessage("작업 중인 데이터가 있습니다.") == DialogResult.No) if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_WORKING + "\n" + _pMSG_RESET_QUESTION) == DialogResult.Yes) { _pGroupMenuAuthorityEntity.CRUD = "R"; MainFind_DisplayData(); //DisplayMessage("조회 되었습니다."); DisplayMessage(_pMSG_SEARCH); } } else { _pGroupMenuAuthorityEntity.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())); //throw pExceptionManager; } //catch (Exception pException) //{ // throw new ExceptionManager(this, "InputData_Save(DataTable dtSave)", pException); //} finally { MainFind_DisplayData(); CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pCRUD = "R"; string pPLAN_ORDER = _luPLAN_ORDER_ID.Text; string pCONFIGURATION_MST_NAME = _luT_CONFIGURATION_MST_NAME.Text; string pCONFIGURATION_NAME = _luT_CONFIGURATION_NAME.Text; _dtList = new ucWorkOrderInfoPopup_T50Business().ucWorkOrderInfoPopup_T50_Return(_pCRUD, pPLAN_ORDER, pCONFIGURATION_MST_NAME, pCONFIGURATION_NAME, _pucWorkOrderInfoPopup_T50Entity).Tables[0]; if (_pCRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); GridColumn colName = _gdMAIN_VIEW.Columns["PLAN_ORDER_QTY"]; colName.AppearanceCell.BackColor = Color.Brown; colName.AppearanceCell.ForeColor = Color.Yellow; } else { //CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); _dtList.Rows.Clear(); 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 MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pInspectFinalApprovalRegisterT01Entity.CRUD = "R"; _pInspectFinalApprovalRegisterT01Entity.DATE_FROM = DateTime.Parse(_luTINSPECT_DATE.FromDateTime.ToString()).ToString("yyyyMMdd"); _pInspectFinalApprovalRegisterT01Entity.DATE_TO = DateTime.Parse(_luTINSPECT_DATE.ToDateTime.ToString()).ToString("yyyyMMdd"); _pInspectFinalApprovalRegisterT01Entity.VEND_PART_CODE = _luTPART_CODE.CodeText.ToString(); _pInspectFinalApprovalRegisterT01Entity.PART_NAME = _luTPART_CODE.NameText.ToString(); _pInspectFinalApprovalRegisterT01Entity.COMPLETE_YN = _luTCOMPLETE_YN.GetValue(); _pInspectFinalApprovalRegisterT01Entity.USE_YN = _luTUSE_YN.GetValue(); using (DBManager pDBManager = new DBManager()) { _dtList = new InspectFinalApprovalRegisterT01Business().InspectFinalApprovalRegisterT01_Mst_info(_pInspectFinalApprovalRegisterT01Entity); if (_pInspectFinalApprovalRegisterT01Entity.CRUD == "") { _dtList.Rows.Clear(); } if (_dtList != null && _dtList.Rows.Count > 0) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); } else { CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); _dtList.Rows.Clear(); 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 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("작업 중인 데이터가 있습니다.\n초기화 하시겠습니까?") == DialogResult.No) if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_WORKING + "\n" + _pMSG_RESET_QUESTION) == DialogResult.No) { return; } else { InitializeSetting(); //DisplayMessage("초기화했습니다."); DisplayMessage(_pMSG_RESET_COMPLETE); } } else { InitializeSetting(); //DisplayMessage("초기화했습니다."); DisplayMessage(_pMSG_RESET_COMPLETE); } } 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 _luTPART_CODE__OnOpenClick(object sender, EventArgs e) { try { PO.UserForm.frmCommonPopup.CRUD = "R"; PO.UserForm.frmCommonPopup.USER_CODE = _pUSER_CODE; PO.UserForm.frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE; //PO.UserForm.frmCommonPopup.FONT_TYPE = _pFONT_SETTING; // 0 서비스네임 1 공통코드경우 CODE_TYPE 으로구분자 올린다. PO.UserForm.frmCommonPopup.ARRAY = new object[2] { "", "" }; PO.UserForm.frmCommonPopup.ARRAY_CODE = new object[2] { _luTPART_CODE.CodeText.ToString(), _luTPART_CODE.NameText.ToString() }; PO.UserForm.frmCommonPopup xfrmCommonPopup = new PO.UserForm.frmCommonPopup("ucProductionPartListPopup"); // new CORE.UserForm.frmCommonPopup("CommonCode"); //유저컨트롤러 설정 부분 xfrmCommonPopup.ShowDialog(); if (xfrmCommonPopup.dtReturn == null) { xfrmCommonPopup.Dispose(); return; } if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0) { _luTPART_CODE.CodeText = xfrmCommonPopup.dtReturn.Rows[0]["VEND_PART_CODE"].ToString(); _luTPART_CODE.NameText = xfrmCommonPopup.dtReturn.Rows[0]["PART_NAME"].ToString(); _pucOutsourcingInfoPopupEntity.PART_CODE = xfrmCommonPopup.dtReturn.Rows[0]["PART_CODE"].ToString(); } xfrmCommonPopup.Dispose(); } 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_InitialButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _luORDER_DATE.FromDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //조회 시작일, 매월 초 날짜로 설정 _luORDER_DATE.ToDateTime = DateTime.Today; //조회 종료일, 당일 설정 } 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 _ucbtPrint_Click(object sender, EventArgs e) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); //this.Text new SystemLogInfoBusiness().SystemEventLog_Info_Save("C", _pUSER_CODE, "제조/작업지시서", _pWINDOW_NAME, "Print Event", "_ucbtPrint", "Button event is executed " + "작업지시번호 : " + pPRODUCTION_ORDER_ID); _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); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pNoticeEntity.CRUD = "R"; _dtList = new NoticeBusiness().Notice_Info_Mst(_pNoticeEntity); if (_pNoticeEntity.CRUD == "") { _dtList.Rows.Clear(); } if (_dtList != null && _dtList.Rows.Count > 0) //&& _dtList.Rows.Count > 0) )|| (_dtList != null && _pNoticeRegisterEntity.CRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩 if (_pLocation_Code != "" && _pLocation_YN) { int rowHandle = _gdMAIN_VIEW.LocateByValue("NOTICE_ID", _pLocation_Code); if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle) { _gdMAIN_VIEW.FocusedRowHandle = rowHandle; } //조회 후 초기화 _pLocation_Code = ""; } } } 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); } }
// DB 처리 #region ○ 메인조회 - MainFind_DisplayData() private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _dtList = new ucEquipmentInspectInfoPopupBusiness().ucEquipmentInspectInfoPopup_Return(_pucEquipmentInspectInfoPopupEntity); if (_pucEquipmentInspectInfoPopupEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); // _gdMAIN_VIEW.Columns["ORDER_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // _gdMAIN_VIEW.Columns["UNITCOST"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // _gdMAIN_VIEW.Columns["COST"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // _gdMAIN_VIEW.Columns["IN_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // _gdMAIN_VIEW.Columns["NIN_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; // // _gdMAIN_VIEW.Columns["ORDER_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}"; // _gdMAIN_VIEW.Columns["UNITCOST"].DisplayFormat.FormatString = "{0:#,###.##0}"; // _gdMAIN_VIEW.Columns["COST"].DisplayFormat.FormatString = "{0:#,###.##0}"; // _gdMAIN_VIEW.Columns["IN_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}"; // _gdMAIN_VIEW.Columns["NIN_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}"; } 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 Dashboard_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); string strFTP_PATH = ""; strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_IP_PORT, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); Dashboard dashboard = new Dashboard(); //FTP의 엑셀 파일 control에 바인딩 using (Stream responseStream = CoFAS_FTPManager.FTPFileBinding(strFTP_PATH, _pXMLFile, _pFTP_ID, _pFTP_PW)) { if (responseStream != null) { dashboard.LoadFromXml(responseStream); //xml 파일 로드 } } dashboard.ConfigureDataConnection += DashboardViewer_ConfigureDataConnection; // xml의 parameter 설정 dashboard.Parameters[0].Value = _pLANGUAGE_TYPE; // Title 설정 dashboard.Title.Visible = false; dashboardViewer.Dashboard = dashboard; dashboardViewer.Refresh(); 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); } }
private void _btPRODUCTION_ORDER_Click(object sender, EventArgs e) { try { // frmCommonPopup._pWINDOW_NAME = _pWINDOW_NAME; ////frmCommonPopup.CORP_CDDE = _pCORP_CODE; // frmCommonPopup.USER_CODE = _pUSER_CODE; // frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE; // frmCommonPopup.FONT_TYPE = _pFONT_SETTING; // // frmCommonPopup.PASS_PARENT_WINDOW_NAME = _pWINDOW_NAME; // frmCommonPopup.PASS_USER_CODE = _pUSER_CODE; // frmCommonPopup.PASS_PARENT_LANGUAGE = _pLANGUAGE_TYPE; // frmCommonPopup.PASS_PARENT_FONT = _pFONT_SETTING; frmCommonPopup.USER_CODE = _pUSER_CODE; frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE; frmCommonPopup.FONT_TYPE = _pFONT_SETTING; //frmCommonPopup.ARRAY = new object[2] { "common_code", "CD99" }; //넘기는 파라메터 에 따라 설정 frmCommonPopup xfrmcommonPopup = new CORE.UserForm.frmCommonPopup("ProductionOrderInfo"); //유저컨트롤러 설정 부분 xfrmcommonPopup.ShowDialog(); if (xfrmcommonPopup.dtReturn == null) { return; } xfrmcommonPopup.dtReturn.Rows[0][0].ToString(); // 리턴 받는 데이터의 값은 해당 그리드 뷰 필드에 설정. //_gdMAIN_VIEW.SetRowCellValue(_gdMAIN_VIEW.FocusedRowHandle, _gdMAIN_VIEW.Columns["TEST1"], xfrmcommonPopup.dtReturn.Rows[0]["CD"].ToString()); //_gdMAIN_VIEW.SetRowCellValue(_gdMAIN_VIEW.FocusedRowHandle, _gdMAIN_VIEW.Columns["TEST2"], 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())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void MainFind_DisplayData() { try { //CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pPOPCheckEntity.CRUD = "R"; _pPOPCheckEntity.EQUIPMENT_CODE = _pTerminal_code; _pPOPCheckEntity.CHECK_CYCLE = _luTCHECK_LIST.GetValue(); _dtList = new POPCheckBusiness().POPCheck_Info(_pPOPCheckEntity); if (_pPOPCheckEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPCheckEntity.CRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩 _gdMAIN_VIEW.RowHeight = 80; } else { //CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT); _dtList.Rows.Clear(); //InitializeControl(false); //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 Form_AddItemButtonClicked(object pSender, EventArgs pEventArgs) { 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] { "Product_Code_R", "" }; frmCommonPopup.ARRAY_CODE = new object[2] { "", "" }; 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) { _pFirstMiddleLastItemEntity.PART_CODE = xfrmCommonPopup.dtReturn.Rows[0]["CD"].ToString(); // SubFind_DisplayData(); } xfrmCommonPopup.Dispose(); } 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 POPProductionOrderCommonBusiness().POPProductionOrderCommon_Recipe_Save(_pPOPProductionOrderCommonEntity, dtSave); if (isError) { //오류 발생. //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); //화면 표시. } else { //정상 처리 //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); _pPOPProductionOrderCommonEntity.CRUD = "R"; MainFind_DisplayData(); } } 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); } }