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