private void OnImportCommand()
{
OpenFileDialog lOpenFile = new OpenFileDialog();
lOpenFile.Filter = "Excel (*.xls)|*.xls";
Dictionary<String, int> lHeaderDictionary = new Dictionary<String, int>();
if (lOpenFile.ShowDialog() == true)
{
ProductEntityList.Clear();
try
{
FileStream fs = lOpenFile.File.OpenRead();
Workbook book = Workbook.Open(fs);
foreach (KeyValuePair<int, Row> rowPair in book.Worksheets[0].Cells.Rows)
{
if (rowPair.Key == 0)
{
try
{
foreach (KeyValuePair<int, Cell> cellPair in rowPair.Value)
{
lHeaderDictionary.Add(cellPair.Value.StringValue, cellPair.Key);
}
}
catch (System.Exception ex)
{
Message.ErrorMessage("表头重复或超出范围！");
break;
}
continue;
}
ProductEntity lProductEntity = new ProductEntity();
lProductEntity.Product = new ProductManager.Web.Model.product();
lProductEntity.ProductEntityDictionary = ProductEntityDictionary;
lProductEntity.ProjectEntityDictionary = ProjectEntityDictionary;
//lProductEntity.ProductPartTypeEntityDictionary = ProductTypeEntityDictionary;
int lManufactureNumberColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("生产令号", out lManufactureNumberColumn)
&& -1 != lManufactureNumberColumn
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lManufactureNumberColumn)))
{
lProductEntity.ManufactureNumber = cell.StringValue;
ProjectEntity projectEntityTemp;
if (!ProjectEntityDictionary.TryGetValue(lProductEntity.ManufactureNumber, out projectEntityTemp))
{
NotifyWindow lNotifyWindow = new NotifyWindow("错误","第 " + rowPair.Key.ToString() + "行 系统中没有生产令号：" + lProductEntity.ManufactureNumber);
lNotifyWindow.Show();
return;
}
}
else
{
NotifyWindow lNotifyWindow = new NotifyWindow("错误", "第 " + rowPair.Key.ToString() + "行 系统中没有生产令号：" + lProductEntity.ManufactureNumber);
lNotifyWindow.Show();
return;
}
}
int lProjectNameColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("序列号", out lProjectNameColumn)
&& -1 != lProjectNameColumn
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lProjectNameColumn)))
{
lProductEntity.ProductID = cell.StringValue;
ProductEntity lProductEntityTemp;
if (ProductEntityDictionary.TryGetValue(lProductEntity.ProductID, out lProductEntityTemp))
{
NotifyWindow lNotifyWindow = new NotifyWindow("错误","第 " + rowPair.Key.ToString() + "行 序列号重复：" + lProductEntity.ProductID);
lNotifyWindow.Show();
return;
}
if (CurrentProductEntityDicationary.TryGetValue(lProductEntity.ProductID, out lProductEntityTemp))
{
NotifyWindow lNotifyWindow = new NotifyWindow("错误", "第 " + rowPair.Key.ToString() + "行 序列号重复：" + lProductEntity.ProductID);
lNotifyWindow.Show();
return;
}
}
}
int lModelNumberColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("产品类型", out lModelNumberColumn)
&& -1 != lModelNumberColumn
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lModelNumberColumn)))
{
lProductEntity.ProductTypeString = cell.StringValue;
int lId;
if (ProductTypeIDDictionary.TryGetValue(lProductEntity.ProductTypeString, out lId))
{
lProductEntity.ProductTypeID = lId;
}
else
{
NotifyWindow lNotifyWindow = new NotifyWindow("错误", "第 " + rowPair.Key.ToString() + "行 系统中无该产品类型：" + lProductEntity.ProductTypeString);
lNotifyWindow.Show();
return;
}
}
}
int lRemarkColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("名称", out lRemarkColumn)
&& -1 != lRemarkColumn
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lRemarkColumn)))
{
lProductEntity.ProductName = cell.StringValue;
}
}
int lInputTimeColume = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("编制日期", out lInputTimeColume)
&& -1 != lInputTimeColume
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lInputTimeColume)))
{
lProductEntity.ProductIDCreateData = cell.DateTimeValue;
}
}
int lOutputNumberColume = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("出厂编号", out lOutputNumberColume)
&& -1 != lOutputNumberColume
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lOutputNumberColume)))
{
lProductEntity.ProductOutputNumber = cell.StringValue;
}
}
int lNote1 = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("备注1", out lNote1)
&& -1 != lNote1
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lNote1)))
{
lProductEntity.ProductDescript1 = cell.StringValue;
}
}
int lNote2 = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("备注1", out lNote2)
&& -1 != lNote2
&& Cell.EmptyCell != (cell = rowPair.Value.GetCell(lNote2)))
{
lProductEntity.ProductDescript2 = cell.StringValue;
}
}
lProductEntity.DUpdate();
ProductEntityList.Add(lProductEntity);
CurrentProductEntityDicationary.Add(lProductEntity.ProductID, lProductEntity);
//ProductContext.projects.Add(lProjectEntity.Project);
}
}
catch (System.Exception ex)
{
Message.ErrorMessage(ex.Message);
}
}
}
