/// <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 = "添加成功"
});
}
