public static void CopyOneData(ExcelUtility sourceEx, int sourceIndex, ExcelUtility destiEx, int destiIndex, ExcelPosition startPosition, ExcelPosition endPosition, string[] pre, string style, out bool sc) { bool checkClear; string text = sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, sourceIndex, startPosition, endPosition, pre, out checkClear); if (text == "") { sc = false; return; } if (style == "") { destiEx.WriteValue(destiEx.ExcelWorkbook, destiIndex, endPosition, text); } else { destiEx.WriteValue(destiEx.ExcelWorkbook, destiIndex, endPosition, text, style); } sc = true; }
/// <summary> /// /// </summary> /// <param name="sourceEx"></param> /// <param name="stateIndex"></param> public static void TypeStandardize(ExcelUtility sourceEx, int stateIndex) { bool checkClear; string str = sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), new ExcelPosition(5, 6), @"型号:", out checkClear).Trim().ToLower(); bool DoNotHave = true; if (str.Contains(@"unfors") || sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 9), new ExcelPosition(5, 10), @"厂家:", out checkClear).Trim().ToLower().Contains(@"unfors")) { sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), @"型号:"); sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 6), @"Xi"); sourceEx.ExcelWorkbook.Save(); sourceEx.ExcelWorkbook.Saved = true; str = sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), new ExcelPosition(5, 6), @"型号:", out checkClear).Trim().ToLower(); } if (str.Contains(@"baracuda")) { sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), @"型号:"); sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 6), @"Barracuda"); sourceEx.ExcelWorkbook.Save(); sourceEx.ExcelWorkbook.Saved = true; str = sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), new ExcelPosition(5, 6), @"型号:", out checkClear).Trim().ToLower(); } if (str.Contains(@"prianha")) { sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), @"型号:"); sourceEx.WriteValue(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 6), @"Piranha"); sourceEx.ExcelWorkbook.Save(); sourceEx.ExcelWorkbook.Saved = true; str = sourceEx.GetMergeContent(sourceEx.ExcelWorkbook, stateIndex, new ExcelPosition(5, 5), new ExcelPosition(5, 6), @"型号:", out checkClear).Trim().ToLower(); } foreach (string item in TestedInstrument.AllTypes) { if (item.ToLower() == str) { DoNotHave = false; break; } } if (DoNotHave) { LogHelper.AddException(@"仪器类型可能出现手误", true); LogHelper.AddLog("错误47", " 仪器类型:" + str, true); } }