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