CCN.Modules.Auction.DataAccess.AuctionDataAccess.UpdateAuctionCarStatus C# (CSharp) Метод

        public int UpdateAuctionCarStatus(AuctionCarInfoModel model)
        {
            //更新拍卖信息状态
            var sql = new StringBuilder("update `auction_carinfo` set `status`=@status where innerid = @innerid;");
            //更车辆状态
            var sqlcar = new StringBuilder("update `car_info`  ");
            if (model.status == 7)
            {
                sqlcar.Append(" set status=2 where innerid =@carid; ");
            }
            else if (model.status == 8)
            {
                sqlcar.Append(" set status=1 where innerid =@carid; ");
            }
            else if (model.status == 6)//上线
            {
                sqlcar.Append(" set status=3 where innerid =@carid; ");
            }
            int result;
            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sql.ToString(), model, tran);
                    if (model.status == 6 || model.status == 7 || model.status == 8)
                    {
                        conn.Execute(sqlcar.ToString(), model, tran);
                    }

                    tran.Commit();
                    result = 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    result = 0;
                    LoggerFactories.CreateLogger().Write("修改拍卖车辆异常：", TraceEventType.Information, ex);
                }
            }
            return result;
        }