private void _btSAVE_Click(object sender, EventArgs e)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes)
{
_pucMaterialVendCostInfoListPopupEntity.PART_CODE = _luPART_CODE.Text.ToString();
_pucMaterialVendCostInfoListPopupEntity.PART_REVISION_NO = _luPART_REVISION_NO.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);
}
}
//private void CoFAS_DevExpressManager__OnButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
//{
// //_gdMAIN_VIEW.EditingValue = "";
// switch (e.Button.Caption.ToString())
// {
// case "TEST": //해당 그리드에 필드명 // 2개 이상 그리드의 버튼 항목들은 버튼 타입에 필드 명칭이 모두 다르게 설정 되어야됨.
// frmCommonPopup.CORP_CDDE = _pCORP_CODE;
// 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("CommonCode"); //유저컨트롤러 설정 부분
// 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();
// break;
// }
//}
#endregion
// 메인 버튼 처리영역
#region ○ 조회 버튼 클릭시 처리하기
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pRuleGeneratorEntity.CRUD = "R";
_pRuleGeneratorEntity.RULE_OPTION = _luOPTSEARCH.Text;
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);
}
}
// 추가 이벤트 생성
#region ○ 메인 그리드 로우 선택 이벤트 생성 - _gdMAIN_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
private void _gdMAIN_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
{
try
{
GridView gv = sender as GridView;
//CoFAS_ControlManager.Controls_Binding(gv, false, this);
if (e.RowHandle < 0)
{
return;
}
string strRESOURCE_CODE = gv.GetFocusedRowCellValue("RESOURCE_CODE").ToString();
string strRULE_OPTION = gv.GetFocusedRowCellValue("RULE_OPTION").ToString();
_pRuleGeneratorEntity.CRUD = "R";
SubFind_DisplayData(strRESOURCE_CODE, strRULE_OPTION);
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
// 메인 버튼 처리영역
#region ○ 조회 버튼 클릭시 처리하기
private void Form_SearchButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pScheduling_T50Entity.CRUD = "R";
_pScheduling_T50Entity.VEND_NAME = chkAll.Checked == true ? "ALL" : "";
Cleartlp();
MainFind_DisplayData();
SUBFind_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);
}
}
private void SubFind_DisplayData(string qWorkOrder)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pManufacturingHistory_T01Entity.PRODUCTION_ORDER_ID = qWorkOrder;
_dtSub = new ManufacturingHistory_T01Business().ManufacturingHistory_T01_Info_Sub(_pManufacturingHistory_T01Entity);
if (_pManufacturingHistory_T01Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtSub != null && _dtSub.Rows.Count > 0) || (_dtSub != null && _pManufacturingHistory_T01Entity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtSub);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
_dtSub.Rows.Clear();
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtSub);
}
}
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 _luORDER_ID__OnButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
CoFAS_MES.UI.QC.UserForm.frmCommonPopup.USER_CODE = _pUSER_CODE;
CoFAS_MES.UI.QC.UserForm.frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
CoFAS_MES.UI.QC.UserForm.frmCommonPopup.FONT_TYPE = _pFONT_SETTING;
CoFAS_MES.UI.QC.UserForm.frmCommonPopup.ARRAY = new object[2] {
"MaterialOrder", ""
}; //넘기는 파라메터 에 따라 설정, 제품/조회할때 품목명을 던지기
CoFAS_MES.UI.QC.UserForm.frmCommonPopup.ARRAY_CODE = new object[2] {
_luORDER_ID.Text, ""
};
CoFAS_MES.UI.QC.UserForm.frmCommonPopup xfrmCommonPopup = new CoFAS_MES.UI.QC.UserForm.frmCommonPopup("ImportInspectOrder"); //유저컨트롤러 설정 부분
xfrmCommonPopup.ShowDialog();
if (xfrmCommonPopup.dtReturn == null)
{
xfrmCommonPopup.Dispose();
return;
}
if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0)
{
_luORDER_ID.Text = xfrmCommonPopup.dtReturn.Rows[0]["ORDER_ID"].ToString();
_luPART_NAME.Text = xfrmCommonPopup.dtReturn.Rows[0]["PART_NAME"].ToString();
}
xfrmCommonPopup.Dispose();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void Sub02Find_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtSub2 = new InspectPartMappingRegisterBusiness().InspectPart_Info_Sub2(_pInspectPartMappingRegisterEntity);
if (_pInspectPartMappingRegisterEntity.CRUD == "")
{
_dtSub2.Rows.Clear();
}
if ((_dtSub2 != null && _dtSub2.Rows.Count > 0) || (_dtSub2 != null && _pInspectPartMappingRegisterEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB02, _gdSUB02_VIEW, _dtSub2);
_gdSUB02_VIEW.RowHeight = 50;
RepositoryItemMemoEdit noteMemo = new RepositoryItemMemoEdit();
noteMemo.Appearance.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
_gdSUB02_VIEW.Columns["INSPECT_VALUE"].ColumnEdit = noteMemo;
}
else
{
_pInspectPartMappingRegisterEntity.CRUD = "";
CoFAS_DevExpressManager.BindGridControl(_gdSUB02, _gdSUB02_VIEW, _dtSub2);
DisplayMessage(_pMSG_SEARCH_EMPT);
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
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _gdSUB01_VIEW_DoubleClick(object pObject, EventArgs pEventArgs)
{
try
{
GridView gv = pObject as GridView;
if (_pPART_TYPE == "" || _pPART_CODE == "" || _pPART_NAME == "")
{
return;
}
if ((_gdSUB02_VIEW.GridControl != null && CoFAS_ConvertManager.DataTable_FindCount(_gdSUB02_VIEW.GridControl.DataSource as DataTable, "INSPECT_CODE IN ('" + gv.GetFocusedRowCellValue("INSPECT_CODE").ToString() + "')", "")))
{
CoFAS_DevExpressManager.ShowInformationMessage("이미 등록된 시험검사항목입니다.");
return;
}
GridView gv1 = _gdSUB02_VIEW as GridView;
gv1.OptionsBehavior.Editable = true;
gv1.AddNewRow();
gv1.SetRowCellValue(gv1.FocusedRowHandle, "CRUD", "C");
gv1.SetRowCellValue(gv1.FocusedRowHandle, "PART_TYPE", _pPART_TYPE);
gv1.SetRowCellValue(gv1.FocusedRowHandle, "PART_CODE", _pPART_CODE);
gv1.SetRowCellValue(gv1.FocusedRowHandle, "PART_NAME", _pPART_NAME);
gv1.SetRowCellValue(gv1.FocusedRowHandle, "INSPECT_CODE", gv.GetFocusedRowCellValue("INSPECT_CODE").ToString());
gv1.SetRowCellValue(gv1.FocusedRowHandle, "INSPECT_NAME", gv.GetFocusedRowCellValue("INSPECT_NAME").ToString());
gv1.SetRowCellValue(gv1.FocusedRowHandle, "INSPECT_VALUE", gv.GetFocusedRowCellValue("INSPECT_VALUE").ToString());
gv1.SetRowCellValue(gv1.FocusedRowHandle, "REMARK", "");
gv.Focus();
gv1.Focus();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void InitializeControl()
{
try
{
//조회조건 영역
_luT_ORDER_DATE.FromDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //조회 시작일, 매월 초 날짜로 설정
_luT_ORDER_DATE.ToDateTime = DateTime.Today; //조회 종료일, 당일 설정
_luT_PART.CodeText = "";
_luT_PART.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;
}
_pNgResultRegisterEntity.CRUD = "";
Dashboard_DisplayData();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
}
}
// DB 처리
#region ○ 메인 조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucPartProcessMapping_Popup_T01Entity.PART_HIGH = _luPART_HIGH.Text.ToString();
_pucPartProcessMapping_Popup_T01Entity.PART_MIDDLE = _luPART_MIDDLE.Text.ToString();
_pucPartProcessMapping_Popup_T01Entity.PART_LOW = _luPART_LOW.Text.ToString();
_dtList = new ucPartProcessMapping_PopUp_T01Business().PartProcessMapping_Info_MST(_pucPartProcessMapping_Popup_T01Entity);
if (_pucPartProcessMapping_Popup_T01Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucPartProcessMapping_Popup_T01Entity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
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_DeleteButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
if (_gdSUB_VIEW.GetFocusedRowCellValue(_gdSUB_VIEW.Columns["CRUD"]).ToString() == "C")
{
// 신규 데이터는 로우 삭제
_gdSUB_VIEW.DeleteRow(_gdSUB_VIEW.FocusedRowHandle);
}
else
{
// 수정 데이터는 "CRUD" 처리
_gdSUB_VIEW.SetRowCellValue(_gdSUB_VIEW.FocusedRowHandle, _gdSUB_VIEW.Columns["CRUD"], "D");
}
// 수정 후 포커스 이동 안되면 데이터 반영 안됨.
// 삭제 버튼 클릭시에는 GetFocusedDataRow().EndEdit() 처리 해야됨.
// 마우스 팝업 메뉴에서 처리는 자동으로 처리됨.
_gdSUB_VIEW.GetFocusedDataRow().EndEdit();
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucMaterialVendCostInfoListPopupEntity.CRUD = "R";
_pucMaterialVendCostInfoListPopupEntity.PART_CODE = _luPART_CODE.Text.ToString();
_pucMaterialVendCostInfoListPopupEntity.PART_REVISION_NO = _luPART_REVISION_NO.Text.ToString();
_dtList = new ucMaterialVendCostInfoListPopupBusiness().ucMaterialVendCostInfoListPopup_Info_Return(_pucMaterialVendCostInfoListPopupEntity);
if (_pucMaterialVendCostInfoListPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucMaterialVendCostInfoListPopupEntity.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 InitializeControl2()
{
try
{
_luWASHER_CODE.Text = "";
_luWASHER_CODE.ReadOnly = true;
_luWASHER_NAME.Text = "";
_luWASHER_UNIT.Text = "";
_luWASHER_UNIT.ReadOnly = true;
_luWASHER_STANDARD.Text = "";
_luT_VEND_PART_CODE.Text = "";
_luWASHER_COST.Text = "";
_luWASHER_COST.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
_luSAFE_STOCK.Text = "";
_luSAFE_STOCK.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
_luUSE_YN.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R", _pLANGUAGE_TYPE, "USE_YN", "", "", "").Tables[0], 0, 0, "");
_luUSE_YN.ItemIndex = 0;
_luUSE_YN.ReadOnly = false;
// 컨트롤러 유효성 검증 처리 기본 컨트롤러 에서만 사용
dxValidationProvider.ValidationMode = DevExpress.XtraEditors.DXErrorProvider.ValidationMode.Manual;
dxValidationProvider.Validate();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
}
}
private void InitializeControl()
{
try
{
//조회조건 영역
_luTCONTRACT_ID.Text = "";
_luTPART.CodeText = "";
_luTPART.NameText = "";
_luTVEND.CodeText = "";
_luTVEND.NameText = "";
_luTCONTRACT_DATE.FromDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //조회 시작일, 매월 초 날짜로 설정
_luTCONTRACT_DATE.ToDateTime = DateTime.Today; //조회 종료일, 당일 설정
// 컨트롤러 유효성 검증 처리 기본 컨트롤러 에서만 사용
dxValidationProvider.ValidationMode = DevExpress.XtraEditors.DXErrorProvider.ValidationMode.Manual;
dxValidationProvider.Validate();
//dxValidationProvider.SetValidationRule(_luGRID_NAME, NotEmptyValidationRule);
//dxValidationProvider.SetValidationRule(_luGRIDVIEW_NAME, NotEmptyValidationRule);
// 컨트롤러 유효성 검증 처리
//그리드 초기화
//여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화
if (_pFirstYN)
{
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strCRUD = "R";
string strLanguage = _pLANGUAGE_TYPE;
_dtList = new VendCodeInfoPopup_T02Business().VendCodeInfoPopup_Return(strCRUD, strCODE, strNAME, strSERVICE_NAME, strLanguage).Tables[0];
if (_pCRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
{
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 SubFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucToolDocumentListPopupEntity.CRUD = "R";
_pucToolDocumentListPopupEntity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.GetValue();
_pucToolDocumentListPopupEntity.DOCUMENT_NAME = _luDOCUMENT_NAME.Text.ToString();
_pucToolDocumentListPopupEntity.DOCUMENT_VER = _luDOCUMENT_VER.Text.ToString();
_pucToolDocumentListPopupEntity.DOCUMENT_FILE_NAME = "";
_pucToolDocumentListPopupEntity.USE_YN = _luDOCUMENT_USE_YN.GetValue();
_dtList = new ucToolDocumentListPopupBusiness().ucToolDocumentListPopup_Info_Sub(_pucToolDocumentListPopupEntity);
if (_pucToolDocumentListPopupEntity.CRUD == "") _dtList.Rows.Clear();
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucToolDocumentListPopupEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList);
}
if (_dtList.Rows.Count == 0)
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList);
}
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pSystemLogInfoStatusEntity.USER_ACCOUNT = _luUSER_ACCOUNT.Text.ToString();
_pSystemLogInfoStatusEntity.USER_NAME = _luUSER_NAME.Text.ToString();
_dtList = new SystemLogInfoStatusBusiness().SystemLogInfoStatus_R10(_pSystemLogInfoStatusEntity);
if (_pSystemLogInfoStatusEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pSystemLogInfoStatusEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
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 ucToolDocumentListPopup_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();
}
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;//화면에 모든 항목 폰트 재설정
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucOrderNumberInfoListPopupEntity.CRUD = "R";
_pucOrderNumberInfoListPopupEntity.DATE_FROM = _luTORDER_DATE.FromDateTime.ToString("yyyyMMdd");
_pucOrderNumberInfoListPopupEntity.DATE_TO = _luTORDER_DATE.ToDateTime.ToString("yyyyMMdd");
_pucOrderNumberInfoListPopupEntity.ORDER_NUMBER = _luTORDER_NUMBER.Text.ToString();
_pucOrderNumberInfoListPopupEntity.ORDER_NAME = _luTORDER_NAME.Text.ToString();
_dtList = new ucOrderNumberInfoListPopupBusiness().OrderNumber_Info_Mst(_pucOrderNumberInfoListPopupEntity);
if (_pucOrderNumberInfoListPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucOrderNumberInfoListPopupEntity.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 InitializeControl()
{
try
{
// 컨트롤러 유효성 검증 처리 기본 컨트롤러 에서만 사용
dxValidationProvider.ValidationMode = DevExpress.XtraEditors.DXErrorProvider.ValidationMode.Manual;
dxValidationProvider.Validate();
_luTORDER_DATE.FromDateTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //조회 시작일, 매월 초 날짜로 설정
_luTORDER_DATE.ToDateTime = DateTime.Today; //조회 종료일, 당일 설정
_luTSTOP_DETAIL.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R", "", "STOP_DETAIL_YB", _luTSTOP_MST.GetValue(), "", "").Tables[0], 0, 0, "", true);
_gdMAIN.DataSource = null;
//dxValidationProvider.SetValidationRule(_luGRID_NAME, NotEmptyValidationRule);
//dxValidationProvider.SetValidationRule(_luGRIDVIEW_NAME, NotEmptyValidationRule);
// 컨트롤러 유효성 검증 처리
_luTTERMINAL_LIST.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R", _pLANGUAGE_TYPE, "Terminal_detail_yb", "", "", "").Tables[0], 0, 0, "");
_luTSTOP_MST.AddValue(new CommonCodeReturnBusiness().CommonCode_Return("R", _pLANGUAGE_TYPE, "STOP_CATEGORY_YB", "", "", "").Tables[0], 0, 0, "", true);
//그리드 초기화
//여러 그리드 사용시 마스터 그리드는 최초 실행 시에만 초기화
if (_pFirstYN)
{
//_gdMAIN.DataSource = null;
_gdMAIN_VIEW = CoFAS_DevExpressManager.Grid_Setting(_gdMAIN, _gdMAIN_VIEW, _pFONT_SETTING, _pLANGUAGE_TYPE, new DevGridSettingBusiness().DevGrid_Info(_pLANGUAGE_TYPE, _pWINDOW_NAME, _gdMAIN.Name.ToString()));
}
_pEquipmentStopHistoryEntity.CRUD = "R";
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
finally
{
}
}
private void Form_ImportButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
OpenFileDialog opd = new OpenFileDialog();
opd.FileName = "";
opd.Filter = "xlsx파일(*.xlsx)|*.xlsx";
opd.Title = "엑셀 저장";
if (opd.ShowDialog() == DialogResult.OK)
{
fileName = opd.SafeFileName;
fileFullName = opd.FileName;
filePath = fileFullName.Replace(fileName, "");
spreadsheetControl1.LoadDocument(fileFullName);
wb = spreadsheetControl1.Document;
basewb = spreadsheetControl1.Document;
worksheetName = spreadsheetControl1.ActiveSheet.Name;
worksheet = wb.Worksheets[worksheetName];
}
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strCODE = _luCD.Text.ToString();
string strNAME = _luCD_NM.Text.ToString();
_dtList = new CodePopUpBusiness().CodePopUp_Return(_pCRUD, _pLANGUAGE_TYPE, _pARRAY[0].ToString(), _pARRAY[1].ToString(), strCODE, strNAME, "", "", "", "").Tables[0];
if (_pCRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
CoFAS_DevExpressManager.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 SubFind_DisplayData(string strWINDOW_NAME, string strGRID_NAME)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//_pGridInfoRegisterEntity.WINDOW_NAME = strWINDOW_NAME;
//_pGridInfoRegisterEntity.GRID_NAME = strGRID_NAME;
//_dtList = new MaterialCollectAndPayBusiness().Sample_Info_Sub(_pMaterialCollectAndPayEntity);
if (_pMaterialCollectAndPayEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pMaterialCollectAndPayEntity.CRUD == ""))
{
// CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
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
{
// _gdSUB_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _ucbtCalc_Click(object sender, EventArgs e)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
DataTable tDataTable = _gdCONTRACT_VIEW.GridControl.DataSource as DataTable;
_ucBOM_SpendQtyCalcPopEntity.CRUD = "R";
_ucBOM_SpendQtyCalcPopEntity.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
_ucBOM_SpendQtyCalcPopEntity.check_yn = false;
_dtList = new ucBOM_SpendQtyCalcPopBusiness().VendCost_Sub_Return(_ucBOM_SpendQtyCalcPopEntity, tDataTable);
if (_pCRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdBOM, _gdBOM_VIEW, _dtList);
}
else
{
// CoFAS_DevExpressManager.BindGridControl(_gdVEND, _gdVEND_VIEW, null);
_gdBOM.DataSource = null;
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
_gdBOM_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _luTPART__OnOpenClick(object sender, EventArgs e)
{
try
{
frmCommonPopup.USER_CODE = _pUSER_CODE;
frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmCommonPopup.FONT_TYPE = _pFONT_SETTING;
frmCommonPopup.ARRAY = new object[2] {
"Product_Code", _luT_PART.NameText
}; //넘기는 파라메터 에 따라 설정, 제품/조회할때 품목명을 던지기
frmCommonPopup.ARRAY_CODE = new object[2] {
_luT_PART.CodeText, _luT_PART.NameText
};
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)
{
_luT_PART.CodeText = xfrmCommonPopup.dtReturn.Rows[0]["PART_CODE"].ToString();
_luT_PART.NameText = xfrmCommonPopup.dtReturn.Rows[0]["PART_NAME"].ToString();
}
xfrmCommonPopup.Dispose();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void _luVEND__OnButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
////VendCostInfo
//frmCommonPopup.CRUD = "R";
//frmCommonPopup.USER_CODE = _pUSER_CODE;
//frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
//frmCommonPopup.FONT_TYPE = fntPARENT_FONT;
//// 0 서비스네임 1 공통코드경우 CODE_TYPE 으로구분자 올린다.
//frmCommonPopup.ARRAY = new object[2] { "Vend_Code_O", "" };
////검색조건 전달 0 코드 1 명칭
//frmCommonPopup.ARRAY_CODE = new object[2] { _luVEND.CodeText.ToString(), _luVEND.NameText.ToString() };
////ucVendCodeInfoPopup xucVendCodeInfoPopup = new CORE.UserControls.ucVendCodeInfoPopup("PartCodeInfo"); //유저컨트롤러 설정 부분
//frmCommonPopup xfrmCommonPopup = new CORE.UserForm.frmCommonPopup("CommonCode"); //유저컨트롤러 설정 부분
//xfrmCommonPopup.ShowDialog();
//if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0)
//{
// _luVEND.CodeText = xfrmCommonPopup.dtReturn.Rows[0]["CD"].ToString();
// _luVEND.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 (!dxValidationProvider.Validate())
{
return;
}
//확인
//if (_luGRID_NAME.ReadOnly)
//{
// _pSampleRegisterEntity.CRUD = "U";
//}
//else
//{
// _pSampleRegisterEntity.CRUD = "C";
//}
//InputData_Save(_gdSUB_VIEW.GridControl.DataSource as DataTable);
}
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);
_pResultStatusDataEntity.CRUD = "R";
_pResultStatusDataEntity.DATE_FROM = DateTime.Parse(_luT_ORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd"); // Convert.ToString(_luT_ORDER_DATE.FromDateTime).Substring(0, 10).Replace("-", "");
_pResultStatusDataEntity.DATE_TO = DateTime.Parse(_luT_ORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd"); // Convert.ToString(_luT_ORDER_DATE.ToDateTime).Substring(0, 10).Replace("-", "");
DateTime stdate = _luT_ORDER_DATE.FromDateTime;
DateTime ltdate = _luT_ORDER_DATE.ToDateTime;
//if ((ltdate.Date - stdate.Date).Days < 1)
if ((ltdate.Date - stdate.Date).Days < 0)
{
CoFAS_DevExpressManager.ShowErrorMessage("시작일, 종료일을 확인해주세요.");
return;
}
_pResultStatusDataEntity.CRUD = "R";
MainFind_DisplayData();
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);
}
}
private void Form_SaveButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
if (!dxValidationProvider.Validate())
{
return;
}
}
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 _luTPLAN_ORDER__OnButtonPressed(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
frmCommonPopup.USER_CODE = _pUSER_CODE;
frmCommonPopup.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
frmCommonPopup.FONT_TYPE = _pFONT_SETTING;
frmCommonPopup.ARRAY = new object[2] {
"PlanOrderInfo_Popup", ""
}; //넘기는 파라메터 에 따라 설정, 제품/조회할때 품목명을 던지기
frmCommonPopup.ARRAY_CODE = new object[2] {
_luTPLAN_ORDER.Text, ""
};
frmCommonPopup xfrmCommonPopup = new CORE.UserForm.frmCommonPopup("PlanOrderInfo_Popup"); //유저컨트롤러 설정 부분
xfrmCommonPopup.ShowDialog();
if (xfrmCommonPopup.dtReturn == null)
{
xfrmCommonPopup.Dispose();
return;
}
if (xfrmCommonPopup.dtReturn != null && xfrmCommonPopup.dtReturn.Rows.Count > 0)
{
_luTPLAN_ORDER.Text = xfrmCommonPopup.dtReturn.Rows[0]["PLAN_ORDER"].ToString();
}
xfrmCommonPopup.Dispose();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
