public static async Task <int> InsertShopVoteAsync(ShopVoteModel model)
{
using (var cmd = new SqlCommand(@"INSERT Activity.dbo.tbl_ShopVote (
ShopId,ImageUrls,CreateDate,Area,EmployeeCount,Description,VideoUrl,CreateTime)
VALUES(@shopId,@imageUrls,@createDate,@area,@employeeCount,@description,@videoUrl,GETDATE())"))
{
cmd.Parameters.AddWithValue("@shopId", model.ShopId);
cmd.Parameters.AddWithValue("@imageUrls", model.ImageUrls);
cmd.Parameters.AddWithValue("@createDate", model.CreateDate);
cmd.Parameters.AddWithValue("@area", model.Area);
cmd.Parameters.AddWithValue("@employeeCount", model.EmployeeCount);
cmd.Parameters.AddWithValue("@description", model.Description);
cmd.Parameters.AddWithValue("@videoUrl", model.VideoUrl);
return(await DbHelper.ExecuteNonQueryAsync(cmd));
}
}
///<summary>门店报名</summary>///
public async Task <OperationResult <bool> > AddShopSignUpAsync(ShopVoteModel model)
{
try
{
//验证是否可以反序列化，保证数据有效
JsonConvert.DeserializeObject <JArray>(model.ImageUrls);
var check = await CheckShopSignUpAsync(model.ShopId);
if (check.Result)
{
return(OperationResult.FromResult(true));
}
else
{
var result = await SexAnnualVoteManager.InsertShopVoteAsync(model);
return(OperationResult.FromResult(result.Result));
}
}
catch (Exception e)
{
return(OperationResult.FromError <bool>("0", e.Message));
}
}
public static async Task <OperationResult <bool> > InsertShopVoteAsync(ShopVoteModel model)
{
return(OperationResult.FromResult(await DalSexAnnualVote.InsertShopVoteAsync(model) > 0));
}
