public bool Save(CellPosition CellPosition, out string strResult) { strResult = string.Empty; bool result = false; var c = CellPositionRepository.GetQueryable().FirstOrDefault(s => s.ID == CellPosition.ID); if (c != null) { try { c.CellCode = CellPosition.CellCode; c.StockInPositionID = CellPosition.StockInPositionID; c.StockOutPositionID = CellPosition.StockOutPositionID; CellPositionRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.Message; } } else { strResult = "原因:未找到当前需要修改的数据!"; } return(result); }
public bool Add(CellPosition cellPosition, out string strResult) { strResult = string.Empty; bool result = false; var c = new CellPosition(); if (c != null) { try { c.CellCode = cellPosition.CellCode; c.StockInPositionID = cellPosition.StockInPositionID; c.StockOutPositionID = cellPosition.StockOutPositionID; CellPositionRepository.Add(c); CellPositionRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.Message; } } else { strResult = "原因:找不到当前登陆用户!请重新登陆!"; } return(result); }
public bool Delete(int cellPositionId, out string strResult) { strResult = string.Empty; bool result = false; var c = CellPositionRepository.GetQueryable().FirstOrDefault(s => s.ID == cellPositionId); if (c != null) { try { CellPositionRepository.Delete(c); CellPositionRepository.SaveChanges(); result = true; } catch (Exception) { strResult = "原因:已在使用"; } } else { strResult = "原因:未找到当前需要删除的数据!"; } return(result); }
public bool Add(CellPosition cellPosition) { var cp = new CellPosition(); cp.ID = cellPosition.ID; cp.CellCode = cellPosition.CellCode; cp.StockInPositionID = cellPosition.StockInPositionID; cp.StockOutPositionID = cellPosition.StockOutPositionID; CellPositionRepository.Add(cp); CellPositionRepository.SaveChanges(); return(true); }
public bool Delete(int cellPositionId) { var cp = CellPositionRepository.GetQueryable().FirstOrDefault(s => s.ID == cellPositionId); if (cp != null) { CellPositionRepository.Delete(cp); CellPositionRepository.SaveChanges(); } else { return(false); } return(true); }
public bool Save(CellPosition cellPosition) { IQueryable <Cell> cellQuery = CellRepository.GetQueryable(); IQueryable <Position> positionQuery = PositionRepository.GetQueryable(); var cell = cellQuery.FirstOrDefault(p => p.CellCode == cellPosition.CellCode); var c = CellPositionRepository.GetQueryable().FirstOrDefault(s => s.ID == cellPosition.ID); //var position = positionQuery.FirstOrDefault(po => po.ID == cellPosition.ID); if (c != null) { c.ID = cellPosition.ID; c.CellCode = cellPosition.CellCode; c.StockInPositionID = cellPosition.StockInPositionID; c.StockOutPositionID = cellPosition.StockOutPositionID; CellPositionRepository.SaveChanges(); } return(true); }