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