/// <summary>
/// 在未QC库中搜索
/// </summary>
private void _searchNotQC(List <SearchItem> list, NnExcel ne)
{
StockInfos infos = new StockInfos();
try
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = m_connection;
foreach (var v in list)
{
if (string.IsNullOrWhiteSpace(v.Value))
{
continue;
}
if (v.SearchType == SearchType.WorkNo)
{
_initNotQCWorkNoSearch(infos, cmd, v);
}
else
{
_initNotQCCoordinateAndOrderIDSearch(infos, cmd, v);
}
}
}
object[][] vs = infos.GetValues();
ne.AddValueWithName(vs, 1, 9, "半纯品");
ne.AutoFit(new int[] { 2, 3, 4, 8 });
ne.SetColor(NPoint.GetPoint(1, 1), NPoint.GetPoint(1, 7), NnExcel.ColorType.Blue);
ne.SetColor(NPoint.GetPoint(infos.CountNormal + 2, 1), NPoint.GetPoint(infos.CountNormal + 3, 9), NnExcel.ColorType.Blue);
}
catch (Exception e) { Console.WriteLine(e.ToString()); }
}
/// <summary>
/// 在库存中搜索
/// </summary>
private void _searchStock(List <SearchItem> list, NnExcel ne)
{
StockSearcher stSearcher = new StockSearcher();
foreach (var v in list)
{
_getSearchValues(v.Value, stSearcher);
}
object[][] vs = stSearcher.GetValues();
ne.AddValueWithName(vs, 1, 11, "库存");
ne.AutoFit(new int[] { 2, 3, 4 });
ne.SetColor(NPoint.GetPoint(1, 1), NPoint.GetPoint(1, 9), NnExcel.ColorType.Blue);
ne.SetColor(NPoint.GetPoint(stSearcher.CountNormal + 2, 1), NPoint.GetPoint(stSearcher.CountNormal + 3, 11), NnExcel.ColorType.Blue);
}
/// <summary>
/// 搜索所有
/// </summary>
internal string SearchAll(string value)
{
List <SearchItem> list = SearchItem.GetSearchItems(value);
NnExcel ne = new NnExcel();
ne.Visible = true;
// 在库存中搜索
_searchStock(list, ne);
// 在未QC库中搜索
_searchNotQC(list, ne);
// 在未树脂肽库中搜索
_searchResin(list, ne);
ne.Workbook.Worksheets[1].Activate();
return("");
}
