/// <summary> /// 更新一个实体信息 /// </summary> /// <param name="Entity"></param> /// <returns></returns> public async Task <int> UpdateAsync(MemberSalaryEntity PEntity) { if (PEntity == null) { return(0); } PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsMemberSalary.Update(PEntity); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
/// <summary> /// 向数据库表添加一个新的记录,如果该记录已经存在,返回-2 /// </summary> /// <param name="PEntity"></param> /// <returns></returns> public async Task <int> AddAsync(MemberSalaryEntity PEntity) { if (PEntity == null || PEntity.Id != null) { return(-2); } PEntity.Id = AppCodes.AppStaticClass.GetIdOfDateTime(); PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsMemberSalary.Add(PEntity); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
// <summary> /// 根据Id删除一个实体信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public async Task <int> DeleteAsync(string Id) { if (Id == null) { return(0); } MemberSalaryEntity tempPlan = _GhDbContext.dsMemberSalary.Find(Id); _GhDbContext.dsMemberSalary.Remove(tempPlan); return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }
public async Task <string> PostAddOrUpdateAsync([FromBody] MemberSalaryEntity PEntity) { ExcuteResult actResult = new ExcuteResult(); if (await _PayRepository.AddOrUpdateAsync(PEntity).ConfigureAwait(false) > 0) { actResult.SetValues(p_state: 0, p_msg: "保存成功", p_tag: PEntity?.Id); } else { actResult.SetValues(1, "保存失败"); } return(JsonConvert.SerializeObject(actResult)); }
public async Task <string> PutAsync([FromBody] MemberSalaryEntity PEntity) { ExcuteResult actResult = new ExcuteResult(); if (await _PayRepository.UpdateAsync(PEntity).ConfigureAwait(false) > 0) { actResult.SetValues(0, "更新成功"); } else { actResult.SetValues(1, "更新失败"); } return(JsonConvert.SerializeObject(actResult)); }
/// <summary> /// 向数据库表添加一个新的记录,如果该记录已经存在,返回-2 /// </summary> /// <param name="PEntity"></param> /// <returns></returns> public async Task <int> AddOrUpdateAsync(MemberSalaryEntity PEntity) { //此记录的Id为员工的身份证号码,必须输入 if (PEntity == null || PEntity.Id == null || PEntity.MemberId == null) { return(0); } bool IsExist = await _GhDbContext.dsMemberSalary.AnyAsync(e => e.Id == PEntity.Id).ConfigureAwait(false); if (IsExist) { return(await UpdateAsync(PEntity).ConfigureAwait(false)); } else { PEntity.Id = AppCodes.AppStaticClass.GetIdOfDateTime(); PEntity.UpDateTime = DateTime.Now; _GhDbContext.dsMemberSalary.Add(PEntity); } return(await _GhDbContext.SaveChangesAsync().ConfigureAwait(false)); }