/// <summary> /// 언어 정보 저장 /// </summary> public bool SystemCode_Info_Save(SystemCodeRegisterEntity pSystemCodeRegisterEntity, DataTable dt, string code) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } else { dtTemp = dt; } using (DBManager pDBManager = new DBManager()) { bool isReturn = new SystemCodeRegisterProvider(pDBManager).SystemCode_Info_Save(pSystemCodeRegisterEntity, dtTemp, code); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "SystemCode_Info_Save(SystemCodeRegisterEntity pSystemCodeRegisterEntity, DataTable dt, string code)", pException); } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool Grid_Info_Save(GridInfoRegisterEntity pGridInfoRegisterEntity, DataTable dt) { try { DataTable dtTemp = new DataTable(); bool isReturn = true; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } if ((pGridInfoRegisterEntity.CRUD == "C" || pGridInfoRegisterEntity.CRUD == "U") || dtTemp.Rows.Count > 0) { using (DBManager pDBManager = new DBManager()) { isReturn = new GridInfoRegisterProvider(pDBManager).Grid_Info_Save(pGridInfoRegisterEntity, dtTemp); return(isReturn); } } else { return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "Grid_Info_Save(GridInfoRegisterEntity pGridInfoRegisterEntity, DataTable dt)", pException); } }
private void _ucbtSAVE_Click(object sender, EventArgs e) { try { DataTable dt; dt = _gdMAIN.DataSource as DataTable; _gdMAIN_VIEW.FocusedRowHandle = -1; if ((CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD = 'Y'", ""))) { dtReturn = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD = 'Y'", ""); PO.UserForm.frmCommonPopup._DataTable = dtReturn; } //dtReturn = null; //_gdMAIN.DataSource = null; _chSave = true; if (_Close_Click != null) { _Close_Click(sender, e); } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void Form_SaveButtonClicked(object pSender, EventArgs pEventArgs) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.No) { return; } if (!dxValidationProvider.Validate()) { return; } //확인 if (_luBAD_GROUP_CODE.Text.Length > 0) { _pBadCodeMstRegisterEntity.CRUD = "U"; } else { _pBadCodeMstRegisterEntity.CRUD = "C"; } _pBadCodeMstRegisterEntity.BAD_GROUP_CODE = _luBAD_GROUP_CODE.Text.ToString(); _pBadCodeMstRegisterEntity.BAD_GROUP_NAME = _luBAD_GROUP_NAME.Text.ToString(); _pBadCodeMstRegisterEntity.USE_YN = _luUSE_YN.GetValue(); DataTable dtTemp = null; if (_gdSUB_VIEW.GridControl.DataSource != null) { if (CoFAS_ConvertManager.DataTable_FindCount(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdSUB_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); } } bool isReturn = false; using (DBManager pDBManager = new DBManager()) { isReturn = new BadCodeMstRegisterBusiness().BadCode_Info_Save(_pBadCodeMstRegisterEntity, dtTemp); } } 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); Form_SearchButtonClicked(null, null); CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool MonitoringDesigner_Info_Save(MonitoringDesignerEntity pMonitoringDesignerEntity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } using (DBManager pDBManager = new DBManager()) { bool isReturn = new MonitoringDesignerProvider(pDBManager).MonitoringDesigner_Info_Save(pMonitoringDesignerEntity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "Sample_Info_Save(SampleRegisterEntity pSampleRegisterEntity, DataTable dt)", pException); } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool DynamicColumn_Info_Save(DynamicColumnInfoRegisterEntity pDynamicColumnInfoRegisterEntity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } using (DBManager pDBManager = new DBManager()) { bool isReturn = new DynamicColumnInfoRegisterProvider(pDBManager).DynamicColumn_Info_Save(pDynamicColumnInfoRegisterEntity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "DynamicColumn_Info_Save(DynamicColumnInfoRegisterEntity pDynamicColumnInfoRegisterEntity, DataTable dt)", pException); } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool Sample_Info_Save(DoorOpeningClosingStatusEntity pDoorOpeningClosingStatusEntity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } using (DBManager pDBManager = new DBManager()) { bool isReturn = new DoorOpeningClosingStatusProvider(pDBManager).Sample_Info_Save(pDoorOpeningClosingStatusEntity, dtTemp); return isReturn; } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "Sample_Info_Save(DoorOpeningClosingStatusEntity pDoorOpeningClosingStatusEntity, DataTable dt)", pException); } }
private void _ucbtREQUEST_Click(object sender, EventArgs e) { if (_Request_Click != null) { if (_gdMAIN_VIEW != null) { DataTable tDataTable = _gdMAIN_VIEW.GridControl.DataSource as DataTable; DataTable data = new DataTable(); DataTable empty_qty = new DataTable(); data = tDataTable; //tDataTable.Select("INPUT ='124'", "").CopyToDataTable(); // empty_qty = CoFAS_ConvertManager.DataTable_FindValue(tDataTable, "INPUT =''", ""); if (CoFAS_ConvertManager.DataTable_FindCount(tDataTable, "INPUT=''", "") || CoFAS_ConvertManager.DataTable_FindCount(tDataTable, "INPUT<'0'", "") || CoFAS_ConvertManager.DataTable_FindCount(tDataTable, "INPUT='0'", "")) { empty_qty = CoFAS_ConvertManager.DataTable_FindValue(tDataTable, "INPUT =''", ""); CoFAS_DevExpressManager.ShowInformationMessage("검체채취량을 입력하지 않은 것이 " + empty_qty.Rows.Count.ToString() + "건 있습니다."); return; } if (CoFAS_ConvertManager.DataTable_FindCount(tDataTable, "INPUT>'0'", "")) { data = CoFAS_ConvertManager.DataTable_FindValue(tDataTable, "INPUT >'0'", ""); } _dtreturn = data; _Request_Click(_gdMAIN_VIEW, e); } } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool MenuAuthority_T02_I20(MenuAuthority_T02Entity pMenuAuthority_T02Entity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('Y')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('Y')", ""); // 신규 and 수정 항목 데이터 테이블 화 } using (DBManager pDBManager = new DBManager()) { bool isReturn = new MenuAuthority_T02Provider(pDBManager).MenuAuthority_T02_I20(pMenuAuthority_T02Entity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "MenuAuthority_T02_I10(MenuAuthority_T02Entity pMenuAuthority_T02Entity, DataTable dt)", pException); } }
/// <summary> /// 언어 정보 저장 /// </summary> public bool GroupUserMailing_Info_Save(GroupUserMailingEntity pGroupUserMailingEntity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } else { dtTemp = dt; } using (DBManager pDBManager = new DBManager()) { bool isReturn = new GroupUserMailingProvider(pDBManager).GroupUserMailing_Info_Save(pGroupUserMailingEntity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "GroupUserMailing_Info_Save(GroupUserMailingEntity pGroupUserMailingEntity, DataTable dt)", pException); } }
/// <summary> /// 정보 저장 /// </summary> public bool ucEquipmentDocumentListPopup_Info_Save(ucEquipmentDocumentListPopupEntity pucEquipmentDocumentListPopupEntity, DataTable dt) { try { DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } using (DBManager pDBManager = new DBManager()) { bool isReturn = new ucEquipmentDocumentListPopupProvider(pDBManager).ucEquipmentDocumentListPopup_Info_Save(pucEquipmentDocumentListPopupEntity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "ucEquipmentDocumentListPopup_Info_Save(ucEquipmentDocumentListPopupEntity pucEquipmentDocumentListPopupEntity, DataTable dt)", pException); } }
private void InputData_Save() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); bool isError = false; DataTable dtBOM = null; DataTable dt = null; DataTable dtTemp = null; using (DBManager pDBManager = new DBManager()) { if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes) { dtBOM = _gdMAIN.DataSource as DataTable; dt = _gdSUB.DataSource as DataTable; if (CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", "")) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); for (int i = 0; i < dtTemp.Rows.Count; i++) { if (Convert.ToDecimal(dtTemp.Rows[i]["USAGE_QTY"].ToString()) == 0) { CoFAS_DevExpressManager.ShowInformationMessage("출고수량이 0인 항목이 있습니다."); return; } } } isError = new ucMeterialUsagePopupBusiness().ucMeterialUsagePopup_Info_Save(_pucMeterialUsagePopupEntity, dtTemp); if (isError) { //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); } else { //정상 처리 InitializeSetting(); //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); } } } } 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 pDataTable) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); bool isError = false; _pWorkOrderInfoPopup_T03Entity.CRUD = "C"; _pWorkOrderInfoPopup_T03Entity.USER_CODE = _pUSER_CODE; DataTable dt; DataTable dtTemp; //string _ptime = System.DateTime.Now.ToString("yyyyMMddHHmmss"); //_pWorkOrderInfoPopup_T03Entity.REFERENCE_ID = _luPLAN_ORDER_ID.Text; //계획정보를 레퍼런스에 담음 //_pWorkOrderInfoPopup_T03Entity.FILE_NAME = "PRODUCTION/"+_ptime + "_" + _pWorkOrderInfoPopup_T03Entity.REFERENCE_ID + "_작업요청서." + _pFile_Attr; if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes) { dt = _gdMAIN.DataSource as DataTable; if (CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D') AND PRODUCTION_ORDER_QTY > 0", "")) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D') AND PRODUCTION_ORDER_QTY > 0", ""); _pWorkOrderInfoPopup_T03Entity.CRUD = "C"; isError = new ucWorkOrderInfoPopup_T03Business().ucWorkOrderInfoPopup_T03_Save(_pWorkOrderInfoPopup_T03Entity, dtTemp); if (isError) { //오류 발생. //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); } else { //정상 처리 //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); } } } //팝업 닫기 _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 _ucbtcontract_SAVE_Click(object sender, EventArgs e) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); bool isError = false; DataTable dt; DataTable dtTemp = null; //if (CoFAS_DevExpressManager.ShowQuestionMessage("저장 하시겠습니까?") == DialogResult.Yes) if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes) { dt = _gdMAIN.DataSource as DataTable; if ((CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D') AND ORDER_QTY > 0", ""))) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D') AND ORDER_QTY > 0", ""); _pOrderNumberInfoPopup_Entity.CRUD = "C"; for (int i = 0; i < dtTemp.Rows.Count; i++) { dtTemp.Rows[i]["CRUD"] = "C"; } isError = new ProductPlanRegister_T02Business().ProductPlanSub_Save(_pOrderNumberInfoPopup_Entity, dtTemp); if (!isError) { //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); _pLocation_Code = _pOrderNumberInfoPopup_Entity.RTN_KEY; //저장 위치 _gdMAIN.DataSource = null; //팝업 닫기 _btCancle_Click(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() { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); DataTable dtTemp = null; bool isError = false; if (_gdMAIN_VIEW.GridControl.DataSource != null) { if (CoFAS_ConvertManager.DataTable_FindCount(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", "")) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); } } bool isReturn = false; using (DBManager pDBManager = new DBManager()) { isReturn = new QualityInspectBusiness().QualityInspect_Info_Save(_pQualityInspectEntity, dtTemp); } if (isReturn) { ////오류 발생. //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); //화면 표시. } else { ////정상 처리 CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); // 화면 갱신 _pQualityInspectEntity.CRUD = "R"; _pLocation_Code = _pQualityInspectEntity.RTN_KEY; //저장 위치 MainFind_DisplayData(); } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void InputData_Save(InspectFinalApprovalRegisterT01Entity _pInspectFinalApprovalRegisterT01Entity) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); bool isError = false; DataTable dt = null; DataTable dtTemp = null; using (DBManager pDBManager = new DBManager()) { if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes) { dt = _gdMAIN.DataSource as DataTable; if (CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", "")) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); isError = new InspectFinalApprovalRegisterT01Business().InspectFinalApprovalRegisterT01_Mst_Info_Save(_pInspectFinalApprovalRegisterT01Entity, dtTemp); if (isError) { //CoFAS_DevExpressManager.ShowInformationMessage("저장 오류 발생! 데이터를 확인 하세요."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); } else { //정상 처리 InitializeSetting(); //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); MainFind_DisplayData(); } } } } } catch (ExceptionManager pExceptionManager) { CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager.TargetSite.ToString())); } finally { CoFAS_DevExpressManager.SetCursor(this, Cursors.Default); } }
private void _btSAVE_CONTROLS_Click(object sender, EventArgs e) { try { CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); } else { return; } //DataTable dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_gdMAIN_VIEW.GridControl.DataSource as DataTable, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 if (dtTemp.Rows.Count > 0) { Controls_InputData_Save(dtTemp); } else { //CoFAS_DevExpressManager.ShowInformationMessage("입력 된 저장 항목이 없습니다."); } } 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 _ucbtMOVE_Click(object sender, EventArgs e) { DataTable dt = _gdSUB_VIEW.GridControl.DataSource as DataTable; DataTable dtTemp = null; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "MOVE IN ('Y')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "MOVE IN ('Y')", ""); // 신규 and 수정 항목 데이터 테이블 화 for (int a = 0; a < dtTemp.Rows.Count; a++) { DataTable dtCheck = _gdMAIN_VIEW.GridControl.DataSource as DataTable; bool isNewChack = CoFAS_ConvertManager.DataTable_FindCount(dtCheck, "DOCUMENT_ID IN ('"+ dtTemp.Rows[a]["DOCUMENT_ID"].ToString() + "')", ""); if (!isNewChack) { _gdMAIN_VIEW.AddNewRow(); int rowHandle = _gdMAIN_VIEW.GetRowHandle(_gdMAIN_VIEW.DataRowCount); if (_gdMAIN_VIEW.IsNewItemRow(rowHandle)) { _gdMAIN_VIEW.SetRowCellValue(rowHandle, "DOCUMENT_ID", dtTemp.Rows[a]["DOCUMENT_ID"].ToString()); _gdMAIN_VIEW.SetRowCellValue(rowHandle, "DOCUMENT_TYPE", dtTemp.Rows[a]["DOCUMENT_TYPE"].ToString()); _gdMAIN_VIEW.SetRowCellValue(rowHandle, "DOCUMENT_NAME", dtTemp.Rows[a]["DOCUMENT_NAME"].ToString()); _gdMAIN_VIEW.SetRowCellValue(rowHandle, "DOCUMENT_FILE_NAME", dtTemp.Rows[a]["DOCUMENT_FILE_NAME"].ToString()); _gdMAIN_VIEW.SetRowCellValue(rowHandle, "DOCUMENT_VER", dtTemp.Rows[a]["DOCUMENT_VER"].ToString()); } } } } _gdMAIN_VIEW.UpdateCurrentRow(); }
/// <summary> /// 언어 정보 저장 /// </summary> public bool Message_Info_Save(MessageInfoRegisterEntity pMessageInfoRegisterEntity, DataTable dt) { try { DataTable dtTemp = new DataTable(); bool isReturn = true; bool isChack = CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } //if (dtTemp.Rows.Count > 0) //{ using (DBManager pDBManager = new DBManager()) { isReturn = new MessageInfoRegisterProvider(pDBManager).Message_Info_Save(pMessageInfoRegisterEntity, dtTemp); return(isReturn); } //} //else // { // return isReturn; // } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "Message_Info_Save(MessageInfoRegisterEntity pMessageInfoRegisterEntity, DataTable dt)", pException); } }
private void ucSimpleButton2_Click(object sender, EventArgs e) { bool isError = false; DataTable _dt = null; DataTable _dtTemp = null; try { if (CoFAS_DevExpressManager.ShowQuestionMessage("데이터를 등록하시겠습니까?") == DialogResult.Yes) { pfrmPOPMain_PRESS_LINEEntity.CRUD = "C"; pfrmPOPMain_PRESS_LINEEntity.USER_CODE = _pUSER_CODE; pfrmPOPMain_PRESS_LINEEntity.PRODUCTION_ORDER_ID = sPRODUCTION_ORDER_ID; #region 결과테이블 생성 DataTable resultdt = new DataTable(); resultdt.Columns.Add(new DataColumn("RESOURCE_CODE", typeof(string))); resultdt.Columns.Add(new DataColumn("COLLECTION_DATE", typeof(string))); resultdt.Columns.Add(new DataColumn("PROPERTY_VALUE", typeof(string))); resultdt.Columns.Add(new DataColumn("CONDITION_CODE", typeof(string))); resultdt.Columns.Add(new DataColumn("COLLECTION_VALUE", typeof(string))); DataRow row = null; #endregion _dt = _gdMAIN.DataSource as DataTable; if (CoFAS_ConvertManager.DataTable_FindCount(_dt, "CRUD IN ('C') AND PRODUCTION_NG_RESULT > 0", "")) { _dtTemp = CoFAS_ConvertManager.DataTable_FindValue(_dt, "CRUD IN ('C') AND PRODUCTION_NG_RESULT > 0", ""); // 실적데이터 추가 row = resultdt.NewRow(); row["RESOURCE_CODE"] = pfrmPOPMain_PRESS_LINEEntity.PROCESS_CODE;; row["COLLECTION_DATE"] = DateTime.Now.ToString("yyyyMMddHHmmss"); row["PROPERTY_VALUE"] = pfrmPOPMain_PRESS_LINEEntity.LOT_ID; row["CONDITION_CODE"] = "CD501001"; row["COLLECTION_VALUE"] = _lbPRODUCTION_OK_QTY.Text.ToString(); resultdt.Rows.Add(row); // 불량데이터 추가 for (int i = 0; i < _dtTemp.Rows.Count; i++) { row = resultdt.NewRow(); row["RESOURCE_CODE"] = pfrmPOPMain_PRESS_LINEEntity.PROCESS_CODE; row["COLLECTION_DATE"] = DateTime.Now.ToString("yyyyMMddHHmmss"); row["PROPERTY_VALUE"] = pfrmPOPMain_PRESS_LINEEntity.LOT_ID; row["CONDITION_CODE"] = _dtTemp.Rows[i]["BAD_CODE"].ToString(); row["COLLECTION_VALUE"] = _dtTemp.Rows[i]["PRODUCTION_NG_RESULT"].ToString(); resultdt.Rows.Add(row); } isError = new frmPOPMain_PRESS_LINEBusiness().pfrmPOPMain_PRESS_LINE_LOT_RESULT(pfrmPOPMain_PRESS_LINEEntity, resultdt); if (!isError) { _pLOT_COMPLETE = true; Refresh_DisplayData(); _gdMAIN.Enabled = false; } else { //CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE_ERROR); CoFAS_DevExpressManager.ShowInformationMessage("저장 실패"); } } } } 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 _ucbtcontract_SAVE_Click(object sender, EventArgs e) { DataTable dt; dt = _gdMAIN.DataSource as DataTable; _gdMAIN_VIEW.FocusedRowHandle = -1; if ((CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD = 'Y'", ""))) { dtReturn = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD = 'Y'", ""); PO.UserForm.frmCommonPopup._DataTable = dtReturn; } _btCancle_Click(null, null); //try //{ // CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); // bool isError = false; // DataTable dt; // DataTable dtTemp = null; // //if (CoFAS_DevExpressManager.ShowQuestionMessage("저장 하시겠습니까?") == DialogResult.Yes) // if (CoFAS_DevExpressManager.ShowQuestionMessage(_pMSG_SAVE_QUESTION) == DialogResult.Yes) // { // dt = _gdMAIN.DataSource as DataTable; // if ((CoFAS_ConvertManager.DataTable_FindCount(dt, "CRUD IN ('C','U','D') AND ORDER_QTY > 0", ""))) // { // dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dt, "CRUD IN ('C','U','D') AND ORDER_QTY > 0", ""); // _pucOutsourcingInfoPopupEntity.CRUD = "C"; // for(int i=0;i<dtTemp.Rows.Count;i++) // { // dtTemp.Rows[i]["CRUD"] = "C"; // } // isError = new ProductPlanRegister_T02Business().ProductPlanSub_Save(_pucOutsourcingInfoPopupEntity, dtTemp); // if (!isError) // { // //CoFAS_DevExpressManager.ShowInformationMessage("저장 처리 되었습니다."); // CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); // _pLocation_Code = _pucOutsourcingInfoPopupEntity.RTN_KEY; //저장 위치 // _gdMAIN.DataSource = null; // //팝업 닫기 // _btCancle_Click(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); DataTable tDataTable = _gdMAIN_VIEW.GridControl.DataSource as DataTable; DataTable tTempData = new DataTable(); if (tDataTable != null) { for (int i = 0; i < tDataTable.Rows.Count; i++) { if (tDataTable.Rows[i]["CRUD"].ToString() == "Y") { tTempData = CoFAS_ConvertManager.DataTable_FindValue(tDataTable, "CRUD ='Y'", ""); break; } } } if (_gdMAIN_VIEW.RowCount >= 0) { if ((tTempData != null && tTempData.Rows.Count > 0) || (tTempData != null && _pCRUD == "")) { CoFAS_DevExpressManager.BindGridControl(_gdMAIN, _gdMAIN_VIEW, tTempData); } SaveFileDialog mDlg = new SaveFileDialog(); mDlg.InitialDirectory = Application.StartupPath; //mDlg.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; mDlg.Filter = "Excel files (*.xls)|*.xls|Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; mDlg.FilterIndex = 1; if (mDlg.ShowDialog() == DialogResult.OK) { _gdMAIN_VIEW.ExportToXlsx(mDlg.FileName); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); } } else { SaveFileDialog mDlg = new SaveFileDialog(); mDlg.InitialDirectory = Application.StartupPath; //mDlg.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; mDlg.Filter = "Excel files (*.xls)|*.xls|Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; mDlg.FilterIndex = 1; if (mDlg.ShowDialog() == DialogResult.OK) { _gdMAIN_VIEW.ExportToXlsx(mDlg.FileName); CoFAS_DevExpressManager.ShowInformationMessage(_pMSG_SAVE); } } //CoFAS_DevExpressManager.SetCursor(this, Cursors.WaitCursor); //string strFTP_PATH = ""; //string strUSE_TYPE = ""; //string strFILE_NAME = ""; //_pTabletBasedSensorInfoPopup_T02Entity.CRUD = "R"; ////조회할거 프로시져 //_dtList = new TabletBasedSensorInfoPopup_T02Business().Sheet_Info_Sheet(_pTabletBasedSensorInfoPopup_T02Entity); //엑셀 시트 조회하기 ////엑셀서식관리 되면 다시 설정하기 //strUSE_TYPE = _dtList.Rows[0]["USE_TYPE"].ToString(); //strFILE_NAME = _dtList.Rows[0]["FILE_NAME"].ToString(); //SaveFileDialog saveFile = new SaveFileDialog(); //saveFile.InitialDirectory = @"C:\"; //saveFile.Filter = "Excel.XLSX(*.xlsx) | *.xls | ALL(*.*) | *.*"; //saveFile.FileName = strFILE_NAME.ToString(); ///* //strUSE_TYPE = "VIEW"; //strFILE_NAME = "HACCPCheckRegister_T07_Sample_v1.xlsx"; //*/ //switch (strUSE_TYPE) //{ // case "PRINT": // strFTP_PATH = string.Format(@"{0}{1}/{2}/", _pFTP_PATH, "ORDER_FORM", _pWINDOW_NAME); // break; // case "VIEW": // strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_PATH, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); // break; // case "REGIT": // strFTP_PATH = string.Format(@"{0}{1}/{2}/{3}/", _pFTP_PATH, "USER", "PROGRAM_VIEW", _pWINDOW_NAME); // break; //} //if (saveFile.ShowDialog() == DialogResult.OK) //{ // _pFTP_DOWNLOAD_PATH = saveFile.FileName; // CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, strFILE_NAME.ToString(), _pFTP_ID, _pFTP_PW, _pFTP_DOWNLOAD_PATH); //} //string curfile = Application.StartupPath + "\\Template\\" + strFILE_NAME; //// 같은 것이 있으면, 폴더에서 해당 파일명을 불러와서 SpreadSheet에 띄우기 / 없으면, 폴더에 다운 //if (!File.Exists(curfile)) //{ // CoFAS_FTPManager.FTPDownLoad(strFTP_PATH, strFILE_NAME, _pFTP_ID, _pFTP_PW, curfile, false); //} ////using (FileStream file = File.OpenWrite(curfile)) //using (Stream file = File.Open(curfile, FileMode.Open)) //{ // if (file != null) // { // IWorkbook workbook = // //Workbooks.OpenFromStream(file); // } //} } 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); } }
public bool SystemCode_Info_Save(SystemCodeRegisterEntity pSystemCodeRegisterEntity, DataTable dtFirst, DataTable dtSecond, DataTable dtThird) { try { DataTable dtTemp = null; DataTable dtWork = null; bool isChack = false; for (int a = 0; a < 3; a++) { switch (a) { case 0: isChack = false; isChack = CoFAS_ConvertManager.DataTable_FindCount(dtFirst, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dtFirst, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } break; case 1: isChack = false; isChack = CoFAS_ConvertManager.DataTable_FindCount(dtSecond, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dtSecond, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } break; case 2: isChack = false; isChack = CoFAS_ConvertManager.DataTable_FindCount(dtThird, "CRUD IN ('C','U','D')", ""); if (isChack) { dtTemp = CoFAS_ConvertManager.DataTable_FindValue(dtThird, "CRUD IN ('C','U','D')", ""); // 신규 and 수정 항목 데이터 테이블 화 } break; } } using (DBManager pDBManager = new DBManager()) { bool isReturn = new SystemCodeRegisterProvider(pDBManager).SystemCode_Info_Save(pSystemCodeRegisterEntity, dtTemp); return(isReturn); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "SystemCode_Info_Save(SystemCodeRegisterEntity pSystemCodeRegisterEntity, DataTable dtFirst, DataTable dtSecond, DataTable dtThird)", pException); } }