private static string _pPROCESS_MST_CODE_COSMETICS = string.Empty; //공정 public frmPOPMain_PRODUCT_BIOCERRA(UserEntity pUserEntity) { InitializeComponent(); _pUserEntity = pUserEntity; _pCORP_CODE = _pUserEntity.USER_CODE; _pUSER_CODE = _pUserEntity.USER_NAME; _pLANGUAGE_TYPE = _pUserEntity.LANGUAGE_TYPE; _pPOPProductionOrderEntity = new POPProductionOrderEntity(); _pPOPProductionOrderEntity.LANGUAGE_TYPE = _pLANGUAGE_TYPE; //TP010001 : 공장PPC = 생산 //TP010002 : 본사PPC = 조립 _pPOPProductionOrderEntity.RESOURCE_CODE = _pUserEntity.RESOURCE_CODE;// "TP010001"; if (_pUserEntity.RESOURCE_CODE == "TP010001") { _lbTitle.Text = "공장 실적등록"; } else { _lbTitle.Text = "본사 실적등록"; } _pPOPProductionOrderEntity.CORP_CODE = ""; _pMessageEntity = new MessageEntity(); _pFONT_SETTING = new Font(_pUserEntity.FONT_TYPE, _pUserEntity.FONT_SIZE); _pUSER_CODE = _pUserEntity.USER_CODE; _pUSER_NAME = _pUserEntity.USER_NAME; Activated += new EventHandler(Form_Activated); FormClosing += new FormClosingEventHandler(Form_Closing); FormClosed += new FormClosedEventHandler(Form_FormClosed); Load += new EventHandler(Form_Load); }
private void MainFind_DisplayData() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); _pPOPProductionOrderEntity = new POPProductionOrderEntity(); _pPOPProductionOrderEntity.CORP_CODE = _pUserEntity.CORP_CODE; _pPOPProductionOrderEntity.USER_CODE = _pUserEntity.USER_CODE; _pPOPProductionOrderEntity.LANGUAGE_TYPE = _pUserEntity.LANGUAGE_TYPE; _pPOPProductionOrderEntity.PROCESS_CODE = _pUserEntity.PROCESS_CODE; _pPOPProductionOrderEntity.RESOURCE_CODE = _pUserEntity.RESOURCE_CODE; _pPOPProductionOrderEntity.PRODUCTION_ORDER_ID = _luORDER_ID.Text; _dtList = new POPProductionOrderBusiness().POPProductionOrder_Info_2(_pPOPProductionOrderEntity); if (_pPOPProductionOrderEntity.CRUD == "") { _dtList.Rows.Clear(); } if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPProductionOrderEntity.CRUD == "")) { _luORDER_ID.Text = _dtList.Rows[0]["PRODUCTION_ORDER_ID"].ToString(); _luORDER_DATE.Text = _dtList.Rows[0]["PRODUCTION_ORDER_DATE"].ToString(); _luORDER_QTY.Text = _dtList.Rows[0]["PRODUCTION_ORDER_QTY"].ToString(); _luPART_NAME.Text = _dtList.Rows[0]["PART_NAME"].ToString(); // _luPART_CODE.Text = frmOr.dtReturn.Rows[0]["PART_CODE"].ToString(); _luPART_CODE.Text = _dtList.Rows[0]["VEND_PART_CODE"].ToString(); _luNG_QTY.Text = _dtList.Rows[0]["PRODUCTION_NG_QTY"].ToString(); _luRESULT_QTY.Text = _dtList.Rows[0]["PRODUCTION_RESULT_QTY"].ToString(); _luOK_QTY.Text = _dtList.Rows[0]["PRODUCTION_OK_QTY"].ToString(); _pPOPSelect_INSPECT_COSMETICSEntity.PART_CODE = _dtList.Rows[0]["PART_CODE"].ToString(); if (_dtList.Rows[0]["INSPECT_STATUS"].ToString() != "QC010001") { if (_dtList.Rows[0]["INSPECT_STATUS"].ToString() != "") { _pINSPECT_CHECK_YN = true; } } // 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); // //_gdMAIN_VIEW.Appearance.SelectedRow.Options.UseBackColor = true; // //_gdMAIN_VIEW.OptionsSelection.EnableAppearanceFocusedRow = true; // //_gdMAIN_VIEW.OptionsView.EnableAppearanceEvenRow = true; // //_gdMAIN_VIEW.Appearance.EvenRow.BackColor = Color.Red; // // //_gdMAIN_VIEW.OptionsSelection.MultiSelect = true; // //_gdMAIN_VIEW.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CellSelect; // // _gdMAIN_VIEW.Appearance.FocusedRow.BackColor = Color.Red; // // // //_gdMAIN_VIEW.Appearance.SelectedRow.Options.UseBackColor = true; // //_gdMAIN_VIEW.Appearance.SelectedRow.BackColor = Color.LightSeaGreen; } 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 Viewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) //{ // if (e.ConnectionName == "m.coever.co.kr_coever_mes_Connection") // { // e.ConnectionParameters = new MySqlConnectionParameters(); // SqlDashboardHelper.SetupSqlParameters((MySqlConnectionParameters)e.ConnectionParameters); // } //} #endregion // 초기화 처리 영역 #region ○ 메뉴 초기화 하기 - InitializeSetting() private void InitializeSetting() { try { //메인 화면 전역 변수 처리 //_pCORP_CODE = MainForm.UserEntity.CORP_CODE; //_pUSER_CODE = MainForm.UserEntity.USER_CODE; //_pUSER_NAME = MainForm.UserEntity.USER_NAME; //_pLANGUAGE_TYPE = MainForm.UserEntity.LANGUAGE_TYPE; //_pFONT_TYPE = MainForm.UserEntity.FONT_TYPE; //_pFONT_SIZE = MainForm.UserEntity.FONT_SIZE; _pFONT_SETTING = new Font(_pFONT_TYPE, _pFONT_SIZE); //_pFTP_ID = MainForm.UserEntity.FTP_ID; //_pFTP_IP_PORT = MainForm.UserEntity.FTP_IP_PORT; //string.Format(@"{0}/{1}/", MainForm.UserEntity.FTP_IP_PORT, "test"); //화면 별 해당 위치 지정 //_pFTP_PW = MainForm.UserEntity.FTP_PW; _pWINDOW_NAME = this.Name; //메뉴 화면 엔티티 설정 _pPOPProductionOrderEntity = new POPProductionOrderEntity(); _pPOPProductionOrderEntity.CORP_CODE = _pCORP_CODE; _pPOPProductionOrderEntity.USER_CODE = _pUSER_CODE; _pPOPProductionOrderEntity.LANGUAGE_TYPE = _pLANGUAGE_TYPE; //화면 설정 언어 & 명칭 변경. DataTable dtLanguage = new LanguageBusiness().Language_Info(_pWINDOW_NAME, _pLANGUAGE_TYPE); if (dtLanguage != null && dtLanguage.Rows.Count > 0) { CoFAS_ControlManager.Language_Info(dtLanguage, this); } //그리드 설정 InitializeGrid(); //화면 컨트롤러 설정 InitializeControl(); //그리드 초기화 ////여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화 //_pSampleRegisterEntity.CRUD = ""; //if (_pFirstYN) //{ MainFind_DisplayData(); //Dev Grid 데이터소스 로 바인딩 작업 처리 할 경우에는 최초 빈 데이터 테이블을 바인딩 해야 됨. // _pFirstYN = false; //} //SubFind_DisplayData("", ""); //Dev Grid 데이터소스 로 바인딩 작업 처리 할 경우에는 최초 빈 데이터 테이블을 바인딩 해야 됨. //컨트롤러 별 추가 이벤트 생성은 화면 설정 마지막에 진행 //_gdMAIN_VIEW.RowCellClick += _gdMAIN_VIEW_RowCellClick; //그리드 버튼추가 시 클릭 이벤트 처리 //CoFAS_DevExpressManager._OnButtonPressed += CoFAS_DevExpressManager__OnButtonPressed; //CoFAS_DevExpressManager._OnOpenButton += CoFAS_DevExpressManager__OnOpenButton; // CoFAS_DevExpressManager._OnOpenClick += CoFAS_DevExpressManager__OnOpenClick; //CoFAS_DevExpressManager._OnDownloadClick += CoFAS_DevExpressManager__OnDownloadClick; // CoFAS_DevExpressManager._OnDeleteClick += CoFAS_DevExpressManager__OnDeleteClick; //CoFAS_ControlManager.SetFontInControls(this.Controls, new Font("Arial", 8, FontStyle.Bold)); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } }
//private void Viewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e) //{ // if (e.ConnectionName == "m.coever.co.kr_coever_mes_Connection") // { // e.ConnectionParameters = new MySqlConnectionParameters(); // SqlDashboardHelper.SetupSqlParameters((MySqlConnectionParameters)e.ConnectionParameters); // } //} #endregion // 초기화 처리 영역 #region ○ 메뉴 초기화 하기 - InitializeSetting() private void InitializeSetting() { try { //메인 화면 전역 변수 처리 //_pCORP_CODE = MainForm.UserEntity.CORP_CODE; //_pUSER_CODE = MainForm.UserEntity.USER_CODE; //_pUSER_NAME = MainForm.UserEntity.USER_NAME; //_pLANGUAGE_TYPE = MainForm.UserEntity.LANGUAGE_TYPE; //_pFONT_TYPE = MainForm.UserEntity.FONT_TYPE; //_pFONT_SIZE = MainForm.UserEntity.FONT_SIZE; _pFONT_SETTING = new Font(_pFONT_TYPE, _pFONT_SIZE); //_pFTP_ID = MainForm.UserEntity.FTP_ID; //_pFTP_IP_PORT = MainForm.UserEntity.FTP_IP_PORT; //string.Format(@"{0}/{1}/", MainForm.UserEntity.FTP_IP_PORT, "test"); //화면 별 해당 위치 지정 //_pFTP_PW = MainForm.UserEntity.FTP_PW; _luIPROCESS_CODE_MST.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R", _pLANGUAGE_TYPE, "PROCESS_MST_CODE_COSMETICS_Lookup", "", "", "").Tables[0], 0, 0, "", true); //빈값이면 = 전체다 조회가능하게 disable if (_pPROCESS_MST_CODE_COSMETICS == "ALL") { _luIPROCESS_CODE_MST.ItemIndex = 0; _luIPROCESS_CODE_MST.ReadOnly = false; } else if (_pPROCESS_MST_CODE_COSMETICS == "PC01")//제조지시서만 { _luIPROCESS_CODE_MST.ItemIndex = 1; _luIPROCESS_CODE_MST.ReadOnly = true; } else if (_pPROCESS_MST_CODE_COSMETICS == "PC02") //포장지시서만 { _luIPROCESS_CODE_MST.ItemIndex = 2; _luIPROCESS_CODE_MST.ReadOnly = true; } else { _luIPROCESS_CODE_MST.ItemIndex = 0; _luIPROCESS_CODE_MST.ReadOnly = false; } _pWINDOW_NAME = this.Name; _pUSER_CODE = _pUserEntity.USER_CODE; _pUSER_NAME = _pUserEntity.USER_NAME; _pLANGUAGE_TYPE = _pUserEntity.LANGUAGE_TYPE; _pFONT_TYPE = _pUserEntity.FONT_TYPE; _pFONT_SIZE = _pUserEntity.FONT_SIZE; //메뉴 화면 엔티티 설정 _pPOPProductionOrderEntity = new POPProductionOrderEntity(); _pPOPProductionOrderEntity.CORP_CODE = _pUserEntity.CORP_CODE; _pPOPProductionOrderEntity.USER_CODE = _pUserEntity.USER_CODE; _pPOPProductionOrderEntity.LANGUAGE_TYPE = _pUserEntity.LANGUAGE_TYPE; if (_pUserEntity.PROCESS_CODE == "frmPOPMain_WEIGHING_COSMETICS") { _pPOPProductionOrderEntity.PROCESS_CODE = "PC01"; } else if (_pUserEntity.PROCESS_CODE == "frmPOPMain_MATERIAL_COSMETICS") { _pPOPProductionOrderEntity.PROCESS_CODE = "PC03"; } else { _pPOPProductionOrderEntity.PROCESS_CODE = _pUserEntity.PROCESS_CODE; } _pPOPProductionOrderEntity.RESOURCE_CODE = _pUserEntity.RESOURCE_CODE; //화면 설정 언어 & 명칭 변경. DataTable dtLanguage = new LanguageBusiness().Language_Info(_pWINDOW_NAME, _pLANGUAGE_TYPE); if (dtLanguage != null && dtLanguage.Rows.Count > 0) { CoFAS_ControlManager.Language_Info(dtLanguage, this); } //그리드 설정 InitializeGrid(); //화면 컨트롤러 설정 InitializeControl(); //그리드 초기화 ////여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화 //_pSampleRegisterEntity.CRUD = ""; //if (_pFirstYN) //{ MainFind_DisplayData(); //Dev Grid 데이터소스 로 바인딩 작업 처리 할 경우에는 최초 빈 데이터 테이블을 바인딩 해야 됨. _luIPROCESS_CODE_MST.ValueChanged += _luIPROCESS_CODE_MST_ValueChanged; // _pFirstYN = false; //} //SubFind_DisplayData("", ""); //Dev Grid 데이터소스 로 바인딩 작업 처리 할 경우에는 최초 빈 데이터 테이블을 바인딩 해야 됨. //컨트롤러 별 추가 이벤트 생성은 화면 설정 마지막에 진행 //_gdMAIN_VIEW.RowCellClick += _gdMAIN_VIEW_RowCellClick; //그리드 버튼추가 시 클릭 이벤트 처리 //CoFAS_DevExpressManager._OnButtonPressed += CoFAS_DevExpressManager__OnButtonPressed; //CoFAS_DevExpressManager._OnOpenButton += CoFAS_DevExpressManager__OnOpenButton; // CoFAS_DevExpressManager._OnOpenClick += CoFAS_DevExpressManager__OnOpenClick; //CoFAS_DevExpressManager._OnDownloadClick += CoFAS_DevExpressManager__OnDownloadClick; // CoFAS_DevExpressManager._OnDeleteClick += CoFAS_DevExpressManager__OnDeleteClick; //CoFAS_ControlManager.SetFontInControls(this.Controls, new Font("Arial", 8, FontStyle.Bold)); } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } }