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