WSHCommon/XmdsCommonServer/XLS/XLSZhanYaoDataLoader.cs


using CommonLang;
using CommonLang.IO;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.IO;
using XmdsCommonServer.XLS.Data;

namespace XmdsCommonServer.XLS
{
	public class XLSZhanYaoDataLoader : XLSLoader
	{
		private HashMap<int, ZhanYaoData> ZhanYaoDatas = new HashMap<int, ZhanYaoData>();

		public XLSZhanYaoDataLoader(string path)
		{
			byte[] data = Resource.LoadData(path);

			if (data == null)
			{
				throw new Exception("Can not read xls file : " + path);
			}

			using (MemoryStream ms = new MemoryStream(data))
			{
				IWorkbook Workbook = null;
				if (path.Contains(".xlsx"))
				{
					Workbook = new XSSFWorkbook(ms);
				}
				else if (path.Contains(".xls"))
				{
					Workbook = new HSSFWorkbook(ms);
				}

				for (int si = 0; si < Workbook.NumberOfSheets; si++)
				{
					ISheet sheet = Workbook.GetSheetAt(si) as ISheet;
					try
					{
						if (sheet.SheetName == "Zhanyao_title")
						{
							LoadSheet(sheet);
						}
					}
					catch (Exception error)
					{
						throw new Exception(string.Format("XLSZhanYaoDataLoader 初始化斩妖配置错误SheetName = {0},Error = {1}",
							sheet.SheetName, error.ToString()));
					}
				}

			}

			log.Info("XLSZhanYaoDataLoader 初始化怪物配置完成.");
		}

		private void LoadSheet(ISheet sheet)
		{
			int index = 0;
			try
			{
				foreach (ZhanYaoData m in LoadSheet<ZhanYaoData>(sheet))
				{
					ZhanYaoDatas.Add(m.Zhanyao_TitleLv, m);
					index++;
				}
			}
			catch (Exception error)
			{
				throw new Exception(string.Format("XLSZhanYaoDataLoader Error : index  = {0} Error = {1}", index, error.ToString()));
			}

			log.Info(string.Format("loadSheet【{0}】Complete", sheet.SheetName));
		}

		public ZhanYaoData GetZhanYaoData(int level)
		{
			return this.ZhanYaoDatas.Get(level);
		}

	}
}