/// <summary> /// 添加或更新流派 /// </summary> /// <param name="storeTypeEntity"></param> /// <returns></returns> public Tuple <bool, SingerTypeEntity> AddOrUpdateSingerType(SingerTypeEntity singerTypeEntity) { SingerTypeEntity updateEntity = singerTypeEntity; int result = 0; if (singerTypeEntity.Id > 0) { var t = helper.QueryScalar($@"select count(1) from SingerType where SingerTypeName='{singerTypeEntity.SingerTypeName}' and Id not in ({singerTypeEntity.Id}) "); if (Convert.ToInt32(t) > 0) { return(Tuple.Create(false, new SingerTypeEntity())); } result = helper.Execute($@"update SingerType set SingerTypeName='{singerTypeEntity.SingerTypeName}',UpdateTime='{DateTime.Now}' where Id={singerTypeEntity.Id}"); updateEntity = singerTypeEntity; } else { var t = helper.QueryScalar($@"select count(1) from SingerType where SingerTypeName='{singerTypeEntity.SingerTypeName}' "); if (Convert.ToInt32(t) > 0) { return(Tuple.Create(false, new SingerTypeEntity())); } var p = new DynamicParameters(); p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output); result = helper.Execute($@"insert into SingerType (SingerTypeName,UpdateTime) values ('{singerTypeEntity.SingerTypeName}','{DateTime.Now}');SELECT @Id=SCOPE_IDENTITY()", p); var id = p.Get <int>("@Id"); singerTypeEntity.Id = id; } return(Tuple.Create(result > 0 ? true : false, updateEntity)); }
public ActionResult AddOrUpdateSingerType(SingerTypeEntity singerTypeEntity) { var result = singerTypeRepository.AddOrUpdateSingerType(singerTypeEntity); return(Json(new { status = result.Item1, data = result.Item2 })); }