public IHttpActionResult Insert(ExperienceVoucher experienceVoucherv)
{
LogHelper.WriteLog("Insert start");
SimpleResult result = new SimpleResult();
IExperienceVoucherService _service = new ExperienceVoucherService();
try
{
if (UserAuthorization)
{
_service.Insert(experienceVoucherv);
result.Resource = null;
result.Status = Result.SUCCEED;
}
else
{
result.Status = ResultType;
result.Resource = ReAccessToken;
result.Msg = TokenMessage;
}
}
catch (Exception ex)
{
LogHelper.WriteLog("Insert插入体验卷：" + ex.Message, ex);
LogHelper.WriteLog("Insert插入体验卷：" + ex.StackTrace, ex);
result.Status = Result.FAILURE;
result.Msg = ex.Message;
}
LogHelper.WriteLog("Insert result" + Json(result));
return(Json(result));
}
public ExperienceVoucher GetExperienceVoucherByCode(string code)
{
DynamicParameters paras = new DynamicParameters();
paras.Add("@code", code, System.Data.DbType.String);
ExperienceVoucher v = DapperSqlHelper.FindOne <ExperienceVoucher>("select * from [dbo].[ExperienceVoucher] where ExperienceVoucherCode=@code ", paras, false);
return(v);
}
public void Insert(ExperienceVoucher v)
{
DynamicParameters paras = new DynamicParameters();
if (string.IsNullOrEmpty(v.ExperienceVoucherCode))
{
v.ExperienceVoucherCode = GetMaxCode();
}
paras.Add("@ExperienceVoucherCode", v.ExperienceVoucherCode, System.Data.DbType.String);
paras.Add("@ProductCode", v.ProductCode, System.Data.DbType.String);
paras.Add("@ExperienceNo", v.ExperienceNo, System.Data.DbType.Int32);
paras.Add("@ExperiencePrice", v.ExperiencePrice, System.Data.DbType.Decimal);
paras.Add("@VersionStartTime", v.VersionStartTime, System.Data.DbType.DateTime);
paras.Add("@VersionEndTime", v.VersionEndTime, System.Data.DbType.DateTime);
string sql = @"insert into [dbo].[ExperienceVoucher](ExperienceVoucherCode,ProductCode,ExperienceNo,ExperiencePrice,VersionStartTime,VersionEndTime)
values(@ExperienceVoucherCode,@ProductCode,@ExperienceNo,@ExperiencePrice,@VersionStartTime,@VersionEndTime)";
DapperSqlHelper.ExcuteNonQuery <ExperienceVoucher>(sql, paras, false);
}