private HcCtgCodeInfo convertFromCodeExcel(FileInfo nextFile) { var ctgCodeInfo = new HcCtgCodeInfo(); ExcelOptions.GetExcelData(nextFile.FullName, s => setCodeInfo(s, ctgCodeInfo)); return ctgCodeInfo; }
public static void WriteOutPut(String path, HcCtgCodeInfo info) { if(genertor == null) { genertor = new GenertorToCode(); } genertor.creatCtgCodeInfo(path, info.Codes); genertor.creatCtgCodeInfoForScene(path, info.SceneCodes); }
private void getCtgCodeInfo(Worksheet sheet, HcCtgCodeInfo ctgCodeInfo) { Range range = null; var starRow = 11; HcCodeInfo codeInfo = null; while (((Range)sheet.Cells[starRow, 5]).Value != null && !string.IsNullOrEmpty(((Range)sheet.Cells[starRow, 5]).Value.ToString())) { HcCodeItemInfo codeItemInfo = new HcCodeItemInfo(); range = (Range)sheet.Cells[starRow, 5]; codeItemInfo.ENName = range.Value.ToString(); range = (Range)sheet.Cells[starRow, 6]; codeItemInfo.Code = range.Value.ToString(); range = (Range)sheet.Cells[starRow, 7]; codeItemInfo.Caption = range.Value; range = (Range)sheet.Cells[starRow, 8]; codeItemInfo.Note = range.Value; range = (Range)sheet.Cells[starRow, 2]; if (range.Value != null) { if (codeInfo != null) { ctgCodeInfo.Codes.Add(codeInfo); } codeInfo = new HcCodeInfo(); codeInfo.Name = range.Value; range = (Range)sheet.Cells[starRow, 3]; codeInfo.Table = range.Value; range = (Range)sheet.Cells[starRow, 4]; codeInfo.Column = range.Value; } codeInfo.Codes.Add(codeItemInfo); starRow += 1; } if (codeInfo != null) { ctgCodeInfo.Codes.Add(codeInfo); } }
private void setCodeInfo(Worksheet sheet, HcCtgCodeInfo ctgCodeInfo) { var name = sheet.Name; switch (name) { case "区分代码一览": // 获得区分代码一览 getCtgCodeInfo(sheet, ctgCodeInfo); break; case "区分代码一览(画面表示用)": // 区分代码一览(画面表示用) getCtgCodeInfoForScene(sheet, ctgCodeInfo); break; default: break; } }