// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new WorkReadingStatusBusiness().Sample_Info(_pWorkReadingStatusEntity);
if (_pWorkReadingStatusEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pWorkReadingStatusEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
//if (_pLocation_Code != "" && _pLocation_YN)
//{
// int rowHandle = _gdMAIN_VIEW.LocateByValue("INOUT_ID", _pLocation_Code);
// if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
// _gdMAIN_VIEW.FocusedRowHandle = rowHandle;
//
//
// //조회 후 초기화
// _pLocation_Code = "";
//}
}
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 MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pPOPLabelPrintEntity.CRUD = "R";
_dtList = new POPLabelPrintBusiness().POPProduction_Info(_pPOPLabelPrintEntity);
if (_pPOPLabelPrintEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPLabelPrintEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
_gdMAIN_VIEW.RowHeight = 80;
_gdMAIN_VIEW.Appearance.Row.Font = new Font("굴림", 25);
_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;
_gdMAIN_VIEW.Columns[1].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
_gdMAIN_VIEW.Columns[1].AppearanceHeader.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//_pDoorOpeningClosingStatusEntity.FROM_DATE = DateTime.Parse(_luT_DATE.FromDateTime.ToString()).ToString("yyyyMMdd");
//_pDoorOpeningClosingStatusEntity.TO_DATE = DateTime.Parse(_luT_DATE.ToDateTime.ToString()).ToString("yyyyMMdd");
//_pDoorOpeningClosingStatusEntity.RESOURCE_CODE = _luT_RESOURCE.GetValue();
//_pDoorOpeningClosingStatusEntity.INTERVAL = check;
_dtList = new DoorOpeningClosingStatusBusiness().Sample_Info(_pDoorOpeningClosingStatusEntity);
if (_pDoorOpeningClosingStatusEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pDoorOpeningClosingStatusEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
//if (_pLocation_Code != "" && _pLocation_YN)
//{
// int rowHandle = _gdMAIN_VIEW.LocateByValue("PART_CODE", _pLocation_Code);
// if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
// _gdMAIN_VIEW.FocusedRowHandle = rowHandle;
// //조회 후 초기화
// _pLocation_Code = "";
//}
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
InitializeControl();
}
}
catch (Exception)
{
throw;
}
finally
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new ProductPlanRegisterBusiness().ProductPlanMst_Info(_pProductPlanRegisterEntity);
if (_pProductPlanRegisterEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pProductPlanRegisterEntity.CRUD == ""))
{
//데이터 필드에 맞춰 자동 바인딩
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
if (_pLocation_Code != "" && _pLocation_YN)
{
int rowHandle = _gdMAIN_VIEW.LocateByValue("PRODUCT_PLAN_ID", _pLocation_Code);
if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
_gdMAIN_VIEW.FocusedRowHandle = rowHandle;
}
//조회 후 초기화
_pLocation_Code = "";
}
}
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
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void Refresh_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
pfrmPOPMain_PRESS_LINEEntity.CRUD = "R";
pfrmPOPMain_PRESS_LINEEntity.USER_CODE = _pUSER_CODE;
pfrmPOPMain_PRESS_LINEEntity.PRODUCTION_ORDER_ID = sPRODUCTION_ORDER_ID;
_dtList = new frmPOPMain_PRESS_LINEBusiness().pfrmPOPMain_PRESS_LINE_REFRESH(pfrmPOPMain_PRESS_LINEEntity);
if (pfrmPOPMain_PRESS_LINEEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && pfrmPOPMain_PRESS_LINEEntity.CRUD == ""))
{
_lbLOT_NO.Text = _dtList.Rows[0]["LOT_NO"].ToString();
_lbPRODUCTION_OK_QTY.Text = _dtList.Rows[0]["PRODUCTION_OK_QTY"].ToString();
//_lbPRODUCTION_NG_QTY.Text = _dtList.Rows[0]["PRODUCTION_NG_QTY"].ToString();
_lbPRODUCTION_PASS_QTY.Text = _dtList.Rows[0]["PRODUCTION_PASS_QTY"].ToString();
// 해당 LOT의 불량조회
_gdMAIN.DataSource = null;
_dtList_ng = new frmPOPMain_PRESS_LINEBusiness().pfrmPOPMain_PRESS_LINE_NG_LIST(pfrmPOPMain_PRESS_LINEEntity);
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList_ng);
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage("LOT 조회 내역이 없습니다.");
}
}
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);
_pPOPFirstMiddleLastEntity.CRUD = "R";
_pPOPFirstMiddleLastEntity.PRODUCTION_ORDER_ID = _pOrder_id;
_pPOPFirstMiddleLastEntity.CHECK_CYCLE = _luFIRSTMIDDLELAST_GUBN.GetValue();
_pPOPFirstMiddleLastEntity.LANGUAGE_TYPE = _pLANGUAGE_TYPE;
_pPOPFirstMiddleLastEntity.PART_CODE = _pPart_code2;
_pPOPFirstMiddleLastEntity.COLLECTION_DATE = DateTime.Now.ToString("yyyy-MM-dd");
_dtList = new POPFirstMiddleLastBusiness().POPFirstMiddleLast_Info(_pPOPFirstMiddleLastEntity);
if (_pPOPFirstMiddleLastEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPFirstMiddleLastEntity.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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pMenuAuthorityEntity.USER_ACCOUNT = _luUSER_MAIL.Text.ToString();
_pMenuAuthorityEntity.USER_NAME = _luUSER_NAME.Text.ToString();
_dtList = new MenuAuthorityBusiness().MenuAuthority_R10(_pMenuAuthorityEntity);
if (_pMenuAuthorityEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pMenuAuthorityEntity.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 SubFind_DisplayData(string strCRUD, string strCONTRACT_ID, string strPART_CODE, string strPART_TYPE, decimal pQTY)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new ucBOM_SpendQtyCalcPopBusiness().VendCost_Sub_Return(strCRUD, strCONTRACT_ID, strPART_CODE, strPART_TYPE, _pLANGUAGE_TYPE, pQTY);
if (_pCRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdBOM, _gdBOM_VIEW, _dtList);
// _gdBOM_VIEW.Columns["SPEND_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// _gdBOM_VIEW.Columns["LACK_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// _gdBOM_VIEW.Columns["STOCK"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// _gdBOM_VIEW.Columns["UNITCOST"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// _gdBOM_VIEW.Columns["ORDER_QTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//
// _gdBOM_VIEW.Columns["SPEND_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}";
// _gdBOM_VIEW.Columns["LACK_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}";
// _gdBOM_VIEW.Columns["STOCK"].DisplayFormat.FormatString = "{0:#,###.##0}";
// _gdBOM_VIEW.Columns["UNITCOST"].DisplayFormat.FormatString = "{0:#,###.##0}";
// _gdBOM_VIEW.Columns["ORDER_QTY"].DisplayFormat.FormatString = "{0:#,###.##0}";
}
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 MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucProductionOrderInfoPopup_T07_Entity.CRUD = "R";
_pucProductionOrderInfoPopup_T07_Entity.DATE_FROM = _ucPRODUCTION_PLAN_DATE.FromDateTime.ToString("yyyyMMdd");
_pucProductionOrderInfoPopup_T07_Entity.DATE_TO = _ucPRODUCTION_PLAN_DATE.ToDateTime.ToString("yyyyMMdd");
_pucProductionOrderInfoPopup_T07_Entity.CONTRACT_NUMBER = _luCONTRACT_NUMBER.Text;
_pucProductionOrderInfoPopup_T07_Entity.ORDER_NUMBER = _luORDER_NUMBER.Text;
//_pucProductionOrderInfoPopup_T04_Entity.PART_CODE = _luPART.CodeText;
//_pucProductionOrderInfoPopup_T04_Entity.PART_NAME = _luPART.NameText;
//_pucProductionOrderInfoPopup_T04_Entity.VEND_CODE = _luVEND.CodeText;
//_pucProductionOrderInfoPopup_T04_Entity.VEND_NAME = _luVEND.NameText;
_dtList = new pucProductionOrderInfoPopup_T07Business().ucProductionOrderInfoPopup_T07_Select(_pucProductionOrderInfoPopup_T07_Entity).Tables[0];
if (_pucProductionOrderInfoPopup_T07_Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucProductionOrderInfoPopup_T07_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);
}
}
// 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);
}
}
// 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 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);
}
}
// 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);
}
}
// 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);
}
}
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 SubFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucMatInspectDocumentListPopupEntity.CRUD = "R";
_pucMatInspectDocumentListPopupEntity.MATSTOCK_ID = _luMATSTOCK_ID2.Text.ToString();
_pucMatInspectDocumentListPopupEntity.MATSTOCK_DETAIL_SEQ = _luMATSTOCK_DETAIL_SEQ.Text.ToString();
_pucMatInspectDocumentListPopupEntity.INSPECT_ID = _luINSPECT_ID.Text.ToString();
_pucMatInspectDocumentListPopupEntity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.GetValue();
_pucMatInspectDocumentListPopupEntity.DOCUMENT_NAME = _luDOCUMENT_NAME.Text.ToString();
_pucMatInspectDocumentListPopupEntity.DOCUMENT_VER = _luDOCUMENT_VER.Text.ToString();
_pucMatInspectDocumentListPopupEntity.USE_YN = _luDOCUMENT_USE_YN.GetValue();
_dtList = new ucMatInspectDocumentListPopupBusiness().ucMatInspectDocumentListPopup_Info_Sub(_pucMatInspectDocumentListPopupEntity);
if (_pucMatInspectDocumentListPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucMatInspectDocumentListPopupEntity.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);
}
}
private void MainFind_DisplayData3()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pProductGoalMonthEntity.CRUD = "R";
_pProductGoalMonthEntity.USER_CODE = _pUSER_CODE;
_pProductGoalMonthEntity.DATE_FROM = DateTime.Parse(_luGOAL_DATE2.DateTime.ToString()).ToString("yyyy01");
_pProductGoalMonthEntity.GOAL_TYPE = "PD030003";
_dtList = new ProductGoalMonthBusiness().ProductGoalMonth_Info3(_pProductGoalMonthEntity);
//_dtList = new ProductGoalMonthBusiness().ProductGoalMonth_Info(_pProductGoalMonthEntity);
// _dtList = new ProductGoalMonthBusiness().ProductGoalMonth_Info(_pProductGoalMonthEntity);
if (_pProductGoalMonthEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pProductGoalMonthEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN3, _gdMAIN_VIEW3, _dtList); //데이터 필드에 맞춰 자동 바인딩
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
_dtList.Rows.Clear();
//Form_InitialButtonClicked(null, null);
CoFAS_DevExpressManager.BindGridControl(_gdMAIN3, _gdMAIN_VIEW3, _dtList); //데이터 필드에 맞춰 자동 바인딩
//InitializeControl();
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
finally
{
_gdMAIN_VIEW3.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void SubFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new InspectCodeMstRegisterBusiness().Inspect_Info_Detail(_pInspectCodeMstRegisterEntity);
if (_pInspectCodeMstRegisterEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if (_dtList != null) // && _dtList.Rows.Count > 0) || (_dtList != null && _pInspectCodeMstRegisterEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
_gdSUB_VIEW.RowHeight = 30;
//_gdSUB_VIEW.Appearance.Row.Font = new Font("굴림", 10);
//_gdSUB_VIEW.RowCellStyle += new RowCellStyleEventHandler(_gdSUB_VIEW_RowCellStyle);
RepositoryItemMemoEdit noteMemo = new RepositoryItemMemoEdit();
noteMemo.Appearance.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
// noteMemo.Appearance.TextOptions.VAlignment = DevExpress.Utils.VertAlignment.Center;
// noteMemo.apprea
_gdSUB_VIEW.Columns["INSPECT_VALUE"].ColumnEdit = noteMemo;
}
else
{
//DisplayMessage("상세 조회 내역이 없습니다.");
DisplayMessage(_pMSG_SEARCH_EMPT_DETAIL);
}
}
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);
string pFROM_DATE = _luTORDER_DATE.FromDateTime.ToString("yyyyMMdd");
string pTO_DATE = _luTORDER_DATE.ToDateTime.ToString("yyyyMMdd");
string strCODE = _luPART_NAME.Text.ToString(); //자재명
string strPART_TYPE = _pucWorkRequestInfoPopupEntity.PART_TYPE;
string pPRODUCTION_ORDER_ID = "";
string pPART_NAME = _luPART_NAME.Text;
string pPART_CODE = "";
string pPROCESS_CODE_MST = "";
_pCRUD = "R";
_dtList = new ucWorkRequestInfoPopupBusiness().ucWorkRequestInfoPopup_Return(_pCRUD, pFROM_DATE, pTO_DATE, pPRODUCTION_ORDER_ID, pPART_NAME, pPART_CODE, pPROCESS_CODE_MST).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 MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new POPProductionOrder_T50Business().POPWorker_Info();
if (_pPOPProductionOrder_T50Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pPOPProductionOrder_T50Entity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
_gdMAIN_VIEW.RowHeight = 60;
_gdMAIN_VIEW.Appearance.Row.Font = new Font("굴림", 10);
_gdMAIN_VIEW.RowStyle += new RowStyleEventHandler(gdMAIN_VIEW_RowStyle);
for (int i = 0; i < 2; i++)
{
_gdMAIN_VIEW.Columns[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
;
}
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);
}
}
// 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();
string strTYPE = _luPART_TYPE.GetValue();
//ucVendCodeInfoPopup_T01로 생성할것!!
_dtList = new CodePopUpBusiness().CodePopUp_Return(_pCRUD, _pLANGUAGE_TYPE, _pARRAY[0].ToString(), _pARRAY[1].ToString(), strCODE, strNAME, strTYPE, "", "", "").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.ShowInformationMessage("조회 내역이 없습니다.");
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
// InitializeControl();
}
}
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 _gdMAIN_VIEW_RowCellClick(object sender, RowCellClickEventArgs e)
{
try
{
GridView gv = sender as GridView;
CoFAS_ControlManager.Controls_Binding(gv, false, this);
int qRowIndex = gv.FocusedRowHandle;
//string qColumnHeader = e.Column.Caption;
//선택한 행의 셀이 작업지시일자인 데이터를 변수에 저장
string qWorkOrderID = gv.GetRowCellValue(qRowIndex, "PRODUCTION_ORDER_ID").ToString();
//_pManufacturingHistoryEntity.PRODUCTION_ORDER_ID = gv.GetRowCellValue(qRowIndex, "PRODUCTION_ORDER_ID").ToString();
_gdMAIN_index = qRowIndex;
// 작업지시를 인수로 넘겨서 해당 메소드 실행
SubFind_DisplayData(qWorkOrderID);
SubFind_DisplayData2(qWorkOrderID);
if ((_dtSub != null && _dtSub.Rows.Count > 0) || (_dtSub != null && _pManufacturingHistory_T01Entity.CRUD == "") ||
(_dtSub2 != null && _dtSub2.Rows.Count > 0) || (_dtSub2 != null && _pManufacturingHistory_T01Entity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtSub);
CoFAS_DevExpressManager.BindGridControl(_gdSUB2, _gdSUB2_VIEW, _dtSub2);
}
else
{
//알림 - 조회할 데이터가 없습니다.
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
_dtSub.Rows.Clear();
CoFAS_DevExpressManager.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtSub);
_dtSub2.Rows.Clear();
CoFAS_DevExpressManager.BindGridControl(_gdSUB2, _gdSUB2_VIEW, _dtSub2);
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void SubFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucPartDocumentListPopup_T02Entity.CRUD = "R";
_pucPartDocumentListPopup_T02Entity.DOCUMENT_TYPE = _luDOCUMENT_TYPE.GetValue();
_pucPartDocumentListPopup_T02Entity.USE_YN = _luDOCUMENT_USE_YN.GetValue();
_pucPartDocumentListPopup_T02Entity.PART_CODE = _luPART_CODE2.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.CONTRACT_ID = "";
//_pucPartDocumentListPopup_T02Entity.CONTRACT_NUMBER = "";
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_NAME = "";// _luDOCUMENT_NAME.Text.ToString();
//_pucPartDocumentListPopup_T02Entity.DOCUMENT_VER = "";//_luDOCUMENT_VER.Text.ToString();
_dtList = new ucPartDocumentListPopup_T02Business().ucPartDocumentListPopup_T02_Info_Sub(_pucPartDocumentListPopup_T02Entity);
if (_pucPartDocumentListPopup_T02Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucPartDocumentListPopup_T02Entity.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);
}
}
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new ucTABCommentBusiness().ucTABComment_Info_Return(_pucTABCommentEntity);
if (_pucTABCommentEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucTABCommentEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
_gdMAIN_VIEW.RowHeight = 80;
_gdMAIN_VIEW.Appearance.Row.Font = new Font("Meiryo UI", 18);
_gdMAIN_VIEW.RowStyle += new RowStyleEventHandler(gdMAIN_VIEW_RowStyle);
_gdMAIN_VIEW.Appearance.FocusedRow.BackColor = Color.Red;
_gdMAIN_VIEW.Appearance.FocusedRow.Font = new Font("Meiryo UI", 18);
}
else
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
// InitializeControl();
}
}
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);
// string strCODE = _luCD.Text.ToString();
// string strNAME = _luCD_NM.Text.ToString();
// string strTYPE = _luPART_TYPE.GetValue();
// //ucVendCodeInfoPopup_T04로 생성할것!!
// _dtList = new CodePopUpBusiness().CodePopUp_Return(_pCRUD, _pLANGUAGE_TYPE, _pARRAY[0].ToString(), _pARRAY[1].ToString(), strCODE, strNAME, strTYPE, "", "", "").Tables[0];
// if (_pCRUD == "") _dtList.Rows.Clear();
// if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pCRUD == ""))
// {
// 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);
// }
//}
//#endregion
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
string strCRUD = "R";
string strLanguage = _pLANGUAGE_TYPE;
string strCODE = _luCD.Text.ToString();
string strNAME = _luCD_NM.Text.ToString();
string strSERVICE_NAME = "VEND_CODE_INFO_T04";
_dtList = new VendCodeInfoPopup_T04Business().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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
//string FromDATE = _luORDER_DATE1.DateTime.ToString("yyyyMMdd");
//string ToDATE = _luORDER_DATE2.DateTime.ToString("yyyyMMdd");
string FromDATE = _luTORDER_DATE.FromDateTime.ToString("yyyyMMdd");
string ToDATE = _luTORDER_DATE.ToDateTime.ToString("yyyyMMdd");
string strCODE = _luPART_NAME.Text.ToString(); //자재명
string strNAME = _luVEND_NAME.Text.ToString(); //거래처명
_pCRUD = "R";
_dtList = new MaterialOrderInfoPopup_RequestBusiness().MaterialOrderInfoPopup_Return(_pCRUD, FromDATE, ToDATE, 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);
}
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pMenuAuthority_T02Entity.CRUD = "R";
_pMenuAuthority_T02Entity.USER_ACCOUNT = "";
_pMenuAuthority_T02Entity.USER_NAME = "";
_pMenuAuthority_T02Entity.USE_YN = "Y";
//_pMenuAuthority_T02Entity.PART_CODE = _luPART_CODE.Text.ToString();
//_pMenuAuthority_T02Entity.PART_REVISION_NO = _luPART_REVISION_NO.Text.ToString();
_dtList = new MenuAuthority_T02Business().MenuAuthority_T02_R40(_pMenuAuthority_T02Entity);
if (_pMenuAuthority_T02Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pMenuAuthority_T02Entity.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 MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pInspectPartMappingRegisterEntity.PART_TYPE = _luTPART_TYPE.GetValue();
_pInspectPartMappingRegisterEntity.PART_NAME = _luPART_NAME.Text;
_pInspectPartMappingRegisterEntity.VEND_PART_CODE = _luVEND_PART_CODE.Text;
_pInspectPartMappingRegisterEntity.USE_YN = _luTUSE_YN.GetValue();
_dtList = new InspectPartMappingRegisterBusiness().InspectPart_Info_Mst(_pInspectPartMappingRegisterEntity);
if (_pInspectPartMappingRegisterEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pInspectPartMappingRegisterEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
_pInspectPartMappingRegisterEntity.CRUD = "";
MainFind_DisplayData();
InitializeControl();
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 Sub01Find_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pInspectPartMappingRegisterEntity.CRUD = "R";
_pInspectPartMappingRegisterEntity.PART_TYPE = _luTPART_TYPE.GetValue();
_dtSub1 = new InspectPartMappingRegisterBusiness().InspectPart_Info_Sub1(_pInspectPartMappingRegisterEntity);
if (_pInspectPartMappingRegisterEntity.CRUD == "")
{
_dtSub1.Rows.Clear();
}
if ((_dtSub1 != null && _dtSub1.Rows.Count > 0) || (_dtSub1 != null && _pInspectPartMappingRegisterEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdSUB01, _gdSUB01_VIEW, _dtSub1);
_gdSUB01_VIEW.RowHeight = 50;
RepositoryItemMemoEdit noteMemo = new RepositoryItemMemoEdit();
noteMemo.Appearance.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
_gdSUB01_VIEW.Columns["INSPECT_VALUE"].ColumnEdit = noteMemo;
}
else
{
_pInspectPartMappingRegisterEntity.CRUD = "";
_gdSUB01.DataSource = null;
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);
}
}
// DB 처리
#region ○ 메인조회 - MainFind_DisplayData()
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucProductionPartListPopup_T01Entity.CRUD = "R";
_pucProductionPartListPopup_T01Entity.VEND_PART_CODE = _luVEND_PART_CODE.Text.ToString();
_pucProductionPartListPopup_T01Entity.PART_NAME = _luPART_NAME.Text.ToString();
_pucProductionPartListPopup_T01Entity.PART_REVISION_NO = _luPART_REVISION_NO.Text.ToString();
_pucProductionPartListPopup_T01Entity.PART_HIGH = _luPART_HIGH.Text.ToString();
_pucProductionPartListPopup_T01Entity.PART_MIDDLE = _luPART_MIDDLE.Text.ToString();
_pucProductionPartListPopup_T01Entity.PART_LOW = _luPART_LOW.Text.ToString();
_dtList = new ucProductionPartListPopup_T01Business().ucProductionPartListPopup_Info_Return(_pucProductionPartListPopup_T01Entity);
if (_pucProductionPartListPopup_T01Entity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucProductionPartListPopup_T01Entity.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);
}
}
