public IHttpActionResult AddAddress(CsAddress address)
{
address.CompanyName = "-";
address.Mobile = "-";
address.AddressState = 1;
bool bl = _csAddressBll.ExistsByWhere($" And UserId={address.UserId}");
address.IsDefault = bl ? 1 : 2;
int addressId = _csAddressBll.Add(address);
if (addressId > 0)
{
return(Json(new
{
status = true,
addressid = addressId
}));
}
else
{
return(Json(new
{
status = false,
addressid = 0
}));
}
}
public bool Update(CsAddress model)
{
var strSql = new StringBuilder();
strSql.Append("UPDATE CrabShop.dbo.[CsAddress] SET ");
strSql.Append("UserId = @UserId,CompanyName = @CompanyName,Consignee = @Consignee,Mobile = @Mobile,Details = @Details,TelPhone = @TelPhone,ConSex = @ConSex,IsDefault = @IsDefault,AddressState = @AddressState");
strSql.Append(" WHERE AddressId = @AddressId");
return(DbClient.Excute(strSql.ToString(), model) > 0);
}
/// <summary>
/// 修改用户默认收货地址
/// </summary>
/// <param name="address"></param>
/// <returns></returns>
public int ChooseAddress(CsAddress address)
{
StringBuilder strSql = new StringBuilder();
strSql.Append($"update CsAddress set IsDefault=2 where UserId={address.UserId} and IsDefault=1;");
strSql.Append($"update CsAddress set IsDefault=1 where AddressId={address.AddressId}");
int number = DbClient.Excute(strSql.ToString());
return(number);
}
public int Add(CsAddress model)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO CrabShop.dbo.[CsAddress] (");
strSql.Append("UserId,CompanyName,Consignee,Mobile,Details,TelPhone,ConSex,IsDefault,AddressState");
strSql.Append(") VALUES (");
strSql.Append("@UserId,@CompanyName,@Consignee,@Mobile,@Details,@TelPhone,@ConSex,@IsDefault,@AddressState);");
strSql.Append("SELECT @@IDENTITY");
return(DbClient.ExecuteScalar <int>(strSql.ToString(), model));
}
public IHttpActionResult ChooseDefault([FromBody] int addressId)
{
CsAddress address = _csAddressBll.GetModel(addressId);
int number = _csAddressBll.ChooseAddress(address);
bool status = false;
if (number > 0)
{
status = true;
}
return(Json(new { status }));
}
