private void gridMain_PreviewMouseLeftButtonUp(object sender, MouseButtonEventArgs e) { try { int rowHandle = gridMainView.GetRowHandleByMouseEventArgs(e); if (rowHandle == GridControl.InvalidRowHandle) { return; } if (gridMain.IsGroupRowHandle(rowHandle)) { return; } // A group row has been double clicked EmsStock target = gridMain.SelectedItem as EmsStock; if (null != target) { CurrentStock = target; SearchStockDetail(target.STOCK_INSP_DT); } } catch (Exception err) { this.BaseClass.Error(err); } }
/// <summary> /// Detail Grid Data Binding /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridMain_MouseDoubleClick(object sender, MouseButtonEventArgs e) { int rowHandle = gridMainView.GetRowHandleByMouseEventArgs(e); if (rowHandle == GridControl.InvalidRowHandle) { return; } if (gridMain.IsGroupRowHandle(rowHandle)) { return; } // A group row has been double clicked EmsStock target = gridMain.SelectedItem as EmsStock; if (null != target) { CurrentStock = target; SearchStockDetail(target.STOCK_INSP_DT); } }
private void btnRegDt_Click(object sender, MouseButtonEventArgs e) { using (E2002_01P frmRegDt = new E2002_01P()) { frmRegDt.ShowDialog(); if (frmRegDt.IsSaved) { StockList.Insert(0, frmRegDt.CurrentStock); gridMain.View.FocusedRowHandle = 0; gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsStock>)[0]; EmsStock target = gridMain.SelectedItem as EmsStock; if (null != target) { CurrentStock = target; SearchStockDetail(target.STOCK_INSP_DT); } } } }
/// <summary> /// 저장 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, MouseButtonEventArgs e) { if (this.tbxManager.Tag == null) { // 담당자를 입력하세요. this.BaseClass.MsgError("ERR_INPUT_MGNR"); return; } if (this.tbxManager.Tag.ToString().Length == 0) { // 담당자를 입력하세요. this.BaseClass.MsgError("ERR_INPUT_MGNR"); return; } if (null != tbxManager.Tag && !string.IsNullOrEmpty(tbxManager.Tag.ToString())) { using (BaseDataAccess da = new BaseDataAccess()) { try { string _SUCCESS_CODE = "100"; var _USER_ID = this.BaseClass.UserID; da.BeginTransaction(); var strInspDate = this.BaseClass.GetCalendarValue(this.dtInsp); var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, { "P_MNGR_ID", tbxManager.Tag.ToString() }, // 관리자 //{ "P_STOCK_INSP_DT", new DateTime(dtInsp.DateTime.Year, dtInsp.DateTime.Month, dtInsp.DateTime.Day) }, // 조사 일자 { "P_STOCK_INSP_DT", strInspDate }, { "P_NOTE", tbxNote.Text.Trim() }, // 비고 { "P_USER_ID", _USER_ID } }; var strOutParam = new[] { "P_RESULT" }; string callProc = "PK_EMS_ESPA002_01P.SP_EMS_STOCK_INSP_DT_INSERT"; 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); } } else { _SUCCESS_CODE = "0"; da.RollbackTransaction(); this.BaseClass.MsgError("INPUT_TYPE_ERR"); } if (_SUCCESS_CODE == "100") { da.CommitTransaction(); //this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("CMPT_SAVE_DATA")); // 저장되었습니다. this.BaseClass.MsgInfo("CMPT_SAVE"); IsSaved = true; CurrentStock = new EmsStock(); CurrentStock.MNGR_ID = tbxManager.Tag.ToString().Trim(); CurrentStock.MNGR_NM = tbxManager.Text.ToString().Trim(); CurrentStock.INSP_STAT_CD = "S"; CurrentStock.STOCK_INSP_DT = new DateTime(dtInsp.DateTime.Year, dtInsp.DateTime.Month, dtInsp.DateTime.Day); CurrentStock.NOTE = tbxNote.Text.Trim(); CurrentStock.IsUpdate = false; this.Close(); } } catch (Exception ex) { da.RollbackTransaction(); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } } } }
/// <summary> /// Confirm /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnStockConfirm_Click(object sender, MouseButtonEventArgs e) { EmsStock target = gridMain.SelectedItem as EmsStock; if (null == target) { return; } if ("CMPT" == target.INSP_STAT_CD) { // 이미 확정된 항목입니다. this.BaseClass.MsgError("EMS_ALREADY_F"); return; } var strConDate = target.STOCK_INSP_DT.ToString("yyyy-MM-dd"); var strConString = this.BaseClass.GetResourceValue("EMS_REF_FF"); // 재고 조사를 확정합니다. var strMessage = this.BaseClass.GetResourceValue("ASK_EMS_CONF_COND", BaseEnumClass.ResourceType.MESSAGE); this.BaseClass.MsgQuestion(string.Format(strMessage, strConDate), BaseEnumClass.CodeMessage.MESSAGE); //this.BaseClass.MsgQuestion($"{strConDate}{strConString}", BaseEnumClass.CodeMessage.MESSAGE); if (this.BaseClass.BUTTON_CONFIRM_YN != true) { return; } if (!StockDetailSave(true)) { return; } using (BaseDataAccess da = new BaseDataAccess()) { try { string _SUCCESS_CODE = "100"; var _USER_ID = this.BaseClass.UserID; da.BeginTransaction(); var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, { "P_STOCK_INSP_DT", new DateTime(target.STOCK_INSP_DT.Year, target.STOCK_INSP_DT.Month, target.STOCK_INSP_DT.Day) }, { "P_INSP_STAT_CD", "CMPT" }, // 확정 (value : F -> CMPT로 수정) { "P_USER_ID", _USER_ID } }; var strOutParam = new[] { "P_RESULT" }; string callProc = "PK_EMS_ESPA002.SP_EMS_STOCK_FIX"; 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); } } else { _SUCCESS_CODE = "0"; da.RollbackTransaction(); this.BaseClass.MsgError("ERR_INPUT_TYPE"); } if (_SUCCESS_CODE == "100") { da.CommitTransaction(); //this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("CMPT_SAVE_DATA")); // 확정되었습니다. this.BaseClass.MsgInfo("CMPT_CONF"); focused_handle = gridMain.View.FocusedRowHandle; SearchStock(); } } catch (Exception ex) { da.RollbackTransaction(); this.BaseClass.Error(ex); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } } }
/// <summary> /// 삭제 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDel_Click(object sender, MouseButtonEventArgs e) { EmsStock target = gridMain.SelectedItem as EmsStock; if (null == target) { return; } if ("CMPT" == target.INSP_STAT_CD) { // 미확정 항목만 삭제 됩니다. this.BaseClass.MsgError("EMS_NOF_DEL"); return; } var strConDate = target.STOCK_INSP_DT.ToString("yyyy-MM-dd"); var strConString = this.BaseClass.GetResourceValue("EMS_REFHIS_DEL"); // 재고 조사 이력을 삭제합니다. this.BaseClass.MsgQuestion($"{strConDate} : {strConString}", BaseEnumClass.CodeMessage.MESSAGE); if (this.BaseClass.BUTTON_CONFIRM_YN != true) { return; } using (BaseDataAccess da = new BaseDataAccess()) { string _SUCCESS_CODE = "100"; try { da.BeginTransaction(); var _USER_ID = this.BaseClass.UserID; var strStockInspDate = target.STOCK_INSP_DT.ToString("yyyyMMdd"); var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, //{ "P_STOCK_INSP_DT", new DateTime(target.STOCK_INSP_DT.Year, target.STOCK_INSP_DT.Month, target.STOCK_INSP_DT.Day) }, { "P_STOCK_INSP_DT", strStockInspDate }, { "P_USER_ID", _USER_ID } }; var strOutParam = new[] { "P_RESULT" }; string callProc = "PK_EMS_ESPA002.SP_EMS_STOCK_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); } } else { _SUCCESS_CODE = "0"; da.RollbackTransaction(); this.BaseClass.MsgError("ERR_INPUT_TYPE"); } if (_SUCCESS_CODE == "100") { da.CommitTransaction(); StockList.Remove(target); gridMain.RefreshData(); //this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("CMPT_DELETE")); } } catch (Exception ex) { da.RollbackTransaction(); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } } }
/// <summary> /// 조회 함수 /// </summary> void SearchStock() { try { var strStartDate = this.BaseClass.GetCalendarValue(this.searchStart); var strEndDate = this.BaseClass.GetCalendarValue(this.searchEnd); var param = new Dictionary <string, object> { { "P_CENTER_CD", this.BaseClass.CenterCD }, { "P_FROM_DT", strStartDate }, { "P_TO_DT", strEndDate } }; var strOutParam = new[] { "P_EMS_STOCK_LIST" }; //string callProc = "PK_EMS_ESPA002.SP_EMS_STOCK_SEL"; string callProc = "PK_EMS_ESPA002.SP_EMS_STOCK_PERIOD_SEL"; using (BaseDataAccess da = new BaseDataAccess()) { var outData = da.GetSpDataSet( callProc // 호출 프로시저 , param // Input 파라메터 , strOutParam // Output 파라메터 ); if (null != StockList) { StockList.Clear(); StockList = null; } StockList = new ObservableCollection <EmsStock>(); if (outData.Tables[0].Rows.Count > 0) { StockList.ToObservableCollection(outData.Tables[0]); //this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("CMPT_INQ")); } else { //this.ChangeStatusLabelEvent(HelperClass.GetMessageByCountryCode("NO_INQ_DATA")); } gridMain.ItemsSource = StockList; if (outData.Tables[0].Rows.Count > 0) { if (-1 < focused_handle) { gridMain.View.FocusedRowHandle = focused_handle; gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsStock>)[focused_handle]; } else { gridMain.View.FocusedRowHandle = 0; gridMain.SelectedItem = (gridMain.ItemsSource as ObservableCollection <EmsStock>)[0]; } EmsStock target = gridMain.SelectedItem as EmsStock; if (null != target) { CurrentStock = target; SearchStockDetail(target.STOCK_INSP_DT); } } else { CurrentStock = null; if (null != CurrentStockDetail) { CurrentStockDetail.Clear(); CurrentStockDetail = null; } } this.btnConfirmHigh.IsEnabled = true; this.btnSaveHigh.IsEnabled = true; this.btnAddHigh.IsEnabled = true; this.btnRowDeleteHigh.IsEnabled = true; } } catch (Exception ex) { this.BaseClass.Error(ex); this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE); } }