Пример #1
0
        public int AddCarPicture(CarPictureModel model)
        {
            const string sql = @"INSERT INTO car_picture
                        (innerid, carid, typeid, path, sort, createdtime)
                        VALUES
                        (@innerid, @carid, @typeid, @path, @sort, @createdtime);";

            try
            {
                Helper.Execute(sql, model);
                return 1;
            }
            catch (Exception ex)
            {
                return 0;
            }
        }
Пример #2
0
        /// <summary>
        /// 单次添加图片
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddCarPictureEx(CarPictureModel model)
        {
            const string sqlSCarPic = "select innerid, carid, typeid, path, sort, createdtime from car_picture where carid=@carid order by sort desc;";//查询车辆图片
            const string sqlIPic = @"insert into car_picture (innerid, carid, typeid, path, sort, createdtime) values (@innerid, @carid, @typeid, @path, @sort, @createdtime);";
            const string sqlUCover = @"update car_info set pic_url=@pic_url where innerid=@carid;";

            using (var conn = Helper.GetConnection())
            {
                //获取车辆图片
                var picedList = conn.Query<CarPictureModel>(sqlSCarPic, new { carid = model.Carid }).ToList();
                var number = picedList.Count + 1;
                if (number > 9)
                {
                    //图片数量控制在>=3 and <=9
                    return 402;
                }

                var tran = conn.BeginTransaction();
                try
                {
                    if (picedList.Count == 0)
                    {
                        model.Sort = 1;
                    }
                    else
                    {
                        model.Sort = picedList[0].Sort + 1;
                    }

                    conn.Execute(sqlIPic, model, tran); //插入图片

                    //表示添加张图片
                    if (picedList.Count == 0)
                    {
                        conn.Execute(sqlUCover, new { carid = model.Carid, pic_url = model.Path }, tran);
                    }

                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    LoggerFactories.CreateLogger().Write("单次添加图片异常:" + ex.Message, TraceEventType.Warning);
                    return 0;
                }
            }
        }