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

        public int AddCar(CarInfoModel model)
        {
            const string sql = @"INSERT INTO `car_info`
                                (`innerid`,`custid`,`supplierid`,`carno`,`title`,`pic_url`,`provid`,`cityid`,`brand_id`,`series_id`,`model_id`,`colorid`,`mileage`,`register_date`,`buytime`,`buyprice`,`price`,`dealprice`,`isproblem`,`remark`,`ckyear_date`,`tlci_date`,`audit_date`,`istain`,`sellreason`,`masterdesc`,`dealdesc`,`deletedesc`,`estimateprice`,`status`,`createdtime`,`modifiedtime`,`seller_type`,`post_time`,`audit_time`,`sold_time`,`closecasetime`,`eval_price`,`next_year_eval_price`,`refreshtime`, `istop`, `istransferfee`)
                                VALUES
                                (@innerid,@custid,@supplierid,@carno,@title,@pic_url,@provid,@cityid,@brand_id,@series_id,@model_id,@colorid,@mileage,@register_date,@buytime,@buyprice,@price,@dealprice,@isproblem,@remark,@ckyear_date,@tlci_date,@audit_date,@istain,@sellreason,@masterdesc,@dealdesc,@deletedesc,@estimateprice,@status,@createdtime,@modifiedtime,@seller_type,@post_time,@audit_time,@sold_time,@closecasetime,@eval_price,@next_year_eval_price,@refreshtime, @istop, @istransferfee);";

            using (var conn = Helper.GetConnection())
            {
                int result;
                try
                {
                    if (model.seller_type != 3)
                    {
                        var num = conn.Query<int?>("select `type` from cust_info where innerid=@custid;", new { model.custid }).FirstOrDefault();
                        if (num == null || num == 0)
                        {
                            return -1;
                        }
                        model.seller_type = num;
                    }

                    result = conn.Execute(sql, model);
                }
                catch (Exception ex)
                {
                    LoggerFactories.CreateLogger().Write("添加车辆异常：", TraceEventType.Information, ex);
                    result = 0;
                }

                return result;
            }
        }