private void FillValue(string key, IntPtr rowNumber, Page9_12_1_Relation relation, Page9_12_1Value value) { if (ApiSetter.SetComboBoxSelected(base.HWnd, rowNumber, key) == false) { return; } ApiSetter.SetComboBoxSelected(base.HWnd, relation.Cert, value.Cert); ApiSetter.SetText(relation.CertNo, value.CertNo); if (string.IsNullOrEmpty(value.Transform)) { ApiSetter.ClickButton(relation.Transform, base.HWnd, null, null); } else { ApiSetter.SetText(relation.TransformText, value.Transform); } ApiSetter.SetComboBoxSelected(base.HWnd, relation.HeightAdj, value.HeightAdj); ApiSetter.SetText(relation.Productor, value.Productor); ApiSetter.SetText(relation.SeatBeltType, value.SeatBeltType); ApiSetter.SetText(relation.Model, value.Model); ApiSetter.SetText(relation.RetractorType, value.RetractorType); ApiSetter.SetText(relation.RetractorAngle, value.RetractorAngle); ApiSetter.SetText(relation.SeatBeltPosition, value.SeatBeltPosition); if (string.IsNullOrEmpty(value.SeatBeltPosAttach) == false) { ApiSetter.ClickButton(relation.SeatBeltPosAttach, base.HWnd, ListenAttachWindow, new FillValue3C() { PublicAttachFile = value.SeatBeltPosAttach, Separators = FillParameter3C.DefaultSeparators }); } ApiSetter.SetText(relation.LockType, value.LockType); ApiSetter.SetText(relation.FixedPosNum, value.FixedPosNum); ApiSetter.SetText(relation.CCCSignPos, value.CCCSignPos); if (string.IsNullOrEmpty(value.SeatBeltPosAttach) == false) { ApiSetter.ClickButton(relation.CCCSignPosAttach, base.HWnd, ListenAttachWindow, new FillValue3C() { PublicAttachFile = value.CCCSignPosAttach, Separators = FillParameter3C.DefaultSeparators }); } ApiSetter.SetText(relation.CCCSignFixation, value.CCCSignFixation); }
//第几排座椅 座椅位置 是否已获证 CCC证书编号 变型,如适用 安全带高度调节装置 生产厂名称 安全带型式* //型号 卷收器型式** 卷收器安装角度 安全带的安装位置 安全带安装位置附件 搭扣锁型式*** 安全带固定点数量 //CCC认证标志的位置 CCC认证标志位置附件 CCC认证标志的固定方法 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_1Value value = null; while (sheet.ReadNextRow()) { value = new Page9_12_1Value(); string key = ""; isEmptyRow = true; 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.Position = str; break; case "是否已获证": value.Cert = str; break; case "CCC证书编号": value.CertNo = str; break; case "变型,如适用": value.Transform = str; break; case "安全带高度调节装置": value.HeightAdj = str; break; case "生产厂名称": value.Productor = str; break; case "安全带型式*": value.SeatBeltType = str; break; case "型号": value.Model = str; break; case "卷收器型式**": value.RetractorType = str; break; case "卷收器安装角度": value.RetractorAngle = str; break; case "安全带的安装位置": value.SeatBeltPosition = str; break; case "安全带安装位置附件": value.SeatBeltPosAttach = str; break; case "搭扣锁型式***": value.LockType = str; break; case "安全带固定点数量": value.FixedPosNum = str; break; case "CCC认证标志的位置": value.CCCSignPos = str; break; case "CCC认证标志位置附件": value.CCCSignPosAttach = str; break; case "CCC认证标志的固定方法": value.CCCSignFixation = str; break; case "第几排座椅": key = str; break; } } if (key == null || isEmptyRow) { continue; } List <Page9_12_1Value> values = null; if (data.ContainsKey(key)) { values = data[key] as List <Page9_12_1Value>; if (values == null) { values = new List <Page9_12_1Value>(); data[key] = values; } } else { values = new List <Page9_12_1Value>(); data.Add(key, values); } values.Add(value); } }