static void TransferFilesFromExcelToJson()
{
string exceDirectorylPath = Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar + EXCEL_DIRECTORY;
string jsonDirectoryPath = Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar + JSON_DIRECTORY;
if (!Directory.Exists(jsonDirectoryPath)) // 如果資料夾不存在
{
Directory.CreateDirectory(jsonDirectoryPath); // 建立目錄
}
ExcelToJsonString tableToJson = new ExcelToJsonString();
int successFileCount = 0;
Array dataLoadTags = Enum.GetValues(typeof(GlobalConst.DataLoadTag));
foreach (GlobalConst.DataLoadTag dataLoadTag in dataLoadTags)
{
string dataJsonString;
EnumClassValue dataConvertInfo;
bool isSuccesGetAttr = CommonFunction.GetAttribute<EnumClassValue>(dataLoadTag, out dataConvertInfo);
if (!isSuccesGetAttr) { continue; }
string fileName = dataConvertInfo.FileName;
System.Type dataType = dataConvertInfo.ClassType;
ReadExcelToJsonStringError error = tableToJson.ReadExcelFile(exceDirectorylPath, dataConvertInfo, NeedReadSite.CLIENT, out dataJsonString, out debugMessage);
if (error == ReadExcelToJsonStringError.NONE)
{
#region JsonString To File
string filePath = jsonDirectoryPath + Path.DirectorySeparatorChar + fileName + JSON_EXT;
using (StreamWriter sw = new StreamWriter(filePath))
{
sw.Write(dataJsonString);
}
#endregion
debugMessage = string.Format("{0}將 {1} 資料轉換成json成功\n", debugMessage, exceDirectorylPath + Path.DirectorySeparatorChar + fileName + ".xlsx");
fileListMessage = string.Format("{0}{1}：O\n", fileListMessage, fileName);
++successFileCount;
}
else
{
debugMessage = string.Format("{0}取得{1}內資料失敗\n", debugMessage, fileName);
fileListMessage = string.Format("{0}{1}：X\n", fileListMessage, fileName);
}
}
debugMessage = string.Format("{0}共轉換 {1}個檔案成功，{2}個檔案失敗\n", debugMessage, successFileCount, dataLoadTags.Length - successFileCount);
}
public void TearDown()
{
_excelToJsonString = null;
}
public void SetUp()
{
_excelToJsonString = new ExcelToJsonString();
}
public void TestJsonStringNotEmptyField()
{
EventConditionData ecd = new EventConditionData();
ecd.CheckCondition1 = 2;
ecd.CheckCondition2 = 1;
ecd.CheckType = 0;
ExcelToJsonString temp = new ExcelToJsonString();
string jsonStr = temp.ObjectToJsonString(ecd);
string realJsonStr = "{\"CheckType\":0,\"CheckCondition1\":2,\"CheckCondition2\":1}";
Assert.AreEqual(realJsonStr, jsonStr);
}
