/// <summary> /// 卡牌删除事件 /// </summary> public void Delete_Click(object obj) { // 选择判空 var selectedItem = _cardPreviewVm.SelectedItem; if (null == selectedItem) { BaseDialogUtils.ShowDialogAuto(StringConst.CardChioceNone); return; } // 删除确认 if (!BaseDialogUtils.ShowDialogConfirm(StringConst.DeleteConfirm)) { return; } // 数据库删除 var deleteSql = CeSqlUtils.GetDeleteSql(selectedItem.Number); var isDelete = DataManager.Execute(deleteSql); BaseDialogUtils.ShowDialogAuto(isDelete ? StringConst.DeleteSucceed : StringConst.DeleteFailed); if (!isDelete) { return; } // 数据库更新 DataManager.FillDataToDataSet(); // 跟踪历史 if (null == _cardPreviewVm.MemoryQueryModel) { _cardPreviewVm.MemoryQueryModel = GetCardQueryExMdoel(); } _cardPreviewVm.UpdateCardPreviewList(_cardPreviewVm.MemoryQueryModel); }
/// <summary> /// 卡牌添加事件 /// </summary> public void Add_Click(object obj) { // 卡编是否重复判断 if (CardUtils.IsNumberExist(CardQueryModel.Number)) { BaseDialogUtils.ShowDialogAuto(StringConst.CardIsExitst); return; } // 添加确认 if (!BaseDialogUtils.ShowDialogConfirm(StringConst.AddConfirm)) { return; } // 数据库添加 var addSql = CeSqlUtils.GetAddSql(CardQueryModel); var isAdd = DataManager.Execute(addSql); BaseDialogUtils.ShowDialogAuto(isAdd ? StringConst.AddSucceed : StringConst.AddFailed); if (!isAdd) { return; } // 数据库更新 DataManager.FillDataToDataSet(); // 跟踪历史 if (null == _cardPreviewVm.MemoryQueryModel) { _cardPreviewVm.MemoryQueryModel = GetCardQueryExMdoel(); } _cardPreviewVm.UpdateCardPreviewList(_cardPreviewVm.MemoryQueryModel); }
public void Md5Cover_Click(object obj) { if (!BaseDialogUtils.ShowDialogConfirm("确认覆写?")) { return; } var sqlList = SqlUtils.GetMd5SqlList(); var succeed = DataManager.Execute(sqlList); BaseDialogUtils.ShowDialogAuto(succeed ? StringConst.UpdateSucceed : StringConst.UpdateFailed); }
/// <summary> /// 卡牌更新事件 /// </summary> public void Update_Click(object obj) { // 选择判空 var selectedItem = _cardPreviewVm.SelectedItem; if (null == selectedItem) { BaseDialogUtils.ShowDialogAuto(StringConst.CardChioceNone); return; } // 卡编是否重复判断 var checkNumber = selectedItem.Number.Equals(CardQueryModel.Number) || !CardUtils.IsNumberExist(CardQueryModel.Number); if (!checkNumber) { BaseDialogUtils.ShowDialogAuto(StringConst.CardIsExitst); return; } // 修改确认 if (!BaseDialogUtils.ShowDialogConfirm(StringConst.UpdateConfirm)) { return; } // 数据库修改 var updateSql = CeSqlUtils.GetUpdateSql(CardQueryModel, selectedItem.Number); var updateSqls = new List <string> { updateSql }; if (_cardQueryExVm.ModeType.Equals(Enums.ModeType.Develop)) { updateSqls.Add(CeSqlUtils.GetUpdateSql(CardQueryModel)); } var isUpdate = DataManager.Execute(updateSqls); BaseDialogUtils.ShowDialogAuto(isUpdate ? StringConst.UpdateSucceed : StringConst.UpdateFailed); if (!isUpdate) { return; } // 数据库更新 DataManager.FillDataToDataSet(); _cardPreviewVm.UpdateCardPreviewList(_cardPreviewVm.MemoryQueryModel); }
public async void DeckDelete_Click(object obj) { OnPropertyChanged(nameof(DeckName)); if (DeckName.Equals(string.Empty)) { return; } if (!await BaseDialogUtils.ShowDialogConfirm(StringConst.DeleteHint)) { return; } var deckPath = CardUtils.GetDeckPath(DeckName); if (!File.Exists(deckPath)) { return; } File.Delete(deckPath); DeckList.Clear(); }
/// <summary> /// 卡组删除事件 /// </summary> public void Delete_Click(object obj) { if (DeckName.Equals(string.Empty)) { return; } if (!BaseDialogUtils.ShowDialogConfirm(StringConst.DeleteHint)) { return; } var deckPath = CardUtils.GetDeckPath(DeckName); if (!File.Exists(deckPath)) { return; } File.Delete(deckPath); ClearDeck(); DeckName = string.Empty; BaseDialogUtils.ShowDialogAuto(StringConst.DeleteSucceed); }
private async void BtnBaseCover_Click(object sender, RoutedEventArgs e) { var filePath = TxtFilePath.Text.Trim(); if (filePath.Equals("")) { BaseDialogUtils.ShowDialogAuto("源文件不存在"); return; } var packName = TxtPackName.Text.Trim(); if (packName.Equals("")) { BaseDialogUtils.ShowDialogAuto("请输入表格名称"); return; } // 获取源文件所有的信息 var dtSource = new DataSet(); var isImport = ExcelHelper.ImportExcelToDataTable(filePath, packName, dtSource); if (!isImport) { BaseDialogUtils.ShowDialogAuto("文件中数据异常"); return; } // 确认状态 if (!await BaseDialogUtils.ShowDialogConfirm("确认覆写?")) { return; } var sourceCardEntitys = GetSourceCardEntities(dtSource); // 生成覆写的数据库语句集合 var insertSqlList = GetInsertSqlList(sourceCardEntitys); // 数据库覆写 var isExecute = DataManager.Execute(insertSqlList); BaseDialogUtils.ShowDialogAuto(isExecute ? "Succeed" : "Failed"); }
private void BtnCover_Click(object sender, RoutedEventArgs e) { var filePath = TxtFilePath.Text.Trim(); if (filePath.Equals("")) { BaseDialogUtils.ShowDialogAuto("源文件不存在"); return; } var packName = TxtPackName.Text.Trim(); if (packName.Equals("")) { BaseDialogUtils.ShowDialogAuto("请输入卡包名称"); return; } // 获取源文件所有的信息 var dtSource = new DataSet(); var isImport = ExcelHelper.ImportExcelToDataTable(filePath, packName, dtSource); if (!isImport) { BaseDialogUtils.ShowDialogAuto("文件中数据异常"); return; } // 确认状态 if (!BaseDialogUtils.ShowDialogConfirm("确认覆写?")) { return; } // 获取源文件编号 var dtNumberList = dtSource.Tables[0].Rows.Cast <DataRow>().Select(column => column["编号"].ToString()).ToList(); var sourceList = GetSourceCardModelList(dtSource); // 获取覆写所有的信息 var dataList = dtNumberList.Select(CardUtils.GetCardModel).ToList(); var selectColumnList = GetSelectColumnList(); // 填充覆写的数据 for (var i = 0; i != dataList.Count; i++) { var dataNumber = dataList[i].Number; foreach (var editorModel in sourceList) { if (!editorModel.Number.Equals(dataNumber)) { continue; } if (selectColumnList.Contains("种类")) { dataList[i].Type = editorModel.Type; } if (selectColumnList.Contains("色")) { dataList[i].Camp = editorModel.Camp; } if (selectColumnList.Contains("种族")) { dataList[i].Race = editorModel.Race; } if (selectColumnList.Contains("标记")) { dataList[i].Sign = editorModel.Sign; } if (selectColumnList.Contains("罕贵度")) { dataList[i].Race = editorModel.Race; } if (selectColumnList.Contains("卡片名_中")) { dataList[i].CName = editorModel.CName; } if (selectColumnList.Contains("COST")) { dataList[i].Cost = int.Parse(editorModel.CostValue); } if (selectColumnList.Contains("力量")) { dataList[i].Power = int.Parse(editorModel.PowerValue); } if (selectColumnList.Contains("能力_中")) { dataList[i].Ability = editorModel.Ability; } } } // 生成覆写的数据库语句集合 var updateSqlList = dataList .Select(cardEntity => GetUpdateSql(cardEntity, cardEntity.Number)) .ToList(); // 数据库覆写 var isExecute = DataManager.Execute(updateSqlList); BaseDialogUtils.ShowDialogAuto(isExecute ? StringConst.UpdateSucceed : StringConst.UpdateFailed); }