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

        public int AddCarLoan(CarLoanModel model)
        {
            const string sql = @"INSERT INTO `car_loan`
                                (`innerid`, `contacts`, `mobile`, `term`, `instruction`,`amount`,`status`, `modifiedid`, `modifiedtime`, `createdid`, `createdtime`)
                                VALUES
                                (uuid(), @contacts, @mobile, @term, @instruction,@amount,0, @modifiedid, now(), @createdid, 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;
            }
        }