/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <FuncResult> Update(int id, DimStoreModel model, int currentuserId) { DimStore entity = await _context.DimStore.FindAsync(id); if (entity == null) { return(new FuncResult() { IsSuccess = false, Message = "店铺ID错误!" }); } entity.stCode = model.stCode; entity.stRegion = model.stRegion; entity.stCity = model.stCity; entity.stLocation = model.stLocation; entity.stBrand = model.stBrand; entity.stOM = model.stOM; entity.stDM = model.stDM; entity.stName = model.stName; entity.stName_en = model.stName_en; entity.stAddress = model.stAddress; entity.stAddress_en = model.stAddress_en; entity.stType = model.stType; entity.stOpenDate = model.stOpenDate; entity.stCloseDate = model.stCloseDate; entity.stTel = model.stTel; entity.stFax = model.stFax; entity.stEmail = model.stEmail; entity.stIP = model.stIP; entity.stSpace = model.stSpace; entity.stSeat = model.stSeat; entity.stBizTime = model.stBizTime; entity.stPOST = model.stPOST; entity.stSM = model.stSM; entity.stSMTel = model.stSMTel; entity.stComments = model.stComments; entity.Last_Updated_By = currentuserId; entity.Last_Update_Date = DateTime.Now; _context.DimStore.Update(entity); await _context.SaveChangesAsync(); return(new FuncResult() { IsSuccess = true, Content = entity, Message = "修改成功" }); }
public async Task <FuncResult> Delete(int id, int currentUserId) { DimStore entity = await _context.DimStore.FindAsync(id); if (entity == null) { return(new FuncResult() { IsSuccess = false, Message = "店铺ID不存在!" }); } entity.Delete_Flag = true; entity.Delete_By = currentUserId; entity.Delete_Time = DateTime.Now; _context.DimStore.Update(entity); await _context.SaveChangesAsync(); return(new FuncResult() { IsSuccess = true, Content = entity, Message = "删除成功" }); }
public async Task <FuncResult> Add(DimStoreModel model, int currentUserId) { if (_context.DimStore.Count(e => e.stCode == model.stCode) > 0) { return(new FuncResult() { IsSuccess = false, Message = "已经存在相同的店铺编码。" }); } DimStore entity = new DimStore { stCode = model.stCode, stRegion = model.stRegion, stCity = model.stCity, stLocation = model.stLocation, stBrand = model.stBrand, stOM = model.stOM, stDM = model.stDM, stName = model.stName, stName_en = model.stName_en, stAddress = model.stAddress, stAddress_en = model.stAddress_en, stType = model.stType, stOpenDate = model.stOpenDate, stCloseDate = model.stCloseDate, stTel = model.stTel, stFax = model.stFax, stEmail = model.stEmail, stIP = model.stIP, stSpace = model.stSpace, stSeat = model.stSeat, stBizTime = model.stBizTime, stPOST = model.stPOST, stSM = model.stSM, stSMTel = model.stSMTel, stComments = model.stComments, Creation_Date = DateTime.Now, Created_By = currentUserId }; await _context.DimStore.AddAsync(entity); using (Microsoft.EntityFrameworkCore.Storage.IDbContextTransaction trans = _context.Database.BeginTransaction()) { try { await _context.SaveChangesAsync(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); return(new FuncResult() { IsSuccess = false, Content = ex.Message }); } } return(new FuncResult() { IsSuccess = true, Content = entity, Message = "添加成功" }); }