/// <summary> /// 삭제 버튼 클릭 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnRowDeleteClick(object sender, MouseButtonEventArgs e) { try { // DelEmsEqpMngr(); if (ValidationRowDelete() == false) { return; } var liHeaderCommonCodeMgmt = this.EmsEqpMngrList.Where(p => p.IsSelected == true && p.IsNew == true).ToList(); if (liHeaderCommonCodeMgmt.Count() <= 0) { BaseClass.MsgError("ERR_DELETE"); } liHeaderCommonCodeMgmt.ForEach(p => EmsEqpMngrList.Remove(p)); } catch (Exception err) { this.BaseClass.Error(err); } }
/// <summary> /// 추가 함수 /// </summary> private void NewEmsEqpMngr() { EmsEqpMngr _item = new EmsEqpMngr() { CENTER_CD = this.BaseClass.CenterCD, EQP_MNGR_ID = "", MNGR_NM = "", MNGR_TEL_NO = "", EMPL_DEV_CD = "DEV01", VNDR_NM = "", USE_YN = "Y", RSTR_ID = this.BaseClass.UserID, UPDR_ID = this.BaseClass.UserID, IsNew = true, IsSelected = true }; EmsEqpMngrList.Add(_item); gridMain.Focus(); gridMain.CurrentColumn = gridMain.Columns.First(); gridMain.View.FocusedRowHandle = EmsEqpMngrList.Count - 1; }
/// <summary> /// 저장 함수 /// </summary> /// <returns></returns> private bool SaveEmsEqpMngr() { using (BaseDataAccess da = new BaseDataAccess()) { try { string _SUCCESS_CODE = "100"; var _saveItems = EmsEqpMngrList.Where(f => f.IsUpdate || f.IsNew).ToList(); //if (0 == _saveItems.Count) if (this.EmsEqpMngrList.Where(p => p.IsSelected).Count() == 0) { // ERR_NO_SELECT - 선택된 데이터가 없습니다. this.BaseClass.MsgError("ERR_NO_SELECT"); return(false); } // ERR_NOT_INPUT - {0}이(가) 입력되지 않았습니다. string strInputMessage = this.BaseClass.GetResourceValue("ERR_NOT_INPUT", BaseEnumClass.ResourceType.MESSAGE); // ASK_SAVE - 저장 하시겠습니까? this.BaseClass.MsgQuestion("ASK_SAVE"); if (this.BaseClass.BUTTON_CONFIRM_YN == false) { return(false); } foreach (var item in _saveItems) { if (item.IsSelected == false) { continue; } if (string.IsNullOrWhiteSpace(item.EQP_MNGR_ID)) { item.CellError("USER_ID", string.Format(strInputMessage, this.BaseClass.GetResourceValue("ID"))); return(false); } if (1 < EmsEqpMngrList.Where(f => f.EQP_MNGR_ID == item.EQP_MNGR_ID).ToList().Count) { // ERR_EXISTS_ID - ID가 존재합니다. this.BaseClass.MsgError("ERR_EXISTS_ID"); return(false); } } var _USER_ID = this.BaseClass.UserID; da.BeginTransaction(); foreach (var item in _saveItems) { var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, { "P_EQP_MNGR_ID", item.EQP_MNGR_ID }, // ID { "P_MNGR_NM", item.MNGR_NM }, // 이름 { "P_MNGR_TEL_NO", item.MNGR_TEL_NO }, // 전화 { "P_VNDR_NM", item.VNDR_NM }, // 회사명 { "P_EMPL_DEV_CD", item.EMPL_DEV_CD }, // 고용 구분 { "P_USE_YN", item.USE_YN }, { "P_USER_ID", _USER_ID } }; var strOutParam = new[] { "P_RESULT" }; string callProc = "PK_EMS_EBSE001.SP_EMS_EQP_MNGR_SAVE"; var outData = da.GetSpDataSet( callProc // 호출 프로시저 , param // Input 파라메터 , strOutParam // Output 파라메터 ); if (outData.Tables[0].Rows.Count > 0) { if (outData.Tables[0].Rows[0]["CODE"].ToString() != _SUCCESS_CODE) { _SUCCESS_CODE = "0"; da.RollbackTransaction(); BaseClass.MsgInfo(outData.Tables[0].Rows[0]["MSG"].ToString(), BaseEnumClass.CodeMessage.MESSAGE); break; } } else { _SUCCESS_CODE = "0"; da.RollbackTransaction(); this.BaseClass.MsgInfo("ERR_INPUT_TYPE"); break; } } if (_SUCCESS_CODE == "100") { da.CommitTransaction(); return(true); } } catch (Exception ex) { da.RollbackTransaction(); this.BaseClass.Error(ex); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } return(false); } }
/// <summary> /// 삭제 함수 /// </summary> private void DelEmsEqpMngr() { var _delItems = this.EmsEqpMngrList.Where(p => p.IsSelected).ToList(); if (0 < _delItems.Count) { using (BaseDataAccess da = new BaseDataAccess()) { string _SUCCESS_CODE = "100"; try { da.BeginTransaction(); foreach (var item in _delItems) { if (item.IsNew != true) { var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, { "P_EQP_MNGR_ID", item.EQP_MNGR_ID } }; var strOutParam = new[] { "P_RESULT" }; string callProc = "PK_EMS_EBSE001.SP_EMS_EQP_MNGR_DELETE"; var outData = da.GetSpDataSet( callProc // 호출 프로시저 , param // Input 파라메터 , strOutParam // Output 파라메터 ); if (outData.Tables[0].Rows.Count > 0) { if (outData.Tables[0].Rows[0]["CODE"].ToString() != _SUCCESS_CODE) { _SUCCESS_CODE = "0"; da.RollbackTransaction(); BaseClass.MsgInfo(outData.Tables[0].Rows[0]["MSG"].ToString(), BaseEnumClass.CodeMessage.MESSAGE); break; } } else { _SUCCESS_CODE = "0"; da.RollbackTransaction(); this.BaseClass.MsgInfo("ERR_INPUT_TYPE"); break; } } } if (_SUCCESS_CODE == "100") { da.CommitTransaction(); foreach (var item in _delItems) { //if (item.IsNew != true) EmsEqpMngrList.Remove(item); } gridMain.RefreshData(); } } catch (Exception ex) { da.RollbackTransaction(); this.BaseClass.Error(ex); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } } } else { // 삭제 대상을 선택하세요. this.BaseClass.MsgInfo("INFO_SEL_DEL"); } }