/// <summary> /// 随从的导入 /// </summary> /// <param name="target"></param> /// <param name="workbook"></param> private void Minion(TargetType target, dynamic workbook) { if (Directory.Exists(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\")) { Directory.Delete(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\", true); } Directory.CreateDirectory(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\"); //随从的导入 dynamic worksheet = workbook.Sheets(1); int rowCount = 4; while (!String.IsNullOrEmpty(worksheet.Cells(rowCount, 2).Text)) { Card.MinionCard Minion = new Card.MinionCard(); Minion.SN = worksheet.Cells(rowCount, 2).Text; Minion.Name = worksheet.Cells(rowCount, 3).Text; Minion.Description = worksheet.Cells(rowCount, 4).Text; Minion.Class = CardUtility.GetEnum<Card.CardUtility.ClassEnum>(worksheet.Cells(rowCount, 5).Text, Card.CardUtility.ClassEnum.中立); Minion.StandardCostPoint = CardUtility.GetInt(worksheet.Cells(rowCount, 7).Text); Minion.ActualCostPoint = Minion.StandardCostPoint; Minion.StandardAttackPoint = CardUtility.GetInt(worksheet.Cells(rowCount, 8).Text); Minion.标准生命值上限 = CardUtility.GetInt(worksheet.Cells(rowCount, 9).Text); Minion.Rare = CardUtility.GetEnum<Card.CardBasicInfo.稀有程度>(worksheet.Cells(rowCount, 12).Text, CardBasicInfo.稀有程度.白色); Minion.IsCardReady = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 13).Text); Minion.Standard嘲讽 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 14).Text); Minion.Standard冲锋 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 15).Text); Minion.Standard不能攻击 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 16).Text); Minion.Standard风怒 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 17).Text); Minion.潜行特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 18).Text); Minion.圣盾特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 19).Text); Minion.法术免疫特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 20).Text); Minion.英雄技能免疫特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 21).Text); Boolean HasBuff = false; for (int i = 22; i < 25; i++) { if (!String.IsNullOrEmpty(worksheet.Cells(rowCount, i).Text)) { HasBuff = true; break; } } if (HasBuff) { Minion.光环效果.Scope = CardUtility.GetEnum<Card.MinionCard.光环范围>(worksheet.Cells(rowCount, 22).Text, Card.MinionCard.光环范围.随从全体); Minion.光环效果.EffectType = CardUtility.GetEnum<Card.MinionCard.光环类型>(worksheet.Cells(rowCount, 23).Text, Card.MinionCard.光环类型.增加攻防); Minion.光环效果.BuffInfo = worksheet.Cells(rowCount, 24).Text; } Minion.战吼效果 = worksheet.Cells(rowCount, 25).Text; Minion.亡语效果 = worksheet.Cells(rowCount, 26).Text; Minion.激怒效果 = worksheet.Cells(rowCount, 27).Text; Minion.连击效果 = worksheet.Cells(rowCount, 28).Text; Minion.回合开始效果 = worksheet.Cells(rowCount, 29).Text; Minion.回合结束效果 = worksheet.Cells(rowCount, 30).Text; switch (target) { case TargetType.MongoDB: //innerCollection.Insert<Card.MinionCard>(Minion); break; case TargetType.Xml: XmlSerializer xml = new XmlSerializer(typeof(Card.MinionCard)); String XmlFilename = XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\" + Minion.SN + ".xml"; xml.Serialize(new StreamWriter(XmlFilename), Minion); break; default: break; } rowCount++; } }
/// <summary> /// 随从的导入 /// </summary> /// <param name="target"></param> /// <param name="workbook"></param> private void Minion(TargetType target, dynamic workbook) { if (Directory.Exists(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\")) { Directory.Delete(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\", true); } Directory.CreateDirectory(XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\"); //随从的导入 dynamic worksheet = workbook.Sheets(1); int rowCount = 4; while (!String.IsNullOrEmpty(worksheet.Cells(rowCount, 2).Text)) { Card.MinionCard Minion = new Card.MinionCard(); Minion.SN = worksheet.Cells(rowCount, 2).Text; Minion.Name = worksheet.Cells(rowCount, 3).Text; Minion.Description = worksheet.Cells(rowCount, 4).Text; Minion.Class = CardUtility.GetEnum <Card.CardUtility.ClassEnum>(worksheet.Cells(rowCount, 5).Text, Card.CardUtility.ClassEnum.中立); Minion.种族 = CardUtility.GetEnum <Card.CardUtility.种族Enum>(worksheet.Cells(rowCount, 6).Text, Card.CardUtility.种族Enum.无); Minion.StandardCostPoint = CardUtility.GetInt(worksheet.Cells(rowCount, 7).Text); Minion.StandardAttackPoint = CardUtility.GetInt(worksheet.Cells(rowCount, 8).Text); Minion.标准生命值上限 = CardUtility.GetInt(worksheet.Cells(rowCount, 9).Text); Minion.Rare = CardUtility.GetEnum <Card.CardBasicInfo.稀有程度>(worksheet.Cells(rowCount, 12).Text, CardBasicInfo.稀有程度.白色); Minion.IsCardReady = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 13).Text); Minion.Standard嘲讽 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 14).Text); Minion.Standard冲锋 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 15).Text); Minion.Standard不能攻击 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 16).Text); Minion.Standard风怒 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 17).Text); Minion.潜行特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 18).Text); Minion.圣盾特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 19).Text); Minion.法术免疫特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 20).Text); Minion.英雄技能免疫特性 = !String.IsNullOrEmpty(worksheet.Cells(rowCount, 21).Text); Boolean HasBuff = false; for (int i = 22; i < 25; i++) { if (!String.IsNullOrEmpty(worksheet.Cells(rowCount, i).Text)) { HasBuff = true; break; } } if (HasBuff) { Minion.光环效果.Name = Minion.Name; Minion.光环效果.Scope = CardUtility.GetEnum <Card.MinionCard.光环范围>(worksheet.Cells(rowCount, 22).Text, Card.MinionCard.光环范围.随从全体); Minion.光环效果.EffectType = CardUtility.GetEnum <Card.MinionCard.光环类型>(worksheet.Cells(rowCount, 23).Text, Card.MinionCard.光环类型.增加攻防); Minion.光环效果.BuffInfo = worksheet.Cells(rowCount, 24).Text; } Minion.战吼效果 = worksheet.Cells(rowCount, 25).Text; Minion.战吼类型 = CardUtility.GetEnum <Card.MinionCard.战吼类型列表>(worksheet.Cells(rowCount, 26).Text, Card.MinionCard.战吼类型列表.默认); Minion.亡语效果 = worksheet.Cells(rowCount, 27).Text; Minion.激怒效果 = worksheet.Cells(rowCount, 28).Text; Minion.连击效果 = worksheet.Cells(rowCount, 29).Text; Minion.回合开始效果 = worksheet.Cells(rowCount, 30).Text; Minion.回合结束效果 = worksheet.Cells(rowCount, 31).Text; Minion.Overload = CardUtility.GetInt(worksheet.Cells(rowCount, 32).Text); Minion.事件类型 = CardUtility.GetEnum <Card.MinionCard.事件类型列表>(worksheet.Cells(rowCount, 33).Text, Card.MinionCard.事件类型列表.无); Minion.事件效果 = worksheet.Cells(rowCount, 34).Text; switch (target) { case TargetType.MongoDB: //innerCollection.Insert<Card.MinionCard>(Minion); break; case TargetType.Xml: XmlSerializer xml = new XmlSerializer(typeof(Card.MinionCard)); String XmlFilename = XmlFolderPicker.SelectedPathOrFileName + "\\Minion\\" + Minion.SN + ".xml"; xml.Serialize(new StreamWriter(XmlFilename), Minion); break; default: break; } rowCount++; } }