CCN.Modules.Car.DataAccess.CarDataAccess.AddCarReward C# (CSharp) Method

        public int AddCarReward(CarReward model)
        {
            const string sql = @"INSERT INTO `car_reward`
                                (`innerid`, `brand_id`, `series_id`,`model_id`, `mileage`,`colorid`, `coty`, `price`, `provid`, `cityid`, `status`, `username`, `usermobile`,`qrcode`, `createdid`, `createdtime`, `modifiedtime`)
                                VALUES
                                (uuid(), @brand_id, @series_id,@model_id, @mileage,@colorid, @coty, @price, @provid, @cityid, 1, @username, @usermobile,@qrcode, @createdid, now(), now());";

            using (var conn = Helper.GetConnection())
            {
                int result;
                try
                {
                    result = conn.Execute(sql, model);
                }
                catch (Exception ex)
                {
                    LoggerFactories.CreateLogger().Write("添加车辆悬赏信息异常：", TraceEventType.Information, ex);
                    result = 0;
                }
                return result;
            }
        }