private void ReadData() { Hashtable columnHeader = new Hashtable(); Office.Excel.ForwardReadWorksheet sheet = base.Sheet; object content; if (sheet.ReadNextRow()) { while (sheet.ReadNextCell(false)) { content = sheet.GetContent(); columnHeader.Add(sheet.CurrentCell.ColumnIndex, content == null ? "" : content.ToString()); } } bool isEmptyRow; Page9_12_2Value value = null; while (sheet.ReadNextRow()) { isEmptyRow = true; value = new Page9_12_2Value(); while (sheet.ReadNextCell(false)) { content = sheet.GetContent(); string str = content == null ? "" : content.ToString(); if (string.IsNullOrEmpty(str) == false) { isEmptyRow = false; } switch (columnHeader[sheet.CurrentCell.ColumnIndex] as string) { case "座椅位置": value.SeatPosition = str; break; case "前气囊": value.FrontAirBags = str; break; case "侧气囊": value.SideAirBags = str; break; case "安全带预加载装置": value.SeatBeltPreloader = str; break; case "第几排座椅": value.RowOfSeat = str; break; } } if (isEmptyRow) { continue; } data.Add(value); } }
private void FillValue(string key, IntPtr rowNumber, Page9_12_2_Relation relation, Page9_12_2Value value) { if (ApiSetter.SetComboBoxSelected(base.HWnd, rowNumber, key) == false) { return; } ApiSetter.SetText(relation.FrontAirBags, value.FrontAirBags); ApiSetter.SetText(relation.SideAirBags, value.SideAirBags); ApiSetter.SetText(relation.SeatBeltPreloader, value.SeatBeltPreloader); }