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);
}
}
