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