public int ModificationCart(SALES_EBASKETModel model) { var entity = SALES_EBASKETList.ToList().Where(t => t.CustomerID == model.CustomerID && t.ContactID == model.ContactID && t.ProductNo == model.ProductNo && t.Status == 0).FirstOrDefault(); if (entity == null) { entity = new SALES_EBASKET { ID = CombHelper.NewComb().ToString(), CustomerID = model.CustomerID, ContactID = model.ContactID, ProductNo = model.ProductNo, Quantity = model.Quantity, UnitPrice = model.UnitPrice, Unit = model.Unit, Creator = model.Creator, Modifier = model.Modifier, CreateDate = model.CreateDate, ModiDate = model.ModiDate, MakeOrderID = model.MakeOrderID, //RowID = model.RowID, Status = model.Status, UnitPType = model.UnitPType, }; return(SALES_EBASKETRepository.Insert(entity)); } else { //entity.ID = model.ID; //entity.CustomerID = model.CustomerID; //entity.ContactID = model.ContactID; //entity.ProductNo = model.ProductNo; entity.Quantity += model.Quantity; //entity.UnitPrice = model.UnitPrice; //entity.Unit = model.Unit; //entity.Creator = model.Creator; entity.Modifier = model.Modifier; //entity.CreateDate = model.CreateDate; entity.ModiDate = model.ModiDate; //entity.MakeOrderID = model.MakeOrderID; //entity.RowID = model.RowID; //entity.Status = model.Status; //entity.UnitPType = model.UnitPType; return(SALES_EBASKETRepository.Update(entity)); //这个是可以成功; 注意entity是通过entities集成读取 //return SALES_EBASKETRepository.Update(e => new { e.Quantity }, entity); //这个局部更新 } }
public OperationResult Insert(SALES_EBASKETModel model) { var entity = new SALES_EBASKET { ID = model.ID, CustomerID = model.CustomerID, ContactID = model.ContactID, ProductNo = model.ProductNo, Quantity = model.Quantity, UnitPrice = model.UnitPrice, Unit = model.Unit, Creator = model.Creator, Modifier = model.Modifier, CreateDate = model.CreateDate, ModiDate = model.ModiDate, MakeOrderID = model.MakeOrderID, RowID = model.RowID, Status = model.Status, UnitPType = model.UnitPType, }; SALES_EBASKETRepository.Insert(entity); return(new OperationResult(OperationResultType.Success, "Added successfully")); }
/// <summary> /// 使用存储过程更新, 但不知道怎样可以同步上下文; /// </summary> /// <param name="model"></param> /// <returns></returns> public int ModificationByProce(SALES_EBASKETModel model) { var entity = SALES_EBASKETRepository.EntitiesToList.Where(t => t.CustomerID == model.CustomerID && t.ContactID == model.ContactID && t.ProductNo == model.ProductNo && t.Status == 0).FirstOrDefault(); if (entity == null) { entity = new SALES_EBASKET { ID = CombHelper.NewComb().ToString(), CustomerID = model.CustomerID, ContactID = model.ContactID, ProductNo = model.ProductNo, Quantity = model.Quantity, UnitPrice = model.UnitPrice, Unit = model.Unit, Creator = model.Creator, Modifier = model.Modifier, CreateDate = model.CreateDate, ModiDate = model.ModiDate, MakeOrderID = model.MakeOrderID, //RowID = model.RowID, Status = model.Status, UnitPType = model.UnitPType, }; } else { //entity.ID = model.ID; entity.CustomerID = model.CustomerID; entity.ContactID = model.ContactID; entity.ProductNo = model.ProductNo; entity.Quantity = model.Quantity; entity.UnitPrice = model.UnitPrice; entity.Unit = model.Unit; //entity.Creator = model.Creator; entity.Modifier = model.Modifier; //entity.CreateDate = model.CreateDate; entity.ModiDate = model.ModiDate; entity.MakeOrderID = model.MakeOrderID; //entity.RowID = model.RowID; //entity.Status = model.Status; entity.UnitPType = model.UnitPType; } int ret = SALES_EBASKETRepository.ModificationByProce(entity); //这里刷新内存中数据集; //------------------------------- ////一直有问题不可以使用 //var entity_new = SALES_EBASKETRepository.EntitiesToList.Where(t => t.ID == entity.ID); //if (entity_new.Count() > 0) { SALES_EBASKETRepository.ReLoad(entity_new.FirstOrDefault()); } else //{ // SALES_EBASKETRepository.Add(entity); //} SALES_EBASKETRepository.Load(); //--------------------------------------- return(ret); }