private void _btSELECT_Click(object sender, EventArgs e)
{
if (_luTPART_ALL.CodeText == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("먼저 품목을 선택해 주세요.");
return;
}
//if (_luTORDER_DATE.FromDateTime > _luTORDER_DATE.ToDateTime)
//{
// //CoFAS_DevExpressManager.ShowInformationMessage("조회 일자를 확인해 주세요.");
// CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_CHECK_SEARCH_DATE);
//}
//else
//{
_pCRUD = "R";
MainFind_DisplayData(); //Dev Grid 데이터소스 로 바인딩 작업 처리 할 경우에는 최초 빈 데이터 테이블을 바인딩 해야 됨.
// }
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (Good.Text == "0" && Bad.Text == "0")
{
CoFAS_DevExpressManager.ShowInformationMessage("実績を入れてください。");
return;
}
else if (CoFAS_DevExpressManager.ShowQuestionMessage("実績を登録しますか？") == DialogResult.Yes)
{
this.DialogResult = DialogResult.OK;
ReturnValue4 = Bad.Text;
ReturnValue5 = PopupValue;
ReturnValue6 = Good.Text;
}
else
{
this.Close();
}
}
private void _gdMAIN_VIEW_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView g = sender as GridView;
// gv.GetFocusedRowCellValue("FILE_NAME").ToString();
int selectedRowNum = g.FocusedRowHandle;
int selectedCellNum = g.FocusedColumn.VisibleIndex;
decimal input_qty = Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "INPUT_QTY") == ""?"0": g.GetRowCellDisplayText(selectedRowNum, "INPUT_QTY"));
decimal possible_qty = Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "POSSIBLE_QTY") == "" ? "0" : g.GetRowCellDisplayText(selectedRowNum, "POSSIBLE_QTY"));
//입력하기 전 글자 길이
// if (Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "INPUT_QTY")) > Convert.ToDecimal(g.GetRowCellDisplayText(selectedRowNum, "POSSIBLE_QTY")))
if (input_qty > possible_qty)
{
CoFAS_DevExpressManager.ShowInformationMessage("출고가능수량을 초과할 수 없습니다.");
g.SetRowCellValue(selectedRowNum, "INPUT_QTY", before_input_qty);
return;
}
}
private void _ucbtVERIFY_Click(object sender, EventArgs e)
{
string strEncrypt = "";
string strDecrypt = "";
strEncrypt = CoFAS_AES256Encrypt.EncryptToString(_luPERMISSIONS.Text.ToString(), "COEVER", saltBytes, false);
strDecrypt = CoFAS_AES256Encrypt.DecryptToString(strEncrypt, "COEVER", saltBytes, false);
if (strDecrypt == strPermissionCode)
{
isReturnGrant = true;
Close();
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage(strMsg);
}
}
private void _ucbtAccept_Click(object sender, EventArgs e)
{
_pucProductStockInfoPopupEntity.CORP_CODE = _pCORP_CODE;
_pucProductStockInfoPopupEntity.USER_CODE = _pUSER_CODE;
_pucProductStockInfoPopupEntity.INOUT_CODE = _luINOUT_CODE.GetValue(); //콤보박스로 체크할것
int cnt = 0;
DataTable tDataTable = _gdMAIN_VIEW.GridControl.DataSource as DataTable;
//for (int i = 0; i < tDataTable.Rows.Count; i++)
//{
// if (tDataTable.Rows[i]["CRUD"].ToString() == "Y")
// {
//
// cnt++;
// }
//}
//if (cnt == 0)
//{
// CoFAS_DevExpressManager.ShowInformationMessage("하나 이상의 의뢰를 선택하세요");
// return;
//}
//if (CoFAS_DevExpressManager.ShowQuestionMessage(cnt.ToString() + "건의 출고를 하시겠습니까?") == DialogResult.Yes)
if (CoFAS_DevExpressManager.ShowQuestionMessage("출고를 하시겠습니까?") == DialogResult.Yes)
{
_pucProductStockInfoPopupEntity.CRUD = "C";
bool isError;
isError = new ucProductStockInfoPopupBusiness().ucProductStockInfoPopup_Save(_pucProductStockInfoPopupEntity, tDataTable);
if (isError)
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
//_pLocation_Code = _pucProductStockInfoPopupEntity.RTN_KEY; //저장 위치
MainFind_DisplayData();
}
}
}
private void InputData_Save(DataTable dtSave)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new GroupMenuAuthorityBusiness().GroupMenuAuthority_I10(_pGroupMenuAuthorityEntity, dtSave);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
//화면 표시.
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_pGroupMenuAuthorityEntity.CRUD = "R";
SubFind_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);
}
}
// 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 InputData_Save(DataTable dtSave)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new SampleRegisterBusiness().Sample_Info_Save(_pSampleRegisterEntity, dtSave);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
//화면 표시.
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
// 화면 갱신
_pSampleRegisterEntity.CRUD = "R";
MainFind_DisplayData();
// SubFind_DisplayData(_pSampleRegisterEntity.WINDOW_NAME, _pSampleRegisterEntity.GRID_NAME);
}
}
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 _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 InputData_Save(WorkOrdersRegisterEntity _pWorkOrdersRegisterEntity)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new WorkOrdersRegisterBusiness().Sample_Info_Save(_pWorkOrdersRegisterEntity);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
//화면 표시.
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_pLocation_Code = _pWorkOrdersRegisterEntity.RTN_KEY; //저장 위치
//InitializeSetting(); //초기화
InitializeControl();
// 화면 갱신
Form_SearchButtonClicked(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_SaveButtonClicked(object pSender, EventArgs pEventArgs)
{
try
{
}
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
{
Form_InitialButtonClicked(null, null);
CoFAS_DevExpressManager.ShowInformationMessage("저장 완료");
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void InputData_Save(DataTable pDataTable)
{
try
{
//CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
_pPOPCheckEntity.CRUD = "C";
_pPOPCheckEntity.USER_CODE = _pUSER_CODE;
isError = new POPCheckBusiness().POPCheck_Save(_pPOPCheckEntity, 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);
}
}
private void _gdMAIN_VIEW_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
if (pfrmPOPMain_PRESS_LINEEntity.PRODUCTION_ORDER_ID == null || pfrmPOPMain_PRESS_LINEEntity.PRODUCTION_ORDER_ID == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("작업지시를 먼저 선택해주세요");
return;
}
if (pfrmPOPMain_PRESS_LINEEntity.LOT_ID == null || pfrmPOPMain_PRESS_LINEEntity.LOT_ID == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("LOT를 생성해주세요");
return;
}
DataTable _dttemp = _gdMAIN.DataSource as DataTable;
if (Convert.ToDecimal(_lbPRODUCTION_OK_QTY.Text.ToString()) <= 0)
{
return;
}
if (_dttemp.Rows.Count > 0)
{
decimal sumqty = 0;
for (int i = 0; i < _dttemp.Rows.Count; i++)
{
if (_dttemp.Rows[i]["PRODUCTION_NG_RESULT"].ToString() != "")
{
sumqty += Convert.ToDecimal(_dttemp.Rows[i]["PRODUCTION_NG_RESULT"].ToString());
}
}
_lbPRODUCTION_PASS_QTY.Text = (Convert.ToDecimal(_lbPRODUCTION_OK_QTY.Text.ToString()) - sumqty).ToString();
}
else
{
_lbPRODUCTION_PASS_QTY.Text = (Convert.ToDecimal(_lbPRODUCTION_OK_QTY.Text.ToString())).ToString();
}
}
private void _ucbtINSPECT_REG_Click(object sender, EventArgs e)
{
if (_luORDER_ID.Text == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("작업지시를 먼저 선택해주세요.");
return;
}
if (_pINSPECT_CHECK_YN)
{
CoFAS_DevExpressManager.ShowInformationMessage("이미 시험의뢰를 맡긴 발주가 있습니다.");
return;
}
//검사등록
if (CoFAS_DevExpressManager.ShowQuestionMessage("'" + _luPART_NAME.Text + "'을(를) 시험의뢰 하시겠습니까?") == DialogResult.Yes)
{
_pPOPSelect_INSPECT_COSMETICSEntity.CRUD = "C";
_pPOPSelect_INSPECT_COSMETICSEntity.PRODUCTION_ORDER_ID = _luORDER_ID.Text;
//_pPOPSelect_INSPECT_COSMETICSEntity.PART_CODE = _luPART_CODE.Text;
bool isError;
isError = new frmPOPMain_SEMIPRODUCT_COSMETICSBusiness().frmPOPMain_PRODUCT_COSMETIC_Info_Check_Save(_pPOPSelect_INSPECT_COSMETICSEntity);
if (isError)
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
// CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
// _pLocation_Code = _pPOPSelect_INSPECT_COSMETICSEntity.RTN_KEY; //저장 위치
_pPOPSelect_INSPECT_COSMETICSEntity.CRUD = "R";
_pPOPSelect_INSPECT_COSMETICSEntity.PRODUCTION_ORDER_ID = "";
_pPOPSelect_INSPECT_COSMETICSEntity.PART_CODE = "";
MainFind_DisplayData();
// MainFind_DisplayData();
}
}
}
private void InputData_Save(DataTable pDataTable)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
// DataTable InsertRequestFileList = null;
_pucWorkOrderInfoPopup_T04Entity.CRUD = "C";
_pucWorkOrderInfoPopup_T04Entity.USER_CODE = _pUSER_CODE;
_pucWorkOrderInfoPopup_T04Entity.RTN_KEY = "";
_pucWorkOrderInfoPopup_T04Entity.REFERENCE_ID = _pCONTRACT_ID; //계획정보를 레퍼런스에 담음
// isError = new ucWorkOrderInfoPopup_T04Business().ucWorkOrderInfoPopup_T04_Save(_pucWorkOrderInfoPopup_T04Entity, pDataTable);
isError = new ucWorkOrderInfoPopup_T04Business().ucWorkOrderInfoPopup_T04_Save(_pucWorkOrderInfoPopup_T04Entity, pDataTable);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_gdMAIN.DataSource = null;
//팝업 닫기
_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);
}
}
private void _ucbtSAVE_Click(object sender, EventArgs e)
{
bool tf = true;
//_gdMAIN_VIEW.GetRow(0)
for (int i = 0; i < _gdMAIN_VIEW.RowCount; i++)
{
try
{
DataTable dt = new POPEquipmentCheckBusiness().POPEquipmentCheck_Info_I10(_gdMAIN_VIEW.GetDataRow(i).ItemArray, _pUserEntity.USER_NAME, lbl_nowdate.Text);
}
catch (Exception ex)
{
tf = false;
}
}
if (tf)
{
CoFAS_DevExpressManager.ShowInformationMessage("설비 점검결과가 저장되었습니다.");
}
}
private void _ucbtPLAN_SAVE_Click(object sender, EventArgs e)
{
try
{
if (_gdMAIN_VIEW.RowCount > 0)
{
_pWorkOrderInfoPopup_T03Entity.CRUD = "C";
InputData_Save(_gdMAIN_VIEW.GridControl.DataSource as DataTable);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("BOM 정보가 없습니다. ");
CoFAS_DevExpressManager.ShowInformationMessage("BOM " + _pMSG_SEARCH_EMPT);
return;
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void MainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucShipmentRegisterInfoPopupEntity.DATE_FROM = DateTime.Parse(_luCONTRACT_DATE.FromDateTime.ToString()).ToString("yyyyMMdd");
_pucShipmentRegisterInfoPopupEntity.DATE_TO = DateTime.Parse(_luCONTRACT_DATE.ToDateTime.ToString()).ToString("yyyyMMdd");
_pucShipmentRegisterInfoPopupEntity.PART_NAME = _luPART_NAME.Text;
_dtList = new ucShipmentRegisterInfoPopupBusiness().ucShipmentRegisterInfoPopup_Info_Mst(_pucShipmentRegisterInfoPopupEntity);
if (_pucShipmentRegisterInfoPopupEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pucShipmentRegisterInfoPopupEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList); //데이터 필드에 맞춰 자동 바인딩
}
else
{
_dtList.Rows.Clear();
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
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 _ucbtAccept_Click(object sender, EventArgs e)
{
_pucWorkRequestInfoPopupEntity.CORP_CODE = _pCORP_CODE;
_pucWorkRequestInfoPopupEntity.USER_CODE = _pUSER_CODE;
int cnt = 0;
DataTable tDataTable = _gdMAIN_VIEW.GridControl.DataSource as DataTable;
for (int i = 0; i < tDataTable.Rows.Count; i++)
{
if (tDataTable.Rows[i]["CRUD"].ToString() == "Y")
{
cnt++;
}
}
if (cnt == 0)
{
CoFAS_DevExpressManager.ShowInformationMessage("하나 이상의 의뢰를 선택하세요");
return;
}
if (CoFAS_DevExpressManager.ShowQuestionMessage(cnt.ToString() + "건의 접수를 하시겠습니까?") == DialogResult.Yes)
{
_pucWorkRequestInfoPopupEntity.CRUD = "U";
bool isError;
isError = new ucWorkRequestInfoPopupBusiness().ucWorkRequestInfoPopup_Check_Save(_pucWorkRequestInfoPopupEntity, tDataTable);
if (isError)
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
//_pLocation_Code = _pucWorkRequestInfoPopupEntity.RTN_KEY; //저장 위치
MainFind_DisplayData();
}
}
}
private void _ucbtNG_REG_Click(object sender, EventArgs e)
{
if (_luORDER_ID.Text == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("작업지시를 먼저 선택해주세요.");
return;
}
// 불량처리
frmPOPBad frmb = new frmPOPBad();
string PopupValue = string.Empty;
string PopupValue2 = string.Empty;
if (frmb.ShowDialog() == DialogResult.OK)
{
PopupValue = frmb.ReturnValue1;
PopupValue2 = frmb.ReturnValue2;
//리턴값이 빈값이 아니고 0도 아닐경우 실적등록
if (PopupValue != "0" && PopupValue != "")
{
_pPOPSelect_INSPECT_COSMETICSEntity.RESOURCE_CODE = "";// _luPROCESS_CODE.GetValue();
_pPOPSelect_INSPECT_COSMETICSEntity.COLLECTION_DATE = DateTime.Now.ToString("yyyyMMddHHmmss");
_pPOPSelect_INSPECT_COSMETICSEntity.PROPERTY_VALUE = _luORDER_ID.Text;
//CD501001 : 양품
//CD501002 : 불량
_pPOPSelect_INSPECT_COSMETICSEntity.CONDITION_CODE = PopupValue2.Replace(",", "");;
_pPOPSelect_INSPECT_COSMETICSEntity.COLLECTION_VALUE = PopupValue.Replace(",", "");
bool isError = false;
isError = new frmPOPMain_SEMIPRODUCT_COSMETICSBusiness().frmPOPMain_SEMIPRODUCT_COSMETICS_Save(_pPOPSelect_INSPECT_COSMETICSEntity);
if (!isError)
{
MainFind_DisplayData();
}
}
//string PopupValue = frmb.ReturnValue1;
//DisplayMessage(_ucbtNG_REG.Text + " -> " + PopupValue);
}
}
private void InputData_Save(DataTable pDataTable)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
_pProductPlanInfoPopupEntity.CRUD = "C";
_pProductPlanInfoPopupEntity.USER_CODE = _pUSER_CODE;
_pProductPlanInfoPopupEntity.PART_CODE_MST = _luPART_CODE.Text;
_pProductPlanInfoPopupEntity.CONTRACT_ID = _luCONTRACT_ID.Text;
DataTable qDataTable = new ProductPlanInfoPopupBusiness().ProductPlanInfoPopup_Save(_pProductPlanInfoPopupEntity, pDataTable);
if (qDataTable.Rows[0]["ERR_NO"].ToString() != "00")
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
frmCommonPopup.ARRAY_CODE[0] = qDataTable.Rows[0]["RTN_KEY"].ToString();
_luPLANID.Text = qDataTable.Rows[0]["RTN_KEY"].ToString();
_gdMAIN.DataSource = null;
InitializeControl();
}
}
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 _btAPPLY_Click(object sender, EventArgs e)
{
try
{
int pRowCount = _gdMAIN_VIEW.RowCount;
if (pRowCount > 0)
{
for (int i = 0; i < pRowCount; i++)
{
_gdMAIN_VIEW.SetRowCellValue(i, "IN_QTY", Convert.ToDecimal(_gdMAIN_VIEW.GetRowCellValue(i, "PLAN_ORDER_QTY")));
}
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("생산계획을 불러오십시오.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_LOAD_DATA);
return;
}
for (int i = 0; i < pRowCount; i++)
{
if (Convert.ToDecimal(_gdMAIN_VIEW.GetRowCellValue(i, "PLAN_ORDER_QTY")) < Convert.ToDecimal(_gdMAIN_VIEW.GetRowCellValue(i, "IN_QTY")) + Convert.ToDecimal(_gdMAIN_VIEW.GetRowCellValue(i, "ORDER_QTY")))
{
for (int j = 0; j < pRowCount; j++)
{
_gdMAIN_VIEW.SetRowCellValue(j, "IN_QTY", "0");
}
//CoFAS_DevExpressManager.ShowInformationMessage("등록할 지시수량이 계획수량보다 큽니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_PLAN_LARGE_THAN_ORDER);
return;
}
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
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);
}
}
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 SubFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_pucMaterialOrderRegister_Request_T01Entity.CRUD = "R";
using (DBManager pDBManager = new DBManager())
{
_dtList2 = new ucMaterialOrderRegister_Request_T01Business().ucMaterialOrderRegister_Request_T01_R20(_pucMaterialOrderRegister_Request_T01Entity);
if (_pucMaterialOrderRegister_Request_T01Entity.CRUD == "")
{
_dtList2.Rows.Clear();
}
if (_dtList2 != null && _dtList2.Rows.Count > 0)
{
_TempGridView2.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList2); //데이터 필드에 맞춰 자동 바인딩
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SEARCH_EMPT);
_dtList2.Rows.Clear();
_TempGridView2.BindGridControl(_gdSUB, _gdSUB_VIEW, _dtList2); //데이터 필드에 맞춰 자동 바인딩
}
}
}
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);
_pMaterialInOutStatusEntity.DATE_FROM = DateTime.Parse(_luORDER_DATE.FromDateTime.ToString()).ToString("yyyyMMdd"); //Convert.ToString(_luORDER_DATE.FromDateTime).Substring(0, 10).Replace("-", ""); //추가 수정
_pMaterialInOutStatusEntity.DATE_TO = DateTime.Parse(_luORDER_DATE.ToDateTime.ToString()).ToString("yyyyMMdd"); // Convert.ToString(_luORDER_DATE.ToDateTime).Substring(0, 10).Replace("-", ""); //추가 수정
_pMaterialInOutStatusEntity.VEND_NAME = _luVEND_NAME.Text;
_pMaterialInOutStatusEntity.PART_NAME = _luPART_NAME.Text;
_dtList = new MaterialInOutStatusBusiness().Sample_Info(_pMaterialInOutStatusEntity);
if (_pMaterialInOutStatusEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pMaterialInOutStatusEntity.CRUD == ""))
{
// CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_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
{
//_gdMAIN_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
// DB 처리
#region ○ 화면에 따른 시트 조회 - SheetMainFind_DisplayData()
private void SheetMainFind_DisplayData()
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
_dtList = new WindowSheetSettingBusiness().SheetMainFind_DisplayData(_pWindowSheetSettingEntity);
if (_pWindowSheetSettingEntity.CRUD == "")
{
_dtList.Rows.Clear();
}
if ((_dtList != null && _dtList.Rows.Count > 0) || (_dtList != null && _pWindowSheetSettingEntity.CRUD == ""))
{
CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, _dtList);
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage("조회 내역이 없습니다.");
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
//throw pExceptionManager;
}
//catch (Exception pException)
//{
// throw new ExceptionManager(this, "InputData_Save(DataTable dtSave)", pException);
//}
finally
{
_gdMAIN_VIEW.BestFitColumns();
CoFAS_DevExpressManager.SetCursor(this, Cursors.Default);
}
}
private void _gdMAIN_VIEW_RowChange(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
if (CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""))
{
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_WORKING);
return;
}
GridView gv = sender as GridView;
if ((gv.DataSource as DataTable) == null)
{
return;
}
if (e.FocusedRowHandle < 0)
{
return;
}
if (gv.GetFocusedRowCellValue("BAD_GROUP_CODE") == null)
{
return;
}
string strPROCESS_CODE = gv.GetFocusedRowCellValue("BAD_GROUP_CODE").ToString();
_pBadCodeMstRegisterEntity.CRUD = "R";
_pBadCodeMstRegisterEntity.BAD_GROUP_CODE = gv.GetFocusedRowCellValue("BAD_GROUP_CODE").ToString();
MainBindingFind_DisplayData();
SubFind_DisplayData();
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString()));
}
}
private void InputData_Save(DataTable dtSave) //(ContractMstRegisterEntity _pContractMstRegisterEntity)
{
try
{
CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor);
bool isError = false;
isError = new WorkResultRegister_T50Business().WorkResultMst_Save_T02(_pWorkResultRegister_T50Entity, dtSave);
if (!isError)
{
//정상처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
//_pLocation_Code = _pContractMstRegisterEntity.RTN_KEY; //저장 위치
MainFind_DisplayData();
//InitializeControl();
//Form_SearchButtonClicked(null, null);
}
else
{
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
}
}
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 LanguageInfoRegisterBusiness().Language_Info_Save(_pLanguageInfoRegisterEntity, dtSave);
if (isError)
{
//오류 발생.
//CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR);
//화면 표시.
}
else
{
//정상 처리
//CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다.");
CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE);
_pLocation_Code = _pLanguageInfoRegisterEntity.RTN_KEY; //저장 위치
_pLanguageInfoRegisterEntity.CRUD = "R";
MainFind_DisplayData();
//InitializeControl();
}
}
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);
}
}
