private void OnOKCommand()
{
ProjectEntity.IsDelete = true;
ProjectEntity.RaisALL();
ProjectEntity.DUpdate();
childWindow.DialogResult = true;
}
private void OnOKCommand()
{
ProjectEntity.IsFreeze = true;
App app = Application.Current as App;
ProjectEntity.LastModifyUserID = app.UserInfo.UserID;
ProjectEntity.RaisALL();
ProjectEntity.DUpdate();
childWindow.DialogResult = true;
}
public void OnOKCommand()
{
ProjectEntity.DUpdate();
childWindow.DialogResult = true;
}
private void OnImportCommand()
{
ProjectImportEntityList.Clear();
OpenFileDialog lOpenFile = new OpenFileDialog();
lOpenFile.Filter = "Excel (*.xls)|*.xls";
Dictionary <String, int> lHeaderDictionary = new Dictionary <String, int>();
if (lOpenFile.ShowDialog() == true)
{
ProjectImportEntityList.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;
}
ProjectEntity lProjectEntity = new ProjectEntity();
lProjectEntity.Project = new ProductManager.Web.Model.project();
// 生产令号
int lManufactureNumberColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("生产令号", out lManufactureNumberColumn) &&
-1 != lManufactureNumberColumn &&
Cell.EmptyCell != (cell = rowPair.Value.GetCell(lManufactureNumberColumn)))
{
lProjectEntity.ManufactureNumber = cell.StringValue;
}
}
// 项目名称
int lProjectNameColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("项目名称", out lProjectNameColumn) &&
-1 != lProjectNameColumn &&
Cell.EmptyCell != (cell = rowPair.Value.GetCell(lProjectNameColumn)))
{
lProjectEntity.ProjectName = cell.StringValue;
}
}
//型号
int lModelNumberColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("型号", out lModelNumberColumn) &&
-1 != lModelNumberColumn &&
Cell.EmptyCell != (cell = rowPair.Value.GetCell(lModelNumberColumn)))
{
lProjectEntity.ModelNumber = cell.StringValue;
}
}
//备注
int lRemarkColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("备注", out lRemarkColumn) &&
-1 != lRemarkColumn &&
Cell.EmptyCell != (cell = rowPair.Value.GetCell(lRemarkColumn)))
{
lProjectEntity.Remark = cell.StringValue;
}
}
//年份
int lYearNumberColumn = -1;
{
Cell cell = Cell.EmptyCell;
if (lHeaderDictionary.TryGetValue("年份", out lYearNumberColumn) &&
-1 != lYearNumberColumn &&
Cell.EmptyCell != (cell = rowPair.Value.GetCell(lYearNumberColumn)))
{
lProjectEntity.YearNumber = Convert.ToInt32(cell.StringValue);
}
}
lProjectEntity.RecordDate = DateTime.Now;
lProjectEntity.DUpdate();
if (lProjectEntity.ManufactureNumber.Length == 0)
{
Message.ErrorMessage("生产令号不能为空 在第 " + rowPair.Key + " 行！");
break;
}
ProjectEntity lProjectEntityTemp;
if (ProjectEntityDictionary.TryGetValue(lProjectEntity.ManufactureNumber, out lProjectEntityTemp))
{
Message.ErrorMessage("生产令号" + lProjectEntity.ManufactureNumber + "重复 在第 " + rowPair.Key + " 行！");
break;
}
ProjectImportEntityList.Add(lProjectEntity);
//ProjectEntityDictionary.Add(lProjectEntity.ManufactureNumber, lProjectEntity);
//ProductContext.projects.Add(lProjectEntity.Project);
}
}
catch (System.Exception ex)
{
Message.ErrorMessage(ex.Message);
}
}
}