/// <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); }
/// <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); }
public void DeckLoad() { OnPropertyChanged(nameof(DeckName)); if ((DeckName == null) || DeckName.Equals(string.Empty)) { return; } DeckList.Clear(); var deckPath = CardUtils.GetDeckPath(DeckName); try { var sr = File.OpenText(deckPath); var numberListString = sr.ReadToEnd().Trim(); sr.Close(); var idList = JsonUtils.Deserialize <List <int> >(numberListString); foreach (var id in idList) { AddCard(id); } } catch (Exception exception) { BaseDialogUtils.ShowDialogAuto(exception.Message); } }
public void Export_Click(object obj) { var pack = CardQueryModel.Pack; if (pack.Equals(StringConst.NotApplicable) || pack.Contains(StringConst.Series)) { BaseDialogUtils.ShowDialogOk(StringConst.PackChoiceNone); return; } var exportPath = DialogUtils.ShowExport(pack); if (exportPath.Equals(string.Empty)) { return; } var sql = SqlUtils.GetExportSql(pack); var dataSet = new DataSet(); if (!DataManager.FillDataToDataSet(dataSet, sql)) { return; } var isExport = ExcelHelper.ExportPackToExcel(exportPath, dataSet); BaseDialogUtils.ShowDialogAuto(isExport ? StringConst.ExportSucceed : StringConst.ExportFailed); }
private void BtnClear_Click(object sender, RoutedEventArgs e) { var sqlList = GetClearSqlList(); // 数据库覆写 var isExecute = DataManager.Execute(sqlList); BaseDialogUtils.ShowDialogAuto(isExecute ? "Succeed" : "Failed"); }
public void DownloadImages_Click(object obj) { if (0 == CardModels.Count) { BaseDialogUtils.ShowDialogAuto("请选择图鉴目录"); return; } DownloadImages(CardModels.ToList(), false); }
/// <summary> /// 卡组另存事件 /// </summary> public void Resave_Click(object obj) { var deckPath = CardUtils.GetDeckPath(DeckName); if (!File.Exists(deckPath)) { Save(); } BaseDialogUtils.ShowDialogAuto(StringConst.DeckNameExist); }
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); }
public void Decrypt_Click(object obj) { if (Password.Equals(string.Empty)) { BaseDialogUtils.ShowDialogOk(StringConst.PasswordNone); return; } if (DataManager.Decrypt()) { UpdatePasswordVisibility(true, false); BaseDialogUtils.ShowDialogAuto(StringConst.DncryptSucced); return; } BaseDialogUtils.ShowDialogOk(StringConst.DncryptFailed); }
public void Encrypt_Click(object obj) { if (Password.Equals(string.Empty)) { BaseDialogUtils.ShowDialogOk(StringConst.PasswordNone); return; } if (DataManager.Encrypt(DataManager.DsAllCache, SqlUtils.GetQueryAllSql())) { UpdatePasswordVisibility(false, true); BaseDialogUtils.ShowDialogAuto(StringConst.EncryptSucced); _cardEditor.InitView(); return; } BaseDialogUtils.ShowDialogOk(StringConst.EncryptFailed); }
public void DeckResave_Click(object obj) { OnPropertyChanged(nameof(DeckName)); if (DeckName.Equals(string.Empty)) { BaseDialogUtils.ShowDialogAuto(StringConst.DeckNameNone); return; } var deckPath = CardUtils.GetDeckPath(DeckName); if (File.Exists(deckPath)) { BaseDialogUtils.ShowDialogAuto(StringConst.DeckNameExist); return; } DeckSave_Click(DeckName); }
/// <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); }
private void BtnCvCover_Click(object sender, RoutedEventArgs e) { var filePath = TxtFilePath.Text.Trim(); if (filePath.Equals("")) { BaseDialogUtils.ShowDialogAuto("源文件不存在"); return; } var jsonString = FileUtils.GetFileContent(filePath); var cvDic = JsonUtils.GetDictionary(jsonString); // 生成覆写的数据库语句集合 var insertSqlList = GetUpdateSqlList(SqliteConst.ColumnCv, cvDic); // 数据库覆写 var isExecute = DataManager.Execute(insertSqlList); BaseDialogUtils.ShowDialogAuto(isExecute ? "Succeed" : "Failed"); }
public void DeckSave_Click(object obl) { OnPropertyChanged(nameof(DeckName)); if (DeckName.Equals(string.Empty)) { BaseDialogUtils.ShowDialogAuto(StringConst.DeckNameNone); return; } var deckPath = CardUtils.GetDeckPath(DeckName); var deckBuilder = new StringBuilder(); var deckNumberList = new List <int>(); deckNumberList.AddRange(DeckList.Select(deck => deck.Id).ToList()); deckBuilder.Append(JsonUtils.Serializer(deckNumberList)); var isSaveSucceed = FileUtils.SaveFile(deckPath, deckBuilder.ToString()); BaseDialogUtils.ShowDialogAuto(isSaveSucceed ? StringConst.SaveSucceed : StringConst.SaveFailed); }
private void Save() { if (DeckName.Equals(string.Empty)) { BaseDialogUtils.ShowDialogAuto(StringConst.DeckNameNone); return; } var deckPath = CardUtils.GetDeckPath(DeckName); var deckBuilder = new StringBuilder(); var deckNumberList = new List <string>(); deckNumberList.AddRange(_playerVm.PlayerModels.Select(deckEntity => deckEntity.NumberEx).ToList()); deckNumberList.AddRange(_deckVm.IgModels.Select(deckEntity => deckEntity.NumberEx).ToList()); deckNumberList.AddRange(_deckVm.UgModels.Select(deckEntity => deckEntity.NumberEx).ToList()); deckNumberList.AddRange(_deckVm.ExModels.Select(deckEntity => deckEntity.NumberEx).ToList()); deckBuilder.Append(JsonUtils.Serializer(deckNumberList)); var isSave = FileUtils.SaveFile(deckPath, deckBuilder.ToString()); BaseDialogUtils.ShowDialogAuto(isSave ? StringConst.SaveSucceed : StringConst.SaveFailed); }
/// <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 void BtnLinesCover_Click(object sender, RoutedEventArgs e) { var filePath = TxtFilePath.Text.Trim(); if (filePath.Equals("")) { BaseDialogUtils.ShowDialogAuto("源文件不存在"); return; } var jsonString = FileUtils.GetFileContent(filePath); var flavourDic = JsonUtils.GetDictionary(jsonString); var tempFlavourDic = new Dictionary <string, string>(); var tempFlavourList = new List <string>(); foreach (var dic in flavourDic) { if (dic.Key.EndsWith("_01") || dic.Key.EndsWith("_02")) { if (dic.Key.EndsWith("_01")) { tempFlavourList.Clear(); tempFlavourList.Add(dic.Value.ToString()); } else { tempFlavourList.Add(dic.Value.ToString()); tempFlavourDic.Add(dic.Key.Substring(0, 9), JsonUtils.Serializer(tempFlavourList)); } } else { tempFlavourDic.Add(dic.Key, dic.Value.ToString()); } } var sqlList = GetUpdateSqlList(SqliteConst.ColumnFlavour, tempFlavourDic); // 数据库覆写 var isExecute = DataManager.Execute(sqlList); BaseDialogUtils.ShowDialogAuto(isExecute ? "Succeed" : "Failed"); }
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"); }
/// <summary> /// 卡组载入 /// </summary> public void LoadDeck() { if (DeckName.Equals(string.Empty)) { return; } ClearDeck(); var deckPath = CardUtils.GetDeckPath(DeckName); try { var numberListString = FileUtils.GetFileContent(deckPath); var numberExList = JsonUtils.Deserialize <List <string> >(numberListString); foreach (var numberEx in numberExList) { AddCard(numberEx); } } catch (Exception exception) { BaseDialogUtils.ShowDialogAuto(exception.Message); } }
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); }