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

        public int DeleteCarPicture(string innerid)
        {
            const string sqlSCarPic = "select innerid, carid, typeid, path, sort, createdtime from car_picture where carid=(select carid from car_picture where innerid=@innerid) order by sort;";//查询车辆id
            const string sqlDPic = @"delete from car_picture where innerid=@innerid;";
            const string sqlUCover = @"update car_info set pic_url=(select path from car_picture where carid=@carid order by sort limit 1) where innerid=@carid;";

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

                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sqlDPic, new { innerid }, tran);
                    //获取封面图片
                    var coverid = picedList.First().Innerid;
                    if (innerid.Equals(coverid)) //删除封面
                    {
                        conn.Execute(sqlUCover, new { picedList.First().Carid }, tran);
                    }

                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    LoggerFactories.CreateLogger().Write("批量删除图片异常：" + ex.Message, TraceEventType.Warning);
                    return 0;
                }
            }
        }